DSXchange

Please note that ASAP is something you pay for in the software industry, and since this is a volunteer site you usually will get a slower response when you use the terms ASAP or urgent in the post; much of the time I will not even answer that type of question for a couple of hours. Excel can be read...

Do you get the same error when you use the dsjob command from the UNIX command line to start your job?

I'm not sure what your question is, dsdoubt. You need to make sure that the number of columns in the query matches that defined in the stage.

No, the license keys are different and are valid only for the OS and configuration given.

Yes, that is true. I was wondering how "code" could be wrong but didn't notice that you had specified your SELECT explicitly. Usually the query that DS generates by default is good enough. Sorry about misdirecting you.

It seems that "CODE" is an invalid column name. Does the error persist if you use and different column name?

I've just finished some work on using public cache on a large P595 AIX machine with 12 CPUs with an attached EMC storage array; this system was idle while I tested so the results are more of a single-user test than a real multi-user one with hundreds of users. Since I am working today and not playin...

(This could be an interesting thread if everyone would post 1 additional commandment ; we'll certainly get more than 10 but it will be interesting!) #1 Don't think or design in terms of the server jobs you know The designer canvas and identical looking designer objects lull you into the false sense ...

A pretty good time to think about using a sparse lookup is when your lookup contains 1 million rows and your incoming data stream contains a few hundred.

Thanks for confirming that my issues weren't just due to me being stupid. I've just managed to get another whole LPAR to play with and am starting to experiment with publich sharing. Unfortunately the limit is 512Mb and this machine has 60Gb of memory for me to use... We have gotten hashed files of ...

A while ago at a customer site I tested the system level public hashed file disk caching mechanism, with less than stellar results. The functionality as described in the Ascential DataStage Hash Stage Disk Caching guide (sorry Ray, that's the title...) did work with multiple users sharing common fil...

In that case look into calling dsjob from your command line with the -log and other options.

DataStage transform stages have @INROWNUM and @OUTROWNUM available, so you no longer need to use your own stage variables for this.

What delimiter are you using? Is it a 3-character string "@@#"?

This is a windows option in the print subsystem.