DSXchange

In Database it's define as "ACCOUNT_NAME" VARCHAR2(50 CHAR),

In Datastage it's define VARCHAR2 (50)

We tried loading the same value in same field through Toad and worked fine.

please find the below in detail log: Abnormal termination of stage MCYRESETJOB..TRF_TH detected Job Aborted after 1 errors logged. Attempting to Cleanup after ABORT raised in job MCYRESETJOB. From previous run DataStage Job 1 Phantom 24758 Job Aborted after 1 errors logged. Program "DSD.WriteLo...

Warning message:

"Abnormal termination of stage MCYRESETJOB..TRF_TH detected"

we are running the ds jobs from unix shell script passig the 9 parameters as one of parameter as 1 (if one warning is generated the job has failed). Here i am going to migrate all DS V7 jobs to DS V8 in Server Edition. Please find the my job design: Source Table A -------> Transformer ------> Target...

From previous run
DataStage Job 1 Phantom 12624
Job Aborted after 1 errors logged.
Program "DSD.WriteLog": Line 253, Abort.
Attempting to Cleanup after ABORT raised in job MCYRESETJOB.

DataStage Phantom Aborting with @ABORT.CODE = 1

Here i am going to migrate datastage jobs from the Datastage V7 To V8 in Server Edition. In one if job has throwing warning message 'Abnormal termination of stage xxxxxx detected' in DS V8 in Server Edition. But the same job running successfully in DS V7. This job has reading the data and updating t...

Here i fixed the issue using Both NLS map charcter set as UTF8 in both sourec(DB2 Db) and Target (SQL Server Db) in Datastage.

OK Thank You Very much.

I Need solution on this.

chulett wrote:Well... the way that was posted in your own thread on the subject comes to mind.

i am also getting the same datetime overflow error because my source column timestamp value is 0010-12-15 00:00:00.000000 while loading into the SQL Server the overflow happen in datetime column Target SQL Server column type is datetime default format is YYYY-MM-DD HH:MI:SS.sss. so kindly suggest on...

The same NLS conversion happen to me today am loading data from db2 database with NLS map MS1252-CS into SQL Server Database with sma NLS map MS1252-CS so job has thrown the below error. Unmappable characters found mapping text string with this characteres: “ characters so please suggest me ho...

How can i?

chulett wrote:In other words, just chop off the last three "s" bits.

Hi,

can anybody suggest me how to convert the Timestamp from db2 database to SQL server Db in Datastage server Edition.

YYYY-MM-DD HH:MI:SS.ssssss To YYYY-MM-DD HH:MI:SS.sss

Hi,

i am getting the below error while loading the data into SQL Server database.

Warning:

JONamexxxxx..TX_L1_xxxxxxx: DSD.BCIPut call to SQLExecute failed.

so please give me an idea how can i overcome this warning.