What is an alias?
Answers were Sorted based on User's Feedback
Answer / wellwisher
Alias is an alternate name of the table. It will be droped
when the base table is deleted.
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / mehdee
That is correct, Alias is an alternate name of the table
and it is used so that application programs will always be
right accessing these DB2 tables, for example:
table name alias name
- - - - - - - -
TABLE_A DATA_FOR_MON_0 (current mon)
TABLE_B DATA_FOR_MON_1 previous
TABLE_C DATA_FOR_MON_2
> now at the end of the month we want to purge the 3rd
month data and start fresh to add or load data for the
duration of the new cuurent month, so what DBADM does is
they simply EMPETY the last month DB2 table and reALIAS the
other two as:
table name alias name
- - - - - - - -
TABLE_C DATA_FOR_MON_0 (current mon)
TABLE_A DATA_FOR_MON_1 previous
TABLE_B DATA_FOR_MON_2
So the application programs using alias name will always
be right about which table is for which month.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ram.g
the last ans is wrong.
alias usually used to hide the location of ds. alias wont
be dropped when ts is dropped. it's avaiable to all.
Is This Answer Correct ? | 1 Yes | 2 No |
Q3. How will you fetch duplicate values from a DB2 table?
what is the process of precompiler?
What is the use of db2 optimizer?
Where are plans stored?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What does DSNDB07 database do?
Can we update view in db2?
Explain about rct.
What is a lock?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?