Home News Version 1 Tech Support Pubs S2K Site Map

SYSTEM 2000 Quick Reference Guide DEFINE Language Commands

CHANGE component
DELETE
ENABLE/DISABLE EXECUTION
Function Definition
Item Definition
MAP
Record Definition
RENUMBER
STOP AFTER SCAN IF ERRORS OCCUR
String Definition

CHANGE component

Changes the number, name, or description (or any combination) of a component.

Syntax

CHANGE old-number TO new-number :

CHANGE old-number TO |new-number * new-name :
                    |old-number

CHANGE old-number TO |new-number * |new-name (new-description) :
                    |old-number    |old-name

old-number: is the number of an existing component, without the C.
new-number: is a new number for a component, without the C. It can be from 1 to 9999, and it cannot duplicate any existing number.
new-name: is a new name for a component using 1 to 250 characters. It cannot duplicate any existing name, and it cannot contain reserved words or characters. See Reserved Words and Characters in Appendices .
old-name: is the name of an existing component.
new-description: defines a new description for a component. Changes to record inclusion are not allowed. You must specify either a new name or the old name when specifying a new description.

Examples

CHANGE 400 TO 500:

CHANGE 0 TO 0*EMPLOYEE:

CH 201 TO 210*SKILLS (CHAR X(24) IN 200 WITH MANY FUTURE
   OCCURRENCES):

