DSXchange

As for the swordfish reference, I had to do a google search. That reference is a little before my time. I always liked the Stooges better. Still don't know the phantom reference, though. The Marx Brothers may have started before the Three Stooges (who were originally a vaudeville act - did you know...

The RPC daemon at this release runs as dsprcd, so your netstat command should be filtered for dsrpc rather than uvrpc. This is to enable the UniVerse RPC daemon (which uses port number 31438) and the DataStage RPC daemon (which uses port number 31538) to co-exist. The daemon can be started manually ...

You can move rows up and down in the Columns grid. It's tricky to do until you learn it. Select the Column Name cell in the row you want to move. Do NOT select the entire row. Release the mouse button. Now, using the left mouse button, drag the column name cell to its new location - the mouse pointe...

Hi Ray, The job was working fine earlier. When I moved that to the production environement, it started hating the decimal characters....The data is getting rejected at the target database, failing to insert the record. If NLS can solve the purpose, then how do I do that. Right now I am replacing th...

Hi Mukund! The maximum number of rows in a hashed file is the maximum possible size of a hashed file (2GB by default, larger if 64-bit addressing is enabled). There are storage overheads, however, which you probably have not allowed for. With 32-bit addressing enabled, these overheads can be summari...

The password is "swordfish".

The password is ALWAYS "swordfish".

The first thing I note in your sample data is that you have addresses from more than one country. INTEGRITY has multinational address validation rules, and also domain (country, in this case) recognition, so you can isolate the addresses from each country for more exact cleansing. INTEGRITY further ...

Some (many) European countries use the comma for a decimal place designator. If NLS is enabled, then the NUMERIC locale category will specify the expected decimal place designator character. It is possible, instead of converting the character, to recognize the comma as a decimal place designator. Ar...

What do you mean by another variable? Another environment variable? If you do this in a job control routine, you would invoke the command using the PERFORM statement (or via a call to DSExecute). Since controlled jobs run as child processes of control jobs, they inherit their parents' environment va...

You just did that for the points, yeah?

While noting your original post that you are doing this in a Routine, note also the fact that if you're doing it in an Expression (or, by extension, in a Transform), it must all be on one line.

(This isn't really a Parallel Extender question!) Hopefully the site admin will move it to the correct forum, perhaps DataStage. Surely PIC 9(7)V99 allows for positive or negative numbers. The workaround is simply to edit the copybook so that the - does not appear. And, perhaps, increase the magnitu...

Pretty much every database has "client" software. For DB2 there's an interactive component of Client Access. There are probably others, too. It's really only the name that changes. Alternatively, every database also has an "error codes and messages" manual. This is what you resort to if you absolute...

Wow, nearly a year has gone by since I used the word asseverated! This (restart from the last commit point) is not a problem easily solved generically; a tailored solution is one of the things that competent consultants can provide. It is also probably the reason that it's not a directly inbuilt cap...

The load factors are two threshholds that govern when the hashed file will grow (split) or shrink (merge). When the total amount of data in the file, as a proportion of the file's storage capacity, called the current load, exceeds the split load threshhold, the file grows by one Group Size, and one ...