DSXchange

Hi,
We have a oracle function which returns boolean value, how can i get this value using stored procedure stage. I mean what should be the Parameter name, data type etc in DataStage. Thanks in advance.

Thanks Shamshad. I had the oracle table as an option, went ahead with that as i could not find any other alternative.

Hi, In my job i need to join a parent column from DataSet to child records in DB, The DB table is big, so i ruled out normal lookup but sparse lookup does not allow multiple records from reference link. How can i use a query like select * from child table where col1=ORCHESTRATE.col1 and join to pare...

Thanks Kumar. But DS_ENABLE_RESERVED_CHAR_CONVERT applies for column names. How to get around it in user id.

Hi,
I am able to connect to Oracle database using "ODBC Enterprise" stage but when i try to connect using "Oracle enterprise" stage i am getting the error.

Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1

Please help.

Table is not partitioned, though there are 8 nodes in configuration file, i guess DB2 runs sequentially.

Hi Chulett,
I made the query pretty simple to check, direct select from a single table, if i run the query against the database directly i am getting unique records.

Hi, I wrote a sql in DB2 and saving the data to sequential file. Allow multiple instance is also NOT checked. I am getting 2 copies of same record, i used distinct also in the query but the problem continues, if i use PK like or PK= in the query then i am getting unique records. Please help me under...

Hi,
Iam facing the same issue, if you were able to resolve, please let us know the solution.

Hi kbcland,
But i found this function in the server jobs documentation.
If not is there any other way to get output links of a stage.

Thanks.

I am getting an error DSGetStageLinks never dimensioned.

I searched the forum and added the below line to my routine then the function is not returning anything.

DEFFUN DSGetStageLinks(JOB.NAME, STAGE.NAME, LINKMODE).

Please suggest a solution.
Thanks in advance

Thanks Ross.
We want to use DS oracle oci load stage, so planning to take necessary steps.

Thanks alot guys.

Thanks Ross. Seems iam getting close to solution. Only problem is if i install my target oracle version client on my source. 1. How can i use sql loader direct mode for both DB on source machine and target DB. i.e I have 2 client versions on source machine.How can i use those 2 versions to use sql l...

Hi, After searching for a while, i found the following restriction on sqlloader direct mode. Beginning with Oracle9i,you can perform a SQL*Loader direct path load when the client and server are different versions. However, both versions must be at least release 9.0.1 and the client version must be h...

Hi Ross, Iam able to use sqlldr in DIRECT MODE when invoked on the local server. But unable to use DIRECT mode when trying to load data from remote server. I confirm the following. 1. Oracle OCI Stage (non-Load) - OK 2. Oracle OCI Load (Automatic) - Error 3. sqlldr Conventional Mode - OK 4. sqlldr D...