DSXchange

...ok I'll import the two text files in two temp tables.. :? .. u mean using ODBC stage and user defined SQL (my server is Informix 9.4) I'll divide in two job. First job : will import the two flat files in two tables using the ODBC stage Second job : using three ODBC stages two for read from the te...

still having problem with merge stage ... I'm getting very Angry

Is there another way to make a left outer join between two files without using merge stage... any help will be appreciated ... thnxxx in adv Marco

I have checked my quota on Datastage server I have 200mb (approx.) of free space, where temporary files are created.

...still have the same problem....

Checked KEY column values, they contains no NULL VALUES, also in the metadata definition for both files KEYCOLUMNS are set to Nullable -> NO

.....still having the same problem........

Hi there all !! I have a problem running a Merge Stage in LeftOuterJoin between two files errror codes are printed in log are the following: Info : MergeFlussi..merge_flussi: Seek failed Info : MergeFlussi..merge_flussi: Function 'put_row_to_page' failed Fatal : MergeFlussi..merge_flussi: Function '...

I've tried to change isolation level of ODBC Informix table stage from : none to AutoCommit.. now seems to work fine.

In first Job I insert/update only field1, field2 In the second job I insert/update only field3 the "strange" is that if I run job1 and the job2 spearate all rows are inseted with correct values, but if I link the two jobs in the sequence and run it with the sequence job it runs correctly b...

First job and scond job end with "OK conditial" with no errrors or warnings. They are not parallel jobs. If I run the jobs separate all rows are inserted correctly.. If I run the two jobs in sequence in the target Informix table in all rows the field value3 (Inserted from the second job) h...

Hello I have a problem with job sequence : I have two jobs with (insert new or update existing clause) that inserts records or update different fields in the same table. Job 1 : Key, field1, field2 Job 2 : Key, field3 Informix table : Key, field1,field2,field3 If I run the two jobs separate all rows...

:? ...but inner join extratcs only rows matching the key (as SQL inner join does)........ I need to have all rows in file A and all rows in file B with columns values merged for same key values as I explained in the example..... I've seen I don't have Lookup Stage in my version :x I'll try to handle...

oh thnxx I'm going to read it carefully in the docs
But I have documentation about Lookup stage on help
..but I don't have lookup stage on palette ?!?!? Is it bossible I don't have it installed ???? My DataStage Designer version is 6.0.0.21...
How is it bossible ?

How can I do that ?

Thnxx Marco

Hi all anyone can help me with this ? I have 2 sequential files (csv) with this structure... 1) File structure : key_col,colA,colB,colC 2) File structure : key_col,colD,colE I need to import the records in these files in an Informix table with this structure merging the records with the same key_col...