What is a base table?
Answers were Sorted based on User's Feedback
Answer / s
Base table is created by using CREATE TABLE and the table
description is stored in Catalog table SYSTABLES. The
definition and data are persistant.
| Is This Answer Correct ? | 1 Yes | 0 No |
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 ?...
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is an alias?
What is check constraint. Explain with example.
When is the skeleton cursor table created?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How to compare data between two tables in db2?
How to resolve -407 sql code in DB2?
Can one database have multiple instances?
How to get the ddl of a table in db2?