Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Jul 2009 @ 07:30:27 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Bteq vs SQL/Assistant output
 
From:   Poddar, Gautam

Hi,

When I am running this query using Teradata SQL Assistant I am able to get 4 columns which I am expecting in the output, but when I am trying to execute the same query using bteq then I am getting all the row but only two columns, What is the reason and what is the possible solution for this?

     Locking row For access
     Select Distinct
      software_seq.part_id,
      description,
      site_id,
      reporting_app_name
     From    software_seq

      Inner join
       (
     Select  part_id
     From    software_seq
     Minus
     Select  vendor_part_id
     From    pkgname_master_t
       ) NewSoftware

      on

      software_seq.part_id = newsoftware.part_id;

Thanks,

Gautam Poddar



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016