Re: changing keys of a physical file

In DB2 a key is very similar to a physical file constraint.  You can 
either use iSeries Navigator to add/remove constraints, look at the 
fields, etc, or use ADDPFCST/RMVPFCST to maintain these.

However, if the goal is to keep the same key, but add other keys then you 
may wish to use SQL to create indexes.  If you are SQL phobic you can 
always create logical file DDS from scratch and use that to create your 
indexes.

Rob Berendt
-- 
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)




"SANTOSH PRASAD" <santoshp@xxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/21/2003 09:58 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Fax to

Subject
changing keys of a physical file













I joined my company in 1999 and have been working with DB2/400 and cobol 
on
AS400.
But, the system has been running here since 1994 when only physical files
were been used.
We do not have much expertise for handling physical data file.
Now we, need to change keys of a physical file.
How can we do it ?
I can say that there is no DDS source of the file in the system.
Plz help.
regards
Santosh.
e- mail at :  santoshp@xxxxxxxxxxxxxxxxx
FPC-IS, ITS, Tata Steel.
Jamshedpur, India.
Tel : 21-47095 (O) .




********************************DISCLAIMER***********************************
  Information contained and transmitted by this e-mail is confidential and
proprietary to Tata Steel Ltd. and is intended for use only by the
addressee. If you are not the intended recipient , you are notified that
any dissemination or copying of this e-mail is strictly prohibited and you
are requested to delete this e-mail immediately and notify the originator.
Tata Steel does not enter into any binding agreement with any party by
e-mail. Any views expressed by an individual do not necessarily reflect 
the
view of Tata Steel. Tata Steel is not responsible for the consequences of
any actions taken on the basis of information provided. While this e-mail
has been checked for all known viruses the addressee should also scan for
viruses. To know more about Tata Steel please visit www.tatasteel.com
********************************************************************************

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.