DSXchange

Dears, I'm transferring around 35,000 records from Oracle Rdb to Oracle 10g. At each run, I've got different glibc error as follows: *** glibc detected *** free(): invalid next size (normal): 0x08395fe8 *** *** glibc detected *** double free or corruption (!prev): 0x0837a0a0 *** *** glibc detected *...

Dears, I've got the following error when job updates around 20,000 records at the destination: Operator terminated abnormally: received signal SIGSEGV. If any one knows the root causes of SIGSEGV error, kindly share them because it appears frequently and just disappear when reset the jobs without kn...

Regarding your technique at 'Truncate & Insert', you put the truncate statement at the Update query and the inset one at the insert query. How can you guarantee that update query will be executed before the insert one? in other words, truncation before insertion talking into consideration the PK...

I think increasing the 'Transaction Size' and 'Array Size' at the Options tab can make it run faster beside the points that Ray has explained.

Regards.

Hi, I have a problem creating a parallel routine using 8x Client on Unix OS, every time i try to create a new routine it gave me the following error messages: 1- Run time error '5': Invalid procedure call or argment 2- Run time error '429': ActiveX component can't create object I have re-installed t...

Kandyshandy, thanks for your reply and I'll answer your two questions. Regarding migration, the data source is Oracle RDB which is an older version of Oracle with a different structure than the current one. For the second one, I'm using the transformer stage for change data capture process because t...

Guys, I've around 1100 parallel jobs which migrating data from an older version of Oracle to Oracle 10g. Each job only captures the changes between data source and destination on daily basis. The used job's pattern is: ODBC Stage --> Transformer Stage to capture data changes --> Oracle Enterprise St...

I think the two dashes counts besides yyyy, mm, & dd.

Try this Function:

UstringToString(StringToData(<FieldName>,"%YYYY-%MM-%DD"))

Try to use this function:

StringToTimeStamp(Convert ("-", "/", TimeStampToString<COLUMN_NAME>))

MGendy,

reading the TimeStamp column as Char(26) requires a type conversion function for each job and I mentioned before it's a luxury I don't have.

Not Yet, Chulett.

Unfortunately It didn't work. DataStage still read it as Zeros.

So what about reading the microseconds as zeros from DataStage when setting the extended property to Microseconds to a timestamp column?

Regarding the other issue I will assure to share the solution once I got it.

Thanks a lot, Andrew.

So what about reading the microseconds as zeros from DataStage when setting the extended property to Microseconds to a timestamp column?

Regarding the other issue I will assure to share the solution once I got it.

Thanks a lot, Andrew.