DSXchange

Hi, My job is to insert data from file to SQL server. Below is my Job flow. Seq file --->transformer --->SQL Server. I'm reading date as varchar and inserting as Timestamp. Eg for date: '8/29/2011 5:26:03AM' 1. when I tried to insert without any conversion, below error is I'm getting odbc_inc_stg: S...

Thanks jgreve for the reply. Here is my response. I'm invoking the scripts using execSH" routines and in sequence job using execute command activity. This issue is resolved by hardcoding the parameter name in the script called from control M. I tried executing the script which you have provided...

The job is getting aborted, if I declare the logfile as global parameter. But I'm able to run the job successfully when I declare it as local parameter. Pls help me to fix this issue Ok, can you paste the error message(s) that it aborts with? And what is your logfile file name expression? I'd like ...

Hi There is a unix script has been called from Control M to execute the DS sequence. Below are the parameters we are passing 1. Sequence name 2. Project name 3. Domain 4. Server 5. User 6. password 7. Logfile The purpose of log file is to store all unix script logs that have been used by the particu...

ray.wurlod wrote:Those are not warnings. Please post the actual warnings (they have yellow or red icons in the log). ...

Ray,
Those are the warnings (with yellow icons in log) i'm getting.
Do we have option for attachment?. If So, I can send the snapshot of the error.

Regards,

Please post any other error messages which you see in the log. The above error messages are not complete Below are the other warnings. odbc_tpgtable,0: 2b0384420000-2b038442e000 r-xp 00000000 fd:17 2082786 /opt/IBM/InformationServer/Server/DSComponents/lib/libicutu.so.32 odbc_tpgtable,0: 2b038452f0...

Hi, My Job is to update the data from file to SQL server table. I'm not able to update.Getting below warning. But I'm able to insert in the same table. odbc_tpgtable,0: 2b2c7c0f6000-2b2c7c3da000 r-xp 00000000 fd:17 2083039 /opt/IBM/InformationServer/Server/PXEngine/lib/liborchgeneralx86_64.so odbc_t...

Hi, I'm getting below error while executing the store procedure. I'm passing 2 parameters eg:(1,'PRG'). SP,0: Failure during execution of operator logic. SP,0: Fatal Error: Fatal: ORA-06550: line 1, column 7: PLS-00201: identifier 'LOG_TASK' must be declared ORA-06550: line 1, column 7: PL/SQL: Stat...

chulett wrote:... and does it work if you run the job on a single node?

I'm able to run in single node. But i suppose to run in 4 nodes

Hi, I'm trying to insert and update into SQL server table through ODBC stage. I'm getting the below error. Pls help me to resolve it. Error 1: ODBC_Connector_21,0: Execute failed on statement INSERT INTO tblBloombergMonthly( ID_CUSIP , MTG_FACTOR , MTG_FACTOR_DT , MTG_EST_ACC_RT,UserID) VALUES (? ,?...

Hi, I'm getting the error: ORA-01722 when i try to insert in DB using oracle connector stage. I checked all the options which were mentioned in the previous posts. I checked the input meta data with target DB metada and I'm not doing any conversions. Below is my input sec_num number, sec_key varchar...

I found there is a junk value(special character) is placed at the poition 8. I believe, that is the reason for not able to read by datastage. Can we handle junk value in datastage while reading file? jwiles: yeah. file is generated from mainframe. checked the format tab. set fields defaults (delimit...

Hi I'm receiving input(fixedwidth) in below format PCR2D11 D 93 G08010CR201 PCR2D2 DC REP G08010CR2 03-01-2011 DC115509435 PCR2DD SOURCE: DEPOSITORY TRUST CO. I'm reading it as char(1)-Col 1,char(4)-Col 2,char(1)-Col 3,char(50)-Col 4 into sequential file. when i view the data, i'm getting it as belo...

Hi, below is my input. CUS_TYPE,CUS_ID,REC_TYPE,DATE,DETAIL C, 123, 1, 2011/02/28, XXXA C, 123, 2, 2011/02/28, XXXB C, 123, D, 2011/02/28, XXXC C, 123, D, 2011/02/28, XXXD C, 100, 1, 2011/02/28, AAA C, 100, 2, 2011/02/28, AAA1 C, 100, D, 2011/02/28, AAA2 based on filed(CUS_ID),i need to do look up o...

Yeah. I'm receiving timestamp fom the database.

Note: As I'm not a premium memmber, I'm not able to read your full message.



Regards,