what types of copies can be made with the COPY Utility ?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is the usage of open cursor command?
How does db2 sample database connect?
what is the sqlcode -501
Where could you look if you had a question about whether a column has been defined as an index?
How does the processing of a correlated subquery differ from a non correlated subquery?
What do you mean by cursor?
How does DB2 store NULL physically?
What do you mean by NOT NULL? When will you use it?
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 are the rules for db2 programming?
what is the input to PLAN? what is the input to DBRM?