OnDemand User Group

Support Forums => z/OS Server => Topic started by: HenryJohansen on February 28, 2020, 07:29:11 AM

Title: zOD V10.1.0.5 - not using the modified sql in the arsutbl C exit
Post by: HenryJohansen 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

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

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.  :)