what are the SQL codes u freequently got?

Answer Posted / krishnan

-805 program is not present in the plan.
u need to compile,package and plan the program once

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3797


What is the default page size of buffer pools?

650


How does a cursor work?

559


What is explain plan in db2?

592


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

662






What are the contents of a dclmgen?

630


What does db2 plan contain?

573


What is a db2 tablespace?

602


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7521


What are iseries servers?

569


Why db2 is called db2?

596


what is diffrence b/w file-aid tool and file-aid utility???

4183


How to execute stored procedure in db2 command editor?

532


How will you return the number of records in table?

518


What r the comman abends in db2, jcl and cobol???????

1820