DSXchange

Get Parameter Manager for DataStage.
You can find out about it from here

I've just checked on a DataStage version 5.2 system. There is no supplied DSWaitForJobList function here. Therefore, if you do have it, and it's compiled, it's in the "user written functions" part of the repository, so your DEFFUN declaration must refer to "DSU.DSWaitForJobList". DEFFUN DSWaitForJob...

"Array never dimensioned" errors usually mean that you've forgotten to include a DEFFUN declaration for a function. When the compiler encounters an identifier followed by a left parenthesis it assumes - because it's not been informed that the identifier is a function name - that the identifier is th...

The obvious one is user IDs, permissions and privileges in the DataStage environment. A slightly less obvious one is things like system tables and indexes. Another less obvious one is licensing. Is it the same UNIX? If it isn't, your licensing won't be valid on the new system. I would not advocate y...

Can't you do someuser-defined SQL like:



Your job only provides values for c1, c2, c4 and c5.

Isolate the actual error messages. What do these tell you? APT_TeraUtils: Slave session CLI Error:: 'Fetch failed: Error Code = 220', error code = 1 message: 'Fetch failed: Error Code = 220' DBCAREA msg_txt: MTDP: EM_DBC_CRASH_A(220): Network connection to the DBC was lost. (The next piece reports t...

Unless it's a "reset if needed then run" from a job sequence there is no such thing as automatic reset. A job can not reset itself if it has aborted. Recompiling the job has the same effect as resetting it. Maybe that's what's happened. Otherwise I suspect that one of your colleagues/operators has t...

Hello everyone, I am new to SDXchange and Ascential. I need to validate certain data coming in from an outside client an place it in an output file: My validations looks like this: If [field 4] > 0, [field 5] should have a date, if not reject the record If [field 5] has a date, [field 4] should hav...

:D Thank you very much!!! Now all it is working fine. Your original post suggested that you were working on a 390 canvas. Clearly this is not the case; mainframe jobs generate COBOL code that is compiled and executed on a mainframe (OS/390) machine, and has no facility whatsoever for executing BASI...

Pseudo code. Open input file for sequential access. Open output file for sequential access. Loop Read next line. Loop Search for closing tag. A closing tag matches the pattern "'</'0X'>'". (A line containing a closing tag matches the pattern "0X'</'0X'>'0X".) Remove the f...

Sorry for may be very simple question, but I can't imagine how to make it easy. Can I use datastage for simple backup of database or transfer the whole database from one host to another(for example). And what is the the simplest way to do this job? For example if I have 50 tables with the same colu...

Nice try, but there isn't one. What you need to do is any of the following. 1. When the job finishes detect its exit status using dsjob. If the exit status is "aborted", then run dsjob again, with -mode reset. 2. Run each job using a parent controlling job or job sequence. When the job finishes dete...

Do you want the solution to the four rows, four columns transpose (which is what you sought in your first mail)? Probably the easiest is to use a Routine or stage variables to capture and accumulate the results, write the output to a text file, then subsequently process just the last four lines of t...

What's not clear in my previous post?

You can NOT use expressions in the Derivations column on the Outputs tab of the Pivot stage. This grid is ONLY for specifying how the input columns are to be pivotted onto the output link.

The Pivot stage does NOT change data. You use a Transformer stage to change data. The only derivations in the Pivot stage are: (a) empty (a key column from the input is a pivot key - preserved in every output row) (b) a single input column (a non-key column from the input is a pivot key - preserved ...