An Ada/SQL (Structured Query Language) Application Scanner.

• Main Authors: Brykczynski, Bill R, Friedman, Fred, Heatwole, Kevin, Hilliard, Kerry
• Other Authors: INSTITUTE FOR DEFENSE ANALYSES ALEXANDRIA VA
• Format: Text
• Language: English
• Published: 1988
• Subjects: Computer Programming and Software; *HIGH LEVEL LANGUAGES; COMPUTER PROGRAMMING; PROGRAMMING LANGUAGES; DEPARTMENT OF DEFENSE; SCANNERS; DATA BASES; MANAGEMENT; SYSTEMS ENGINEERING; COMPILERS; LPN-IDA-T-W5-206; Ada Programming Language; Structured Query Language; DDL(Data Definition Language); SQL Programming language; DML(Data Manipulation Language); Software engineering; SBI1; FY88; Ida; DML
• Online Access: http://www.dtic.mil/docs/citations/ADA194517; http://oai.dtic.mil/oai/oai?&verb=getRecord&metadataPrefix=html&identifier=ADA194517

This IDA Memorandum Report identifies and describes a version of software delivery, the Ada/SQL Application Scanner. The purpose of this software system is to provide a tool which will aid in the generation of subprograms necessary for a Level 1 Ada/SQL implementation. Ada/SQL is an interface between the Ada programming language and the database programming language SQL. Ada/SQL, like SQL, comprises two main components: a Data Definition Language (DDL) and a Data Manipulation Language (DML). Both the DDL and the DML are coded using pure Ada syntax and semantics. The DDL resides in a package specification and is used to define the data types, variable definitions, and table and column definitions. The DML is expressed as syntax very similar to the syntax of SQL DML. This expression is allowed due to a set of underlying operators and subprograms which must be 'with'ed by the application. However, many of these subprograms are application dependent and are tedious to code. To alleviate the coding of these subprograms, a tool, the Application Scanner, has been developed. The Application Scanner reads the Ada/SQL data definition package, the Ada/SQL data manipulation package, and various other packages to determine exactly the necessary functions and procedures required for completion. If errors are found in any of these files, a listing will be generated showing the text of the package, and pointer to the appropriate line number and column position where the error occurred.