Interested to Buy Any Domain ? << Click Here >> for more details...
wht steps we need will coding cobol and db2 pgm ?
- 6 Answers
- 10418 Views
- CGI, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankitha
when you start coding any DB2 pgms you should include SQLCA
and DCLGEN member in w-s section and perform activities of
coding which need to be processed in procedure division.
all statements should be scoped in EXEC SQL and END-EXEC scope
only and you should precompile, create package and plan, you
should run this pgm by using plan. these are the steps we
follow these days.
i this this will help you
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / yuvaevergreen
step1>>put all the sql statements in cobol program inside
exec sql and end-exec.Because precompiler identifies using
sql using these keywords.
step2>>all sql statements should be within 12th and 72th
column in program.
step3>>Include the dclgen if created or use the host
variable declaration name and sqlca.
step4>>precompile,compile,bind,linkedit and execute.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jujubi
when you start coding any DB2 pgms you should include SQLCA
and DCLGEN member in w-s section and perform activities of
coding which need to be processed in procedure division.
all statements should be scoped in EXEC SQL and END-EXEC
scope
only and you should precompile, create package and plan, you
should run this pgm by using plan. these are the steps we
follow these days.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / niveditha
This question does not make any sense. please explain correctly
| Is This Answer Correct ? | 1 Yes | 2 No |
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is the syntax required for the creation of a cursor?
What is view db2?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is explain plan in db2?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is CHECK PENDING ?
How can you quickly find out the # of rows updated after an update statement?
What are the uses of db2 optimizer?
COBOL 
