DSXchange

Hi, Thanks everybody, it worked. Thanks again. Patrick You can also stick an IPC stage in between the transformer and the link collector stage to get rid of that error. This error occurs because both transformer and link collector are active stages and DataStage will not allow a direct link between ...

Kumar. thanks kumar for sharing the idea. It gives me an error when use the Link collector . It says "Link collector stage does not support in-process active-to-active inputs or outputs". I did use like what u suggested, like from Transfer created 3 links (hdr,trailer,detail) sort on key a...

Thanks for your suggestion What 'little more details'? If you have specific questions, ask. And why the concern about the three files? You create the three to create the one, I don't see any way to create that kind of output directly. However, if you are worried about 'the three files' ( why does th...

Hi, thanks for replying, this is what i was looking for. Can you give little more details , my requirement is same as you mentioned below. Instead of creating 3 seq files, Is there any way we can create in one file. Give more details please. HDR 111 DTL 111 PAT 100 DTL 111 ABC 100 TRL 111 2 200 HDR ...

Hi, I need a help in creating extract from the database. the problem is for each value i need to create trailer and header in the same file. for eg : EMP EMPNAME SAL 111 PAT 100 111 ABC 100 222 JON 200 222 JON1 200 333 JJJJ 300 333 JJJJ 300 I need to create an extract with the following from the abo...

I don't know i was able to see the data, what u suggest for if the decimal field value is null?. i tried to give 0 or 000000.00. it didn't work.

Kris, Thanks again for Ur reply, My problem is resolved actually I should just take care COMM field which has null values. I gave null field value='' and pad char space as suggested by you. Thanks again. It works even for schema file also. What I did for schema file strucuture I took defn SHOW OSH d...

Kris, I tried as per Ur suggestion, still I am not able to resolve, You can try here is my data and strucuture: I have given field defaults as Delimeter=| Null field value='' In Type defaults : General Pad char = space My Structure is EMP NO -- Integer COMM -- decimal 7,2 deptno -- Integer Data is a...

Hi Kumar, Thanks for the reply, Actuall this am not able to resolve this issue. Take the case COMM field which decimal(7,2), when set null field value 0 or 0000000.00 or 00000000. If the COMM field value is null, it is not recognizing and showing zero values. When viewing (View data) from the Sequen...

Hi, I am getting the following error Sequential_File_1: When checking operator: When validating export schema: At field "HIREDATE": "null_field" length (1) must match field's fixed width (19) Sequential_File_1: When checking operator: When validating export schema: At field "...

Even I can't read Ray's Comments, Would somebody explain how to resolve this issue. Appreciate Ur help.

Thanks for the reply, I was able to create using schema file, for testing purpose i used sequential file as source and target. when I am loading emp data to the target sequential file using schema file,I am getting following errors, i tried to null value , can you help on this error. Sequential_File...

I read that, but still i am not clear with my requirement, where I need to load several different format sequential files to Oracle database. Somebody recommended to schema file. Can you let me know how to use this functionality.

Thanks for the reply, Still I am not getting with your answer. Can you elaborate your answer. When should use schema file, how to use. I have seen few forumns on this, i was not able. With what file name I need to save and import. Can you be breif about this. Thanks again.

Could you please explain how Schema file to be used. I know we can go table defnitions , layout tab , select parallel option. if i copy the schema and pasted into an editor. then How to use this file into datastage ?. If i have several sequential files which want to load to Oracle database. How Sche...