we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
2 16513One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
3 16893What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 9827My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
3 113891. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
1 7676What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
2 8153What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
1 5611What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
3 11353i 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.
1946
What is the use of db2 optimizer?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are the bind parameters ibm db2?
Which are the db2 tools to protect integrity of the database?
What is the maximum size of a char data type in db2?
Explain the contention situations caused by locks?
How do you find the maximum value in a column in db2?
What are the rules for db2 programming?
How is deadlock resolved?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Are view updateable?
Explain package in db2 and its advantages?
What is alias in db2?
List out the buffer pools in db2