DSXchange

i do not understand what is your problem. Please describe it more clearly.

de_conne, tell me the case, where this doesn't work and Arnd doesn't get his 100 %

It works just the way as Arnd wrote. Alternatives are to write it into any Database (Access, Oracle....) and use a Frontend-Tool (Word, Excel, BusinessObjects ....) which all can produce *.pdf-files. With windows Batch you can automate this.

If you can connect to db2 AIX, the basic db2-connect is into your world. ODBC allone is neither possible without it. What you should do or you should let do is to install the Mainframe connect into the catalogue of DB2 on your Server.

Craig is right. To install the samples and look at their details helps very well to understand the way XML and DataStage work.

If you are looking for a tool, that does import and compile from a windows command line you should concern "dsmove".

you should at lease write:
a apostroph ' before and after the param.

Look in your manual.

Dear RK, please describe clearly all your machines (operation system) The machine, where DataStage Server is on The machine, where Oracle Database is on On the machine where your DataStage Server is on you have to: (1) Have at least a Oracle Client on (2) Have to put manualy several lines concerning...

Transaction handling with commit and rollback is a good and nessary feature of all databases. It was and is intended for normal database usage as to insert one order at a time which has several tables. You can use this feature also within ETL-processes, but for that purpose it is in my oppinion a ce...

read the manual and first try to access the DB2-Tables from the Windows 2003 server directly without DataStage. Use a client Installation on this Machine.

All detail can be found also in the Manual.

(1) Oracle Client has to be installed on the same Machine as DataStage resides.

(2) Details for to connect ot oracle has to be set in the dsenv file of your DataStage Machine.

(3) Best is to read the manual and do as described there.

yes

This is no universe code.

What do you realy want to do?

Вы хотите сделать? Опишите с словами.

use transformer stage