Home > IT Answers > AS/400 > Changing Table with RUNSQLSTM
Las Vegas Lopez
5 pts.
 Changing Table with RUNSQLSTM
DDM, QDDSSRC, RUNSQLSTM, SQL
I have a table that I need to increase in size. It was created using QDDLSRC and the RUNSQLSTM command. This table has a DDM file connected to it. Is the a CHANGE TABLE or REPLACE TABLE statement that I could replace the CREATE TABLE statement with so I can rerun the RUNSQLSTM and leave the DDM file attached? Or do I need to delete both and recreate them?

Software/Hardware used:
ASKED: December 13, 2007  5:54 PM
UPDATED: August 12, 2009  6:06 PM
RELATED QUESTIONS
Answer Wiki:
You should be able to just a a CHGPF command and increase the file size.
Last Wiki Answer Submitted:  August 12, 2009  6:06 pm  by  CharlieBrowne   33,710 pts.
All Answer Wiki Contributors:  CharlieBrowne   33,710 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Never mind I figured it out. I used a ALTER TABLE command to change the field length

Las Vegas Lopez
 5 pts.