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 'construct_hash_table' failed
...any suggestion will be appreciated.
ThnX in advance MarK
Does this happen with every Merge stage you use? If so, it could be that you lack write permission in the temporary directory (which you specify in the stage properties).
Or it could be a problem within one of those temporary files.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I have checked the permissions on the directories and files. I can view the data in the 2 files from the job that creates them and it looks like it should. The key columns for the merge are not null.
Any help or advice would be much appreciated, I've run out of ideas!
...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 temp tables linked to the third which is the target tables with user defined SQl option on and Outer join sintax
...... ?? Is that correct ? LOL