Commands

Use APPX ILF X-Ref (reliable) and APPX PDF X-Ref (not so reliable) from item 2.9. Check for APPX Inquiry Process too!

Inspect End-of-Process Event Point in Query

ASI: 12.11

Revise Combined Event Points

ASI: 9.12, 9.42 CAUTION: Not all combined event points are being flagged!

Set Alt Commands Skipped - Alt # > 1

ASI: This message is printed if an input or output process has commands present in the Set Alternate No. command series and the window has an Alternate No. greater than 1. The conversion utility does not convert these commands since they are not executed in SP2. No action is needed.

Revise Use of (PHASE)

APPX CG: In APPX, (PHASE) becomes OPERATIONAL PHASE. This predefined field may be compared against or set only to one of the constant literals INITIAL SETUP, LIVE OPERATIONS, or RECOVERY PROCESSING (or to a field whose value is one of these literals). Any statements that set or compare OPERATIONAL PHASE to another field are flagged and must be revised.

Revise Use of (PF KEY) On Display Only Window

ASI: 9.21

Inspect Use of (PF KEY) 1

APPX CG: In APPX, PF keys 1 and 2 are combined into the SCAN key. The statements should be inspected to see if the distinction between keys 1 and 2 is significant.

Inspect Use of (PF KEY) 2

APPX CG: In APPX, PF keys 1 and 2 are combined into the SCAN key. The statements should be inspected to see if the distinction between keys 1 and 2 is significant.

Revise Use of (PF KEY) 6

Revise Use of (PF KEY) 7

Revise Use of (PF KEY) 8

Inspect Use of (PF KEY) 13

Revise Use of (PF KEY) 14

Inspect Use of (PF KEY) 16

Revise Use of (PF KEY)

Inspect Use of (MODE)
Revise Use of (MODE)

ASI: 8.12, 9.12

Revise Use of (ENTRY)
Inspect Use of (ENTRY)

ASI: 8.20, 9.9, 9.10, 9.11

Revise Use of (SCAN)

Inspect Use of (INCLUDE)

ERROR Revise Use In End-of-Function Command Series

ASI: 11.3 This message prints if an ERROR command is found in the End of Function command series for an update function.

IF EXIST Inspect AAA FILENAME For Shared Company Use

ASI: 8.3, 8.17

BEG AT Inspect Usage of BEG AT

ASI: 8.10/OK, 8.30

AT FIELD Revise AT FIELD in Non-Image Event Point

ASI: 8.21

DISPLAY Revise DISPLAY in Non-Image Event Point

ASI: 9.8, 9.14, 10.12

BLINK Revise BLINK in Non-Image Event Point

ASI: 9.8, 9.14, 10.12

DELETE Inspect Use for DELETE after WRITE

ASI: 2.29, 8.8

WRITE AAA FILENAME Inspect Unique Keys For Date/Time

ASI: 8.33, 8.36/(8.31)

BEG READ Inspect for BEG AT / END AT

ASI: 8.10/OK

DATE ADD Inspect DATE ADD: AAA FieldName
Unit n AAA Fieldname

ASI: 8.15

SET MNTH Inspect Usage of SET MNTH Short

ASI: 8.16

WARNING Revise Use In End-of-Function Command Series

ASI: 11.3 This message prints if an WARNING command is found in the End-of-Function command series for an update function.

END AT Inspect Usage of END AT

ASI: 8.10/OK

NO INPUT Revise NO INPUT in Non-Image Event Point

ASI: 9.8, 9.14, 10.12

READNEXT Inspect for READNEXT Within BEG READ Loop

ASI: 8.9

APPX CG: READNEXT within a BEG READ/END READ loop operates slightly differently in APPX than in SPEED II. In SPEED II, a BEG READ command affects the current file position and, thus, the record read by a READNEXT within the loop. In APPX, a BEG READ statement has no affect on what record is read by a subsequent READNEXT.

If the conversion program detects READNEXT following a BEG READ statement in the command series, it is reported in the conversion message. The BEG READ may not necessarily be related to the same file as the READNEXT; the conversion program does not check for this (if the files are not the same, the conversion message can be ignored).

