How do I delete a table in database?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the function of data manager.
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is SPUFI?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is dynamic SQL?
How and when does the db2 enforces the unique key?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
How to define the a field which accepts value till 99999.99 in db2
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.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2