DSXchange

We are currently having difficulty in using the Stored Procedure Stage to properly insert into a DB2 Mainframe table. We have a decimal 15,2 field passing to Mainframe Stored Proc PIC S9(13)V9(2) USAGE COMP-3. All of the values get inserted except before the decimal place, this gets inserted as .00 ...

"ORAOCIBL_TEST..Oracle_OCI_Load_0: Internal Error: Unable to initialize the Direct Path Context ORA-00942: table or view does not exist" I am receiving the above message. What is exactly the "Direct Path Context?" Is this the connection to the database? the Directory Path field -...

Thank you! Is that one of the main differences between the two ("Oracle 7 Load" and "Oracle OCI Load")? So for the ORAOCIBL, will I need another stage to run the sqlldr (like Wrapped stage) if the Load Mode is set to "Manual"? What are the pros and cons of using the &qu...

In the ORABULK stage, I created the datafile and the controlfile and the rest of the properties (properties tab), what goes to the input fields in the General tab that are required? Where exactly is the database connection done? Is it on the server side or can it be done in the ORABULK stage?

How can I set up SQL loader (sqlldr) within DataStage? We have sequential files that will need to be loaded to our Orable database table. Also, is it possible to sql load a dataset, or the file has to be a sequential file?

Thank you.

Any advise on how to generate surrogate keys within datastage and reuse them within and in the next batch process. Currently, we utilize oracle's sequence option to manage the surrogate keys in our database. We are planning to leverage the Datastage Key generator option to minimize calls to the data...

I am attempting to have multiple input files with same file name execpt for symbolic , like state, into a funnel. How can I use a symbolic in job parm to grap all files?

I am attempting to have multiple input files with same file name execpt for symbolic , like state, into a funnel. How can I use a symbolic in job parm to grap all files?

Can the DSParams file be copied in it's entirety from one project to another without hurting messing anything up?

We are testing node failure scenarios in our datastage cluster and find that the conductor node can take a very long time to detect the failure of a compute node that is executing a job. As long as 25 minutes in one case. The job just hangs for a very long time before it aborts. Is there a setting t...