The APPX statements should be inspected to see if the READNEXT is within a BEG READ/END READ loop on the same file. If so, a BEG AT should be added before the READNEXT to read the desired record.

READNEXT Inspect for BEG AT / END AT

ASI: 8.9, 8.10/OK

CNV ZONE Revise Use of CNV ZONE

ASI: 8.37

CNV FLT Revise Use of CNV FLT

BLANK Revise BLANK in Non-Image Event Point

ASI: 9.8, 9.14, 10.12

OK INPUT Revise OK INPUT in Non-Image Event Point

ASI: 9.8, 9.14, 10.12

OK INPUT AAA FIELDNAME Field Not On File

OK INPUT AAA FIELDNAME Cross Appl Field NOF

OK INPUT AAA FIELDNAME Inspect - Not In PCF

ASI: 9.25 All OK INPUT commands which reference a field which is not in the input function PCF file are listed.

BRIGHT Revise BRIGHT in Non-Image Event Point

ASI: 9.8, 9.14, 10.12

DIM Revise DIM in Non-Image Event Point

ASI: 9.8, 9.14, 10.12

SELECT Revise Use of SELECT

SELECT SELECT not converted - No Extra TF Level

APPX CG: In SPEED II, the SELECT statement permits a variable value for Shared Y/N, SELECT is converted to a CLOSE followed by an OPEN. APPX does not permit a variable value for this in the OPEN statement. The conversion program converts this by inserting an IF statement to test the value of the variable, but can do this only if there is at least one level remaining in the T/F field on the SELECT statement.

SELECT Check for Subsequent IF EXIST on AAA FILENAME

ASI: 8.14, 10.25

APPX CG: In SPEED II, the SELECT statement is used to open a file for another company. This is converted to a CLOSE followed by an OPEN, each of which is preceded by a SET statement setting the predefined field NEXT DATABASE to the database ID (company ID). If this file is subsequently checked using an IF EXIST statement, it is necessary to manually insert prior to the IF EXIST statment a SET statement setting NEXT DATABASE to the database ID.

POSITION Revise POSITION in Non-Image Event Point

ASI: 9.8, 9.14, 10.12

END FN Revise Use of EXIT in APPX Query

ASI: 1.12, 8.26

* Revise Reference To 'PF' / 'SPEED' / 'EXPLAIN'
** Revise Reference To 'PF' / 'SPEED' / 'EXPLAIN'
ERROR Revise Reference To 'PF' / 'SPEED' / 'EXPLAIN'
WARNING Revise Reference To 'PF' / 'SPEED' / 'EXPLAIN'
MESSAGE Revise Reference To 'PF' / 'SPEED' / 'EXPLAIN'
CANCEL Revise Reference To 'PF' / 'SPEED' / 'EXPLAIN'

ASI: 2.30 (SPEED/EXPLAIN flagged in V05 after 08/27/96) The appropriate message is printed if the command contains any one of the following phrases: 'PF', 'Pf', 'pf', 'SPEED', 'Speed', 'speed', 'EXPLAIN', 'Explain', or 'explain'.

AAA FIELDNAME Field Not On File

ASI: This message is printed when attempting to determine if a total field is being used in a non-total command.

AAA FIELDNAME Cross Appl Field NOF

ASI: This message is printed when attempting to determine if a total field is being used in a non-total command.

Inspect SET TOT on AAA FIELDNAME

ASI: 1.66, 8.13

SET Inspect COMMAND On Total-Type Field
COMPUTE Inspect COMMAND On Total-Type Field
RESTORE Inspect COMMAND On Total-Type Field

ASI: 8.13, 10.23, 11.4 A message is printed if the left operand for one of these statements is a total field.

TOTAL AAA FIELDNAME Inspect - Rounding

ASI: 8.27

TOTAL AAA FIELDNAME Field Not On File

ASI: This message is printed when checking the precision of the operands for a TOTAL command.

TOTAL AAA FIELDNAME Cross Appl Field NOF

TOTAL Revise Rounding: AAA FIELDNAME
with: AAA FIELDNAME

