Home > IT Answers > Development > Changing Table with RUNSQLSTM
Help

Question

  Asked: Dec 13 2007   5:54 PM GMT
  Asked by: Las Vegas Lopez

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?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

CREATE ANSWER
View History
Start this Answer and Earn your Knowledge Points!

By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.

Browse more Questions and Answers on Development and AS/400.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

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

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