DSXchange

Borat, since it has a capital letter, is a proper noun (in both senses). It is a person's name, albeit a fictitious person, an alter ego of Sacha Baron Cohen. I leave the remaining research as an exercise for the reader.

UTF-8 is a term that covers a multitude of different encodings of Unicode. DataStage actually uses an idiosyncratic encoding that should strictly be called UV-UTF8; it preserves dynamic array delimiter characters as single byte characters, and therefore must map genuine Char(248) through Char(255) i...

No WHERE clause in the DB2 stage? Please check the generated SQL (in the job log).

I dont care abt hw n wat i write, in posts or sms or any personal mails or on messanger..I use abbr to make it fast & its simple enough for anyone to understand..my motive "msg shd be clear" Not everyone here has English as a first, or even second language. Your shortcuts make it more difficult...

Please write in English, otherwise we will send Borat to your site.

And for that to work your DSHOME environment variable has to have been set.

Change the source!

:D (My links were to the 9.6 manuals.)

Not enough information. What other stages are in your job? Are you using a filter command? Does the job execute using the same user ID as you use when you view data? (Have you checked that?)

The UNION ALL ought not to matter, since the ORDER BY is applied after the rows are selected. Involve your support provider - you may need a patch or an upgrade. I have not encountered this particular message except when the rows genuinely were not in the order the developer asserted (on the input l...

And UV.

What I meant was there is no way in the GUI just to put a null into the values in the Test grid. You have to come up with some representation of null (I used the word "NULL", so maybe that wasn't clear). Assign genuine null (system variable @NULL) to Arg1 if this is detected. Wrap everything in $IFD...

Still push back on company policy, or at least ask their reasons (and post them here so we can arm you with the appropriate refutation).

UniVerse System Description or UniVerse User Reference

Yes, Validate.

Reset would have to check the SP, however, to determine whether any transaction needs to be rolled back, cursor(s) to be dropped, and so on.