Home > IT Answers > AS/400 > AS400
Help

Question

  Asked: Jun 20 2007   2:50 PM GMT
  Asked by: AS400person

AS400


AS/400, Application development, Backup & recovery, CLP, DB2 universal database, Printing, RPG, RPGLE, Security, DataCenter

hi,
i want to know about the answers of these questions..

1.)
If any data has been deleted from the PF then how can we recover that and what are the limitiations for that.

2.)
If in run time user want to choose the Access Path of a PF then how can it be possible.

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)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jun 20 2007  3:24 PM GMT  by BigKat




re question 1: if you journal the PF, you can determine what was deleted and restore the data.

re both questions: you really need to provide more information if you expect to get a reasonable answer. Try to include OS version, language(s) being used, and if possible samples of code causing the problem. Also, be sure to include enough code to see the problem line in context, as many times problem at point a causes line at point b to fail.

hope this helps some -- BigKat
  • AddThis Social Bookmark Button

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

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


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

Knowledgeseekerone  |   Sep 26 2007  4:06PM GMT

The access path is created when you do an opnqryf for your file in cl. Not sure if you can choose between access paths at run time

 

Kevleemor  |   Dec 20 2007  5:20PM GMT

Within the RPG program you can specify user open on each access path (USROPN) then within the program you can use logic to control the open and close of the access path you require.

Some utility packages allow deleted records to be recovered, I haven’t had any reason to do this outside of journalling.