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

Previous topic - Next topic

HenryJohansen

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

Justin Derrick

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.  :)
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR