DSXchange

Are you using the same configuration file and the same partitioning when reading the Data Set that were used when it was written? If not you are incurring the cost of repartitioning these data, as well as of partitioning the sequential file data (which is unavoidable for parallel execution).

Almost no difference at all when performing a SELECT operation. The Oracle Enterprise is constrained to executing in sequential mode because of the way that Oracle delivers the result set. However, the Oracle Enterprise stage can quite happily perform parallel Upsert operations or parallel Load oper...

Your understanding is imperfect. The BAPI stage actually generates ABAP code that is passed to the SAP environment for execution.

Just about any stage in a parallel job has an "Insert Job Parameter" tool or a "Job Parameter" selection from an expression editor menu.

SQL via ODBC Enterprise stage using driver for text files?

I also sell DataStage curriculum. See my web site (link from signature block). Then contact me off line for pricing, delivery (if needed), etc.

What is the default value set in the Administrator client for this environment variable?

It can not be $PROJDEF, $ENV or $UNSET; it must be a "proper" value. $PROJDEF is only to use as the default value of a job parameter, not of an environment variable.

Never believe anyone who says "should be". Check.

Do you need the system time "now", or the system time when the job started? If the former, you could use SYSDATE as the default value for the column and not insert it from the DataStage job. Or Oconv(Date(), "D-YMD[4,2,2]") : " " : Oconv(Time(), "...

RFC is one of the two available mechanisms for getting ABAP code generated in DataStage to be sent to the SAP environment. Read the documentation that accompanies your SAP R/3 Load PACK.

Read the manual for the Complex Flat File stage (cff.pdf) and learn about (lack of) support for OCCURS DEPENDING ON.

Everything except the example job supplied by the vendor, which uses a different value to mark it as read-only. This may be a desirable result for jobs - after all, they're all designed in-house, and can be switched back to read-only if desired using a similar UPDATE statement. UPDATE DS_JOBOBJECTS ...

Oracle functions are used within SQL queries. You can put them into the Derivation column in the Columns grid when selecting, or in user-defined SQL.

... and repeated assertions that the problem is not with the configuration file.

Like any QA person, an advanced sense of cynicism is essential. Skill in constructing test cases (you may need to create test data according to specifications) is also vital. Ultimately, testing not only needs to ensure that jobs finish OK, it needs to test that they produce correct results; that al...