how to update physical files using normal logical file

Answers were Sorted based on User's Feedback



how to update physical files using normal logical file..

Answer / anand

in the above code file should be in update mode or file
addition mode

Is This Answer Correct ?    8 Yes 0 No

how to update physical files using normal logical file..

Answer / keshar jain

HI,
To Update physical file in RPG use opcode UPDATE.
example
FLF1 IF E k DISK
key1 Setll LF1
READ LF1
UPDATE LF1

Note: Logical file should be simeple logical file. We can't
update physical file with help of Join logical file.

Is This Answer Correct ?    9 Yes 5 No

how to update physical files using normal logical file..

Answer / anand

what Keshar Jain is saying is correct but open the logical file in update mode i.e FLF1 UF E k DISK

Is This Answer Correct ?    2 Yes 0 No

how to update physical files using normal logical file..

Answer / abhishek agrawal

Hi,,Whatever code written above is right...but opcode for
update in rpg is 'updat'...so the right statement will be
Updat flf1

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More DB400 Interview Questions

Last statement of any rpg program is lr?

0 Answers  


Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  


1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,


Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


Maximum how many fields we can create under a record format of PF?

5 Answers  


pls anyone explain about compile time array,pre run time array run time array

4 Answers  


how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,


how to know total no of records in pf with out using sql??????

3 Answers  


How to update physical file using logical file with example?

0 Answers  


what is use of self join and which cases you will use this join

1 Answers   TCS,


I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,


Categories