PSQLC(1)

NAME

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

SYNOPSIS

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

REMARKS

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

DESCRIPTION

Psqlc, psqlpas, psqlfor, and psqlcbl invoke the C, Pascal, FORTRAN, and COBOL preprocessors, respectively, for programmatically accessing an ALLBASE/HP-UX 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.

DBEnvironmentName
Identify the DBEnvironment in which a module is stored.

−o ownername Associate 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
Assign a name to the stored module. Modulenames must follow the rules governing HP SQL 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 Delete any module currently stored in the DBEnvironment by the modulename and ownername specified in the options list. If the −d 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.sql
Identify the name of the input file containing the source code being preprocessed. If sourcefilename.sql is not specified, a default file sqlin is assumed. It is recommended but not required that the source file name have a file extension 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 file extension indicating the language of the source code: .c (C), .p (Pascal), .f (FORTRAN), or .cbl (COBOL).

DEPENDENCIES

Series 300
The psqlcbl preprocessor is not currently supported.

AUTHOR

Psqlc, psqlpas, psqlfor, and psqlcbl 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/bin/psqlcbl COBOL preprocessor program file.

/usr/lib/hpsqlproc HP SQL program file.

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

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

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

INTERNATIONAL SUPPORT

Series 800
8- and 16-bit data, object names, file names, messages are supported by all preprocessors except psqlcbl.

Museum