My DB2 program first read the data from a file and then it
look into a table with the data it got from the file.If we
did not bind the program , should the file read before SQL
execution be success??

Answer Posted / reddy

Program successfully reads the file as the Bind is only for
DB2 queries and it would give an abend(-805) once it
reaches the SQL statement.
Any comments

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for FETCH in DB2 ?

899


List down the types of triggers in the db2 database?

769


How many types of page locks can be held in db2?

800


What is db2 catalog database?

785


What is a bind in db2?

768


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

2017


How to execute stored procedures?

833


What is runstats utility in db2?

757


What is the reason behind not using select * in embedded sql programs?

833


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2653


What is dclgen (declaration generator)?

808


What is difference between rollback and commit?

863


What is cloudant database?

834


What is a db2 package?

783


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?

8285