Error in Merge stage(Sequential files)

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Amar_nath
Participant
Posts: 56
Joined: Tue Apr 18, 2006 5:03 am

Error in Merge stage(Sequential files)

Post by Amar_nath »

I am currently dealing with Server Jobs only
I have taken 1 merge stage output is linked to a Seq file.


I have entered names of two existing Seq files in the input of the merge stage.And mapping is done on Primary key

the error message is :-
MergeSeqFiles..Merge_0: Error opening first input file
MergeSeqFiles..Merge_0: Link property retrieval error
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:? Are you sure you have the file names correct? Case is correct and they are fully pathed?
-craig

"You can never have too many knives" -- Logan Nine Fingers
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Check with View Data option.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

Check if you mentioned file names in the First and Second file directory paths on the General tab of the Merge stage. If so, change it only to directory path. Thats one common pitfall one can overlook and hence that error. Also, as Craig mentioned, check the case of the file names and see if you gave them correctly.

IHTH
Kris.
Post Reply