DSXchange

We have oracle 9i at client place. In datastage 7.5 all DS server jobs are devloped by using DRS ( Dynamic RDBMS ) stage. I guess Oracle OCI 8 & Oracle OCI are not compatible with 9i ?


Also can you tell what are pros/cons of using Dynamic RDBMS stage ?

Here is more info on problem given above...

when DS job is from perl script we are seeing following info in Perl job log
Error running job

Status code = -2 DSJE_BADSTATE

There is simple parallel DS job which has a data set and Oracle Enterprize Stage. The data is read from data set and rows are updated in table in Oracle. Oracle stage has upsert mode with update statement. The jobs shows inital 1000 rows are read and then job hangs...DS director is not showing any s...

Thanks for update...So i can't use OR condition in look up expressionn ? It's giving me ora 1008 error Also on db stage if create different alias for curr2 curr2_dummy it does not allow me to use it in where clause ?

Thanks

Amit

In DS job we have DRS Lookup ( Database is Oracle ) stage. Where we have query Select curr1 , curr2 , factor from table where curr2 = :1 or curr2 = :2 Then in transformer we are adding expression from input link which is mapped to curr2 field. link1.curr or link1.quote_curr. Then I am getting this e...

Sample code ***Initialization section Ans="" v_cents_yen="" v_cents="" v_cycledate = CYCLE_DT **If CRNCY OR QUOTED_CRNCY IS IN MINOR CURNCY SET FLAG =2 IF (FLAG = 2) THEN v_yen=Index(UpCase(FUT_QTE_UNITS),"100 YEN",1) if(v_yen > 0) then if(num(PX_SETTLE) and T...

We have written sever routine which does some multiplications based on certain conditions . The returning value from routine will be assigned to varchar2 field. We are getting ' Improper Data Type ' error when we run the job. The log mentions the line number of the routine and Datastgae Fantom abort...