DSXchange

Just gathering ideas for the book. No, really.

Include the duplicates with UNION ALL instead of UNION - should remove your objection to UNION.

Icons can also default to that "power socket" icon when the client machine is running out of memory. You need to open the stage properties to determine what kind of stage it is. And use Task Manager to spot the memory hog! Of course, that does not help with the "unable to CATALOG" problem, which I'v...

Yep. Floating point numbers (such as pi) can not, by definition, be stored with infinite precision in a finite number of bits. Therefore comparisons between them may not be exact. To get around this, DataStage uses a "close enough" algorithm (called "wide zero"). It is set up in uvconfig as a mask o...

"Error in filter command /xxx/xxx/xxx/xxx.sh" seems fairly obvious as a diagnosis. Do you have execute permission to the shell script? Does the shell script exit with a status code of other than zero?

What if you return the pointer to px?

Maybe dssh would be better than uvsh, even though they're presently the same executable.

The radio show, the books, the CDs, the videotape, the TV series, the movie and the DVD were all different. The scene is Milliways - the Restaurant at the End of the Universe. The speaker is, indeed, Zaphod Beeblebrox. He also asks the maitre d' for the telephone - "hand me the rap-rod, plate captai...

Not Ford Prefect.

Is this thread wandering a little off topic?

My comment: my opinion sounds right

Take Sherlock Holmes's advice; eliminate one factor at a time. Or heed Occam's Razor - don't go looking for unnecessarily complicated explanations.

Modify the WHERE clause to suit your requirements.

Do you preserve the bulk loader data file created by DataStage? If so, does it contain all the rows? If so, the problem is in loading Sybase IQ, and you need to check the bulk loader log file to find out why.

By default, the *.adm files aren't present. And you won't see them even if they are, unless you enable listing of hidden files (for example ls -la .*.adm ) The files are brought into use by using the Administrator client's Permissions tab. Or by using a text editor on the server. File name .develope...

Only DSXchange and Ascential Developer Net

DataStage (server) recognizes four data classes. Numeric - you can do arithmetic and Num(x) returns true String - any data including numeric but not opaque Null - all operations except certain dynamic array operations on these return Null, IsNull() returns true, will abort jobs if used in fixed argu...