Answer Posted / prasad botu
no user cant access data in db2 directory by sql but it db2
can access it for its internal purpose...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What's The Percentage Free Space ?
Why cursor is used in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is the role of data manager in the db2 database?
What is the use of runstats in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the difference between using bind () and rebind () methods of naming class?
Define sqlca.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
can we view the access paths created by dbrm ? how ? thx
What type of database is db2?
What is null indicator in db2?
What is dbrm? When it will be created?
What is host variable in db2 cobol?