Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different methods of accessing db2 from tso?
How is the connection established between TSO & DB2?
- 3 Answers
- 14150 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 |
what is the difference between declaring the cursor in WS section and Procedure division?
What is the difference between db2 and oracle?
What is meant by AUTO COMMIT?
Explain the benefits you can get from mainframe connect?
What's the difference between DB2 active log and archive log? Thanks a lot...
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
When can an insert of a new primary key value threaten referential integrity?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is dbrm? When it will be created?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
Hi All, In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)
COBOL 
