DB2 program preparation these you need to know

DB2 Program

To prepare DB2 program you need to know about bind, host variables, Plan and package. You can embed DB2 SQL and database connections in COBOL or PL/I modules. Explained all the details here.

  • A. DB2 Program Preparation Prepare your COBOL program by giving Table layout in the form of copy book.
  • B. The SQL Pre-compiler – It converts all DB2 statements into COBOL callable statements.
  • C. SQL Pre-Compiler OptionsList of compiler options
  • D. The Bind Function – Before your DB2 application run, you must use BIND command to bind the DBRM to a package. For example, you might decide to put certain SQL statements together in the same program in order to precompile them into the same DBRM and then bind them into a single package.
  • E. A Typical Bind Statement – Plan – This is executable statement.
  • F. A Typical Bind Statement – Package – A package can contain multiple DBRMs
  • G. Multiple Program Applications – You can use DB2 both in main and sub-program.
  • H. Multiple DBRM Bind – Multiple DBRMS using bind you can create a package.
  • I. Executing DB2 Programs – You can read sample DB2 COBOL JCL
  • J. The DSN Command – The DSN session which runs under TSO in mainframe. All of the DSN subcommands, except SPUFI, run under DSN in either the foreground or background, and all, except END, also run under DB2 Interactive (DB2I). SPUFI runs only in the foreground under ISPF.
  • K. The Run Subcommand -The DSN subcommand RUN executes an application program, which can contain SQL statements.

Also read

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.