DSXchange

Why are you using DB2 API stage rather than DB2 Enterprise stage? (There can be valid reasons for this.) If you're on version 8.1 you really should use a DB2 Connector.

Now you know the source of the error and may more closely focus your diagnostic efforts. Check whether there is a metadata mismatch; the stored procedure stage does not report these.

DataStage will create the control and data files.

Sometimes you might like to create a custom control file separately from DataStage and just have DataStage create the data file. This is also an acceptable approach.

Both UniVerse and Unidata are independent database products. Between 2000 and 2009 they were owned and marketed by IBM; in October 2009 they were sold to Rocket Sotftware. Both were created in the mid-1980s to try to take some of the market share of Prime INFORMATION. The original vendor of UniVerse...

You seem to have two threads operating for this question!

Not because of that. But the new server may well have faster CPUs, which will make a difference. DataStage 7.5 is a 32-bit application, so does not take any advantage of a 64-bit architecture. You must make sure that 32-bit versions of commands and libraries are found by DataStage before the 64-bit ...

Welcome aboard. You have posted in the wrong forum, and demanded an answer ASAP. Moderator: please move to Enterprise Edition (parallel) forum DSXchange is an all-volunteer site whose members post as and when (and if) they can. We don't do "urgent". If you want "urgent" or "...

Something like the following code would appear to meet the requirement. FUNCTION GetController(JobName) $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF If UnAssigned(JobName) Or (Len(JobName) = 0) Then Ans = @NULL End Else hJob = DSAttachJob(JobName, DSJ.ERRNONE) Controller = DSGetJobInf...

But how u call this function in server transformer.... Your original question was how to do it in a routine. People have been answering that question. I doubt that U (one of our posters) is interested in calling this function at all, but I could be wrong. The second person personal pronoun in Engli...

Welcome aboard. Never reinvent the wheel if you don't have to. There are already written routines here.

I would strongly suggest you get some experience actually using the product. For example, can you remember the different things that are signified by red flags, green flags, red squares, green squares, red triangles?

Just think about what parallel execution mode might mean for an XML Output stage. What are the "records" to be partitioned? How are you specifying that they be partitioned? What do you expect to be produced - multiple output files? After all, what you deal with in XML is a free-format stru...

You can begin by effecting a Search of DSXchange. This error code has been discussed many times before. You could even read the documentation associated with the definition of the constant in the JOBCONTROL.H header file in DSINCLUDE. Bad state means that the job (instance) was not in a runnable sta...

Yes and no. You can perform the two lookups, but you can not do either of AND or OR in a Lookup stage. The test must be in a downstream Transformer or Filter stage.

OK triggers do not have any effect. When automatic handling is enabled one of the following occurs: if there is an explicit Failure trigger this handles the failure if there is no explicit Failure trigger but there is an Exception handler, then the Exception handler will fire if there is neither an ...