DSXchange

We have PROD, ACCP and DEV projects in the same Server. There is a scheduler sequence that calls other sequences and it is scheduled to run nightly. Intermittenly the sequences/jobs that are being called fail - each time it could be a different job. Some sequences/jobs are called in parallel others ...

You can not remove the eof character - the operating system needs this to tell it when to stop reading the file. Make sure that every line in the file, including the last line, has a correct line terminator. Your metadata expects it to. Hi Ray Unfortunately I don't have control over that - the file...

hi , please use tr -d command in the sequential file stage..that could resolve the problem.. for the verification check the same command in unix using the following command. tr -d '\r' <oldfile> newfile. thanks.. 1. So are you saying I can use tr -d in the file pattern property of Sequential File S...

Reading from a fixed-length sequential file stage using Read Methos = File Pattern, to read multiple files. Final Delimiter = END, Field Delimiter = None Getting the following warnings: SRC_pharmacy_inputfile,0: Missing record delimiter "\r\n", saw EOF instead SRC_pharmacy_inputfile,0: Imp...

Either the questions were too vague, too tough or too easy!

Thanks Craig

Does ExecCommand wait for the command (.exe or .bat) to complete or does it just launch by sending it to the OS and returns success? Could not find this in the help file or the site. Is the behaviour different if the cmd is run via job before/after subroutine?

Thanks

Hi ArndW Thanks for your valuable answer. I have a question about option 2 answer. You said "DataStage will run the procedure sequentially, per processing node." Does that mean Stored Procedure Stage will run an instance of stored proc on each node with different parameters coming from the...

Hi All My requirement is to call a DB2 stored proc 25 times in parallel with different INPUT parameters. The sp returns 2 status columns in a single row. We are going to use Stored Procedure Stage to run SPs. We have an after job subroutine that tests if the value returned by the sp was a success or...

Hi Stefan

Thanks for the answer, it was helpful.

Hi Miwinter

As mentioned, "generally" cross-platform is not an issue but I was wandering have you actually tested this?

And regarding the other questions:

Can we connect to a specific partitions on DB2, using any DB2 API/EE/PLUG-IN, ODBC or DRS?

Thanks for your help

No clue how the "DPF" part affects this answer but outside of that it's still a "no". There's no database that needs to be "co-resident" to work with DataStage that I am aware of. Or to utilize DB2 parallelism. Hi Chullet The ques in the above mentioned post is: I have...

chulett wrote:I don't see him saying any such thing. Can you point out the part you are referring to, please?

May be my question is incomplete instead. I wanted to know if DB2 Enterprise Stage requires both DS and DB2 to be on same platform inorder to utilize DB2 parallelism or DPF?

Oooo, oooo - I don't do DB2 but I can answer one of the questions! :wink: 2. Nope! I found this post: http://dsxchange.com/viewtopic.php?t=112136&sid=155d2b832dff144350a565f2a8ccc550 Where Ray said the answer to # 2 is Yes. Now I am confused which one is true. But I guess thats for 7.x, has thi...

ENVR: We have a mixture of physical hosts and logical partitions on DB2 DB Server with DPF. 1 coordinator host (Partition #0) and 3 data hosts, each with 4 logical partitions (Partitions #1-#4, #4-#8 and #8-#12) Most of the data is on partitions 1 through 12, we usually connect to partition #0 (whic...