DSXchange

Hi All, Got the sucka fixed.... this batch was opening a text file..IPY004File.txt Jobxxxx was also opening the same file to get the file name and extract the date for version...here the job was hanging... now i am passing as parameter the file name for Jobxxxx to extract the date... sorry for wasti...

Hi All I am in a fix...my job control is waiting infinitely while doing DSWaitForJob(). I am reading a text file which has a list of files, which are to be processed by JobXXXX, sequentially. Here is the code. ********************************************************************************* * Open f...

Thanks all....i tried everything and am still getting the warnings...so me and my teammates are deciding to ignore the warnings for the time being...

I am still getting this warning for all the PX jobs....

How will you see the job ? Shall i send you a dsx file ?

Staging Oracle DB = Oracle9i Enterprise Edition Release 9.2.0.4.0

Target Oracle DB = Oracle8i Enterprise Edition Release 8.1.7.4.0

Is this a problem ?

Database is Oracle 8.1.7.4.0

I read somewhere in this forum that its how Oracle organises its data and there is some problem for Datastage to read them.

Hi All, I am getting similar warnings in all the 4 PX jobs i am developing. Source table has EMPLOYEE_NBR in Numeric(8,0). compareEmployeeTables: When checking operator: On input data set 0: When binding input interface field "EMPLOYEE_NBR" to field "EMPLOYEE_NBR": Implicit conve...

Thanks, T42. It seems that the job is working fine.

I'll keep you posted...

T42,

Thanks for the idea...now its working good...

one more question....Edit code=3 is never set in my case....

I am changing the value of one of the columns....so for the same key it should give a change_code of 3.....

but it is giving a change_code of 2.

Any suggestions?

Thanks
jay

Hi All, I am using the Change Capture stage to get insert/edit/delete rows comparing one table to another. Change codes: Insert=1, Delete=2, Edit=3. Here is one result which is baffling me. 1 new row, from 1st table(before data set) + 0 rows from 2nd table(after data set), change_code=2 (considers a...

One resolution will be to use Matches to do the comparision instead of <>.

I am not sure if we are supposed to use <> while comparing strings...

Jay

Need some help here... I set values in the Change Capture as Delete code=2, Edit code =3, Insert code=1. For actual inserts into the target tbl, what is happening is , change_code=2. I am comparing two tables. I think waht is happening is for inserts, there are no rows in the 2nd table. So delete co...

Also check the length of the individual columns in the actual file and as defined in the column definition.

Thanks...i'll keep you posted...

Hi All, I am getting the following error Lkp: When checking operator: Dropping component "LAST_NM" because of prior component with same name The lookup is being done on 1 key column. But i need to pass the other columns that come in the stream link... Any ideas as to what could be happenin...