Answer / noah

cpyf copy file member is to copy file content to an existing
file. If file does not exist then user can create a new
file. The structure will be based on source file.

crtdupobj create duplicate object, create clone exactly as the
source file with structure and content with its link to prgram
and logical file and its authority setting as well. no need to
recompile pgm that use this file.

Answer / sujan

wE CAN'T ABLE TO CREATE A LOGICAL FILE DUPLICATE BY USING
CPYF COMMAND, IF U USE THIS THE LOGICAL FILE CREATED OF FILE
TYPE *PF INSTEAD OF *LF.SO THAT U USE CRTDUPOBJ TO CREATE
THE LOGICAL FILES DUPLICATES

SYNTAX:

CRTDUPOBJ OBJ(OLD_OBJNAME) FROM lIB(LIBNAME)
OBJTYPE(OBJTYPENAME) TOLIB(TOLIB_NAME) NEWOBJ(NEWOBJ_NAME)

Answer / indraneel

cpyf command is to be used when you want to copy the data
of the file. For eg. if want a selection of data that can
be done. It is not necessary that from file and to file
record format are exactly same

In case of crtduobj, a clone of the object is created.

Answer / sanjay

CPYF command are used to copy the all data from one data
base file to another or copy the required data from one
file to another files .

when we copy the data from one file to another file that
time if user want to create new file then create new file
object by using CPYF command

CRTDUPOBJ - this command used to create duplicate object
from any existing object your AS400 system.

Answer / swami redddy

the command is used to create a duplicate object crtdupobj
from an existing object .this command not only creates a
duplicate objects but also copies the contents of the existing
object into a newly created duplicate object.
syntax for crtdupobj as given below
crtdupobj obj(old object name)
from lib(lib name)
obj type(any valid as/400 obj type)
to lib(into which obj.must be created)
newobj(new obj name)
data(*yes/*no)
(constraint) cst (*yes)
(trigger) trg (*yes)

Answer / parikshit

CRTDUPOBJ:1)triggers gets copied in the new file, also new
files gets journalled if base file is being journalled.
2)New file member name can able to changed.
3)Can copy selected members data from base file
to new file.
CPYF: 1)triggers not copied. New file not journalled.
2)New file member name cant changed.
3)all members data gets copied into new file.

Answer / suri

CPYF works on physical files only.
CRTDUPOBJ works on any file.
If we use CRTDUPOBJ New files gets journalled if base file
is being journalled.
In CPYF new files r not jounalled.

Answer / shikha

Copy File (CPYF) command could be used to copy the source
into a database file.
(CRTDUPOBJ) command to create a copy of an existing object.
The duplicate object has the same object type and
authorization as the original object and is created into
the same auxiliary storage pool (ASP) as the original
object. The user who issues the command owns the
duplicate object.

If you create a duplicate object of a journaled file, the
duplicate object (file) will not have journaling active.
However, you can select this object for journaling
later. If you create a duplicate object and the object
(file) has no members, the last used date field is blank
and the count for number of days used is zero.

Answer / swami reddy

copyfile command copies the contents of existing database
file into another datbase file .
1.using cpyf command we cancopy data from external device to
a datbase file and viceversa..

Can anybody tell me that why we use option(*nodebugio)in H- Spec?

3 Answers  

How to print output from openquery in as400 ?

1 Answers   Four soft,

Please help me, I have created window subfile,I have created Footer with same lengh and postion of window SFL. When I call the pgm, first is shows only Footer and then it shows subfile records.This time Footer is not showsing ..plz hel me how can i do it...? Sameple DDS and RPG: A R WIN1 SFL A*%%TS SD 20090130 165346 MUNSHIJ REL-V4R2M0 5769- PW1 A FLD001 1Y 0B 4 3EDTCDE (Z) A ATFILE R O 4 7REFFLD (QWHFDBAS/ATFILE LIB/LIBF- A ILE) A R WINCTL SFLCTL (WIN1) A*%%TS SD 20090202 123459 MUNSHIJ REL-V4R2M0 5769- PW1 A ALTNAME ('y') A SFLSIZ (0004) A SFLPAG (0004) A WINDOW (FOOTER) A ROLLUP (27) A ROLLDOWN (28) A CF12 (12 'Cancel') A 50 SFLDSP A N51 SFLDSPCTL A 51 SFLCLR A 1 2'Select Option,Press enter' A 2 3'1= Select' A R FOOTER A* A WINDOW(8 31 9 43) A 8 4'F12 = Cancel' A R DUMMY ASSUME A 24 10' ' in RPG: Dow *IN12 = *Off Write Footer Fxfmt WInCTL

2 Answers  

how to retrieve RRN value in RPGLE program

3 Answers  

What is use of IMPORT and EXPORT in RPGLE ? What is activation Group ? What is Service Program ???? How to call another program in RPGLE ?

1 Answers  

purpose of pannel group??/

2 Answers   CTS,

In RPG program one file using as a PRIMARY file while running program some of the records reading twice any body know why its happening

2 Answers  

Mr.Yallamanda Reddy P thanks for your answer sir,can we use test(D) opcode in RPG/400,if yes please help me by eloborating on that answer by writing a sample code for that sir

2 Answers   iGate,

How to handle duplicate error handling in RPG?

0 Answers  

How Commitment and Roll back control is used in as400, explain with real time senario ???

2 Answers   Acolite, HSBC,

How do you code file / field renames in ILE RPG?

4 Answers   Accenture, IBM,

As Packed veriable store 2 digits in 1 byte and ZONE variable store 1 digit in 1 byte... Please tell me when we have to use Packed and Zone variable...?

1 Answers