trimming line terminator

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

allavivek
Premium Member
Premium Member
Posts: 211
Joined: Sat May 01, 2010 5:07 pm

Post by allavivek »

Hi Andrw,

I gave the code which youve gave in uservariable activity before start loop ..

Next in start loop i gave 'delimited values' option -> value from uservariable activity.

Next in command stage inside loop i gave #StartLoop.$Counter value..


Its getting same error...

Is this correct approach ...
vivekgadwal
Premium Member
Premium Member
Posts: 457
Joined: Tue Sep 25, 2007 4:05 pm

Post by vivekgadwal »

Hey,

Please try doing the following within the Uservariable activity:

Code: Select all

Oconv(<Command activity name>.$CommandOutput,"MCN")
We execute a shell script to get the loop values and we use this command at the end. Please try this and see if it helps :)
Vivek Gadwal

Experience is what you get when you didn't get what you wanted
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Or

Add tr command to your unix command

Code: Select all

your_unix_cmd | tr -d '\n'
You are the creator of your destiny - Swami Vivekananda
Post Reply