ENFORM

Enform is a part of ENCOMPASS Distributed Data Base Management System. It is primarily used to retrieve data from Enscribe database, perform calculations, sort and group the retrieved database.

Enform can return the data in form of a file, on the screen or to the spooler.

Important terms:

  • Database – It consists of the physical files which actually contains the data on which one needs to perform query.

  • Dictionary – It is a collection of description of the structure of each record in the database. Enform accesses the dictionary obtains information about the record descriptions and stores that information in the internal table of the query compiler/report writer.

  • Query Specification – It is a detailed description of the information you want to retrieve from database.

  • Query Compiler/Report Writer – It has two functions; compiling the query and formatting and writing a report. The query compiler performs the syntactical correctness, if any error is encountered the error message is generated and query processing is stopped and if the query specification is correct then the query compiler compiles into a form called compiled representation of the query that can be understood by the query processor.

  • Query Processor – It is a server process that receives the query specifications and record description information from the query compiler. After receiving this information, the query processor retrieves data fom the database.

RUNNING AN ENFORM

There are two ways to start ENFORM: Interactively and Non-Interactive mode.

  • In Interactive mode – you can start Enform directly from your TACL prompt by giving ENFORM.

  • In Non-Interactive mode – you can write all the Enform commands into a TEDIT file and execute below command on TACL prompt:

    ENFORM /IN <infile contaning enform commands>/

    If you want to route your output to printer then execute below commands:

    ENFORM /IN <infile contaning enform commands>, OUT <$S.#LOC.LOC/

SYNTAX:

ENFORM
?DICTIONARY <dict subvolume>
OPEN <record name>
?ASSIGN <record name> to <database file>
LIST <fields or records> WHERE <condition>;

2 Comments

  1. Very nice post. I simply stumbled upon your blog and wished to mention that I’ve truly enjoyed surfing around your blog posts. After all I’ll be subscribing to your rss feed and I hope you write again soon!

Leave a Reply

Your email address will not be published. Required fields are marked *