Print Page - zOD V10.1.0.5 - not using the modified sql in the arsutbl C exit

Title: zOD V10.1.0.5 - not using the modified sql in the arsutbl C exit
Post by: HenryJohansen on February 28, 2020, 02:29:11 PM

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

Title: Re: zOD V10.1.0.5 - not using the modified sql in the arsutbl C exit
Post by: Justin Derrick on February 29, 2020, 04:51:06 AM

This question was split from another topic. Please ask questions in a new post, where they can get the most visibility, and have the best chance of being answered by others. :)

OnDemand Users Group

Support Forums => CMOD for z/OS Server => Topic started by: HenryJohansen on February 28, 2020, 02:29:11 PM