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.

what are the different types of data areas?

1747

---

Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?

2437

---

can you have multiple key lists for a single file ?

1701

---

give three main purposes of file specification ?

1741

---

what is a physical file?

1810

---

what is *iso date format?

1053

---

if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?

1685

---

how can you detect overflow for a print program that prints multiple lines per cycle?

1731

---

distinguish between terminating a program through seton lr and return?

1106

---

Write a CL program which will run a batch job at 1 am every night

1096

---

I have created a command that display Source file and library. Now i want that when i enter library name and press f4 on Source file, pgm should display all the PF- SRC's in that Library. For F4 option i have used Choice program but since only limited paramters are passed in Choice pgm i am not able to paas library name and further can't call a pgm that will display list of Source files. Below is the Code snippet for CMD type object :- CMD PROMPT('Source Scan for HUB Standard') PARM KWD(SOURCE) TYPE(*CHAR) LEN(1) RSTD(*YES) + VALUES(N A) MIN(1) + CHOICE('N,A') PARM KWD(SRCFILE) TYPE(FILE) RSTD(*NO) + PROMPT('SOURCE FILE') FILE: QUAL TYPE(*NAME) LEN(10) RSTD(*NO) EXPR (*YES) + CHOICE(*PGM) + CHOICEPGM (XXXXXLIB/YYYPGM) QUAL TYPE(*NAME) LEN(10) DFT(*LIBL) + SPCVAL((*LIBL)) EXPR(*YES) PROMPT ('Library') Below is the Choice pgm:- PGM PARM(&PARM1 &PARM2) DCL VAR(&PARM1) TYPE(*CHAR) LEN (21) DCL VAR(&PARM2) TYPE(*CHAR) LEN (2000) IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + 21 1) = 'P')) THEN (DO) /* (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + */ CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') ENDDO IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + %SST(&PARM1 21 1) = 'P') THEN (DO) CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') CALL PGM(GTSQL) PARM ('XXXXLIB') return ENDDO Thanks in Advance for looking into.

3498

---

what are the different types of arrays available in rpg ?

1718

---

In 'o' Specs What Is The Opcode For Write?

1212

---

How to reverse the string in rpg

1814

---

What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?

1027

---