DSXchange

Instead of using the CHAR(13) {which is <cr>}, use CHAR(10) {which is <lf>}.

Most of the parameters in the uvconfig file don't need to be modified. The few that may be changed are covered in this forum. If you really wish to know more, download the IBM pdf document Administering UniVerse and look at chapter 4 for a description of the uvconfig file. Please note that not all t...

Have you thought about using the MKS Toolkit or a similar set of utilities and implementing "rsh" and/or "ssh" to to this? If you are remaining in the Windows environment you can use the Microsoft built-in facilities for remote command execution as well. All of these commands can be executed in para...

I would suggest starting in the Parallel Job Developer's Guide, pages 58-9 onwards. This details the basic configuration setup required by PX to run on a distributed system configuration - as you've stated this is the way that a future true grid solution will work with PX jobs. Although this is not ...

Erik, What sort of a tool are you looking for - one that works under Windows in a similar way to the UNIX "rsh"? You can call OS commands from DataStage, so almost any command you can call from a command window can also be called from DataStage and return both an error code and all of the screen out...

It does seem to be something to do with NLS; were the jobs written with NLS enabled and/or is this new installation NLS-enabled?

A search of the forum revealed only one related post

No pitfalls unless you have encrypted values in there; I'm not sure that they will re-parse.

Hemant,

you will need to supply more information. Are all jobs aborting, all the time? Is it always player 11? What has changed between the time when youir jobs were running and now?

Kumar - I see what you mean; I went back and saw that the poster did use a constant text, not data. So it really ought to have worked, regardless of any NLS setting!

Kumar - I don't understand what your post means. The point of my question was to make sure that the string contains a "0" character as we expect it - namely one which has ascii value of 48. If the string contains another glyph then then you would need to change the TRIM function to remove that. All ...

AnjinReddy,

you posted the question in a PX forum, but specified Windows/Server in the comments. Could you specify which system you are actually using, and what your error message is?

Hello Sri, A NULL and an empty string are different values. Are you saying that ISNULL() and ISNOTNULL() have a bug or that they aren't working the way you expect them to? If you are reading the values from a csv file as you showed, you will be getting empty fields and not NULL values, so your ISNUL...

Yep - thanks for the correction.

<sarcasm=on> Ray, the google search of "crc32 c++ function" returned over 81,000 pages to me. I think that is too much. Could you help me and Somaraju out? Please write (and of course debug) the parallel routine and post it here for us? <sarcasm=off> Somaraju, the CRC32 algorithm is not only availab...

Sri, let's take the problems you are having one at a time, that way it might turn out that you don't have that many issues but just one or two. NULL and ISNOTNULL work. Always. Accept that as a given and you can start analyzing your data. If a string of length 0 comes from the FTP (or sequential or ...