What is the purpose of 'CPYTOIMPF' command?
- 6 Answers
- 19424 Views
- Aditya Birla, Redington, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the use of dspatr(mdt) keyword?
WHAT IS FERERENTIAL INTRIGRITY ?
What Is The Difference Between Goto & Exsr?
what are the limitations of cl (compare to rpg) ?
what are dds required for subfile?
what is the maximum number of record formats in dspf?
how can I start a page in a new window?
which type of object is used in db2/400?
Difference Between Ca & Cf?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
why is as/400 called object oriented machine?
What is RETURN CURSER LOCATION in subfile?
what is the maximum number of subfiles that can specified in a display file ?
what is a join logical file?
Pose, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular name field. How can we do the above using search criteria other than using the if cond?
