Re: changing keys of a physical file

["Denis Robitaille" <denis_robitaille@xxxxxxxxxxxx>]

For the missing DDS part, easy. You can use the DSPFFD command to
extract the definition of the files. I would also suggest that you use a
logical file to access the physical file with a new key. This way, only
the programs that require the new files need to be changed.

By the way, I have a hard time understanding how you can be working
with DB2 for 4 years without source DDS!!!

Denis Robitaille
Directeur services technique TI
819 363 5187

SUPPORT
Jour (EST) Daytime : 819-363-5087
En-dehors des heures (EST) After hour : 819-363-5095
Network Status : 819-363-5096

>>> santoshp@xxxxxxxxxxxxxxxxx 12/21 9:58 pm >>>







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.