DSXchange

In the Chapter in the Modify stage in the Parallel Job Developer's Guide is a table showing what data type conversions can happen automatically and which ones require a function. Read that first. Then read through the available data type conversion and cast functions.

Look in the file RT_BP1095/JOB.166157985.DT.1400823392.TRANS1 on your server around about the line numbers indicated. Identify the corresponding expressions in your Transformer stage, and add If functions to make sure that zero-valued divisors are properly handled.

Doesn't matter. You can extract the contents of the parentheses with Field(Field(TheString, "(", 2, 1), ")", 1, 1) - possibly having used the Index() function in an If statement to determine whether there are parentheses.

The only way, in server jobs, to suppress warnings of this kind is to pre-check the data so that you do not send duplicate key values to be INSERTed into the table.

Oconv() is not natively available in parallel jobs.

Contact me off line. I have some materials that might be appropriate.

Etymologically at least, invocation could be defined as putting something in the VOC file. This definition is not appropriate in the context of DataStage.

It really does look like an interview question. There are three ways to create a job control routine within DataStage server jobs. These are two of them. The other is hand coding, with some templating assistance (if required) from the Designer tool. If you've read this far you've paid for premium me...

DataStage server routines are of three kinds. A transform function takes one or more arguments and returns a result. It is intended to be invoked from Transformer stages and Routine activities. A before/after subroutine takes precisely two arguments, one input (from the Input Values field), the othe...

Developer role can't touch a protected project.

In Hawk the same repository is used by not only DataStage but also InformationAnalyzer (formerly AuditStage, ProfileStage and some of the QualityStage investigation pieces), QualityStage and MetaStage. And you won't have direct access to the repository at all - there is a layer of services between y...

With DataStage you can install a "run only" client license. This has "-DSDIR" as the last part of its authorization code, rather than "-DSDES".

IBM (the vendor) regularly offers both DataStage Essentials for Enterprise Edition and Advanced DataStage for Enterprise Edition. The former has been re-written recently, in parallel with development of the certification examination. If the people are already competent with server edition, then the ...

where Create_Date>'#PARMDATE#'

Initialize before invoking the job, either from a job sequence or job control routine, or when prompted for a value.