DSXchange

Just revisiting this post... I've found that the Oracle CAST statement helps to eliminate these errors. For example, SELECT CAST(acc_ref AS NUMBER(13)) acc_ref FROM (SELECT acc_ref FROM ..... UNION SELECT acc_ref FROM .....) Thus forcing the Oracle Enterprise stage to see the field acc_ref as it's o...

That's the strange thing. The UNION query is 2 part and each part on its own gives a resulting data type of Integer(6) which the Oracle Enterprise stage accepts without warning. It's only when in a UNION query that the resulting data type appears to be Decimal(38,10) - hence the warning. The Oracle ...

Unfortunately I'm using 7.1 - no Message Handler.

Do you know why this data type conversion is occurring in a union query and not when the same column is referenced in a non-union query?

Hi, I've run into a slight problem/feature with the Oracle Enterpise stage. When running a union query within this stage I received the following warning relating to the column AGRMT_NUM (which is set in the stage to Integer): oraIssue: Column AGRMT_NUM floating point decimal not fully supported. Ad...

I'm running a job which extracts data from several Oracle 8 databases (using the DRS stage). The job has always worked in the past but now gives the following fatal errors: buffer(5),2: Failure during execution of operator logic buffer(5),2: Output 0 produced 0 records buffer(5),2: Fatal Error: Cann...

Yes, HP-UX.

I've changed the script from ksh to sh and it now works fine.

Cheers!

Hi, I'm trying to execute a shell script before a DS job starts. However I'm getting the following error: BeforeJob (ExecSH): Error when executing command: files/cgabs_mat.ksh *** Output from command was: *** SH: 28989 Bus error(coredump) The shell script calls SQL*Plus to execute some stored proced...