Archives of the TeradataForum

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

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

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>>