Search found 27 matches
- Thu Feb 21, 2013 5:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rounding off issue with datastage
- Replies: 12
- Views: 18692
- Wed Mar 28, 2012 12:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to Insert into Oracle Database
- Replies: 8
- Views: 4590
- Wed Mar 14, 2012 1:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to Insert into Oracle Database
- Replies: 8
- Views: 4590
Re: Unable to Insert into Oracle Database
In the above mentioned issue: The target table contains compound primary key with two columns I and C. C is hardcoaded to 11536 and I is a Oracle sequence generator column(finapp_mig.socpartycontractrole.nextval). can i use the above function in datastage? I dont know how to handle this sequence in ...
- Wed Mar 14, 2012 12:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to Insert into Oracle Database
- Replies: 8
- Views: 4590
Unable to Insert into Oracle Database
Hello Everyone, I am trying to insert a record into the oracle database by using the Oracle Enterprise Stage, Options I am using in the stage: Writing mode : Upsert Upsert Mode: Userdefined update only Update Sql: Insert Statement It is rejecting. It is not even showing any warning while running. Pl...
- Wed Dec 21, 2011 9:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best Method to Join the Tables
- Replies: 10
- Views: 7299
- Mon Dec 19, 2011 12:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best Method to Join the Tables
- Replies: 10
- Views: 7299
Are the key columns indexed ? YES How many nodes the DataStage server is running on? 4 How many nodes the Database server is running on? Are there any filter conditions over the selected data? NO If your job is supposed to be running in Production, then what are the loads on the database and datast...
- Fri Dec 16, 2011 12:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best Method to Join the Tables
- Replies: 10
- Views: 7299
- Fri Dec 16, 2011 10:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best Method to Join the Tables
- Replies: 10
- Views: 7299
Re: Best Method of Joing Tables
Each Table has nearly 80000 to 100000 records..
- Fri Dec 02, 2011 1:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datetime2(7) issue in SQl server 2008
- Replies: 6
- Views: 9572
- Fri Dec 02, 2011 9:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datetime2(7) issue in SQl server 2008
- Replies: 6
- Views: 9572
- Thu Sep 22, 2011 8:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DRS Stage
- Replies: 1
- Views: 1517
DRS Stage
Hello Everyone :) , I am using the DRS Stage to extract the data from SQL SERVER 2008 and i am using the below select SQL statement in it: Select A.XX, B.YY From A Inner Join B on A.ZZ = B.ZZ and i am getting the below error: [datadirect] [ODBC lib] Fuction sequence error SQLNUMResultCols: Error ret...
- Mon Jun 13, 2011 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to implement Change Data Capture in PX job
- Replies: 19
- Views: 28148
Re: How to implement Change Data Capture in PX job
You can use the CDC Transaction stage in an IBM InfoSphere DataStage job to read data that is captured by IBM InfoSphere Change Data Capture (InfoSphere CDC) and apply the change data to a target database. The CDC Transaction stage integrates the replication capabilities that are provided by InfoSph...
- Thu Jun 09, 2011 8:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Stage
- Replies: 2
- Views: 2214
- Tue Jun 07, 2011 1:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Stage
- Replies: 2
- Views: 2214
FTP Stage
Hi, In our ETL job design we need to FTP the files from DataStage server to the Mainframe. Could any one can suggest me the best approch: 1: Use FTP stage 2: Use Unix Script If FTP stage is the answer i have 2 FTP stages in Datastage 7.5 Verssion, 1: FTP Plug in Stage 2: FTP Enterprise Stage Could a...
- Fri Mar 04, 2011 4:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compile Confirmation Window
- Replies: 5
- Views: 4727