DSXchange

I want to create a generic job to get the schema file name and target table name and source file name as parameter. The problem is that i can't make the RCP to work with Multiloader, i keep getting the following error: 0008 .layout internal indicators; 0009 .dml label tdmload; 0010 insert TEST.Testt...

when you view the data from CFF stage, they are read sequencially and in order. This means that your data gets mixed up after reading. so dont change the CFF, but the stages after.

I think it is like SQL*Loader direct path. Default or triggers on a table work on a one row inserts. they wont work with bulk loads.

turn off bulk load and it should work, then it will be slow. so do your defaults on datastage, instead of a trigger by database.

when you create the copy book for the EBCIDIC file, you use COMP-3 and (19,2) or (17,2) look at it, it will tell you the size in bytes. it is perhaps 6 or 7 bytes. fix your filler accordingly.

RELEASE MLOAD Table_Name

is the answer

in the worst case, put an If statement and if any number is < 0 then multiply it by -1 else take it as it is.

Check if you try to push a nullable column to non nullable column. this happens often. It happened to me, it shows as writing and but nothing is written.

so my suggestion is to check the null values.

Observation: COBOL files don't usually have delimiters. Are you translating from EBCDIC to ASCII as part of your processing? ... the delimiter i just put for readability. i just wanted to demonstrate the three columns. i am reading from cobol and want to write to a sequencial file in ascii format. ...

Hello, I am reading cobol files. i noticed recently that some character fields are modified. data reads like this in cobol: ID, CMT, DATE 11, OK!, 2007-12-12 12,Done,2007-12-12 ... When I read this from data stage parallel job, i get this: ID, CMT, DATE 11, OK], 2007-12-12 12,Done,2007-12-12 ... ! c...

sort is needed for duplicate remover based on the keys to be considered during removing, not primary keys or business keys. in your case sort based on Value, not Key1, because in your example, for removing a duplicate, your key is value not key1. then sort it based on key1 if you need it. same as jo...

Maveric wrote:Copy paste the exact error message here. Also check the metadata of the two streams to see if they are same. Switch off RCP in the stages preceding the funnel stage and try.

Thanks Man, turning off the RCP solved the problem. You are the man.

We have one source file which we duplicate its records and each record will be processed differently, at the end we have to write all to the same target file. meaning, source has 10 records, target will have 20 records. process1 -> more processes-> source -> Copy -| | -> funnel -> target process2 ->...

I just browsed through other posts and found my answer.
If anyone still has this issue, just add a default property to the decimal field and make it default to 0 or 999999999 or whatever you wish.

I have the same problem and yes those fields have ebcidic 40404040 value in there.

I have tried that, still it inserts null to teradata.