Home > IT Answers > AS/400 > Duplicate object (PF) using SQL with same attributes
Anwer
5 pts.
 Duplicate object (PF) using SQL with same attributes
CRTDUPOBJ, LVLCHK, PF, Physical File, RPG, RPG/400, SQL, SQL/400
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

Software/Hardware used:
ASKED: April 5, 2009  6:46 AM
UPDATED: December 15, 2011  10:27 PM
RELATED QUESTIONS
Answer Wiki:
Hi, <a href="http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/index.jsp?topic=/db2/rbafzhctabl.htm&tocNode=toc:rzahg/i5os/4/7/7/7/33/">You should be able to use the CREATE TABLE with the LIKE clause.</a> Regards, Martin Gilbert.
Last Wiki Answer Submitted:  April 6, 2009  10:07 am  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

how to use duplication.?

Bosxz
 10 pts.
 

how to use duplication.?

What are you duplicating? And what are you wanting to “use” it in? (In a program? A manual procedure? Something else?) What problem are you having? How is your problem related to this question thread?

More information is needed in order to give an answer.

Tom

TomLiotta
 108,330 pts.