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

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.

What is the information associated with sysibm.syslinks table?

0 Answers  

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---

How is the value function used?

0 Answers  

---

difference between group clause and order clause

1 Answers  

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---

How can deadlocks be resolved?

0 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---