Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


wht r the requirements for writing a cobol-db2 pgm ?

Answers were Sorted based on User's Feedback



wht r the requirements for writing a cobol-db2 pgm ?..

Answer / tej

1. Declare the table structure you wanted to access in
working storage section or linkage section.(Can use DCLGEN
here).
2.Declare host variables in Working storage section.(if
DCLGEN used no need of declaring these host variables
separately).
3.Include SQLCA.
3.Now you can add the embedded SQL statements to your program.

Please add if i missed any other info..

Is This Answer Correct ?    2 Yes 0 No

wht r the requirements for writing a cobol-db2 pgm ?..

Answer / yuvaevergreen

Steps in program preparation
>>Step 1: Process SQL statements
>>Step 2: Compile (or assemble) and link-edit the
application
>>Step 3: Bind the application
>>Step 4: Run the application

Is This Answer Correct ?    1 Yes 1 No

wht r the requirements for writing a cobol-db2 pgm ?..

Answer / ali baba

writing a pgm does not involve running it - answer #2 and #3
got that wrong.

Is This Answer Correct ?    0 Yes 0 No

wht r the requirements for writing a cobol-db2 pgm ?..

Answer / ajay kumar ande

3 steps..........

1.)pre-compilation
2.)bind
3.)run

1.PRECOMPLATION
// jobcard job......
// act01 exec pgm=dsnhpc
// DBRMLIB DD DSN=

// act01 exec pgm=IGYCRCTL
// SYSLOAD DD DSN=&&TEMP,DISP=PASS

// act01 exec pgm=IEWL
// SYSLMOD DD DSN=&&TEMP,DISP=OLD

BIND
// act01 exec pgm=IKJEFT01
// DBRMLIB DD DSN=
SYSIN DD *
BIND PLAN( ) MEM( ) ISOLATION(CS) ACTION(REP)

RUN
// act01 exec pgm=IKJEFT01
SYSIN DD *
RUN PROG( ) PLAN( ) LOADLIB( )

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,


What is EXPLAIN?

1 Answers  


Where can you declare a cursor in a cobol-db2 program?

0 Answers  


What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  


What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  


what is the difference between join and union?

4 Answers   IBM,


Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  


How does DB2 store NULL physically?

2 Answers  


If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,


Explain what are the various isolation levels possible?

0 Answers  


is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,


Categories