Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

How can I add a field to the end of a physical file?

How can I add a field to the end of a physical file? Is it possible to add a field in LF? I know one way is by editing the source using option two from wrkmbrpdm. I will change the parm LVLCHK to *No so that I don't have to recompile all programs. But is there any other way? Is it possible by CHGPF?

The CHGPF command (& SQL Alter Table) can be used to add, remove, and change columns from physical files and SQL tables. Logical files would have to be dropped and recreated.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.


Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close