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 FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  


Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  


What is reorg in database?

1 Answers  


How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,


What is cobol db2?

0 Answers  


Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,


i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


What is correlation names?

1 Answers  


Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,


What is the use of predicate?

0 Answers  


What does the REORG Utility do?

2 Answers  


how to take the back up of the DB2 table.

7 Answers  


Categories