Search found 25 matches
- Wed Feb 03, 2010 3:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage 7.5.3 with DB2
- Replies: 1
- Views: 1795
DataStage 7.5.3 with DB2
Hi, We have created a DSN for accessing the DB2 DB using IBM DB2 ODBC Driver & when we executed the DataStage Server job for either extract ( or ) load, we were getting the execution error that "IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSIBM.SQLTABLES" failed due to ...
- Tue Feb 02, 2010 1:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Server Edition 7.5.3 => Iconv not working with
- Replies: 2
- Views: 4093
DataStage Server Edition 7.5.3 => Iconv not working with
Hi, We are in the process of testing the DataStage Server Upgrade from 7.5.1 A to 7.5.3 & found that Iconv is not working at all using the format as "D/E". We have the date in the Input File as "YYYYMMDD" & this needs to be loaded to DATE datatype of Teradata Target table...
- Thu Dec 24, 2009 5:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migration of DataStage Server from 7.5.1A to 7.5.3
- Replies: 1
- Views: 1820
Migration of DataStage Server from 7.5.1A to 7.5.3
Hi All, We have DataStage Server version 7.5.1A & we are planning to migrate the Server to 7.5.3 May I request you to let us know the Pros & Cons of this migration. Additionally, we want to make sure that we are impacted very minimal. So, please share any special test cases that we need to e...
- Thu Feb 05, 2009 6:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage 7.5.1 A Server Edition Sequence Problem
- Replies: 1
- Views: 1497
DataStage 7.5.1 A Server Edition Sequence Problem
Hi, We are using DataStage 7.5.1 A Server Edition on Windows OS. The issue we have here is with the Job Seq. Suppose let's say we have 2 jobs in the sequence & we have enabled the trigger in the first job as "DS.JS = RUN OK OR DS.JS = RUN WARN" meaning if the first job finishes success...
- Tue Apr 22, 2008 8:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Compile error: Array 'NB' never dimensioned.
- Replies: 12
- Views: 12620
Hi All, I have written one server Routine which checks for the given file existance. I am using this routine in the Parallel Job Sequencer. But When I compiled the Sequencer I am facing the following error. Compiling: Source = 'RT_BP319/JOB.400836368.DT.1471123245', Object = 'RT_BP319.O/JOB.40083636...
- Tue Apr 22, 2008 6:19 am
- Forum: General
- Topic: Datastage Transform
- Replies: 6
- Views: 4944
Datastage Transform
Hi All,
I want to write a transform to check whether a file exists or not in the given location. So, please help me how can I write the Basic code for checking the existance of a file in a transform.
Thanks in advance.
Regards,
ETL Developer.
I want to write a transform to check whether a file exists or not in the given location. So, please help me how can I write the Basic code for checking the existance of a file in a transform.
Thanks in advance.
Regards,
ETL Developer.
- Mon Feb 18, 2008 6:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Flat File
- Replies: 2
- Views: 2034
Complex Flat File
We are using Information Server 8.0.1 Parallel Extender. We have a requirement of loading the rows with same RECORD_ID into single table,i.e., Records with ABCDEF (RECORD_ID) should be loaded into table ABCDEF & GHIJKL should be loaded into the table GHIJKL & so on. The INPUT FILE is FIXED W...
- Thu Jan 31, 2008 5:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamically get metadata
- Replies: 1
- Views: 1415
Dynamically get metadata
Hi all , I have a Complex requirement in Datastage. I am using Information Server 8.0.1. I have a huge fixed field length file with records of different MetaData.That is each records with different fields ( with no field separator and are of fixed length ) need to be loaded into separate tables. Rec...
- Thu Jan 24, 2008 8:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: want to get how many rows written/updated to the o/p file
- Replies: 6
- Views: 3606
- Thu Jan 24, 2008 5:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: want to get how many rows written/updated to the o/p file
- Replies: 6
- Views: 3606
want to get how many rows written/updated to the o/p file
I want to get Number of Rows written or updated to the o/p to a variable.
How can i get this.
How can i get this.
- Wed Jan 23, 2008 4:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting error while compiling
- Replies: 5
- Views: 2701
- Wed Jan 23, 2008 3:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting error while compiling
- Replies: 5
- Views: 2701
Getting error while compiling
Hi All,
I am getting the following error while trying to compile the Server Job.
Unable to open RT_LOG4438.
Can i delete this log and recompile??
Please advice me
I am getting the following error while trying to compile the Server Job.
Unable to open RT_LOG4438.
Can i delete this log and recompile??
Please advice me
- Wed Jan 23, 2008 2:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to see the LOG
- Replies: 3
- Views: 1829
How to see the LOG
I am getting the following messge while opening the director
failed to OPEN LOG_4484
How to see this log.
failed to OPEN LOG_4484
How to see this log.
- Wed Jan 23, 2008 2:05 am
- Forum: Site/Forum
- Topic: What to do when the LOG data unusable?
- Replies: 1
- Views: 3262
What to do when the LOG data unusable?
I dont know the Correct forum for this......But give me the Solution ASAP
- Thu Dec 27, 2007 6:12 am
- Forum: General
- Topic: I want to use Oracle comp instead of ODBC to connet ORACLE
- Replies: 2
- Views: 1219
I want to use Oracle comp instead of ODBC to connet ORACLE
when i am using Oracle component instead of ODBC com to connet to ORACLE database it is generating error.Whats the critetria to use this Oracle component The following is the error: ds_loadlibrary: error in dlopen of Oraclei8.so -Id.so.1:dsapi_slave:fatal: libclntsh.so:open failed: no such file or d...