DSXchange

Great! Thanks Ray. I just had a close look at transformations in this particular job and this particular column is used in join stage as joining key. Its coming as integer from reference link while source has varchar data type. Finally getting inserted as integer though. Probably not so good data mo...

Nope. There is no reject link on target oracle connector stage. So do you suggest to remove the to_number conversion in source select query and have target reject link which will reject this record automatically.

Hi, We have a job which extracts data from oracle table and loads in another oracle table after certain transformation. The number of records are pretty huge around 50 million plus. This job sometimes aborts with The OCI function OCIStmtFetch returned status -1. Error code: 1722, Error message: ORA-...

Hi All, I have a DS Server routine where I am trying to insert a record in DB2 table. Below is the routine code used and after that error I am getting is posted. Somehow those single quotes are not appearing for varchar fields and its giving this error. Any inputs how to correct this syntax. Have tr...

Thanks for the inputs !! As we are using v9.1 for our project operations DB will make life much easier.

Thanks all. Information provided helped to take a decision

Rgds,
Sachin

Hi, We have installed DS 9.1 recently for our project and currently running on a trial version of c++ compiler. We need to purchase the licensed version of the same and have confusion about below two products. Can anyone suggest on which one to go for 1. C for AIX Authorized user license 2. C for AI...

Just an update which I missed in previous post
We will be using unix shell scripts to call datastage sequence

Hi All,
Can anybody suggest on deciding factors between using datastage native scheduler (Through datastage director) and cron scheduling.

Rgds,
Sachin

When you say before sub routine, does it mean you are accessing link counts to get source, target and reject records. I believe in that we should have before subroutine and after sub routine for each job.

Rgds,
Sachin

Hi, We have a requirement to capture datastage job level stats for each and every job in a application. The rough audit table structure we have is DSJobName Source_Rec_Count Reject_Rec_Count - will be combining all rejects in various transformations using funnel in single output Target_Rec_Count Job...

Hi Ray, We have changed datatype of one column in production table and hence some update statement is running on this table. Table is partitioned and at the same time we have hourly job which inserts data into this table. Datastage job is getting aborted due to this. So we were checking if we can ex...

Dear All,
We need to set transaction isolation level in Oracle Enterprise stage.
Any pointers

-Sachin

I am using write method as Load. I tried reading generated ctl file for the same and following are contents of the same. It is using some "FIX 20". OPTIONS(DIRECT=TRUE, PARALLEL=TRUE, SKIP_INDEX_MAINTENANCE=YES) LOAD DATA INFILE '/data03/Scratch/Scratch12/ora.1183988.635332.fifo.0.out' &qu...

Yes. Already done this. Have added peek parallel to oracle stage and data is coming properly till peek stage. Only existing spaces in string are getting preserved. But in ORACLE it is padded with additional spaces based on length of the string