What are the different methods of accessing db2 from tso?
How is the connection established between TSO & DB2?
Answers were Sorted based on User's Feedback
Answer / guest
You can access DB2 using the interactive TSO/ISPF panels
like SPUFI, QMF. You can also invoke DB2 through TSO batch
by invoking the DSN command processor to run a DB2 program.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / s
DB2I will invoke the DSN command processor to establish a
connection with DB2. SPUFI,QMF also allows access to DB2
from TSO/ISPF.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / k murali krishna
By using QMF and SPUFI, we can access DB2 from TSO
Is This Answer Correct ? | 4 Yes | 1 No |
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
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
How to find primary key of a table in db2?
How can we read records for specific member in CL? AND rpg?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
Mention the different locking levels that are available in db2.
Why cursor is used in db2?
what is the name of the default db2 catalog database?
What is reorg in database?
What is concurrency in db2?
What are the uses of db2 optimizer?