DSXchange

I have DS installation version 8.1.0.1 on RHEL 5.2, the same installation is working at our client machine, but locally most command line tools fail with: An error has occurred during DataStage initialization Please contact the system administrator Error code: 3 22 For example: uvsh, dslictool, smat...

the Oracle Enterprize stage its giving me sql code as -1400. I am using upsert method. I think you're trying to insert empty string '' not a space ' ' into Oracle. Because Ora-1400 means not able to insert null into not nullable column and Oracle treats the empty string as NULL. Re-check your fixed...

ArndW wrote:while the modify stage is an OSH call, transform stages are compiled c programs that are executed at runtime.

This means that Modify stage has better performance than the transformer as the transformer is executed at the runtime?

an error is generated only if both actions fail, the insert and then the update. Got them. I changed the Upsert Mode to 'user-defined Update & Insert' and copied the insert statement to update statement place as I don't expect any updates. And I captured them. :) Thanks Arnd & chulett for y...

- Stage is Oracle Enterprise Stage
- The Write Method is 'Upsert'
- Upsert Order is 'Insert then Update'
- Upsert Mode is 'Auro-generted Update & Insert'

The data source table have no physical primary key but the destination have, I need to capture those records which are not inserted.

Regards.

Any Suggestions?

Any Suggestions?

The Oracle enterprise stage performs a strange behavior here. The inserted data into the stage contains redundant data but it's not rejecting them although it inserts only the unique records into the database according to the primary keys? And there're no warning at the job log. I'm enabling the 'Ou...

Thanks chulett, you're right I've no previous idea about this feature in DataStage and it's urgent as the client needs such an ETL report and I need to know how to implement first, and how much time it will take.

Thanks again.

Saikailas & kduke,

would you please share any posts or topics which can guide me to generate such ETL status report for project jobs because i'm quite new to this & I need it urgently?

Regards.

ArndW wrote:If you monitor physical and virtual memory usage during the job run, do you see a large amount of memory used or constant growth until out of memory?

How can I do that?

May be a new clue here. The job aborts while it transfers all data from source to destination Correctly? At Director, it generates SIGSEGV or "*** glibc detected *** free(): invalid next size (normal): 0x08395fe8 ***" errors. At the second the run after reset, job runs normally without war...

it's not always gospel as the viewer has issues of its own. Use it as a general check of correctness but when you really really need to know what's in there, use another tool. That's right. Just for the record, sqlplus & Toad were viewing (REAL,FLOAT,DOUBLE) data correctly, but DataStage viewer...

I found out an important fact here that DataStage has no problem with REAL, DOUBLE, OR FLOAT datatypes. DataStage transfers data as it stored as the source even it was REAL datatype. I realized that the main issue when inserting REAL data into Oracle database that it could be inserted in a wrong way...

ArndW, my data source is Oracle RDB not DB2 and I'm quite sure that its character set is US7ASCII.