Home > IT Answers > join logical file
Spandanaacha
5 pts.
 join logical file
rpg db2
can you do update operation on join logical file

Software/Hardware used:
ASKED: November 16, 2011  4:06 PM
UPDATED: November 23, 2011  3:39 AM
RELATED QUESTIONS
Answer Wiki:
A Join Logical file is a READ only file. Here is a web page that explains how to to it and all you need to know about join files. http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fdbp%2Frbafox2phyf.htm
Last Wiki Answer Submitted:  November 16, 2011  5:34 pm  by  CharlieBrowne   32,905 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,905 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

can you do update operation on join logical file

Maybe yes, maybe no. It depends on what your “join logical file” is, what version of the OS you’re running and possibly how you intend to perform the update.

For many cases, you can create an http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Fsqlp%2Frbafyinsteadofsql.htm that can make your view updateable.

See Perform the Impossible: Update a Multi-Table View using INSTEAD OF Triggers and INSTEAD OF Triggers Provide Additional Possibilities for DB2 Developers for some general background.

Tom

TomLiotta
 108,260 pts.
 

That should have been “…create an INSTEAD OF trigger…”.

Tom

TomLiotta
 108,260 pts.