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 |
Explain about dbrm.
Name some fields from SQLCA
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is access path in db2?
What is the difference between drop table and delete table?
What are the advantages of using a PACKAGE?
Which isolation level provides maximum concurrency?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the logical entity between plan and Package?
What is a base table?
difference between group clause and order clause
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.