why we go for SPUFI for creating tables or for sql queries?
Answer Posted / vijay krishna
SPUFI is abbreviated as SQL Processing for File Input.
Through SPUFI, you can execute a set of queries one time by
feeding an input file and whereas through QMF, you can
execute only one query at a time.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define check constraint.
Define predicate?
What is db2?
What is explain plan in db2?
How to restart a DB2 program?
What is the usage of open cursor command?
What is page size in db2?
What is the advantage in De-normalizing tables in DB2?
How do I add a column to a table in db2?
What is multi row fetch in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is declare cursor?
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 ?...
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is check constraint in db2?