DSXchange

Hi. I tried to delete the records in the JDedwards buffer file(DB2/As400)...but it doenst allow me to perform any operations except for Select. Error i got is: SQL statement:DELETE FROM JDEDTA.F56BO04 SQLSTATE=S1000, DBMS.CODE=-7008 [DataStage][SQL Client][ODBC][INTERSOLV][ODBC 20101 driver][DB2/400...

Thanks for all the help...
Could somebody tell me if I could acheive the same (clear JdEdwards source files)using CALL DSExecute("............") from job control?
Thanks,
madhu

I did check it.I didnot find it.There are only four of them.......

I dont see the ExecDos in the Built-in before/after subroutines?why is it so?

Thanks for the reply Ken.My source is in JdEdwards buffer files..and I want to delete the data in buffer files after the job is finished.I need a script to run from windows...

Hi All,
I need to delete data from the source after the job finishes.I figured out that I need to write an after-job subroutine to achieve this.Does any body have a routine to accomplish this?
Thanks,
Madhu

I dont see the reference link with multi row result set in my Trnsf properties??Any idea?

I have loaded oracle into a hash file and joined both databases in the Transformer stage.
I have left the account name to deafult.but when i try to run the job,I see an error"DSD.UVOpen Unable to open file xxxx"
Could somebdy help me out?
Thanks,
madhu

by datasets,do you mean to use PX?We dont have Enterprise edition.

Hi All,
I need to join 2 tables from DB2 and Oracle.Join should be performed on th DB2 side(ODBC) and put in the Oracle database.
Could somebody help me out.
Thanks,
Madhu

Hi, To log the warnings(success,fatal etc..)in the job sequencer stage, a log file should be created.So,is it that admin should create the log file or in the routine we should hard code to create the log file if one is not already present?? And also about handling the rejected records,should there b...

Thanks..i got it

query is like this;
select a.*,b.x from zzz a,yyy b where a.cc=b.cc;
This query appends a column 'x' in the table 'a' when i run it in sql plus but does not in datastage.

Hi,
Does anyone have an idea why a sql query that works fine in SqlPlus doesnot work in Datastage(oci9)?
Thanks..

Thanks...