DSXchange

Why not just "LEFT(In.InputColumnName:STR('0',50),50)" - simpler and uses somewhat less CPU?

What format and datatype is "Date of Birth"? And is "age" an integer number of years?

LEFT(In.InputColumnName:'00000',5) should do the trick for you assuming your datatype is CHAR or VARCHAR

"Phantom" is a historical term from PRIMOS and is just a quaint name for a background process, which is pretty much every DS process! If you search for the file "JOB.1940505370.DT.1479438034.TRANS3" in your project directory and choose the one in the "BP" directory and then open it with your favorit...

So if you read from SQL-Server and write to a sequential file the data has been corrupted? What character set is used in the SQL-Server data?

Server has no concept of dates or timestamps. If you data is in the form "2008-07-01" (i.e. YYYY-MM-DD) then if you sort it, it will be done as a string and will sort correctly, this wouldn't work with a format of DD-MM-YYYY.

The delimiters are spaces or, for formatting, you can use shift-return. IF condition THEN assignment ELSE IF condition THEN assignment ELSE assignment

The problem might be that the "view data" window doesn't always show NLS characters correctly, the only way to be 100% certain that a problem is occurring is to write it to a file and then use your favorite viewing tool which you know works correctly with NLS to view the data.

Is this Server or Parallel? If parallel, use an output PEEK instead of the Netezza stage and see if the "junk" is in the source or the target.

If you don't want to use "vi" on Windows, try Notepad.exe or Wordpad.exe or even WinWord.

You are opening a sequential file. Check to see if it is a "real" file or a named pipe (as suggested by the stage name).

If your integer column is set to be NULLable then it will pass on null values correctly.

I started on the link but they expected far too much time and information from the participants, so I gave up. If you take it, you can at least plug DSXChange in there somewhere.

Are you passing in

"Jobname"

or the actual name of the job you want to find the controller for? Can you do a test and either print out or return the JobHandle variable value?

To add to what Ray has suggested, use "COMO ON {Choose a filename}" to start saving screen IO, then "COMO OFF" to stop. You will then find the screen IO stored in your project directory/&COMO&/{Your Chosen filename}.