DSXchange

Thanks a ton Ray for your hel and support. After understanding the BCI function I have created a server routine and it's connecting and executing query in SQL server absolutely fine. I'm making it as resolved. Again thanks a lot.

My datastage is installed in AIX server. I can connect SQL server databse using ODBC driver in parallel DS job. Now can I connect that particular SQL Server database using server routine?

Is the datastage running on MPP configuration?

I have a simple job where loading to a oracle table using oracle connector table. I have set the value of APT_ORAUPSERT_COMMIT_ROW_INTERVAL to 0. So all the rows will be committed at a time. Now purposefully I'm aborting the job by creating some unique violation in the target table and observed the ...

This can be done in the following ways.

1. Perform a advance search with that job name in designer
2. From director select that particular job and clear the state file

Can you please use the below format when you are setting up connection with oracle and executing the query. sqlplus -s User_Id/Password@DB_Name<<! SET HEADING OFF SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF...

Also you can achieve by using transformer looping and saveInputRecords() and getSavedInputRecords() function.

What is the version you are using?
If it is 8.5 and above then best option is to use transformer loop with cache memory.

Guessing that your data volume is high. Separate out the insert and update job. In the update job push down the update totally in the DB server in the following way. create a temp table and then load it in bulk load mode with the updated records. In the after sql write a query to update the target t...

Are you using join after aggregator? If so and using sort method in the aggregate then sort the input on the basis of aggregation key.

For larger no of distinct key combination use sort method otherwise hash method in aggregator stage

Thanks a lot for your response. I deleted the transformer and again build from transformer to DB2 connector. Then the job ran fine. From my understandings this basically happens when we are trying to run DB2 connector on DB node and we don't have distribution key of that particular table is not pres...

I have a simple job where performing SCD(using SCD stage) and followed by a transformer and lastly a DB2 connector which is running in upsert mode. The job is throwing some unusual error message in one of the environment but in other environment it works fine.Below is the error message. APT_Combined...

I have faced the problem sometimes. All the parameter including connection parameters and parameters used in the sql statement have been hard coded with the values which was used to view data in the DB2 connector stage in 8.5 version.

What is the DS version you are using?

I got the clarification. Did one basic mistake. One of the field value was becoming null after xml parsing that's why that records are getting dropped in the sequential file.

Thanks a lot Ernie for your help and support.I'm marking it as resolved.