Name some fields from SQLCA.
Answers were Sorted based on User's Feedback
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.
What is a precompiler?
What is the physical storage length of timestamp data type?
What is the difference between spufi and qmf?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
How would the varchar column remarks defined?
What is ibm db2 database?
Name the lockable units in DB2?
Return code 100 means?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Define predicate?
What is a db2 cursor?