DSXchange

Hi,

We have a requirement to load packed decimal fields from an EBCIDIC file into a colum with RAW datatype in ORACLE.

How do we do this using a datastage job.
Any help will be appreciated.

Regards,
Samyam

Can anyone reply to this please?

Hi, We are using Oracle Enterprise stage. and the job is running on 4 node. if we use Oracle 8 Partition option the jobs gives a warning saying "The index option included will be ignored because table loading will be done sequentially." So whats the point of this option if we cannot run it...

Hi All, I want to run a Merge query in the Oracle connector PX stage and get the number of records processed in the director log. The PL/SQL block runs fien but in the director we can only see. "Number of records processed by the PL/SQL block on the current node: 1." How can i get the outp...

Hi All, We have a couple of jobs which read XML data from DB2 and loads into oracle. datastage is being used to extract the data and do parse the XML data into tabular format and load it into Oracle. These jobs are running for 4 hours each. What i am planning to do now is to load the data from DB2 t...

Ya even i am trying to the same. Bulk load into a temp table and then merge it with teh actual table.

Lets see. If the support team aggres to this approach and the creation of new table we may just go ahed with this idea.

We have a job which does this operation using two oracle stage. But the job runs for 3 hrs every day. Its a simple update insert job with 500 columns and 9 million record. What i was trying to do here was to push that operation onto the database side rather then fetching 9 million wide records fron ...

Hi,

My requirement is to connect to two different oracle databases using a single oracle enterprise stage or an OCI stage.

Is this possible?

REgards,
Samyam

DBA's have no solution for this.

Used an Oracle Enterprise stage to avoid this error.

Allrite will go back the BBA's and check what this is.

Hi, I am using a oracle connector stage. When it runs in insert mode the job runs fine. But when i change the load to bulk mode the job aborts with the following error. "Oracle_Connector_676,0: [IIS-CONN-ORA-001003] The OCI function OCIDirPathPrepare returned status -1. Error code: 600, Error m...

Thanks a lot Ray And ArndW

I used this as a parameter and passed the value

POST_CODE:string[max=8] = string_trim[" ",end,begin] (POST_CODE)

Works brilliantly.

Hi,

Sorry about that. Yes its a parallel job.

Regards,
Samyam

Hi, I am trying to trim few of the varchar columns. I am using a generic job which uses a schma file to load from the file to the database. Is there way i can use a trim function on the varchar columns. I saw few of the posts which said this is not possible in RCP. Want to get any idea on how to do ...

In column import stage the input column for import was defined as Unicode.

I removed it and now the job is working super fine.

But what has double quotes got to do with unicode which was causing this problem.

Thanks,
Samyam