Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

I have a pf, it contains 5 members, how to access particular member data from logical file?

0 Answers  


what is general and type of general

1 Answers   Active Brains,


How to know the perticular record in pf with out reading?

2 Answers   Cap Gemini,


what is the difference between adding keys & constraints into a phisical file

6 Answers   HSBC,


How we can't update join logical files?

10 Answers  


CRTDTA AND CRTARA should be used along with?

2 Answers  


I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?

0 Answers  


How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?

3 Answers  


If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  


I had created one physical file tell me command to enter data in to?

1 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,


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

1 Answers   HCL,


Categories