![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
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,
CALL myproc('2015-06-01','2015-06-30')...
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):
USING
_spVV0 (VARCHAR(128), CHARACTER SET LATIN, NOT CASESPECIFIC),
_spVV1 (VARCHAR(128), CHARACTER SET LATIN, NOT CASESPECIFIC)........
Dirk
| |