How to “Create Ad Hoc Parameters” …

Background Knowledge:

The word “Ad Hoc” simply means a specific purpose, case, or situation. Ad Hoc is a utility program in the NTCSS environment that enables R-Supply user to create customized queries. The user can select specific data elements from the database tables for display. Additionally, the user can establish criteria for the data elements, perform calculations, sort and group items, and specify print formats. In other words, it is all up to the user's unlimited imagination how the reports will look like or what informations are to be displayed on the report.

The primary purpose of Ad Hoc is to quickly generate customize reports or pull out information stored in R-Supply database.  Caution…large Ad Hoc Queries can substantially slow down the system. Ad Hoc is very powerful tool for querying data from various tables in R-Supply database.

What is Ad Hoc Query? Ad Hoc Query is a set of SQL (Structured Query Language) statements to generate customized reports. It is used to pull information from your database for managers who want immediate answers. Departmental managers, line managers, and other business managers often need fast answers to very precise operational questions. Ad hoc delivery of specific data is a key component of Enterprise Reporting, designed to speed up and improve decision-making.

What is SQL? SQL (Structured Query Language) is an ANSI standard computer language for accessing and manipulating relational databases. SQL is used to access, define, and manipulate data in Oracle, DB2, Sybase, Informix, Microsoft SQL Server, Microsoft Access, and other database systems.

What is “Relational database”? A relational database is a set of tables containing data fitted into predefined categories. Each table (which is sometimes called a relation) contains one or more data categories in columns. Each row contains a unique instance of data for the categories defined by the columns. It is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. The relational database was invented by E. F. Codd at IBM in 1970. The standard user and application program interface to a relational database is the structured query language (SQL). SQL statements are used both for interactive queries for information from a relational database and for gathering data for reports.

'Ad Hoc' training material is available at the site mention below:

LOGON to or click the link: http://www.force-rsupplyViking.com and click on the links provided at the HomePage... or simply Click on any of the three links below.)

(1) Ad Hoc Crash Course

(2) Ad Hoc simulated process (Click-by-click simulation)

(3) Ad Hoc Trainee Guide

Any questions, feedback or comments, email Lonnie Auza. (absalon.auza@navy.mil)