Search found 4 matches

by vijaydasari77
Wed Oct 18, 2017 10:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to pass string with spaces to Teradata Connector stage
Replies: 6
Views: 3589

Craig,

Thank You for trying to help me. I will check with my DS Admin.
by vijaydasari77
Wed Oct 18, 2017 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to pass string with spaces to Teradata Connector stage
Replies: 6
Views: 3589

Hi Chulett, Here is my dsjob statement ${DS_BIN_DIR}/dsjob -run -param ROBO_ID="${ROBOID}" -wait ${DS_RDW_PROJECT} ${JOB_NAME} I am enclosing my data in the file between single quotes as unix is not reading complete string. Here is my full error msg. load_ANNOTATION_WB_SN: Unrecognized arg...
by vijaydasari77
Tue Oct 17, 2017 8:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to pass string with spaces to Teradata Connector stage
Replies: 6
Views: 3589

Additional Info

My input is from a file as below 'ROBO0001 ADD' 'ROBO0002 ADD' 'ROBO0003ADD' I am reading these values into a unix variable and passing it to my parallel job which has a Teradata BTEQ script as before EXECSH. the Bteq is getting the value correctly. But in the job I have a Teradata connector where I...
by vijaydasari77
Tue Oct 17, 2017 2:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to pass string with spaces to Teradata Connector stage
Replies: 6
Views: 3589

how to pass string with spaces to Teradata Connector stage

Hi All, I am calling a Datastage parallel job repeatedly while passing a char string with spaces as parameter. I want to use this parameter in SQL as part of condition check for a column in Teradata Connector. If the parameter has one word it is working fine. if it has two or more words, the job is ...