CPYFRMSTMF

From sourcefile to IFS and back..

I want to use CPYTOSTMF and CPYFRMSTMF commands to copy sourcemember to and fro the IFS. To test functionality, I created the following test: Sourcemember A_1.TXT :    FMT ** ...+... 1 ...+... 2 ...+... 3 ...+...              *************** Beginning of data **** 0001.00...

How can I copy records from a Physical file to Excel Sheet ?

I would like to know about copying records from a physical File to Excel sheet , Can any one brief me in this regards ? Eg: I have a PF called ATMLIB/ATMTRA. EXC.XLS is a Excel Book . Now this is the situation . I am working on V4R4M0. I would like to know on this version whether it can be...

In cpyfrmstmf, can a wildcard be used in the path? I thought I could use * or?.

My path is '/lexicom/ftp120/. Under the directory ftp120 there are many stream files that I want to pull in to a source pf on the iSeries. It works from a command line when I type in a stream file name, but I want to automate it and have the command pull in all of the stream files.

CPYFRMSTMF

Get error CPFA0DB The operation expected an object in the Qsys.Lib. Cmd issued: CPYFRMSTMF FROMSTMF('/LINOMA/AMBLINOMA/APPX855') TOMBR('QSYS.LIB/MCKESSON .LIB/MCKSSRC.FILE/APPXW855.MBR') MBROPT(*REPLACE)

Reading IFS file from CL program

I have a requirement of reading a IFS file from CL program. As far as I know there is no direct way of achieving this. I am planning ot use CPYFRMSTMF followed by CPYF to copy the IFS file first as a memeber and then as a database file. Is there any better way to achieve this? Regards Sudip