Answer Posted / s
Synonym is alternate name for a table.
Use of synonyms avoids changes to programs when you migrate
programs from test to production.
create synonym abc for test.abc in test
create synonym abc for prod.abc in production
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the syntax for FETCH in DB2 ?
When the like statement is used?
What is cloudant database?
What is netezza database?
What is the difference between drop table and delete table?
How can you classify the locks in db2?
How to find the number of rows in a db2 table?
What is bind and rebind in db2?
what is utility for parm lib
B37 abend during spufi?
How do I add a column to an existing table in db2?
Is db2 a database?
How does db2 sample database connect?
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 .....
Explain about rct in db2?