Class04.1_NX_SQL_COBOL_Overview_Spring2009

Class04.1_NX_SQL_COBOL_Overview_Spring2009 - BCIS 4620...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
BCIS 4620 INTRODUCTION TO DATABASE PROCESSING Class 4 NX COBOL/SQL Supplement Spring 2009 Dr. Jack D. Becker
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
NX COBOL with SQL Homework #3 (20 points) Running NX COBOL with SQL SQLCOBOL add to new project folder (.app) Homework 3.A to 3.B (10 points) Basic Install and Test Control Break report FILE.INFILE (copy to SQLCOBOL project folder); FILE.OUTFILE will be produced Install copies of DEPT and DEPARTMENT [Use unique index names] DEPTLOAD.SQL, DEPARTMENT.SQL Install copies of EMP and EMPLOYEE EMPLOAD.SQL, EMPLLOAD.SQL Adjust Location.SQLID to correct locations in SQL/Database CREATE VIEW VPHONE VPHONE.SQL Homework 3.C (10 points) SELECT05.SQL to SELECT24.SQL demos (Some Tables may not exist) EXPORT DEPT & EMP to SQL files
Background image of page 2
NX COBOL with SQL COBOL Source Programs SQLCOBOL.CBL FILE.INFILE SQL/DB2 Data: EMP, DEPT [EMPLOYEE, DEPARTMENT backups] PRE-Compile [Rebuild] PGMPREP SQLCOBOL CBL REFRESH.SQL COBOL Compile [Animator; Run] COBOL2.SQLCOBOL Execution
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/09/2011 for the course BCIS 4620 taught by Professor Staff during the Spring '08 term at North Texas.

Page1 / 18

Class04.1_NX_SQL_COBOL_Overview_Spring2009 - BCIS 4620...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online