We are using OCI Stage in server job. We are planning to migrate to 11.5 after importing the job ORACLE OCI stage its showing in grey color as this stage was Deprecated. Please advise how to migrate server job with ORACLE OCI to 11.5 version without re-designing.
Thanks,
Krisna
Search found 76 matches
- Wed Nov 16, 2016 3:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle OCI
- Replies: 1
- Views: 6325
- Thu Sep 27, 2012 6:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: unprintable characters
- Replies: 6
- Views: 4537
- Mon May 07, 2012 11:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: unprintable characters
- Replies: 6
- Views: 4537
- Tue Mar 20, 2012 5:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML input stage
- Replies: 3
- Views: 2767
- Tue Mar 20, 2012 5:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML input stage
- Replies: 3
- Views: 2767
XML input stage
All,
When XML input stage or output stage is placed on designer canvas getting the below error.
40906 unable to create the new object.
Please advise
Thanks in Advance
When XML input stage or output stage is placed on designer canvas getting the below error.
40906 unable to create the new object.
Please advise
Thanks in Advance
- Thu Mar 15, 2012 12:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading images
- Replies: 1
- Views: 1568
loading images
Hi All,
Need to extract images from oracle and load to DB2. Please advise how can we achieve this.
In Source image column datatype is BLOB.
Thanks in advance.....
Need to extract images from oracle and load to DB2. Please advise how can we achieve this.
In Source image column datatype is BLOB.
Thanks in advance.....
- Mon Mar 12, 2012 7:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not Extracting data from Oracle
- Replies: 2
- Views: 1778
Not Extracting data from Oracle
Hi All,
upto 2 days back the job was running (extracting data) from DB. But now it's not extracting and i don't see any progress. But when i executed that query in oracle client it shows the result. Please Advise.
Thanks in Advance.......
upto 2 days back the job was running (extracting data) from DB. But now it's not extracting and i don't see any progress. But when i executed that query in oracle client it shows the result. Please Advise.
Thanks in Advance.......
- Thu Jan 12, 2012 8:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance
- Replies: 7
- Views: 3883
- Wed Jan 11, 2012 9:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance
- Replies: 7
- Views: 3883
Performance
Hi, We are loading data from a sequential file to oracle and volume is 650 millions of records. It took 45 hours to load 318 million records, performance wise it's very poor. Job design is like this sequential file --> transformer --> oracle enterprise stage | V oracle enterprise stage in transforme...
- Sun Oct 30, 2011 11:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle enterprise stage
- Replies: 5
- Views: 3196
- Sat Oct 29, 2011 9:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle enterprise stage
- Replies: 5
- Views: 3196
Oracle enterprise stage
Below error we are getting when we run the job. The provided insert statement did not prepare correctly; please verify that your statement is correct; statement: INSERT INTO STG.LDM_DWR_CPS_REJECTS (SOURCE_ID, EXTR_BTCH_ID, SUBJECT_AREA, JOB_NAME, ERROR_TXT, ERROR_DT_TIMSTM) VALUES ( :SOURCE_ID, :EX...
- Wed Mar 16, 2011 1:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fixed width file
- Replies: 4
- Views: 3125
- Wed Mar 16, 2011 1:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fixed width file
- Replies: 4
- Views: 3125
- Wed Mar 16, 2011 12:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fixed width file
- Replies: 4
- Views: 3125
for example from source table x and y columns had values like 234.5 and -145.64 then in file it should display as 0000000000000234.5000-0000000000000145.6400 (if it is positive number it should have a leading space so that the total width will be 22 characters.) (if it is negative number with sign i...
- Tue Mar 15, 2011 9:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fixed width file
- Replies: 4
- Views: 3125
Fixed width file
Hi All, My target is a file which contains amount columns of 22 width. 16 for integer part, 1 for decimal point, 4 for decimal digit. 1 for sign. for example : 0000000000000000.0000, if we have -ve sign it should be -0000000000000000.0000. My question is if it is a +ve number it should have leading ...