Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is the purpose of 'CPYTOIMPF' command?

Answers were Sorted based on User's Feedback



What is the purpose of 'CPYTOIMPF' command?..

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

What is the purpose of 'CPYTOIMPF' command?..

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

What is the purpose of 'CPYTOIMPF' command?..

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 ?    3 Yes 1 No

What is the purpose of 'CPYTOIMPF' command?..

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

What is the purpose of 'CPYTOIMPF' command?..

Answer / praveen

to copy any file from as400 to STMF

Is This Answer Correct ?    0 Yes 0 No

What is the purpose of 'CPYTOIMPF' command?..

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

Post New Answer



More IBM AS400 AllOther Interview Questions

what is a keyed physical file?

1 Answers   IBM,


what are activation group and what are its types.?

2 Answers   IBM,


what would be the effect on the field where reverse image, underline and highlight display attributes were active?

1 Answers   IBM,


what is the maximum number of subroutines allowed in rpg?

1 Answers   IBM,


How to inner join more than 2 PFs in a CL program using OPNQRYF command?

1 Answers  






What is SDA used for?

7 Answers  


What is an authorization list?

1 Answers  


can I copy content of Physican file in some source Member of type TXT? Thanx..

1 Answers  


how to get no of records in file in rpg with out cl cmd

2 Answers   iGate,


Hi,while writing a program, what is the mandatory specification using rpg/400 (in7 specification)?And please tell me what is the difference between SCAN AND CHECK opcodes?can any body tell me in real time senario?with example?

3 Answers  


how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.

1 Answers   iGate,


which cl command can be used at program execution to redirect the file named in an rpg program?

0 Answers   IBM,






Categories