{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Class04.2_NX_SQL_COBOL_Assignment3_Tutorial_Spring2009

Class04.2_NX_SQL_COBOL_Assignment3_Tutorial_Spring2009 -...

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

View Full Document Right Arrow Icon
BCIS 4620 Assignment #3 SQLCOBOL Project Running COBOL with Embedded  SQL Code
Background image of page 1

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

View Full Document Right Arrow Icon
Assignment Overview 1. Project folder created 2. All files included; FILE.INFILE,  SQLCA.CPY 3. Edit COBOL program.  SQLCOBOL.CBL 4. Maintain SQL Environment CREATE all TABLEs and VIEWs DEPT, DEPARTMENT, EMP, VPHONE Primary, foreign key constraints 5. Rebuild/Run
Background image of page 2
We will use the SQLCOBOL.CBL  program provided by Instructor 1. Open a New PROJECT folder 1.  I suggest you create the physical  subdirectory  first.    Put it on the  Drive you plan to do most of your programming.    This may be your Flash Drive
Background image of page 3

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

View Full Document Right Arrow Icon
SQLCOBOL.CBL, FILE.INFILE
Background image of page 4
Select the Main COBOL  Program
Background image of page 5

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

View Full Document Right Arrow Icon
That Was Easy!
Background image of page 6
Check “Yes”
Background image of page 7

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

View Full Document Right Arrow Icon
SQLCA.CPY?
Background image of page 8
SQLCA.CPY – COBOL Copylibrary  Program (COPYLIB)
Background image of page 9

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

View Full Document Right Arrow Icon
All Files Present in Workspace
Background image of page 10
Start to Edit COBOL program
Background image of page 11

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

View Full Document Right Arrow Icon
Search/Find in Text
Background image of page 12
Find “BECKER”  [line 03080]
Background image of page 13

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

View Full Document Right Arrow Icon
Replace ALL… [8 fixes]
Background image of page 14
Adjust the Sequence Identifier in  Columns 73-80 [8 fixes]
Background image of page 15

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

View Full Document Right Arrow Icon
Save Close  “Find/Replace”
Background image of page 16
Find “DEPARTMENT”
Background image of page 17

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

View Full Document Right Arrow Icon
Find “VPHONE” the VIEW
Background image of page 18
Missing “DEPARTMENT”
Background image of page 19

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

View Full Document Right Arrow Icon
DEPARTMENT = Backup Copy of  DEPT
Background image of page 20
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '08
  • staff
  • PostgreSQL, Check box, Comparison of relational database management systems, Edit COBOL program., COBOL program.  SQLCOBOL.CBL

{[ snackBarMessage ]}