ASI: 8.27

AAA FIELDNAME Field Not On File

ASI: This message is printed when validating a constant against the receiving field.

AAA FIELDNAME Cross Appl Field NOF

ASI: This message is printed when validating a constant against the receiving field.

Revise Invalid Date Constant

CNV BIN Inspect Usage: APPX Rounds - SP2 Truncates

ASI: 8.7 All CNV BIN commands are flagged.

CNV BIN AAA FIELDNAME Field Not On File

ASI: This message prints when checking the operand of a CNV BIN command to see if it is a 3 byte alpha field.

CNV BIN AAA FIELDNAME Cross Appl Field NOF

ASI: This message prints when checking the operand of a CNV BIN command to see if it is a 3 byte alpha field.

CNV BIN Revise CNV BIN - Uses 3-Byte Alpha

APPX CG: SP2 permits a CNV BIN command using a three-byte alpha field. APPX does not permit this. Any instances of a CNV BIN command using a three-byte alpha field must be revised.

IF Revise Relation
AND Revise Relation
OR Revise Relation

ASI: 8.34 This message prints if the relation operator is 'BW'

Inspect Use of (ALTERNATE NUMBER)

ASI: 8.23 This message prints if the command is not in the SP2 Set Alternate No. command series.

Inspect Use of (RECORD NUMBER) If Multi-Level

ASI: 8.24 Note that the conversion log message is misleading. Until this feature is implemented in APPX, it does not work at any level.

Inspect Use of (FUNCTION CODE) In Sort

ASI: 12.11

APPX CG: In SPEED II, a sort function is completed before a subsequent output or update. Consequently, if (FUNCTION CODE) is set in a sort function, a subsequent output or update can be executed conditionally based on the (FUNCTION CODE) value. In APPX, a query process (which performs the sort) is executed concurrently with an output or update process, and will begin execution before the query sets (PROCESS CODE), which is the APPX equivalent of (FUNCTION CODE).

Revise (PRINT FILE) For Portability

Inspect Use of (SCAN) If Multi-Level

Inspect Use of (NEXT COMPANY)

Inspect Use of (CURSOR COLUMN)

ASI: 8.18, 9.15

Revise (PRINT LIBRARY) For Portability

Revise (PRINT VOLUME) For Portability

Revise (PRINT SIZE FACTOR) For Portability

SET (PF KEY) Not In Valid Event Point

ASI: 9.32 All SET commands which modify the value of (PF KEY) are listed if they are not in the Pre-Display or Option Intercept command series in an input function.

SET AAA FIELDNAME Field Not On File

SET AAA FIELDNAME Cross Appl Field NOF

SET AAA FIELDNAME = Num Use CNV TEXT?

ASI: 8.28 To find commands setting an alpha field from an indexed variable (the only circumstance specifically known to be a problem), run the APPX Software, Inc. UTL CS utility "APPX STMT 'Format 5' List" and enter "ALPHA" as basic field type 1, "NUMERIC" as basic field type 2, and "---" as app ID 2. If any found, use a numeric work field to set the alpha field, rather than the indexed variable.

Revise Query To Eliminate Updating

ASI: 12.2, 12.11

Inspect Query For Updating

ASI: 12.11

RUN Revise Xtrnl Fn For Portability

RUN Revise Xtrnl Fn For Portability /X-Appl Ref AAA

RUN Inspect X-Application Reference to AAA

RUN WAIT Converted To LOGOUT

RUN Revise BEGIN LIVE OPNS - Move To Menu Item

RUN SET ALARM Cannot Be Converted

RUN PRINT USAGE LOG Cannot Be Converted

RUN TRANSFER USAGE LOG Cannot Be Converted

RUN INTERNAL Cannot Be Converted

RUN MENU - Inspect Invocation Type
RUN JOB - Inspect Invocation Type
RUN INPUT - Inspect Invocation Type
RUN OUTPUT - Inspect Invocation Type
RUN UPDATE - Inspect Invocation Type
RUN INQUIRY - Inspect Invocation Type
RUN STATUS - Inspect Invocation Type

ASI: 8.19