DSXchange

NewCol is derived as and no stage variables. This assumes that for line 1 f1 is "a" and f2 is "aa,bb,cc".

The orchadmin cp command will truncate the target dataset and will not accept wildcards. You could do this concatenation from a DS job with the target DataSet set so that it appends records and doesn't truncate.

Does the "lost" memory stay gone if you bring down the DataStage server engine?

Does your input file have 2 columns defined with a delimiter of "|"? If so, how do you get DSLink3.f3?

try not to "cd" to a shell script, but to the directory where the shell script is located, i.e. "cd /home/dsadm/abc"

Check out Parameter Navigator by Kim Duke; this might help you.
As of Version 8 you have Parameter Sets, which greatly help this kind of work.

Venkat - this particular question has been asked and answered to many times in the past. Please use the "search" function to find the responses.

Could you post both the error message you get and your system virtual memory setting?

Venkat - I am certain I responded to this query with a post yesterday, but I cannot see (or is this a duplicate thread?). Ah, yes - a duplicate identical question to this thread with a different userid

Could you post an explanation of where and how you are doing this from DataStage?

Is this the same site as this question?

xyz_chatter - You can use the ICONV/OCONV functions to convert from display to internal format and vice-versa. Convert to internal format using ICONV(In.DateStringCol,'D4/MDY'), the you can get the day of week using format 'DWA' or 'DWB' to get the day name and 'DJ' to get the julian day number in t...

I can't recall if the PX sequential stage has a "header" option, but if not you could use a filter of "sed '1,1d'" to remove the header line and then read the rest as fixed width.

Output 2 new columns to test - Len(In.Col) and Len(Trim(In.Col)). Both should be equal and 9 for "M'Sateesh"

This is a samilar issue as in your thread here. You need to make ODBC sources visible on a Windows machine from UNIX.