Show Posts
1
z/OS Server / zOD V10.1.0.5 - not using the modified sql in the arsutbl C exit
« on: February 28, 2020, 07:29:11 AM »
I currently writing a 64-bit arsutbl exit in C on z/OS where I'm changing the SQL for CREATE INDEX to CREATE UNIQUE INDEX for a particular index key. And set the *created = 0 in order to let CMOD create the index with the modified SQL.
The output from the "printf-trace" in the ARSSOCKD stc shows the exit being invoked and it also displaying the original SQLs and the changed SQL (both variabel sql from ArcChar *sql declaration).
But in DB2 I can see the original SQL has been invoked instead for the modified SQL.
Any suggestions what's wrong?
Regards
Henry
The output from the "printf-trace" in the ARSSOCKD stc shows the exit being invoked and it also displaying the original SQLs and the changed SQL (both variabel sql from ArcChar *sql declaration).
But in DB2 I can see the original SQL has been invoked instead for the modified SQL.
Any suggestions what's wrong?
Regards
Henry