Changing Table with RUNSQLSTM
Home > IT Answers > Development > Changing Table with RUNSQLSTM
Las Vegas Lopez
5 pts.
0
Q:
Changing Table with RUNSQLSTM
SQL, DDM, RUNSQLSTM, QDDSSRC
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?
ASKED: Dec 13 2007  5:54 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
CharlieBrowne
6500 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You should be able to just a a CHGPF command and increase the file size.
Last Answered: Aug 12 2009  6:06 PM GMT by CharlieBrowne   6500 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Las Vegas Lopez   5 pts.  |   Dec 13 2007  7:00PM GMT

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

 
0