What is a synonym? How is it used?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vinod
A synonym is used to reference a table or view by another
name. The other name can then be written in the application
code pointing to test tables in the development stage and to
production entities when the code is migrated. The synonym
is linked to the AUTHID that created it.
Is This Answer Correct ? | 0 Yes | 0 No |
When would you prefer to use VARCHAR?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
How to resolve -805 error in DB2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How to execute stored procedures?
What is the maximum length of sqlca?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
what is differnece between DROP TABLE & DELETE TABLE .
What is the STOSPACE Utility used for?
What information is used as input to the bind process?
Explain the use of the WHERE clause?