DSXchange

The BASIC Transform stage has always been available, but it isn't found in the list of stages. In the Designer you need to access via the directory tree. See the following screenshot for the location:

If the peek isn't showing timezones then none are being passed to the DB, which might be the source of your problem.

What is the datatype going into the peek stage of the column in question?

Unless you control the creation of a new GUID inside DataStage then you will have to choose the path you outlined involving writing, then reading the newly created record in order to retrieve the GUID.

If you wish to auto-generate the header row then the simplest solution would be to not add this terminator in the DataStage flow, but subsequently in an after-job command or from a job-sequence, simply use something like

Can you put a peek stage into your job right at last possible stage to show what DataStage thinks it is writing?

To confirm that you are in the right database in the right environment, what happens if you write a test job with the SQL "SELECT TABLE_ID FROM VEN_DETAILS "?

If "slapped" means "subtracted" then another question would be : What time zone are you in? GMT -5 by any chance?

UTF-8 can have characters of more than 2 bytes. So the question is do you want to perform some action on any character that is more than 1 byte long? And what exactly do you mean, in this context, by "escaping" them? Putting a "\" in front of them?

Not that I know of, but you've mentioned the single most important factor for your organisation that outweighs other factors.

Not really, but you could fake it by using just one column per row (if the file has CR/LF) or by using a dummy column with fixed length and accepting an error on the last row.

I don't have the install guide handy, but it used to be a requirement that the (correct) compiler is installed prior to installing the DataStage server so the worse case scenario is uninstalling DataStage and then re-installing it. Does your post mean that there is no "windows.h" file on t...

This is a good example of either a support contract or, at the very least, a Premium Membership here show its value. It is Sunday, and this is an all-volunteer forum. You have posted in "DSXChange Testimonials", an inappropriate forum. Had you read the requested readme, you would have seen...

Hello Ray,

I wasn't aware of that; does that mean that jobs don't use a UNIX type fork mechanism anymore?

Convert(Char(11):Char(0),'',In.Column) should work to remove those 2.

Since DataStage is delivered with MKS Toolkit, you can do a "head -1 <file> | od -x" to see what exactly those characters are.
For the column in question you should also check the column output details, perhaps you have a conversion which you don't expect.