HP 3000 Manuals

Index [ ALLBASE/SQL COBOL Application Programming Guide ] MPE/iX 5.0 Documentation


ALLBASE/SQL COBOL Application Programming Guide

Index

A
    access
       optimization   
       validation   
    active set   
    ADD_MONTHS function
       example with BULK SELECT   
       syntax   
    aggregate function   
       simple data manipulation   
    ALTER TABLE command
       syntax for LONG columns   
    ANSI SQL1 level 2
       specifying a default value   
    ANSI SQL86 level 2
       floating point data   
    application development   
    arrays   
       BULK SELECT   
       declarations of   
    atomic operation
       defined   
    authorization   
       and program maintenance   
       changing   
       dynamic preprocessing   
       granting   
    automatic rollback   
    autostart mode   

B
    BEGIN DECLARE SECTION   
       declaring host variables   
    BEGIN WORK
       defining transactions   
       in transaction management   
    binary data
       compatibility   
       host variable definition   
       how stored   
       using the LONG phrase with   
    BULK FETCH   
       basic uses of   
    BULK FETCH command
       used in example program   
    BULK INSERT   
       basic uses of   
    BULK INSERT command
       used in example program   
       used with LONG columns   
    bulk processing
       INTO clause   
    bulk processing variables   
    BULK SELECT   
       basic uses   
    [BULK] SELECT command
       used with LONG columns   
    BULK SELECT command
       example with LONG columns   
       with ADD_MONTHS function   
    BULK table processing   
       BULK FETCH   
       BULK INSERT   
       BULK SELECT   
       commands   
       overview   
       sample program   
       techniques   

C
    CHAR data   
    CLOSE   
       before ending a transaction   
       freeing buffer space with   
       with COMMIT WORK   
       with KEEP CURSOR   
    COBEX10A   
    COBEX10B   
    COBEX2   
    COBEX5   
    COBEX7   
    COBEX8   
    COBEX9   
    COBOL compiler directives
       $SQL COPY   
       $SQL NOCOPY   
    COBOL COPY statement
       code expansion   
       compiler directives for   
       introduction to   
       REPLACING clause   
       use of NOLIST reserved word   
       where used   
    COBOL SET and IF statement
       use of NOMIXED reserved word   
    COBOL SET and IF statements
       where used   
    COBOL subprograms   
    coding considerations
       for date/time functions   
       for LONG columns   
    column specifications for floating point data   
    comments, ALLBASE/SQL   
    comments, COBOL   
    COMMIT WORK   
       defining transactions   
       in transaction management   
       with CLOSE   
       with KEEP CURSOR   
    comparison predicate   
    compiler   
       separate compilable section   
    compiler directive
       $INCLUDE   
    compiler directives
       for COBOL COPY statement   
    compiling and linking   
       C subprogram COBOL calls   
    concurrency   
    CONNECT   
    CONNECT authority   
       with START DBE   
    constant
       as default data value   
    constraint test matrix for integrity constraints   
    continuation lines   
    conversion   
    COPY statement in COBOL
       code expansion   
       compiler directives for   
       introduction to   
       REPLACING clause   
       use of NOLIST reserved word   
       where used   
    CREATE TABLE command
       syntax for LONG columns   
    C subprogram COBOL calls   
    CURRENT_DATE function result
       used as default data value   
    CURRENT_DATETIME function result
       used as default data value   
    current language   
    current row   
       DELETE WHERE CURRENT   
    CURRENT_TIME function result
       used as default data value   
    cursor
       and BULK FETCH   
       closing   
       deleting with   
       effect of commands on   
       introduction to   
       opening   
       positioning   
       updating with   
       use of   
    cursor processing
       CLOSE   
       commands   
       DECLARE CURSOR   
       definition   
       DELETE WHERE CURRENT   
       FETCH   
       OPEN   
       techniques   
       transaction management   
       UPDATE and FETCH   
       UPDATE WHERE CURRENT   

