DSXchange

What is the value that you have given in "Filename" option?
The given option works. If I dont pass any value to parameter it gives out
"DSD.SEQOpen GCI $DS.SEQOPEN error 11.|" from datastage.

Ray, I suggested Iconv(Input,"MT") as per your IsValid function.

What is the job logs shows? Are you calling the script with fully quallified path, I guess you are focusing in adding the path to the Filename that you are tying to move.

Can you post the code, what you use to check?

DSguru2B, atleast for this sake you can display you name DSguru2B .
Yes... DSguru2B?
No... DSguru2B ?

Try with Iconv(Input,"MT") followed by Status().

Hi Poorna,
What is the data in After DataSet? Is it the updated output or copy of merged output from funnel?
Do you have any date field from table getting generated at runtime during load or something??So that every time you get updated time, and the data found to be changed?

venkycool ,
DSguru2B has quoted a famous quote from Brian Wilson Kernighan, who is a computer scientist who worked at Bell Labs.
Many new people around here thanking Brian instead of DSguru2B.
I was just kidding DSguru2B, that he is adding credit to Brian Wilson Kernighan by this.

You want add credit to Brian Kernighan, don't you?

orchadmin utility with -dump option can be used to convert the dataset into sequential file.

That happens, if the ASCII file of DOS mode transfered in Binary mode to unix. Hence the /r will be displayed as ^M in Unix view. You can find the actual character using od -bc {filename}. The last character will be displayed in Hex as well as Ascii mode.

Do you think you can mark the topic as resolved.

Its because due the persence of ^M as Narashima noted. May be due wrong format in FTPing the file.

Starflake Schema - Combination of Star and Snowflake.

/ at the path isn't necessarily giving a problem.
Since a backslash is present in File path, it need to be quoted.
awk -F"," '{if( FILENAME != /dir1/dir/) ..... giving out the error that you have reported, where as awk -F"," '{if( FILENAME != "/dir1/dir") ..... is not.