I have explored cpytoimpf which you have shared with me from your last posts and a friend of mine have taught me of downloading a physical or logical file using CSV types.
My objective is to download the components (fields and field attributes) in an excel type of file so that I can open it using MS Excel.
I used the above command and used get filename.csv in the ftp command.
Is there a way I could download a pf or an lf directly to an .XLS file (MS Excel file)? Is it mandatory that I always use " for string delimiters? What delimiter shall I use for fields to obtain an .XLS file? Thanks. You are a big help for me. I really appreciate your generosity.
My objective is to download the components (fields and field attributes) in an excel type of file so that I can open it using MS Excel.
Code:
CPYTOIMPF FROMFILE( library/filename ) TOSTMF( 'directoryname/filename.csv' ) MBROPT( *ADD ) RCDDLM( *CRLF ) DTAFMT( *DLM ) STRDLM( '"' ) FLDDLM( ',' )
Is there a way I could download a pf or an lf directly to an .XLS file (MS Excel file)? Is it mandatory that I always use " for string delimiters? What delimiter shall I use for fields to obtain an .XLS file? Thanks. You are a big help for me. I really appreciate your generosity.
Comment