Archives of the TeradataForum
Message Posted: Fri, 31 Jul 2015 @ 19:38:03 GMT
| Subj: || || Re: Parameters that get passed in a SP |
| From: || || Anderson, Dirk |
The SQLTextInfo field will have the CALL statement with the values that were passed in using ODBC. For example,
However, in this example, the dates do not actually appear in the subsequent SQL logs. Instead, you will find notation like "_spVV0"
which indicates the first parameter passed in the CALL. So, you have to marry up the call statement positionally with the statements you see in
the actual SQL log (below):
_spVV0 (VARCHAR(128), CHARACTER SET LATIN, NOT CASESPECIFIC),
_spVV1 (VARCHAR(128), CHARACTER SET LATIN, NOT CASESPECIFIC)........