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
How to create backup table in db2?
On which levels locks can be applied?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
what is utility for parm lib
What is buffer pool and list some of them?
What is the picture clause of null indicator variable?
What is load utility in db2?
How to find the number of rows in db2 tables?
How can you find out the # of rows updated after an update statement?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is null indicator in cobol db2?
Are views updateable?
Is ibm db2 free?
Comment whether the cursor is closed during commit or not.