SQL code made simpler
I have 2 files that are clones – created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the [...]

Answer Question   |  June 24, 2011  7:11 PM
CRTDUPOBJ, SQL iSeries, SQL Server, V5R4

Duplicate object (PF) using SQL with same attributes
I want to create a duplicate object using SQL. I don’t want to use CRTDUPOBJ and also do not want to compile my rpg’s pgm because of new file level identifier. Please advice

Answer Question   |  December 15, 2011  6:46 AM
CRTDUPOBJ, LVLCHK, PF, Physical File, RPG, RPG/400, SQL, SQL/400

CPYF and CRTDUPOBJ
What is the actual difference between CPYF and CRTDUPOBJ

Answer Question   |  March 21, 2012  12:36 PM
CPYF, CRTDUPOBJ

ovrdbf doesn’t get deleted with a dltovr
I’ve got a cl that copies a PF file to qtemp then I use CRTDUPOBJ to get a LF attached to the qtemp PF file. Then ovrdbf of LF to qtemp/LF with OVRSCOPE(*JOB). After calling 2 programs to update the qtemp/LF I DLTOVR FILE(*ALL) LVL(*JOB). But the override stays doesn’t get deleted. I can’t figure [...]

Answer Question   |  January 27, 2009  7:21 PM
CL programming, CRTDUPOBJ, DLTOVR, OVRDBF, OVRSCOPE, PF

File pointer is being reset to the top in a CLP program
I am processing the *OUTFILE from a DSPOBJD command. Trying to create a logical file. When the CRTDUPOBJ fails the program loops to the RCVF command but the same record is being read again…WHY??

Answer Question   |  September 26, 2008  4:44 PM
CLP, CRTDUPOBJ, DSPOBJD, File Pointer, RCVF

File Objects creation
Is there any way to find out what command was used by an authorised user to create a file object. Any help is highly appreciated.

Answer Question   |  June 9, 2008  6:30 PM
AS/400, CRTDUPOBJ, iSeries programming commands

Create Duplicate Object using CRTDUPOBJ
I have tried to copy the records from 1 physical file TESTING(PF) to another physical file TESTING1 using CRTDUPOBJ. But after using RUNQRY *N TESTING1 i could not see any records in this help. Can any1 help me.?

Answer Question   |  February 29, 2008  7:26 AM
AS/400, CRTDUPOBJ