DSXchange

Writing an own plugin is not something easy. You should do it in any case in a close contact to the Ascential Development Team. An other way for to solve your problem may be an export of a flat file from your database and use the Sequential file plug-in. For to write a plugin contacting the database...

Bonjour Maurice,

you can use environment variables also in DOS/Windows (NT, 2000.....) the syntax is only different.

Setting a Variable in Windows:
SET VAR1=Hello world
Refering a Variable in Windows:
%VAR1%

Wolfgang

Hi Dennis, you are right. Beside the frequence of his answers also the quality is first class. He doesn't know holiday nor Christmas nor Ramadan. Nearly every day he is several times on. I have told him already last year, that if he will pass one day Europe I will open a bottle of the best wine in m...

Hi Luca, easiest way is to write a job like this. [OCI] => TRANSFORMER1] => [TRANSFORMER2] => [SEQUENTIAL] You can do on this way anything you want within the transformers, what you like. - you can filter - you can change it and so on. In transformer2 you may write then nonsens to your sequential fi...

Ralf, DataStage is an anglo-american Tool an when working within this tools you should see, that you keep everything anglo-american. Generally reading Databases with native driver or ODBC and the correct metadata imported and writing to database need no concern from you, but if you read from sequent...

when using dscmdexport this programm needs some *.dlls from DataStage. So you can only start the tool on a Client Maschine with DataStage present on this machine. On a Windows Maschine without DataStage on it (remote Server) you can't use this tool nor any other DataStage Tools.

Wolfgang

luca, for the optimal version of any job only rules of thumb could be given. You are right, that you have to take into account the time of filling the Hashfile. Also with the Hashfile you have several posibilities. One is to fill it completly within the Job an other is to keep it permanent on your f...

Hi dickfong,

have you also started successfully the using the command from the windows commandline?

Wolfgang

Universe and Unidata are RDBMS from a former company called VMARK, which is also the father of DataStage. DataStage until version 6 is on the Basis of Universe. Meanwhile this both products are owned by IBM. If you don't have Unidata in your house you do not need to regard it. Universe it the RDBMS ...

Truncate is a statement in Oracle-dialect. Most Oracle developpers think, that the Oracle slang is the SQL-ANSI-Slang. Access is more SQL-ANSI-like than oracle.

luca, it is right, that there is in the beginning no additional report present but you can use the normal report with the view and print option and you even have by choosing some options to include in the documentation. If you need additional customized reports you have to build them yourself (when ...

Luca,

you can for sure use the Update action "Update existing rows or insert new rows" (Beware of the opposite!!) and your job will work.

If you don't have anything in the file or in a lookup table which tells you what action to proceed use the above action.

Wolfgang

Rogier,

I don't have any more logical ideas how to proceed. Sometimes I have successful results, when I am experimenting a bit.

Ma proposition:
Wrap the job in a batch.
Start the batch from director.
If it runs okay start the batch from commandline.

Wolfgang

Hi Sam, there are several things you should analyse to solve your Problem. As you already know there are two ways to migrate Jobs from on DataStage-Project on a server to an other project on maybe another server. One is Releasing and the other is Export/Import. Both with its advantages and disadvant...

Bonjour Rogier,

How have you defined your ODBC Connection on the Windows Server?

USER DSN or SYSTEM DSN?

Attention it should be SYSTEM DSN!!!

Wolfgang