D
    Database Environment Configuration File   
    data compatibility
       binary   
       floating point   
       for date/time function parameters   
       for default data values   
       LONG binary   
       LONG varbinary   
    data consistency   
       in sample database   
    data definition
       overview   
    data description entries   
    DATA DIVISION   
    data input using date/time functions   
    data integrity
       changes to error checking    
       introduction to   
       number of rows processed    
       row level versus statement level   
       using sqlerrd[2]   
    data manipulation
       commands   
       overview   
       techniques   
    data retrieval using date/time functions   
    data storage
       binary data   
    data type
       compatibility   
    data type conversion   
    data types   
       binary   
       compatibility   
       equivalency   
       floating point   
       used with LONG columns   
    date/time ADD_MONTHS function
       overview   
       where to use   
    date/time data conversion
       example program   
       example programs   
    date/time functions   
       coding considerations   
       data compatibility   
       example program   
       example programs   
       examples using ManufDB database   
       example using default format specifications   
       how used   
       introduction to   
       leading zeros required for input functions   
       parameters for   
       unspecified format elements default filled   
       used to add a number of months   
       used when inputting data   
       used when retrieving data   
       using host variables for format specifications   
       using host variables for input and output data   
       using host variables with   
       where to use ADD_MONTHS   
       where to use input functions   
       where to use output functions   
       where to use TO_CHAR   
       where to use TO_DATE   
       where to use TO_DATETIME   
       where to use TO_INTEGER   
       where to use TO_INTERVAL   
       where to use TO_TIME   
       where used   
    date/time input functions
       examples   
       not intended for use in select list   
       overview   
       where to use   
    date/time output functions
       examples   
       overview   
       where to use   
    DBA authority   
    DBECon file   
    DBEnvironment
       access   
    DBE session
       and autostart mode   
       terminating   
    DDL operations
       used with integrity constraints   
       used with LONG columns   
    deadlock
       and error recovery   
       status checking   
    DECIMAL data   
    declaration of data
       FLOAT   
    DECLARE CURSOR   
       FOR UPDATE OF   
       preprocessor directive   
       SELECT   
       specify location of stored section   
       syntax   
    DECLAREing for UPDATE
       KEEP CURSOR   
    declare section   
       defined   
    declaring
       host variables   
       indicator variables   
       SQLCA   
    default data values
       constant   
       data compatibility   
       for columns allowing nulls   
       in addition to null   
       not used with LONG BINARY data   
       not used with LONG columns   
       not used with LONG VARBINARY data   
       NULL   
       result of CURRENT_DATE function   
       result of CURRENT_DATETIME function   
       result of CURRENT_TIME function   
       USER   
    default format specification example
       date/time functions   
    defining integrity constraints   
    defining LONG columns
       in a table   
       input and output specification   
       with the LONG column I/O string   
    definitions
       input device specification   
       LONG column I/O string   
       output device specification   
       row level integrity   
    DELETE
       and simple data manipulation   
    DELETE command
       used with LONG columns   
       with TO_DATETIME function   
    DELETE WHERE CURRENT   
       current row   
       restrictions   
       syntax   
    DELETE WHERE CURRENT command
       used with LONG columns   
    delimiting SQL commands   
    designing an application using statement level integrity   
    directives   
    DML operations
       used with date/time functions   
       used with integrity constraints   
       used with LONG columns   
    DROP MODULE   
       obsoleting programs   
       updating programs   
    dynamic command   
       passing to ALLBASE/SQL   
    dynamic commands   
       and authorization   
    dynamic FETCH command
       used with LONG columns   
    dynamic operations   
       dynamic commands   
       overview   
       queries, using C, Pascal routines   
       techniques   
    dynamic preprocessing   
       authorization for   

E
    embedding commands
       continuation lines   
       introduction   
       prefix   
       suffix   
    embedding SQL commands   
       comments   
       general rules   
       punctuation   
    END DECLARE SECTION   
       declaring host variables   
    END-EXEC   
    error checking
       changes for this release   
       example COBOL copy file   
       using sqlerrd[2]   
       with row level integrity   
       with statement level integrity   
    error messages   
    example
       BULK SELECT command with ADD_MONTHS function   
       BULK SELECT command with LONG columns   
       DELETE command with TO_DATETIME function   
       FETCH command with TO_INTEGER function   
       INSERT command with TO_DATE function    
       INSERT command with TO_DATETIME function   
       INSERT command with TO_INTERVAL function   
       INSERT command with TO_TIME function   
       LONG column descriptor declaration   
       SELECT command with TO_CHAR function   
       SELECT command with TO_DATETIME function   
       SELECT command with TO_INTERVAL function   
       UPDATE command with TO_DATE function   
       UPDATE command with TO_DATETIME function   
    example application design
       using integrity constraints   
    example COBOL copy file
       for error checking   
    example data file
       BULK INSERT command with LONG columns   
    example program
       date/time data conversion   
       using date/time functions   
    example programs
       date/time data conversion   
       date/time functions   
    examples of date/time input functions   
    examples of date/time output functions   
    EXEC SQL   
    EXECUTE   
       non-dynamic queries   
       using   
    EXECUTE IMMEDIATE   
       using   
    executing programs   
    explicit status checking
       defined   
       introduction   
       uses of   
    expression   

