Pass SQL Query @ Run time not working

[chulett]

ps. Here is the TechNote for the issue and APT environment variable in question.

[SURA]

IBM asked me to do 3 steps and out of 3 I already did 2 (one is your suggestion of the APT) and i have mentioned it here.

Code: Select all

Check if the quoted ID is enabled for the problem DSN, if so disable it and run the job again.

I tried it, but no luck.

I am going to share my log details and based on their reply!

[SURA]

H i craig

Your suggestions was the right one. I declared it for the job level rather than the project level was the issue. If i could did it properly at the time when you given that APT, I could have resolved it.

IBM guy noticed my mistake and asked me to declare it globally.

Now the issue is resolved.

Code: Select all

As Craig said, add this variable $APT_OSL_PARAM_ESC_SQUOTE  in the project level and use it in the job by passing the value as 1

Thanks to all for your time and suggestion.

[chulett]

Sweet! Thanks for the clarification, I would have thought having it at the job level would have been fine as well. Good to know.

[SURA]

I would have thought having it at the job level would have been fine as well. Good to know.

I was also in the same thought is the another reason why i declared it in job level.

thanks