Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 12 Feb 2004 @ 15:37:36 GMT

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

Subj:   Re: DBC.AccessLog
From:   Dempsey, Mike

I think there is some confusion here over the use of '?' in SQL Assistant.

SQL Assistant will (by default) display a '?' for any column that is returned as NULL, but it will not change the data values in the table itself.

If you are using IMPORT mode you would also (by default) use '?' in the Import file to tell SQL Assistant that you want to insert a NULL value in the corresponding column. (This does effect table data)

Thirdly, SQL Assistant uses the '?' character as a parameter marker in an Import statement. These '?' characters will be replaced by the data from the Import file before they are inserted (or whatever) into the table. (This is an ODBC standard)

None of these things should cause '?' to show up in the SQL inserted into the QueryLog table however.

My guess (for your AccessLog table problem) is that MS Access is submitting a prepared statement (which would include '?' characters to indicate where the data values go) followed by the data in a separate parcel.

Records are inserted into the AccessLog table during the Parsing phase (when Teradata checks to see if you have the appropriate rights) and at this time the data has not yet been merged with the prepared statement... So the parameter markers would still be in the statement text.

Mike Dempsey
Teradata Client Tools

  <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