F
    FETCH   
       and null values   
       cursor processing   
    FETCH command
       used dynamically with LONG columns   
       used with LONG columns   
       with TO_INTEGER function   
    file
       Database Environment Configuration   
       DBECon   
    file IO
       KEEP CURSOR   
    file name
       fully qualified   
       relative   
    FLOAT data
       host variables and   
    FLOAT data declaration   
    floating point data
       4-byte   
       8-byte   
       column specifications   
       compatibility   
       REAL keyword   
    FOR UPDATE OF
       UPDATE WHERE CURRENT   
    FROM clause   
    fully qualified file name   

G
    GOTO vs. GO TO   
    GRANT   
    GROUP BY clause   

H
    heap space input and output   
    host variables
       and data manipulation   
       and modified source code   
       bulk processing   
       declaring   
       declaring for savepoints   
       for dynamic commands   
       for messages   
       for savepoint numbers   
       in arrays   
       in data types   
       indicator   
       initialization   
       input   
       names   
       output   
       overview   
       purpose   
       used for binary data   
       used for LONG column I/O strings   
       used with date/time functions   
       uses   

I
    IF statement in COBOL
       use of NOMIXED reserved word   
    implicit status checking
       defined   
       introduction   
       usage   
    $INCLUDE
       compiler directive   
    INCLUDE   
    include files
       contents of   
       creation   
    index scan   
    indicator variables   
       declaring   
       location of   
       null   
       null values   
       truncation   
    input device specification
       definition   
    INSERT
       and null values in unnamed columns   
       and simple data manipulation   
    INSERT command
       used with LONG columns   
       using host variables for LONG column I/O strings   
       with LONG columns:example data file   
       with TO_DATE function   
       with TO_DATETIME function   
       with TO_INTERVAL function   
       with TO_TIME function   
    INSTALL   
    INTEGER data   
    integrity constraint definition   
    integrity constraints
       and statement level integrity   
       commands used with   
       constraint test matrix   
       designing an application   
       example application using RecDB database   
       in RecDB database   
       introduction to   
       restrictions   
       unique and referential   

J
    job mode   
    join condition   
    joining tables   
    join variable   

K
    KEEP CURSOR
       DECLAREing for UPDATE   
       example code   
       file IO   
       terminal IO   
    KEEP CURSOR WITH NOLOCKS command
       use with OPEN command    

L
    language
       current language   
       native language support   
    linker   
       separate linked objects   
    locking
       and cursors   
       table level   
    logging   
    LONG binary data
       compatibility   
       definition   
       how stored   
    LONG binary versus LONG varbinary data usage   
    LONG column definition
       in a table   
       input and output specification    
       with the LONG column I/O string   
    LONG column descriptor
       contents of   
       example declaration   
       general concept   
       how used   
       introduction to   
    LONG column I/O string
       general concept   
       heap space input and output   
       how used    
       input device specification   
       output device specification   
       used with host variable   
       used with INSERT command   
    LONG columns
       changing data   
       coding considerations   
       commands used with   
       considering multiple users   
       data types used with   
       deciding on space allocation   
       deleting data   
       file usage from an application   
       general concepts   
       input options   
       introduction to   
       maximum per table definition   
       output options   
       performance   
       putting data in   
       restrictions   
       retrieving data from   
       size maximum   
       specifying a DBEFileSet   
       storage   
       storing and retrieving data   
       used with [BULK] INSERT command   
       used with [BULK] SELECT command   
       used with DELETE [WHERE CURRENT] command   
       used with dynamic FETCH command   
       used with FETCH or REFETCH commands   
       used with UPDATE [WHERE CURRENT] command   
       using file naming conventions   
       using file versus heap space   
       using the LONG column descriptor   
    LONG phrase
       used with binary data   
       used with varbinary data   
    LONG varbinary data
       compatibility   
       definition   
       how stored   

M
    maintaining ALLBASE/SQL programs   
    ManufDB database
       examples using date/time functions   
       program using date/time functions   
    message catalog   
       and SQLEXPLAIN   
       defaults   
       introduction   
    message catalog number
       related to SQLCODE   
    messages from SQLEXPLAIN
       when produced   
    modified source
       creation   
       inserted statements   
       sample   
    modified source file   
    module
       creation   
       DBEfileset   
       definition   
       installation   
       name   
       owner   
       ownership   
       storage   
       updating   
    multiple rows
       not allowed in simple data manipulation   
    multiple rows qualify
       runtime error   
    multiple users of LONG columns   
    multiple warnings
       SQLEXPLAIN   

