DSXchange

I am able to fire this SQL statements in toad and the same is working for server jobs. If it something to do with the DB privilages it should not work for Server job either right?

I tried this, even this job is not working giving the same error.

I am using datastage 7.5x2

tnsping is working. I am able to connect to the database with toad and this is working for server jobs also. In parallel job I am able to import the table definition but not able to view data or run the job to extract or write to the database

There are no more details available about the error. The same ODBC seting is working for server jobs.

I tried with both Oracle enterprise and ODBC stage, Its not working

No I am able to view data either. This is not working both for source and targetr stages, No matter what write rule i give.

I hardcoded the connection details. I tried connecting to an access DB in the same server its working but not for Oracle. I am able to connect to the same Oracle DB in a server job but not in a parallel job

Hi all, I am getting an error when I am tring to fetch data or write data to Oracle database using a paralle job. Here is the erro message that I got: Error executing View Data command: ##F TFPM 000281 16:18:03(000) <main_program> Fatal Error: Caught unknown exception in main program: terminating. O...

Thanks a lot for the responses...

Can I get an evaluation version of PX to see if this can be used for my project. If yes, Where can I get this.

I tried the "DD if=<> of =<> conv=<>" unix command. But Even this corrupts the data. I had 18 lines of records in the source after converting using the "DD" function this was reduced to 2 .

By DB EBCDIC function do you mean the database functions. We are using Oracle 9i database. WE could not find a way to load this packed format into Oracle tables. Could you please help us on this.

In my projects I am getting source files from Mainframe system in packed format. I am converting this using the tranformation "DataTypePicComp3()",but we are not getting correct values after conversion. Could anyone help me in this. Is there any other transformation for this.

sorry I will post this in server jobs