DSXchange

Too busy right now (at least for a week).

Preprocess the pipe delimited column into separate columns before applying the Pivot stage. This is easily accomplished in a Transformer stage.

You won't be able to use a message handler in a server job. Oracle defaults to reporting 38,10 if the Oracle data type is an unqualified NUMBER. DataStage isn't insisting upon anything. Under the covers, the ODBC stage in server jobs uses BCI functions; therefore it is subject to the same constraint...

Search the forum, say for "invalid transaction state". More information, and your solution, will be revealed.

Whether you're using NLS or not, you can be specific about the order of components in the date, and Iconv() will always work. For example, in your case: Iconv("31 DEC 1967", "DDMY").

Read this wiki entry to enhance your understanding.

Once sqlldr has started things are out of DataStage's control. There is no way that DataStage can detect (while sqlldr is running), much less intercept, any errors in the load.

DataStage can check the sqlldr log and/or bad files after the load is complete, but that's about all.

Use the UNIX command cat file1 file2 > file3

You don't need DataStage for this one.

Etiquette Note 1 If it's urgent, sign up with your support provider for premium service, and learn the true cost of "urgent". When you posted it was the middle of the night in the USA. We don't do "urgent" here. DSXchange is an all volunteer site, folks post as and when they can, and none of them g...

I am unaware of any way to achieve this in server jobs. Doubtless some kind of wizard could be written to read the file and create the table definition in the DataStage Repository - indeed, I've done that, but what becomes of the metadata after that? There's no extra information in the file about wh...

(1) Provide a Null Field Value property for any nullable field in the Sequential File stage. (2) Handle any possible NULL value for DATE_ID explicitly. Make sure you never have nullable on the input and not nullable on the output of a stage. The Aggregator stage will generate this warning irrespecti...

It ought to be possible, but you would need to guarantee that only one file matches the regular expression if you are planning to use it as the filename property directly. Otherwise, specify a filter command of cat feedata_*_1_????.txt and use /dev/null as the file name. The stage will read stdout f...

My error, it's an underscore; DS_CONNECT.

Type in HELP CONNECT at the ">" prompt to learn more about it. DS_CONNECT is the same as CONNECT, but includes the override for the Data Direct ODBC drivers; that is, DS_CONNECT is licensed to use them.

You can do it in the same run, but would need to split your source data into two streams and use two Change Data Capture stages, one for each.

How you combine the results is up to you, and will be driven by your business requirements, about which we have no information.

Take a look at the score. This will show you the buffer operators that were inserted to avoid data flow deadlock situations. There are at least two of these (buffer(1) is the second). Based on the virtual Data Sets these are using, you might discern what is happening. My guess is that the TCP port n...

What were your search criteria? A "search for all terms" inquiry on "jobs sequence list" returns 115 hits, some of which are pertinent.