DSXchange

ExecuteCommand is returning a string, not an integer value. You need to parse the number out of your string.

Althaf6553 - Craig suggested you try searching for the specifc answer to your specific problem. It would seem that you prefer not to follow that recommendation. I feel that that if a poster doesn't feel it necessary to invest the time in searching for prior solutions then I won't invest the time int...

What did you declare the MessagePayload as? If you write to a Dataset instead of to a peek stage, do you get an error message or warning, I presume that you don't.

Using "Char" was a necessary first step. It looks like you have specified delimiters in the column import file definitions, though.

There is not enough information in the question to really get a good answer. Why have you used the hashed file stage? How big is the ODBC data compared to your mainstream data?

WinZip has a command line interface, as do other Windows compression programs. These commands can all be called through from inside DataStage sequence jobs.

What did you change in the constraint?

What is the actual compiler error?

Declare the 4 output fixed columns and make the file format with fixed width & no column separators.

Put a constraint of "RIGHT(In.DateColumn,4)<>'000'"

In the server plugin you give the remote host name, the path and the file. No URI

Drop the "ftp:/" and make it an absolute path on the remote machine, not an URI

Convert(Link.YY_ZZ,'.','') will remove the period.

Ok, then go into your job and change DSLink18 and DSLink25 into something different (and hopefully better) and see if the error message still refers to DSLink18 or to the "new" link name.

Have you tried using user-defined SQL and using the #Parameter Name# value in it?