I have a requirement to transfer data displayed into an output file that too in excel format. As per the syntax
TRANSFER dobj TO dset [LENGTH len]
[NO END OF LINE].
a single obj is supposed to be used in the syntax but the data displayed is not only from one internal table but there is another internal table from which data is also displayed.
How to transfer the entire thing into the file.
concatenate all the data what u want into one string and then use transfer command to transfer data to file.