TL;DR: In this article, a system and method enabling the use of a COBOL compatible structured query language (CCSQL) to manipulate data stored in a CoBOL data file, which is in a non-first normal, hierarchical format is presented.
Abstract: A system and method enabling use of a COBOL compatible structured query language (CCSQL) to manipulate data stored in a COBOL data file, which is in a nonfirst normal, hierarchical format. Initially, a dictionary generator subsystem creates a corresponding dictionary for each COBOL data file. In the dictionary, the NF 2 hierarchical logical relationship between the items and attributes (hierarchical nature) of each item of a COBOL data file are defined. Thereafter, whenever a new COBOL data file is produced, a corresponding dictionary is generated. When a user enters a request in the CCSQL format to query a COBOL data file, the request is parsed. The definitions in the dictionary are used by the CCSQL kernel to manipulate the data in response to the user's query. A command interpreter processes the request to determine the appropriate data manipulation to apply and initiates a CCSQL kernel request that carries out the intended action, with reference to the corresponding dictionary. For example, the request may require that certain items from a COBOL data file be extracted to produce a report. Because the hierarchical logical relationships between the items in the COBOL data are defined in the corresponding dictionary, a CCSQL report generator subsystem can produce the report using data extracted from the COBOL data file in accordance with criteria provided by the user, but without converting the data in the COBOL data files to a 1NF. COBOL programs with embedded CCSQL commands are preprocessed to convert the CCSQL commands to a COBOL compatible structured language that uses the dictionaries to access data referenced in the COBOL data files.
TL;DR: The program development process introduction to structured programming principles of report design - report program design and coding conditional operations designing and writing control break programs principles of file processing.
Abstract: The program development process introduction to structured programming principles of report design - report program design and coding conditional operations designing and writing control break programs principles of file processing.
TL;DR: A structured approach to learning the Cobol computer language on a microcomputer, this book presents fundamental algorithms, stresses principles of good programming, and introduces debugging techniques.
Abstract: From the Publisher:
A structured approach to learning the Cobol computer language on a microcomputer, this book presents fundamental algorithms, stresses principles of good programming, and introduces debugging techniques. Also shows how the language is used to implement common data processing tasks such as file updating, table loading, and control break processing. Contains many examples and problems.
TL;DR: In this paper, a CCSQL-compatible structured query language (CCSQL) is used to manipulate data stored in a COBOL data file, which is in a non-first normal, hierarchical format.
Abstract: A system (10) and method enabling use of a COBOL compatible structured query language (CCSQL) to manipulate data stored in a COBOL data file (90), which is in a non-first normal, hierarchical format. Initially, a dictionary generator subsystem (68) creates a corresponding dictionary (74) for each COBOL data file (90). In the dictionary (74), the NF2 hierarchical logical relationship between the items and attributes (hierarchical nature) of each item of a COBOL data file are defined. Thereafter, whenever a new COBOL data file is produced, a corresponding dictionary is generated. When a user enters a request in the CCSQL format to query a COBOL data file, the request is parsed. The definitions in the dictionary are used by the CCSQL kernel (78) to manipulate the data in response to the user's query. A command interpreter (64) processes the request to determine the appropriate data manipulation to apply and initiates a CCSQL kernel request that carries out the intended action, with reference to the corresponding dictionary (74). For example, the request may require that certain items from a COBOL data file be extracted to produce a report (82). Because the hierarchical logical relationships between the items in the COBOL data are defined in the corresponding dictionary, a CCSQL report generator subsystem can produce the report using data extracted from the COBOL data file in accordance with criteria provided by the user, but without converting the data in the COBOL data files to a 1NF. COBOL programs with embedded CCSQL commands are preprocessed to convert the CCSQL commands to a COBOL compatible structured language that uses the dictionaries to access data referenced in the COBOL data files.
TL;DR: A case study of a fictional company, Prestige Gifts Inc followed by 10 programming modules that ask the students to write integrated programs geared to the needs of the company.
Abstract: Part I: The basics. The COBOL language and its syntax. Coding the identification and environment division. Identifying and defining program output. Identifying and defining program input. Introduction to the procedure division. Part II: The algorithms. The standard program algorithm. Creating a sequential file. Coding the edit program. Writing the control break program. Using indexed files in COBOL programs. Updating a master file. Sorting in a COBOL program. Using tables in a COBOL program. Part III: The building blocks. All COBOL verbs, clauses, phrases, and other language elements presented in alphabetical order and discussed in detail. Part IV: The applications. A case study of a fictional company, Prestige Gifts Inc followed by 10 programming modules that ask the students to write integrated programs geared to the needs of the company.