DSXchange

This is coming from your Sequencer job log? My guess is that your Job Y has aborted. You need to go look in the log of that job and figure out why the job blew up. The stage Getid may still be operating as a zombied process, so check to see if that process is still running, which could be why the se...

Writing to a file will impose file structure maintenance challenges (we have a lot of these jobs running and all of them need this). What are you talking about? I don't think you understand the trick. Every job will have a specific column structure relative to that job. Write it to a sequential fil...

Ascential wanted to be able to tick that box (so as not to lose an easy ranking point) whilst expending the least effort and expense developing a basically redundant feature. Hellooooo, Feature Bloat. Shiny objects to dazzle the eye during sales presentations. Poor implementation on the backend... ...

Craigs suggestions are all good. But you have to realize that your SELECT in the source OCI is also consuming rollback segment because you're holding all of that source data as well. With 20+ million rows held, you're running the risk that other activity in the database will require rollback and the...

Check out the perl libraries. They have freely available libraries that read .xls files and normalize the worksheets into separate files.

Otherwise, re-read Ray's last post, because he states worksheets are different tables. You'll need to know the worksheet names to know the table names.

Woohoo.

From a TCL prompt, do a SORT-ITEM DS_JOBOBJECTS to get a text dump, you'll see all the stage pieces and parts. Compile the job and look in RT_BPnnn at the text files there and you'll see your job design. Look in RT_BPnnn.o and you'll see the executables.

RT_CONFIGnnn is runtime configuration information. Run the job once and checkout the contents. Look at RT_STATUSnnn change as the job executes. Look at RT_LOGnnn to see log messages. Look at DS_JOBOBJECTS and have a bucket ready in case you spill your dinner. Look at RT_BPnnn to see your job written...

May be you can use two different links (writing to the same file) Only if it's a hash file. Sequential files can't have multiple input links to the same file, they have to be separate files and later you concatenate. Using a hash file solves this issue as long as the primary key is unique, but you ...

Doesn't exist. Since IBM now owns Version, you need to go to them with the enhancement request. There are capabilities to get at this information, but if you don't know DS BASIC well or have a background in the Universe engine from which the DS Engine is derived you have a long way to go. One of the...

Use the dsjob API to dump log summaries. If you want full log dumps, youre going to have to write something using intenal knowledge of the job repository. The APIs are not complete enough to give you full dumps of the job log. The simplest thing to do is cross-reference the job name to the job numbe...

Yep, you need to create the project first. Then, copy the all files from under one project folder into the new project folder. You should see everything exactly copied over. What you can't do is magick an account into a project. Back in release 4 and prior DS was licensed by the project, now you get...

It sounds like any reject is treated as fatal. There might be some way of going into the driver connection information in the .odbc.ini file and adjusted some setting there, but it's probably slim. Have fun, I'll stop dragging out the conversation.

I really can't track your data example. Separate your files into distinct rows when posting please, it's really awkward the way you did it. If what you are saying is that one input row could have multiple issues, and you want each issue to be a separate output row, then you have to rethink your job ...

Does it abort at 50 warning messages or on the first reject? If it's on the warning messages, that can be accommodated. I'm not saying you don't know what you're doing, but if you're using job control to run the job you need to make sure that the setting is unlimited. If you're running from Director...