Search found 153 matches
- Fri Dec 05, 2014 10:55 am
- Forum: General
- Topic: Routine to connect SQL server
- Replies: 2
- Views: 1906
- Tue Dec 02, 2014 12:20 pm
- Forum: General
- Topic: Routine to connect SQL server
- Replies: 2
- Views: 1906
Routine to connect SQL server
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?
- Mon May 26, 2014 1:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with XML input stage
- Replies: 7
- Views: 4136
- Tue May 06, 2014 1:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Commit issue in Oracle Connector
- Replies: 1
- Views: 1094
Commit issue in Oracle Connector
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 ...
- Tue May 06, 2014 12:22 pm
- Forum: General
- Topic: How to find Last compilation of the datastage job?
- Replies: 8
- Views: 10079
Re: How to find Last compilation of the datastage job?
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
1. Perform a advance search with that job name in designer
2. From director select that particular job and clear the state file
- Sat Apr 19, 2014 12:49 pm
- Forum: General
- Topic: Oracle command in Datastage Sequence
- Replies: 8
- Views: 7639
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...
- Mon Apr 14, 2014 2:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Looking for effective solution for sum
- Replies: 6
- Views: 4259
- Mon Apr 14, 2014 10:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Looking for effective solution for sum
- Replies: 6
- Views: 4259
- Fri Apr 11, 2014 1:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get max performance using upsert mode?
- Replies: 4
- Views: 2467
Re: how to get max performance using upsert mode?
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...
- Wed Apr 02, 2014 10:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join error - invalid record count
- Replies: 2
- Views: 1371
Re: joiner error
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
For larger no of distinct key combination use sort method otherwise hash method in aggregator stage
- Sat Mar 08, 2014 12:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job aborts with unusual error message
- Replies: 2
- Views: 3123
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...
- Thu Mar 06, 2014 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job aborts with unusual error message
- Replies: 2
- Views: 3123
Datastage job aborts with unusual error message
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...
- Sat Feb 08, 2014 1:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameterized values getting hard coded
- Replies: 10
- Views: 7269
- Mon Jan 20, 2014 1:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Scenario?
- Replies: 5
- Views: 2728
- Mon Jan 13, 2014 11:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file at the output of xml stage
- Replies: 6
- Views: 4482