pls help me abt these questions..

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
abcdef1234
Member
Posts: 6
Joined: Mon Aug 27, 2007 2:39 pm

pls help me abt these questions..

Post by abcdef1234 » Fri Sep 14, 2007 12:12 pm

hi .

pls give me answers for the follwing questions

1) Tell me COBOL-DB2 compilation process? How U can run this program?

2) What is DBRM? What is use for Per-compilation time?

3) What is BIND & PAKAGE & PLAN?

4) What is the use of PAKAGE during pre-compilation time?

5) What is time-stamp-token?

6) What is -818 SQL error? When U are get this error? How U going to solve?

7) What is -811 SQL error? When U are get this error? How U going to solve?

8) What is -922 SQL error? When U are get this error? How U going to solve?

9) What are the compiler options is there? Give me some examples?

10) What is WITHHOLD option? Why its need for CURRSOR?


Thanks
krishna

User avatar
DavidatK
Active Member
Posts: 65
Joined: Tue Mar 27, 2007 8:41 am
Location: Troy, MI USA

Post by DavidatK » Sat Sep 15, 2007 3:40 am


giri
Member
Posts: 8
Joined: Tue Sep 04, 2007 1:47 pm

Post by giri » Fri Sep 21, 2007 1:46 pm

What is DBRM? What is use for Per-compilation time?


its an content which contains executable sql codes in our program.and at the time of pre-compilation the cobol lines and sql codes will divide in to two parts and all sql code will store in dbrm. and after that in BIND phase it will execute and create plans or packages.

giri
Member
Posts: 8
Joined: Tue Sep 04, 2007 1:47 pm

Post by giri » Fri Sep 21, 2007 2:06 pm

What is -811 SQL error? When U are get this error? How U going to solve?


It will come when u r not using cursors and using select stmt in which the stme gettinhg more than one record .

User avatar
guru
Member
Posts: 24
Joined: Fri Apr 20, 2007 7:17 pm

Post by guru » Thu Sep 27, 2007 5:21 pm

Why dont you try to find the answers in the manuals yourself? Are you too busy?

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others