N
    name qualification   
    naming conventions for LONG column files   
    NATIVE-3000
       defined   
    native language
       current language   
       defaults   
    native language support   
       message catalog   
       SQLMSG   
    NOLIST reserved word
       used with COBOL COPY files   
    NOMIXED reserved word
       used with COBOL SET and IF statements    
    non-dynamic commands   
    NULL
       as default data value   
    null predicate   
    NULL result of a dynamic fetch of a LONG column   
    null value
       in key column of unique index   
    null values
       and unnamed columns in an INSERT   
       indicator variables mandatory   
       in groups   
       in UPDATE   
       properties of   
       runtime errors   
       using indicator variables with   
       with FETCH   
       with SELECT   
    number of rows processed
       data integrity   
    NumberOfRows variable
       usage   

O
    odd-byte columns   
    OPEN   
       cursor processing   
    OPEN command
       use with KEEP CURSOR WITH NOLOCKS command   
    optimization   
    ORDER BY clause   
    output device specification
       definition   
    output file
       attributes   
       preprocessor   
    overflow   
    OWNER
       authority   
    OWNER authority   

P
    padding of DECIMAL values   
    Pascal subprogram COBOL calls   
    passing SQLCA   
    performance
       integrity constraints   
       LONG columns   
    permanent section
       and DBEnvironment   
    precision   
    predicates   
    prefix   
    PREPARE
       non-dynamic queries   
       using   
    preprocessing
       directives   
    preprocessor
       access to DBEnvironment   
       and authorization   
       and DBE sessions   
       effect on source code   
       events   
       input   
       invoking   
       job mode   
       logging   
       modes   
       modified source file   
       modifying output of   
       output   
       transactions   
       UDC's   
       vs. COBOL preprocessor   
    preprocessor directive
       DECLARE CURSOR   
    PROCEDURE DIVISION   
    program
       compiling and linking   
       creation steps   
       date/time data conversion   
       execution   
       maintenance   
       obsolescence   
       starting DBE session   
       user authorization   
    programs
       date/time functions   
    program structure   
    punctuation   
    PurchDB database
       date/time conversion example programs   

Q
    query result   

R
    REAL keyword
       floating point data   
    RecDB database application design
       example maintenance menu   
       example of deleting data   
       example of error checking   
       example of inserting data   
       example of updating data   
       integrity constraints defined   
    REFETCH command
       used with LONG columns   
    relative file name   
    RELEASE
       introduction   
       without ending transaction   
    REPLACING clause
       used with COBOL COPY Statement   
    restrictions
       integrity constraints   
       LONG columns   
    retrieving LONG column data
       with SELECT, FETCH, or REFETCH commands   
    REVOKE   
    robust program
       defined   
    ROLLBACK WORK
       defining transactions   
       to ensure data consistency   
    row level integrity
       definition   
    RUN authority   
       with START DBE   
    running the preprocessor   
    run-time
       defining SQL commands at   
    runtime
       authorization   
       events   
    runtime errors   
       bulk processing   
       multiple rows qualify   
       null values   
    runtime status checking
       possible errors   
       status codes   
    runtime warnings   

