merge_test..Merge_1: Link property retrieval error

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
padmalavanya
Participant
Posts: 9
Joined: Tue Nov 07, 2006 4:36 pm

merge_test..Merge_1: Link property retrieval error

Post by padmalavanya »

Hi,

I am trying to merge to sequential files

job design: merge stage, transformer, sequential file.

I am getting
merge_test..Merge_1: Error opening second input file
fatal error: merge_test..Merge_1: Link property retrieval error

Please any help on this
Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It doesn't like what you specified as the second filename. Make sure it is spelled (and cased) properly and permissions are correct.
-craig

"You can never have too many knives" -- Logan Nine Fingers
padmalavanya
Participant
Posts: 9
Joined: Tue Nov 07, 2006 4:36 pm

Post by padmalavanya »

I checked, I defined it.
but still this is Fatal error:

merge_test..Merge_1: first file column 'Name' must be present in output column list.

Thanks
padmalavanya
Participant
Posts: 9
Joined: Tue Nov 07, 2006 4:36 pm

Post by padmalavanya »

What is the cirteria to merge the files.
2 file with same meta data, IS THIS RIGHT?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Think for a moment what the Merge stage is doing. This will provide some guidance about which columns need to be identically named and which ones do not.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply