Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
1 7143How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
2 9212In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
1 10416
What happens when we move a comp-3 field to an edited (say z (9). Zz-)?
Name some translator and compile options and explain their meaning?
We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?
What is nvl in db2?
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.
What is db2 connect?
Explain in DD statement what is the use of DCB parameter?
Explain the difference between a symbolic map and physical map?
What are the different rules of SORT operation?
how can we repair a soc-7 error?
What is mpp mode?
What is the meaning of the deq command?
How do I change the column size in db2?
what is the responsibility of the construction superintendent
Which commend used for terminating a browser operation?