CHANGE 2000 TO 2000*FUNA(FUNCTION $((COUNT C600)/*1*)$):

Rules

Abbreviation: CHANGE = CH
If you do not include the old name, only the component number is changed.
If you do not include a new description, only the component number, the name, or both are changed.
If you are changing any part of a component description, the new description must include all specifications, or the system will use the defaults.
For record C0, you can change only the component name.
All constraints on defining new components apply to changing components.
When you change a schema record number, the software also changes the IN specification record number for its items and descendant records.
You can change non-key items to key or key items to non-key.
You cannot change a parent-child record relationship or the record membership of an item.
You cannot change a component type (for example, item to record). However, you can change a string to a function or a function to a string.
Most changes to an item type or picture are acceptable as long as there are no data in the record (and no reusable space for the record) that the item belongs to. However, REAL, DOUBLE, and UNDEFINED items cannot be changed to other item types and vice versa.

If data exist for the item, you can change the following:

     INTEGER to DECIMAL or MONEY
     DECIMAL to INTEGER or MONEY
     MONEY to INTEGER or DECIMAL
     TEXT to CHARACTER
     CHARACTER to TEXT
     DATE to INTEGER, DECIMAL, or MONEY

If data exist in the record that an item belongs to, you cannot change the picture of DECIMAL, MONEY, or INTEGER items. However, you can move the decimal point.
If data exist in the record that an item belongs to, you can change the picture for CHARACTER and TEXT items. However, the picture must be at least X(4). The picture for an UNDEFINED item cannot be changed.
If a DATE item is changed to a numeric item, the picture must have seven digits.

DELETE

Deletes components and their data from a database definition.

Syntax

DELETE |COMPONENTS        number |[, number] ...   :
       |SCHEMA COMPONENTS        |[THROUGH number]
       |STRINGS
       |FUNCTIONS

number: is the number of an existing component, without the C.

Examples

DELETE COMPONENT 100:

DELETE COMPONENTS 410, 408, 412:

DELETE STRING 4000:

DELETE COMPONENTS 600 THRU 605:

Rules

Abbreviations and synonyms:

     COMPONENTS = COMPONENT
     FUNCTIONS = FUNCTION
     STRINGS = STRING
     THROUGH = THRU or TO

You can delete individual components or a range of components.
Each keyword designates one or more types of components: COMPONENT accepts record, item, string, and function numbers, SCHEMA COMPONENT accepts record and item numbers, STRING accepts string numbers only, and FUNCTION accepts function numbers only.
If you specify THROUGH (for example, 600 THROUGH 605), the first number must precede the second number in DESCRIBE output.
Components separated by commas can be in any order.
If you delete a schema record, all member items and descendant records are also deleted.

ENABLE/DISABLE EXECUTION

Allows the scanning of commands while allowing or preventing the execution of those commands.

Syntax

|ENABLE  EXECUTION  :
|DISABLE

Examples

ENABLE EXECUTION:

DISABLE EXECUTION:

Rules

At the beginning of each Self-Contained Facility session, execution is enabled.
You can enable or disable execution from the DEFINE, QUEST, or QUEUE processor. Commands in all three processors are affected, regardless of which processor the command is issued from.

Function Definition

A function stores an arithmetic expression. Specify the component number and name and arithmetic expression, using the syntax below. This type of function is referred to as a stored function.

Syntax

number * name |[DECIMAL] FUNCTION delimiter (expression) delimiter) :
             |[INTEGER]
             |[MONEY]
             |[REAL]
             |[DOUBLE]
             |

number: is a component number from 1 to 9999.
name: is a component name using 1 to 250 characters. It cannot be a reserved word or character or the current system separator. See Reserved Words and Characters in Appendices .
DECIMAL
INTEGER
MONEY
REAL
DOUBLE
DATE: specifies the function type. The default is DECIMAL.
delimiter: is a single special character to be used as the expression delimiter. The delimiter must appear at both ends of the function expression and cannot appear within the expression. It cannot be the current system separator or command terminator. See Special Characters in Appendices .
expression: defines an arithmetic expression containing one or more item names or component numbers, constants, system functions (AVG, COUNT, MAX, MIN, SUM, SIGMA), arithmetic operators (+, -, *, /), other functions or strings, the system string *FTODAY*, parameters, parenthetical arithmetic expressions, or Collect File items called by retrieval commands.

Examples

3004* YRS EMPLOYED (INTEGER FUNCTION
     $ ((END DATE-START DATE)/365.25)$):

3050* DEDUCTION-ADJ (MONEY FUNCTION/(C114 - 5.50)/):

Rules

Abbreviations and synonyms:

     DECIMAL = DEC
     INTEGER = INT
     REAL = FLOAT
     DOUBLE = DOUBLE PRECISION

Each component must have a unique name and number.
Components do not have to be defined in any order.
Functions are included in the maximum number of components specified with NEW DATA BASE IS.
Each system function within a stored function must be enclosed by parentheses.
Functions can be simple or parametric. Parametric functions contain parameters, whose values must be supplied when the function is invoked. Simple functions have no parameters and are issued by their component name or component number.
You can specify up to 31 levels of nesting, 31 parameters, any combination of the two yielding a total of 31, or a maximum of 1200 characters of function expansion and/or parameters. Parameters can be supplied within a function definition calling another string or function with parameters.
You invoke a function in the action-clause of QUEST retrieval and update commands or in a REPORT action-clause. See SYSTEM 2000 QUEST Language and System-Wide Commands, Version 12, First Edition for information about invoking functions.

Item Definition

A schema item represents a class of values. You specify the component number and name, key status, item type, item picture, record membership, and padding, using the following syntax.

Syntax

number * name ([NON-KEY] |CHARACTER [picture] [IN sr-number]
                        |TEXT
                        |UNDEFINED
                        |INTEGER
                        |DECIMAL
                        |MONEY
                        |REAL
                        |DOUBLE
                        |DATE

     [WITH |NO  FUTURE OCCURRENCES]) :
           |FEW
           |SOME
           |MANY

number

is a component number from 1 to 9999.

name

is a component name using 1 to 250 characters. It cannot be a reserved word or character or the current system separator. See Reserved Words and Characters in Appendices .

NON-KEY

specifies non-key processing. The default is KEY.

picture

is the picture for data to be entered.

CHARACTER default is X(7) with a maximum of 250.
TEXT default is X(7) with a maximum of 250.
UNDEFINED default is X(4) with a maximum of 250; no overflow.
INTEGER default is 9(7) with a maximum of 15.
DECIMAL default is 9(6).9(2).
MONEY default is 9(6).9(2) and can be preceded by $.
REAL never needs a specified picture.
DOUBLE never needs a specified picture.
DATE never needs a specified picture.

Note: For DECIMAL and MONEY items, if the picture is of the format 9(n).9(m), then n and m must each be greater than or equal to zero and less than 11. Their sum must be a positive integer less than 16.

sr-number

is the record component number (previously defined) that the new item belongs to. Do not include the C. The default is 0.

NO

FEW

SOME

MANY

specifies future occurrences for padding. The default is NO.

Examples

1* EMPLOYEE NUMBER (INTEGER NUMBER 9999):

2* LAST NAME (CHAR X(20) WITH FEW FUTURE OCCURRENCES):

4* HIRE DATE (DATE):

11* ACCRUED VACATION (NON-KEY DECIMAL NUMBER 999.99):

303* COMMENT (NON-KEY TEXT X(15) IN 300):

124* GROSS PAY (NON-KEY MONEY $9(4).9(2) IN 120):

511* SAMPLE (UNDEF X(12) IN 500):

513* FPS (NON-KEY REAL IN 500):

514* FPD (DOUBLE IN 500):

Rules

Abbreviations and synonyms:

     CHARACTER = CHAR
     DECIMAL = DEC
     DOUBLE = DOUBLE PRECISION
     INTEGER = INT
     NON-KEY = NK
     REAL = FLOAT
     UNDEFINED = UNDEF

You must specify an item type.
All components must have unique names and numbers.
Items do not have to be defined in any order.
[IN sr-number] determines an item's record membership. However, the parent record must be defined before its items or descendant records.
Items are included in the maximum number of components specified with NEW DATA BASE IS.
If CHARACTER or TEXT values exceed the picture, those items must have at least a 4-character picture. Numeric and UNDEFINED items cannot overflow.
The pictures of INTEGER, DECIMAL, and MONEY items do not need a position for a + or - sign.
Only key items can have padding.
The order in which you define items determines their top-to-bottom order within a record.
For clarity, you can specify the keyword NUMBER after INTEGER, DECIMAL, MONEY, REAL, and DOUBLE items. (You can abbreviate NUMBER as NUMB or NUM.)

MAP

Processes DEFINE commands and places the results in the database definition.

Syntax

MAP [[ordering-clause] where-clause] :

ordering-clause: specifies the order of selected data records. Use only level 0 items. A where-clause is required if an ordering-clause is specified. See Ordering-Clause in QUEST.
where-clause: selects specific data records. The SAME operator cannot be included. See Where-Clause in QUEST.

Examples

MAP:

MAP WHERE HIRE DATE GT 01/15/90:

MAP ORDERED BY LAST NAME WHERE HIRE DATE GT 01/15/90:

Rules

Use a where-clause and an ordering-clause only when a database is to be restructured.
If the RECORD format option is in effect and you issue a MAP command that causes restructuring, only level 0 records are retained. Descendant records are lost.
If a where-clause is included and LIMIT is in effect, only the number of selected data records within the specified limits are honored by MAP.
After you issue this command, the software changes to the QUEST processor.

Record Definition

A schema record represents a class of data records. You specify the component number and name and the parent-child relationships between records, using the following syntax.

Syntax

number * name (SCHEMA RECORD [IN sr-number]) :

number: is a component number from 1 to 9999.
name: is a component name using 1 to 250 characters. It cannot be a reserved word or character or the current system separator. See Reserved Words and Characters in Appendices .
sr-number: is the record component number (previously defined) that the new record belongs to. Do not include the C. The default is 0.

Examples

100* POSITION WITHIN COMPANY (RECORD):

110* SALARY WITHIN POSITION (RECORD IN 100):

130* ADDITIONAL INFORMATION (SR IN 100):

Rules

Abbreviations: SCHEMA RECORD = RECORD or SR
All components must have unique names and numbers.
You must define a parent record before you define its descendant records or items. Descendant records do not have to be defined in any order.
Records are included in the maximum number of components specified with NEW DATA BASE IS.
You can define 32 levels of schema records (including level 0).
[IN sr-number] is required except for level 1 records.
The order in which you define siblings determines their left-to-right order in DESCRIBE output.

RENUMBER

Renumbers components in a database definition.

Syntax

RENUMBER [STARTING WITH number [INCREMENTING BY n]] :

number: is a positive number from 1 to 9999 to be assigned to the first component in DESCRIBE order after C0. The default is 1.
n: specifies the increment for renumbering. It can be a number from 1 to 9999. You cannot use 0, and the default is 1.

Examples

RENUMBER:

RENUMBER STARTING WITH 100:

RENUMBER STARTING WITH 100 INCREMENTING BY 10:

Rules

You cannot renumber the C0 record.
No component number in a definition can be greater than 9999.
Components are renumbered consecutively in DESCRIBE order. Schema components are renumbered first, then strings, then functions.
When a record number changes, the IN specification for all member items and descendant records automatically changes, too.
RENUMBER does not affect component numbers within stored strings and functions. Use the DEFINE language CHANGE command to change those numbers.

STOP AFTER SCAN IF ERRORS OCCUR

Prevents mapping of DEFINE commands if errors occur. You can then edit the commands to correct errors. If no errors are encountered, mapping occurs.

Syntax

STOP AFTER SCAN IF ERRORS OCCUR :

Example

STOP AFTER SCAN IF ERRORS OCCUR:

Rules

The default is that processing continues. It is set at the beginning of each Self-Contained Facility session.
If an error is encountered after you issue this command, the software changes to the QUEST processor without mapping the definition.
When both STOP AFTER SCAN IF ERRORS OCCUR and DISABLE EXECUTION are issued, DISABLE EXECUTION prevails.
You can issue this command from the DEFINE, QUEST, or QUEUE processor. Commands in all three processors are affected, regardless of which processor STOP IF is issued from.

String Definition

A string stores a SYSTEM 2000 command, one part of a command, or a series of commands. Specify the component number and name and command stream, using the syntax below. Strings are sometimes referred to as stored strings.

Syntax

number * name (STRING delimiter command-stream delimiter) :

number: is a component number from 1 to 9999.
name: is a component name using 1 to 250 characters. It cannot be a reserved word or character or the current system separator. See Reserved Words and Characters in Appendices .
delimiter: is a single special character to be used as the command stream delimiter. The delimiter must appear at both ends of the command stream and cannot appear within the command stream. It cannot be the current system separator or command terminator. See Special Characters in Appendices .
command-stream: defines a SYSTEM 2000 command stream using 1 to 250 characters. The command stream can consist of partial commands, one command, or several commands. It also can contain parameters, calls to other strings or functions, or system strings (*NOW*, *FTODAY*, *TODAY*, *DATA*).

Examples

1100* EMP-NO (STRING / PRINT C1: /):

1000* LIST OF DATES (STRING $ LIST C1, C4, OB C4
     WH HIRE DATE GT 01/01/91: $):

1050* LATEST POSITION (STRING $ C101 EXISTS AT 1 $):

Rules

Each component must have a unique name and number.
Strings do not have to be defined in any order.
Strings are included in the maximum number of components specified with NEW DATA BASE IS.
Strings can be simple or parametric. Parametric strings contain parameters, whose values are supplied when you invoke the string. Simple strings have no parameters and are invoked by their component name or component number.
You can specify up to 31 levels of nesting, 31 parameters, any combination of the two yielding a total of 31, or a maximum of 1200 characters of string expansion and/or parameters. Parameters can be supplied within a string definition calling another string or function with parameters.
You can invoke a string in one of three situations: by itself, in a retrieval clause, in the where-clause of a QUEST or QUEUE retrieval or update command. See SYSTEM 2000 QUEST Language and System-Wide Commands, Version 12, First Edition for information about invoking strings.

Resources

SYSTEM 2000 Quick Reference Guide DEFINE Language Commands

CHANGE component

Syntax

Examples

Rules

DELETE

Syntax

Examples

Rules

ENABLE/DISABLE EXECUTION

Syntax

Examples

Rules

Function Definition

Syntax

Examples

Rules

Item Definition

Syntax

Examples

Rules

MAP

Syntax

Examples

Rules

Record Definition

Syntax

Examples

Rules

RENUMBER

Syntax

Examples

Rules

STOP AFTER SCAN IF ERRORS OCCUR

Syntax

Example

Rules

String Definition

Syntax

Examples

Rules