S
    sample database
       data consistency   
    sample program
       COBEX10A   
       COBEX10B   
       COBEX2   
       COBEX5   
       COBEX7   
       COBEX8   
       COBEX9   
       simple data manipulation   
    scale   
    section
       commands requiring   
       creation   
       dynamic vs. non-dynamic   
       permanently stored   
       purpose   
       temorarily stored   
       temporary   
       validity   
    segmenter   
    SELECT   
       and simple data manipulation   
       DECLARE CURSOR   
    SELECT command
       used with LONG columns   
       with TO_CHAR function   
       with TO_DATETIME function   
       with TO_INTERVAL function   
    select list   
    SELECT with CURSOR
       input host variables only   
    self-joins   
    sequential table processing   
       overview   
    serial scan   
    SET and statements in COBOL
       where used   
    shared memory problem
       status checking   
    simple data manipulation
       commands   
       DELETE   
       INSERT   
       multiple rows not allowed   
       overview   
       sample program   
       SELECT   
       techniques   
       transaction management   
       UPDATE   
    size maximum
       LONG columns   
    slack byte
       odd byte columns   
    SMALLINT data   
    space allocation for LONG column data   
    sqlca
       declaring   
    SQLCA
       declaring   
       elements of   
       in subprograms   
       overview   
       purpose   
    SQLCODE   
       and SQLWARN6   
       a negative number   
       deadlock detected   
       introduction   
       multiple messages   
       multiple SQLCODEs   
       of 0   
       of 100   
       of -14024   
       related to message catalog number   
       SQLEXPLAIN   
       usage   
    SQLCODE of -10002   
    SQLCODE of -4008   
    SQL commands
       and data manipulation   
       defining at run time   
       delimiting   
       embedding   
       for data definition   
       for data manipulation   
       length   
       length of   
       location   
       prefix   
       suffix   
       use of   
    SQLCONST   
    $SQL COPY
       COBOL compiler directive   
    sqlerrd[2]
       error checking   
    SQLERRD(3)
       introduction   
       usage   
       uses for   
    SQLEXPLAIN
       introduction   
       multiple messages   
       multiple warnings   
       no message for SQLCODE=100   
       overview   
       simultaneous warning and error   
       SQLCODE   
       SQLWARN0   
       using   
       when messages are available   
    SQLIN   
    SQLMOD   
    SQLMSG
       defaults   
    $SQL NOCOPY
       COBOL compiler directive   
    SQLOUT   
    SQLVAR   
    SQLWARN0
       introduction   
       SQLEXPLAIN   
       usage   
    SQLWARN1
       introduction   
       string data truncation   
       usage   
    SQLWARN2
       introduction   
       usage   
    SQLWARN6   
       introduction   
       transaction rollback   
       usage   
    START DBE   
    StartIndex variable
       usage   
    statement level integrity
       and integrity constraints   
    status checking
       deadlock   
       explicit   
       explicit defined   
       implicit   
       implicit defined   
       information available   
       introduction to explicit   
       kinds of   
       procedures   
       purposes of   
       runtime techniques   
       shared memory problem   
    status codes
       runtime status checking   
    storage
       LONG columns   
    stored sections   
    string data truncation
       SQLWARN1   
    subprograms
       COBOL   
       C subprogram COBOL calls   
       Pascal subprogram COBOL calls   
       SQLCA declaration   
    suffix   
    syntax for date/time functions
       ADD_MONTHS   
       input functions   
       output functions   
       TO_CHAR   
       TO_DATE   
       TO_DATETIME   
       TO_INTEGER   
       TO_INTERVAL   
       TO_TIME   
    syntax for LONG columns
       ALTER TABLE command   
       CREATE TABLE command   
       select list   
    system catalog   

T
    temporary files   
    temporary section   
    terminal IO
       KEEP CURSOR   
    TID function   
    TO_CHAR function
       example with SELECT command   
       syntax   
    TO_DATE function
       example with INSERT command   
       example with UPDATE command   
       syntax   
    TO_DATETIME function
       example with DELETE command   
       example with INSERT command   
       example with SELECT command   
       example with UPDATE command   
       syntax   
    TO_INTEGER function
       example with FETCH command   
       syntax   
    TO_INTERVAL function
       example with INSERT command   
       example with SELECT command   
       syntax   
    TO_TIME function
       example with INSERT command   
       syntax   
    transaction management   
       automatic   
       cursor processing   
       overview   
       simple data manipulation   
    truncation   
       detecting in strings   
    type
       compatibility   

U
    UDC's
       PCOB   
       PPCOB   
       preprocess   
       preprocess, compile, link   
    unique index   
    UPDATE
       and simple data manipulation   
    UPDATE and FETCH
       cursor processing   
    UPDATE command
       used with LONG columns   
       used with TO_DATE function   
       used with TO_DATETIME function   
    UPDATE WHERE CURRENT   
       FOR UPDATE OF   
       restrictions   
       syntax   
    UPDATE WHERE CURRENT command
       used with LONG columns   
    updating application programs   
    USER
       as default data value   
    using default data values
       introduction to   
    using host variables   
    using indicator variables
       assigning null values   

V
    validation   
    varbinary data
       using the LONG phrase with   
    VARCHAR data   
    views
       and DELETE   
       and SELECT   
       and UPDATE   
       restrictions   

W
    warning message
       and SQLCODE   
       and SQLWARN0   
       and SQLWARN1   
       SQLWARN2   
    warning messages   
    warnings
       runtime handling   
    WHENEVER
       components of   
       duration of command   
       for different conditions   
       introduction to   
       transaction roll back   
       when starting DBE session   



MPE/iX 5.0 Documentation