How to update physical file using logical file with example?
- 1 Answers
- 1151 Views
- I also Faced
- E-Mail Answers
Answer Posted / Reshu Kumari
In DB400, you can update a physical file (PHLFILE) using a logical file (LLLFILE) by using the SQL UPDATE statement. Here's an example:nn```sqlnSET EXEC SQLnUPDATE PHYSICAL_FILE SET COLUMN1 = 'New Value 1', COLUMN2 = 'New Value 2' WHERE KEY_COLUMN = 'Key Value';nEND-EXEC;n``
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
