User defined sql(Stripping off quote char)

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Inquisitive
Charter Member
Charter Member
Posts: 88
Joined: Tue Jan 13, 2004 3:07 pm

Post by Inquisitive »

Hi Craig,
I work using DB2 API Stage using PX version 7.0 . View data fires the sql taking the job parameter and it works fine. However while running the job, it ignores the singles quotes in the job parameter. Is it a bug or is there a way to escape the single quotes and pass it to the SQL

Rgds
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”