HP 3000 Manuals HP 3000 Manuals
Pascal Preprocessor
Invocation
Syntax Checking Mode.
:RUN PSQLPAS.PUB.SYS;INFO="(SYNTAX)"
Full Preprocessing Mode.
[ {MODULE(MName) } ]
[ {OWNER(OName) } ]
:RUN PSQLC.PUB.SYS;INFO="DBEName [({{DROP {PRESERVE}}}|...|)]"
[ {{ {REVOKE }}} ]
[ {{ }} ]
[ {{NODROP }} ]
[REV BEG]
Static Conversion Mode.
:RUN PSQLPAS.PUB.SYS;INFO="(DYNAMIC [MODULE (MName)] |...| )"
[OWNER (OName) ]
[REV END]
Preprocessor Input and Output
----------------------------------------------------------------------------------------------
| | | |
| File Type | User Supplied FileName | Default Filename |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Input to the Pascal | Use file equation | SQLIN |
| Preprocessor | | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| ALLBASE/SQL Message | | SQLCT000.PUB.SYS |
| Catalog | | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Preprocessor Message File | Use file equation | SQLMSG |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Modified Pascal Source | Use file equation | SQLOUT |
| Code File | | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Constant Declaration File | Use file equation | SQLCONST |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Variable Declaration File | | SQLVAR |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Subprogram Variable | | SQLVARn |
| Declaration File | | |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Type Declaration File | Use file equation | SQLTYPE |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| External Procedure File | Use file equation | SQLEXTN |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| Installable Module File | Use file equation | SQLMOD |
| | | |
----------------------------------------------------------------------------------------------
Files are created in the current group and account.
Pascal Declarations for ALLBASE/SQL Data Types
-----------------------------------------------------------------------------------------------
| | | |
| ALLBASE/SQL Data | Description | Pascal Declaration |
| Type | | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| BINARY(1) | single binary byte | char |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| BINARY(n) | fixed length binary string | packed array [1..n] of char |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| VARBINARY(n) | variable length binary string | string[n] |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| LONG BINARY | descriptor string for long column | string[96] |
| | data | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| LONG VARBINARY | descriptor string for long column | string[96] |
| | data | |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| CHAR(1) | single byte | char |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| CHAR(n) | fixed length character string | packed array [1..n] of char |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| VARCHAR(n) | variable length character string | string[n] |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| DECIMAL | up to 15 digits plus sign | compatible with longreal |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| REAL | floating point | real |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| FLOAT | double precision floating point | longreal |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| INTEGER | binary integer--31 bits plus sign | integer |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| SMALLINT | binary integer--15 bits plus sign | smallint |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| DATE | 10-character date | packed array [1..10] of char |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| TIME | 8-character time | packed array [1..8] of char |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| DATETIME | 23-character timestamp | packed array [1..23] of char |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| INTERVAL | 20-character interval | packed array [1..20] of char |
| | | |
-----------------------------------------------------------------------------------------------
Compatibility of ALLBASE/SQL and Pascal Data Types
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| | char | packed | string | smallint | integer | longreal | real |
| | | array | | | | | |
| | | [1..n] of | | | | | |
| | | char | | | | | |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| BINARY(n) | C | C | C | I | I | I | I |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| VARBINARY(n) | C | C | C | I | I | I | I |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| CHAR(1) | E | C | C | I | I | I | I |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| CHAR(n) | C | E | C | I | I | I | I |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| VARCHAR(n) | C | C | E | I | I | I | I |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| DECIMAL | I | I | I | C | C | C | C |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| REAL | I | I | I | C | C | C | E |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| FLOAT | I | I | I | C | C | E | C |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| INTEGER | I | I | I | C | E | C | C |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| SMALLINT | I | I | I | E | C | C | C |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| DATE | C | C | C | I | I | I | I |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| TIME | C | C | C | I | I | I | I |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| DATETIME | C | C | C | I | I | I | I |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
| | | | | | | | |
| INTERVAL | C | C | C | I | I | I | I |
| | | | | | | | |
-----------------------------------------------------------------------------------------------------------
E=Equivalent C=Compatible I=Incompatible