I am using the SYSLIB.MONITORQUERYBAND Open API in my application.
the API takes three parameters,
The CLIv2 counterpart of this API has the option of passing null/0 for the parameter VprocNo , but the open API doesn't allow me to do this..
FROM TABLE(MonitorSession(-1,'*',0)) AS T1
fails saying PE Vproc number.
Note: I have tried explicit zero/null instead of coalesce. Teradata version 13.10
The RunVProcNo parameter must be an existing PE number, but neither NULL nor 0 exist.
Remove the offending NULL: WHERE RunVprocNo IS NOT NULL
or use COALESCE(RunVprocNo ,LogonPENo)
Thanks for your reply..
But the issue is that some of the sessions that I process are FASTLOAD/MLOAD/FASTEXPORT sessions (through TPT).
Hence I think these sessions are logged on to the AMP directly.
I do believe we have an option in TPT to set querybands to sessions used in Load/Update/Export operators.
I am not sure whether these querybands will be applied only to PE sessions of Opertor or the AMP sessions as well.
If the query bands are applied to Amp Session as well then I would have to somehow get the querybands for these sessions as well.
If not then how would I associate a AMP based TPT session with a specific TPT triggered from my Application.
Please let me know if I am wrong about the AMP based sessions in TPT.
Thanks in advance,