Interested to Buy Any Domain ? << Click Here >> for more details...
What are the functions of Bind?
- 2 Answers
- 8406 Views
- Amdocs, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha dasari
there are three things bind does:
1. as stated above, it derives the most optimised path for
each SQL in the DBRM.
2. it does a syntax check. this might sound redundant, but
here is where it refers to the DB2 Catalog and verifies the
table names, column names etc.
3. it checks authorization. here is where it checks if the
user has bind access to the table refered.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ms. stanley
To create the most optimal path for the SQL Queries in the
program
| Is This Answer Correct ? | 3 Yes | 0 No |
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
Can there be more than one cursor open for any program?
how to u check the query is executing or not ?where will u check for sqlcode ?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
Describe what a storage group(STOGROUP) is?
What is db2 connect?
B37 abend during spufi?
How to resolve -407 sql code in DB2?
how can we retrieve the 100 records of the file ?
Why db2 is called db2?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
COBOL 
