How is a typical DB2 batch program executed ?
Answer / s
You can use TSO to run a batch program using the TSO
Terminal Monitor Program IKJEFT01 which involes the DSN
command and runs the application program.
| Is This Answer Correct ? | 1 Yes | 0 No |
How can you do the explain of a dynamic sql statement?
What are the three lock types?
Mention the definition of cobol in varchar field.
Mention the location where the output received from explain statement is stored.
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
what's the error code for Unique Index Violation?
What is an alias?
What is bind and rebind in db2?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is an access path?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.