DSXchange

here in target we update action :
insert new rows and clear exciting rows


Regards,
Malli

Hi All, while loading the data into db2 table i am getting the following warning can anybody suggest how can we across. SQLExecDirect: Returned success with info for statement 'DELETE FROM Table Name'. See following DB2 error for details. [DB2/AIX64] SQL0513W The SQL statement will modify an entire ...

Hi All, i am using the Source file have some tags based on the tags i transform the vlues here one of the Tag has coming from Empty which is not null column in target thats way whcih shows the warning has assigned to null value to a not null column. In the tags are required value but which empty tha...

Hi All, while running datastage job in Afterjob Subroutine will call the that particular datastage job. i used the commandline to run the dsrun command.After that i am getting the below Error can anybody suggest me how can we reslove that. Error message: A problem was encountered while running write...

Hi All,

I have got the below warning can anybody suggest me.

SQL0206N "BEPERSTAT" is not valid in the context where it is used. SQLSTATE=42703

Regards,
Malli

Hi All,
can anybody give me an idea in below log:
we running the datastagejob using Robot Schedular then after that we were
getting the below log how can slove that.

Abnormal termination of Robot/CLIENT task at client "xxxxxxxxx".


Regards,
Malli

Hi, I have got the below fatal can anybody give me an idea how to slove the problem. SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553 SQLTables: Error retrieving system cat...

Hi All, i have got the below fatal error with warnings can anybody suggest me how can solve that Fata errror:Job Aborted after 1 errors logged warnings: (1)Abnormal termination of stage Jobname.x detected (2)Attempting to Cleanup after ABORT raised in job jobname.x Regards, Malli

Hi All, I am getting the below warning can anybody suggest me how to slve the below warning? SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified b...

Hi, i am using the same table as source and target to update the satatus codes while running the jobs which shows the following warnings: (1) SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 (2)SQL0911N The current tran...

Is DB2 API stage is Supports to extracts data is db2 9.5 version in Server Edition 8.0.1?

Thanks,
Malli

Hi,
can anybody suggest me the above issue?

Thanks,
Malli

Hi,

can anybody help me using db2 satge can we extract the Version 9.5 of db2 data in server edition 8.0.1

Thanks,
Malli

In datastage how to implement the audit logs mechanisam

Thanks,
Malli

Hi,
Is not a interview question to implement datastage projects how can do that?

Thanks,
Malli