PSQLC(1)

Series 300, 800 Only

NAME

psqlc, psqlpas, psqlfor − ALLBASE/HP-UX preprocessors for C, Pascal and FORTRAN

SYNOPSIS

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

REMARKS

The ALLBASE/HP-UX product must be previously installed on the system for psqlc, psqlpas, or psqlfor to function.

DESCRIPTION

Psqlc, psqlpas and psqlfor invoke the C, Pascal and FORTRAN preprocessors, respectively, for programmatically accessing an ALLBASE/HP-UX relational DataBase Environment (DBEnvironment). Psqlc, psqlpas and psqlfor can be executed by all system users.

Options

−s Specifies that the preprocessor is only to check the syntax of embedded SQL commands.

DBEnvironmentName
Identifies the DBEnvironment in which a module is to be stored.

−o ownername Associates the stored module with a user’s login name, 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 to be stored. If not specified, the default ownername is your login name.

−m modulename
Assigns a name to the stored module. Modulenames must follow the rules governing HPSQL basic names as described in the ALLBASE/HP-UX SQL Reference Manual. If a modulename is not specified, the preprocessor uses the PROGRAM Statement name as the modulename.

−d (DROP) Deletes any module currently stored in the DBEnvironment by the modulename and ownername specified in the options list. If not specified, NODROP is assumed and all existing RUN authorities for that module are preserved.

−r (REVOKE) Is specified when the program being preprocessed already has a stored module and you want to revoke all existing RUN authorities for that module. REVOKE cannot be specified unless DROP is also specified. If the −r (REVOKE) option is not specified, it is assumed that all existing RUN authorities for that module are to be PRESERVED.

−i sourcefilename.sql
Identifies the name of the input file containing the source code to be preprocessed. If sourcefilename.sql is not specified, a file by the name of sqlin is assumed. It is recommended that the source file name have a file extension of ".sql"; however, this is not required.

−p sqloutfilename.f
Identifies the name of the output file containing the preprocessor generated code. If sqloutfilename.f 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 file extension of ".f".

AUTHOR

Psqlc, psqlpas, and psqlfor were developed by Hewlett-Packard.

FILES

/usr/bin/hpdbdaemon 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/lib/hpsqlproc HP SQL program file

/usr/bin/isql Interactive SQL program file

/usr/bin/sqlutil SQLUTIL program file

/usr/lib/hpsqlcat HP SQL message catalog file

/usr/lib/isqlwel Interactive SQL welcome banner file

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

Museum