SYNCSORT Append to the file

meena90 · New User Joined: 13 Oct 2008 Posts: 4 Location: Chennai

Hi All,

I have two input file

F1 - VB of Record length = 250

F2 - VB of record length = 1(which will be a character)

I need to append the data in file2 to file1.Can anyone help me out regarding this.

Thanks,
Meena

gcicchet · Posted: Mon Oct 13, 2008 3:31 pm

Hi,

try this

expat · Posted: Mon Oct 13, 2008 3:33 pm

Or do you mean that you want the data of file 1 to be followed by the data of file 2 in one record.

Please ask your questions in a clear manner.

meena90 · New User Joined: 13 Oct 2008 Posts: 4 Location: Chennai

Hi Expat,

Ya,I need the data of file1 to be followed by the data of file2.

Thanks,
Meena

Alissa Margulies · Posted: Mon Oct 13, 2008 8:01 pm

OK, still not quite clear. Which scenario below is what you want:

#1

meena90 · New User Joined: 13 Oct 2008 Posts: 4 Location: Chennai

I need for the second one.

Thanks,
Meena

Alissa Margulies · Posted: Mon Oct 13, 2008 9:15 pm

Are there the same number of records in File 1 and File 2?

Are they both already in sorted order?

meena90 · New User Joined: 13 Oct 2008 Posts: 4 Location: Chennai

There are equal no of records in it(say File1 and file2 both have 5 records). And they are not sorted.

Input in File1:

ID# Department Class
----- -------------- -------
10 4 2
12 2 1

Input in File2:

Flag
-----

Y
Y

Expected output:

ID# Department Class Flag
----- -------------- ------- -----
10 4 2 Y
12 2 1 Y

Arun Raj · Posted: Tue Oct 14, 2008 9:45 am