psqlc(1)

Requires Optional ALLBASE/SQL Software

NAME

psqlc, psqlpas, psqlfor, psqlcbl − preprocess ALLBASE/SQL source programs written in C, Pascal, FORTRAN and COBOL

SYNOPSIS

C Preprocessing:

psqlc -s [-i sourcefilename] [-p sqloutfilename .c ]
psqlc DBEnvirnomentName [-o ownername] [-m modulename] [-d [-r]]
[−i sourcefilename] [-p sqloutfilename .c ]
psqlc -D [-i sourcefilename] [-p sqloutfilename .c ]

Pascal Preprocessing:

psqlpas -s [-i sourcefilename] [-p sqloutfilename .p ]
psqlpas DBEnvirnomentName [-o ownername] [-m modulename] [-d [-r]]
[−i sourcefilename] [-p sqloutfilename .p ]
psqlc -D [-i sourcefilename] [-p sqloutfilename .p ]

FORTRAN Preprocessing:

psqlfor -s [-i sourcefilename] [-p sqloutfilename .f ]
psqlfor DBEnvirnomentName [-o ownername] [-m modulename] [-d [-r]]
[−i sourcefilename] [-p sqloutfilename .f ]

COBOL Preprocessing:

psqlcbl -s [-i sourcefilename] [-p sqloutfilename .cbl ]
psqlcbl DBEnvirnomentName [-o ownername] [-m modulename] [-d [-r]]
[−i sourcefilename] [-p sqloutfilename .cbl ]

REMARKS

The ALLBASE/SQL product must be installed on the system before psqlc, psqlpas, psqlfor, or psqlcbl can be used.

DESCRIPTION

psqlc, psqlpas, psqlfor, and psqlcbl invoke the C, Pascal, FORTRAN, and COBOL preprocessors, respectively, for programmatically accessing an ALLBASE/SQL relational database environment (DBEnvironment). psqlc, psqlpas, psqlfor, and psqlcbl can be executed by all system users.

Options

-s Specify that the preprocessor checks only the syntax of embedded SQL commands.

-D Specify that all static SQL statements are to be converted to dynamic SQL statements. Dynamic statements remain dynamic and no module is created.

DBEnvironmentName Identify the DBEnvironment in which a module is stored.

-o ownername Associate the stored module with a DBEUserID, a classname, or a groupname. You can specify an ownername for the module only if you have DBA authority in the DBEnvironment where the module is created, or if you are the current owner of the module. If not specified, the default ownername is your DBEUserID.

-m modulename Assign a name to the stored module. modulenames must follow the rules governing ALLBASE/SQL basic names as described in the ALLBASE/SQL Reference Manual. If no modulename is specified, the preprocessor uses the PROGRAM Statement name as the modulename or, for C programs, the source file name.

-d Delete any module currently stored in the DBEnvironment by the modulename and ownername specified in the options list. If this option is not specified, the module is retained and all existing run authorities for that module are preserved.

-r Revoke all existing run authorities for a module when a program being preprocessed already has a stored module. The -r option cannot be specified unless -d is also specified. If the -r option is not specified, all existing run authorities for that module are preserved.

-i sourcefilename Identify the name of the input file containing the source code being preprocessed. If sourcefilename is not specified, a default file sqlin is assumed. It is recommended but not required that the source file name have a filename suffix of .sql.

-p sqloutfilename Identify the name of the output file containing the preprocessor generated code. If sqloutfilename is not specified, the preprocessor generated code is written to a file with the same name as the source file name but with an appended filename suffix indicating the language of the source code: .c (C), .p (Pascal), .f (FORTRAN), or .cbl (COBOL).

EXTERNAL INFLUENCES

Environment Variables

For preprocessors psqlc, psqlpas, and psqlfor, LANG determines the language in which messages are displayed.

International Code Set Support

For preprocessors psqlc, psqlpas, and psqlfor, single- and multi-byte character code sets are supported.

DEPENDENCIES

Series 300/400
The psqlcbl preprocessor is not currently supported.

AUTHOR

psqlc, psqlpas, psqlfor, and psqlcbl were developed by HP.

FILES

/usr/lib/sqldaemon Cleanup daemon program file.

/usr/bin/psqlc C preprocessor program file.

/usr/bin/psqlpas Pascal preprocessor program file.

/usr/bin/psqlfor FORTRAN preprocessor program file.

/usr/bin/psqlcbl COBOL preprocessor program file.

/usr/lib/hpsqlproc ALLBASE/SQL program file.

/usr/lib/hpsqlcat ALLBASE/SQL message catalog file.

/usr/lib/libsql.a Run time routine library file.

/usr/lib/nls/$LANG/hpsqlcat
Localized ALLBASE/SQL message catalog file.

Museum