Pass SQL Query @ Run time not working
Moderators: chulett, rschirm, roy
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.
I tried it, but no luck.
I am going to share my log details and based on their reply!
Code: Select all
Check if the quoted ID is enabled for the problem DSN, if so disable it and run the job again.
I am going to share my log details and based on their reply!
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
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.
Thanks to all for your time and suggestion.
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
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
I was also in the same thought is the another reason why i declared it in job level.chulett wrote:I would have thought having it at the job level would have been fine as well. Good to know.
thanks
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.