This can cause problems if one file has more rows than the other. The Link Collector waits for the never-to-arrive next row, and eventually takes a timeout error.
Better is to use a filter command in your sequential file stage that creates a stream of all lines from the two files. I prefer TYPE as the command; others like COPY.
Ray, how could the link collector cause problems? I use it all the time and sometimes with 10 differents archives (with the same metadata off course) and always works fine.
The CAT, COPY and TYPE commands are also good options too.
By the way, if you are joining only two files you can also append the files using 2 sequential file stages and in the input from the second specified the option "append to existing file"
By the way, if you are joining only two files you can also append the files using 2 sequential file stages and in the input from the second specified the option "append to existing file"
Not if both links are 'firing' at the same time. Sequential files by their very nature support multiple readers but only one writer at a time, so you'd need to arrange for them to run in a serial fashion.
-craig
"You can never have too many knives" -- Logan Nine Fingers