What is dynamic SQL?
Answer / s
Dynamic SQL are built at execution time. Dynamic SQL does
not go through the program preparation process like static
SQL and can execute different SQL statements in one
program.
| Is This Answer Correct ? | 0 Yes | 0 No |
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What do you need to do before you do EXPLAIN?
What is sqlca?
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??
How to resolve -805 error in DB2?
Give the name of some fields form sqlca.
What is release/acquire in bind?
How can you find out the # of rows updated after an update statement?
How can we read records for specific member in CL? AND rpg?
How many Buffer pools are there in DB2 and what are they?
Is db2 a mainframe?
What is meant by union and union all?