DSXchange

jreddy wrote:Ray, how would be set the value returned from Oracle job/table to the userStatus variable

In a job that selects the value from Oracle use an interlude to DSSetUserStatus() function as the derivation in a Transformer stage. Search the forum for sample code.

The message suggest that your job design has, or should have, a Switch stage upstream of the Match stage. Without knowing your design, I find it difficult to be more precise than that. What does your support provider have to offer?

This error usually occurs when there is at least one row in your data file that contains more columns than are specified in the file dictionary for that file. That is the first thing that you must check. The easy way is to determine the number of lines in the file ( wc -l ) and divide by the line le...

Sequencers only have unconditional triggers.

If you are having this problem in a job sequence, chances are that you require the DataStage patch for Windows XP sp2, which can be had for asking from your support provider.

Create a parallel routine, which is an interlude in the Repository explaining where the C function is to be found and the argument types it requires. If the C program includes a main() function, you will need to call it as if it is a command, for example from an Execute Command activity in a job seq...

What have you listed here? It looks like the outout from DSGetLogSummary(). We really need detail of log events to be able to diagnose the problems more thoroughly. You may also need to disable combination, at least in the ODBC/DRS stage, to isolate the stage in which the errors are occurring.

It's what electrical engineers know as "back emf" (which I learned in my BE degree in the 1960s).

You can also get a version of DataStage that runs on "UNIX Support Services" (USS), which is a partition of a mainframe pretending to be running AIX.

You don't need anything intermediate. You can select the value directly into the reference link into a Lookup stage. Make sure that partitioning is Entire. Then add this (constant) value to the zero-based sequence generated in the Surrogate Key Generator or Column Generator stage, where it should ha...

"All zeroes" is not a legitimate decimal number. Read about it in the manual. There is a setting (environment variable?) that allows DataStage to tolerate it.

"node1" and "node2" are each named twice in the configuration file. That's almost certainly an "issue". In the job log, what is reported as the configuration file used? Are you using the same configuration file when reading the Data Set that you used when writing the Data Set? Are there any repartit...

Your data do not match your metadata, or the phpBB software has removed your spaces. I assume that you mean your data look like RAY ...... FITZGERALD HIGGINS .. MICHAEL .. ORLOW .... JANICE ... H What have you specified as: record delimiter field delimiter record length? Try record length = fixed

Have you tried revisiting Set Defaults in the Director's Job menu and clicking on "Set to Default" or "All to Default"?

I can't check at the moment. My experience is that $PROJDEF works in 7.5.1A for string parameters, but I wonder is this also the case for encrypted parameters?

The helper subroutines (DSR_xxxx) are just that - subroutines. They are not functions. Arg2, in this particular case, is an input/output argument. A1 = 5 A2 = 2 A3 = "RateFileCreate" Call DSR_AUDIT(A1, A2, A3) Ans = A2 The problem with using undocumented subroutines is that you don...