DSXchange

Would have been a good idea to mention your "transformation" right up front. Can this be marked as Resolved now?

In other words, those fields are not actually null but have the value "NUL" in them. Perhaps you should be converting them.

Split from another topic, so you'll need to edit your first post if I missed my guess on your particulars regarding version or O/S.

To capture the output, you have to switch the stage from 'Target' to (something like) 'Transform' from what I recall.

Oddly enough, it is "iconv".

Show us your syntax and the datatypes involved.

There's plenty of information out there you can simply google for. Also, our own Vincent McBurney has blogged about it quite a bit on ITToolbox and (as one example) has a video here.

The MKSToolkit installs with DataStage so you do have ls and other 'UNIX' commands available to you. Or you could get dir working as well, I would imagine.

jwiles to csrazdan, not jwiles to chulett. I assume.

The Connectors are 'native' as well.

Could anyone help me in this.... Have some patience. You waited a grand total of 4 hours at a time where people in the States like Ernie are either sleeping or just starting their day. Regardless, the people who volunteer their time here will help whenever and however they can and pushing is counte...

You could certainly have another job that goes thru any job's log looking for information of interest and writes it anywhere you please, including database tables. Case in point - ETLStats from Kim Duke, something he gives away freely from his website. Inspiration? Starting point? It can be whatever...

You can capture warnings that way, however fatal errors are still... well, you know, fatal.

Since you didn't specify, let's get this out of the way - are you running the 8.5 release?

:idea: General rule of thumb: Never simply post an example of your input data followed only by an example of your desired output. By doing so, you are forcing anyone attempting to help to puzzle out the business rule(s) behind how you got from A to B. Help us help you and always include a written ex...

Define "read". I'd also be curious if you've tried this and what the result was.