Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of 'CPYTOIMPF' command?
- 6 Answers
- 22248 Views
- Aditya Birla, Redington, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vignesh c
The Copy To Import File (CPYTOIMPF) command copies an
externally described file to an import file. The term import
file is used to describe a file created for purposes of
copying data between heterogenous databases.
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / sasikumar
Used to copy or import data from Stream files to a PF/LF.
The stream files may be an excel,txt,......etc
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / bhupendra tomar
if u want to copy a EDF from otherwhere to your local
system in a PDF then we use this cmd
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / yogesh
CPYTOIMPF – Copy to import file
The Copy To Import File (CPYTOIMPF) command copies an
externally-described file to an import file. The term
import file is used to describe a file created for purposes
of copying data between heterogeneous databases. The
import file (TOSTMF or TOFILE parameter) will be called the
to-file for this command.
TOSTMF: - Specifies the output stream file to which data is
to be copied
A stream file is a randomly accessible sequence of bytes,
with no further structure imposed by the system. The
integrated file system provides support for storing and
operating on information in the form of stream files.
Documents that are stored in your server's folders are
stream files. Other examples of stream files are PC files
and the files in UNIX systems. An integrated file system
stream file is a system object that has an object type of
*STMF.
TOFILE:- Specifies the database file to receive the copied
records.
The to-file can be any of the following file
types:
o source physical
file.
o if the file is not a source file, the file can have
only one non-numeric
field.
o program-described physical
file.
o externally-described physical file with one non-numeric
field.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / megha
one more advantage is that we can convert spool file
to .csv file using this command
cpytostmf frommbr(db file) tostmf(/home/xx/megha.csv)
| Is This Answer Correct ? | 0 Yes | 1 No |
(1)In Cl Program,Are PGM and ENDPGM mandatery Keywords or not .If yes, please tell me why these keywords is necessary. (2)If we will not define these two keywords (PGMand ENDPGM) then any error will be come or not.
when is a tag statement used in rpg?
how do you detect unused spool storage?
What is the purpose of "A CSRLOC (F1ROW F1COL)"?
what are all the contents of subfile?
Diff B/w ref and reffld?
How many secondary files allowed in a program?
Describe the function of SETGT operation in RPG language?
PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM In above example,what is content of myfile.txt ...Thanx
what opcode will be used to test the zone of a character field?
how will you display a particular page in subfile ?
What Is The Object Type Of Pf, Lf, Printer File & Display File?
RPG400 
