Hello friends,
i wanted to whether we can merge rows from two different hold files.that is for example if we have 10 rows in hold1 and 25 rows in hold2 and both these hold files have the same fields then is it possible to club both the hold files and make a single file which should contain total 35 rows.
thanks for ur help
maddy

There are several way to accomplish this one way I us is hold format FOCUS then use the USE command. example:

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END
TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS HOLD2 FORMAT FOCUS
END

USE
HOLD1 AS HOLD1
HOLD2 AS HOLD1
END

TABLE FILE HOLD1
PRINT COUNTRY CAR
END

-* END EXAMPLE 1
another way is like this

TABLE FILE CAR
PRINT
CAR
BY COUNTRY
MORE
FILE CAR
PRINT
CAR
BY COUNTRY
ON TABLE HOLD AS HOLD1
END

TABLE FILE HOLD1
PRINT
COUNTRY
CAR
END

Hope this helps

Once again, universal concatenation is perfect.

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS HOLD2 FORMAT FOCUS
END

If both files are identical in layout you can do the following

TABLE FILE HOLD1
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS MERGE
MORE
FILE HOLD2
END

MERGE contains all records.
Ken

Not to beat a dead horse but you can also create a filedef with an append( and use

HOLD AS HOLD1 FORMAT ALPHA for the first and SAVE AS HOLD1 FORMAT ALPHA for the second file...

Thanks gut=ys its working now

and to be totally beligerent and to beat a dead horse,.....

my favorite way is an SQL UNION of the hold files. ie:

select blah from hold1
union
select blah from hold2