DSXchange

Basically, you have to track down why Oracle believes you've used an invalid number. The only possibility in your query is 'Y'. Check the data type of IS_EXPIRED (use DESCRIBE).

What you need to remember (or remind yourself by inspecting the generated OSH in Job Properties) is that, everywhere you have a link, there is a virtual Data Set. So, in theory, you should be able to look up against anything. However, note that the "sparse lookup" strategy for DB2, Oracle work a lit...

WHERE ORCHESTRATE.INPUTFIELD > -1 Because you're working on a lookup, you have to have a WHERE clause, one that will always return a row. Elsewhere on the Forum (perhaps you found it in a search) I posted a similar solution for Oracle, from memory WHERE ROWNUM = :1 and provided 1 as the reference k...

That's the old way, but still works. Nowadays most stage types have a property called Commit Row Interval.

Just as a point of interest, if the text file is fixed-width format, then a parallel job can automatically read it in parallel. Because the row size and file size are known, the beginning and ending offset for each read can be pre-calculated. Therefore multiple read processes can be applied to the i...

This is something that happens in lots of applications, not just the Ascential suite. The final line lacks a terminator, and the application either hangs or complains because it's not there.
One for your "tips and tricks" folder!

1) Simply does not work. IPC stage requires row buffering enabled. 2) The two active stages run in the same process, but rows are buffered so that the upstream stage can begin processing a row as soon as it has finished with its predecessor (rather than waiting for the row to pass right through the ...

That's not actually a question. I'm guessing that you want to know how to enable the "Unlock All" selection. You must select a process from the upper pane first. If that process owns any locks, then Unlock All will be enabled, to release all locks held by that process. Whether or not it works will b...

Call a shell script from an after-stage subroutine or after-job subroutine. Specify ExecSH as the subroutine, and add the pathname of the shell script plus any command line arguments (which can be job parameter references) in the Input Value field. Or you can write your own before/after subroutine -...

Editing the VOC file is fraught with danger for the inexperienced. If you cause some damage, for example by deleting vital records, your support provider will not talk to you.

OLETYPE is 'CSeqInput' and 'CSeqOutput' for Sequential File stages. Note that other stage types can also generate sequential files, in particular the bulk loader stages. Or, perhaps, and ODBC stage invoking the driver for text files. If you want to intercept these as well, then you will need to adap...

Not my experience on AIX.

Or...

get a bigger stick then counsel patience


(It's no coincidence that SAP also means South African Police!)

If something external to DataStage is locking the table there is nothing DataStage can do except wait for that lock to be released. All YOU can do is scheduled the DataStage job to run at a time (and lock the table) when the mainframe is not locking the table. This isn't a DataStage problem. You wou...

To run simultaneously you do NOT join the job activities to each other with links.