Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 09 Feb 2004 @ 15:57:44 GMT


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


Subj:   Re: DBC.AccessLog
 
From:   Coffing Christopher L

The "?" is usually a NULL value. Change the SQL as follows...

SELECT  "col1" , "col2"
FROM    "PROD"."View1"
WHERE   ( "col2" is NULL ) ;

Sometimes a ? is also used as a parameter and so the SQL not complete is because MS Access is looking for a value to replace the ?....

Hope this helps...

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master



     
  <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: 23 Jun 2019