DSXchange

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 ...

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...

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...

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...

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...

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.

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...

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...

A variable in a shell script

I want to get Number of Rows written or updated to the o/p to a variable.

How can i get this.

AmeyJoshi14 wrote:Are you using any routines, in your job?

No i am not using any routine.Its a server Job.

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 messge while opening the director

failed to OPEN LOG_4484

How to see this log.

I dont know the Correct forum for this......But give me the Solution ASAP

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...