Troubleshooting
Problem
In a job stream process, a database value is retrieved and a command line is built and run similar to: dsjob -run -wait -param P_SQL_IN_COND='a','b,'c' TODDH Kash_ReadOra_With_Param_in_Query The -param is used in a InfoSphere DataStage job SQL Query but it produces incorrect results or fails. Normally the single quotes would need to have back slashes -param P_SQL_IN_COND=\'a\', \'b\', \'c\' This still produces incorrect results or fails
Symptom
The job runs and either fails or produces incorrect results.
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"}],"Version":"9.1;8.7;8.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
swg21621938