Archives of the TeradataForum
Message Posted: Tue, 05 Aug 2003 @ 15:44:09 GMT
| Subj: | | Re: Queries with Prompts |
| |
| From: | | Dempsey, Mike |
These are submitted as parameterized queries - the ? characters being the parameter markers. The query is submitted (and 'prepared')
once, and then can be executed multiple times using different sets of values. (This is how Import mode works in SQL Assistant/Queryman.)
The Access log will be written when the query is 'prepared'. At that time no values are associated with the query ... so you will not see
any values.
When you upgrade to V2R5 you may be able to get what you want from the Query Log as I think that may log the queries when they are
executed rather than when they are prepared.
In the next version of SQL Assistant you will be able to use 'named parameters' in your queries. When you submit a query it will prompt
you to enter the parameters. Those parameters will actually be edited into the query text before the query is submitted... so they will
show up in the Access Log. This feature will not be available until TW 7.1 near the end of the year however ... and it wont help your own
'custom' ODBC apps.
Mike Dempsey
Teradata Client Tools.
| 
