ADABAS D SQL-PL

Top Level

Ordering the Manual

 

• Field of Application

 

• Field of Application

 

• SQL-PL Objects

 

• SQL-PL Objects

 

• General Properties of SQL-PL Objects

 

• Routines

 

• Functions

 

• DB Procedures

 

• DB Triggers

 

• Forms

 

• HELP Forms

 

• Menus

 

• Syntax of the SQL-PL Objects

 

• The Workbench

 

• The Handling of the Workbench

 

• The Function Keys of the Workbench

 

• The Workbench for Beginners

 

• The Version Administration

 

• The Action Bar of the Workbench

 

• The Action Bar of the Workbench

 

• The Menu Item 'Object'

 

• The Menu Item 'Selection'

 

• The Menu Item 'Privileges'

 

• The Menu Item 'Test'

 

• The Menu Item 'Tools'

 

• The Menu Item 'Scroll'

 

• The Menu Item 'Info'

 

• Commands

 

• Commands

 

• User-specific SET Parameters

 

• User-specific SET Parameters

 

• The SQL-PL Language

 

• Basic Elements

 

• Basic Elements

 

• Comments

 

• Names

 

• Literals

 

• Literals

 

• Numbers

 

• Character Strings

 

• Hexadecimal Strings

 

• Language-dependent Literals

 

• Key Literals

 

• Variables

 

• Variables

 

• Arithmetic Expressions

 

• Arithmetic Expressions

 

• String Expressions

 

• String Expressions

 

• Boolean Expressions

 

• Boolean Expressions

 

• Variable Declaration

 

• Variable Declaration

 

• Basic Statements

 

• Basic Statements

 

• Value Assignments

 

• The IF Statement

 

• The CASE Statement

 

• The REPEAT Statement

 

• The WHILE Statement

 

• The FOR Statement

 

• The SKIP Statement

 

• The RETURN Statement

 

• The STOP Statement

 

• The Statements LTSORT and GTSORT

 

• Calling Routines, Forms, and Functions

 

• Calling Routines, Forms, and Functions

 

• The Statements CALL, SWITCH, and SWITCHCALL

 

• Parameters for CALL, SWITCH, and SWITCHCALL

 

• Calling Functions

 

• Calling DB Procedures

 

• Calling DB Procedures

 

• Embedding SQL

 

• Embedding SQL

 

• Database Accesses

 

• Dynamic SQL Statements

 

• Dynamic FETCH Statements

 

• Mass Fetch

 

• Support of the ADABAS Data Type LONG

 

• Support of the ADABAS Data Type LONG

 

• Dynamic Opening of LONG Columns

 

• Multi-DB Operation

 

• Multi-DB Operation

 

• SQL Error Handling

 

• SQL Error Handling

 

• Routines for the SQL Error Handling

 

• Routines for the SQL Error Handling

 

• Catching Runtime Errors (TRY-CATCH)

 

• Catching Runtime Errors (TRY-CATCH)

 

• QUERY Call

 

• QUERY Call

 

• Stored Commands

 

• REPORT Formatting

 

• Further Facilities

 

• Master/Detail REPORT

 

• Editor Call

 

• Editor Call

 

• Line-oriented Input and Output

 

• Line-oriented Input and Output

 

• Processing Files

 

• Processing Files

 

• Calling Operating System Commands

 

• Calling Operating System Commands

 

• SQL-PL System Functions

 

• SQL-PL System Functions

 

• Arithmetic Functions

 

• String Functions

 

• Date and Time Functions

 

• SET Function

 

• Time Measuring Functions

 

• System or $ Variables

 

• System or $ Variables

 

• Module Options

 

• Module Options

 

• The LOOP Option

 

• The Option AUTOCOMMIT OFF

 

• The Trace Options MODULETRACE and SQLTRACE

 

• The TEST DBPROC Option

 

• The LIB Option

 

• The KEYSWAP Option

 

• The SUBPROC Option

 

• Stored Procedures

 

• Stored Procedures

 

• Creating Stored Procedures

 

• Creating Stored Procedures

 

• DB Procedures

 

• Triggers

 

• DB Functions

 

• Parameter Declaration

 

• Restrictions

 

• Calling a DB Procedure

 

• Calling a DB Procedure

 

• Setting the Error Number

 

• Difference from CALL PROC

 

• Calling a Trigger

 

• Calling a Trigger

 

• The Debugger

 

• The Debugger

 

• Procedure

 

• Functions of the Debugger

 

• Functions of the Debugger

 

• Displaying and Modifying Variable Contents

 

• Breakpoints

 

• Single-step Mode

 

• Continuing the Execution

 

• Displaying the Call Sequence

 

• Displaying System Variables

 

• Displaying Parameters

 

• Interrupting the Program

 

• Displaying Help Information

 

• Initializing the Screen

 

• Forms

 

• General Points on Forms and Menus

 

• The Form Layout

 

• The Form Layout

 

• Form Fields and Messages (MESSAGE, ERROR)

 

• Form Fields of Variable Lengths (

 

• Multi-line Form Fields ( " )

 

• Vector Components with Constant Index

 

• Vector Components with Dynamic Index (FIELD/OFFSET)

 

• Field Numbers Instead of Variable Names

 

• Definition of LAYOUT Control Characters

 

• Definition of LAYOUT Control Characters

 

• Display Attributes (HIGH,LOW,INV,BLK,UNDERL,ATTR1..ATTR16)

 

• Control Characters for Input and Output Fields (IN,OUT)

 

• Displaying NULL Value Fields (PROMPT)

 

• Graphic Characters in Forms

 

• Form Processing Statements

 

• Form Processing Statements

 

• The FIELD Statement

 

• The FIELD Statement

 

• Initializing the Fields (FIELD/INIT)

 

• Explicit Field Limiting (FIELD/SIZE)

 

• Field Limiting for Multi-line Fields (FIELD/WIDTH)

 

• Checking the Input (FIELD/CHECK)

 

• Using DOMAIN Definitions (FIELD/DOMAIN)

 

• The FIELD/HELP Statement

 

• Preparing Output Fields (FIELD/DISPLAY)

 

• The FIELD/OFFSET Statement

 

• Assigning Field Attributes (FIELD/ATTR)

 

• NOINPUT Fields

 

• NOAUTONEXT Fields

 

• BEFORE/AFTER FIELD

 

• Dividing into Field Groups (GROUP)

 

• Dividing into Field Groups (GROUP)

 

• BEFORE/AFTER GROUP

 

• BEFORE/AFTER GROUP

 

• Ignoring the Input Check (IGNORE)

 

• Ignoring the Input Check (IGNORE)

 

• Initializing the Cursor Position (MARK)

 

• Initializing the Cursor Position (MARK)

 

• Key Activation (ACCEPT)

 

• Key Activation (ACCEPT)

 

• The KEYSWAP Statement

 

• The KEYSWAP Statement

 

• Leaving the Form (RETURNONLAST)

 

• Leaving the Form (RETURNONLAST)

 

• Scrolling Support (AUTOPAGE, PAGE)

 

• Scrolling Support (AUTOPAGE, PAGE)

 

• Header Lines and Bottom Lines (HEADERLINES, BOTTOMLINES)

 

• Header Lines and Bottom Lines (HEADERLINES, BOTTOMLINES)

 

• Situation-dependent Display Attributes (SPECIALATTR)

 

• Situation-dependent Display Attributes (SPECIALATTR)

 

• Displaying the Input Mode (INSERTMODE)

 

• Displaying the Input Mode (INSERTMODE)

 

• Controlling the Dialog Sequence (CONTROL, CASE)

 

• Controlling the Dialog Sequence (CONTROL, CASE)

 

• The PAGE Statement

 

• The PAGE Statement

 

• PICK/PUT Mechanism in Forms (PICK/PUT/AUTOPUT)

 

• PICK/PUT Mechanism in Forms (PICK/PUT/AUTOPUT)

 

• The NEXTFIELD Statement

 

• The NEXTFIELD Statement

 

• The NEXTGROUP Statement

 

• The NEXTGROUP Statement

 

• The SCROLLFIELD Statement

 

• The SCROLLFIELD Statement

 

• The KEYS Statement

 

• The KEYS Statement

 

• Options for Form Calls

 

• Options for Form Calls

 

• Suppressing the INIT Phase (NOINIT)

 

• Cursor Control (MARK, $CURSOR)

 

• Overriding Keys (ACCEPT)

 

• Overriding Display Attributes (ATTR)

 

• The Window Options SCREENPOS, SCREENSIZE, and CLEAR

 

• Form Segments (FORMPOS)

 

• Automatic Framing by FRAME

 

• Superimposing Forms (BACKGROUND)

 

• Restoring the Form Background (RESTORE)

 

• Form Output via Printer (PRINT)

 

• Overriding the Active Input Fields (INPUT/NOINPUT)

 

• Activating the Action Bar (ACTION)

 

• HELP Forms as Pick Lists

 

• HELP Forms as Pick Lists

 

• Action Bar with Pulldown Menus and BUTTON Bar

 

• Action Bar with Pulldown Menus and BUTTON Bar

 

• Defining a Separate MENU Module

 

• Defining the Action Bar within a Form

 

• Defining an Action Bar and a Pulldown Menu

 

• Defining an Action Bar and a Pulldown Menu

 

• Defining the Action Bar (ACTIONBAR)

 

• Defining a Pulldown Menu (PULLDOWN)

 

• Defining Guidance Texts (COMMENT Clause)

 

• Dynamical Deactivation of a Label (WHEN Clause)

 

• Optical Grouping of Menu Items

 

• Examples of Action Bars with Pulldown Menus

 

• Examples of Action Bars with Pulldown Menus

 

• Using an Action Bar with Pulldown Menus

 

• Using an Action Bar with Pulldown Menus

 

• The BUTTON Bar

 

• The BUTTON Bar

 

• Module Options

 

• Module Options

 

• The LIB Option

 

• The WRAP Option

 

• Language-dependent Programs

 

• Language-dependent Programs

 

• Language-dependent Literals in Routines

 

• Language-dependent Literals in Forms

 

• The Generator EXPRESS

 

• The Generator EXPRESS

 

• The Handling of EXPRESS

 

• The Handling of EXPRESS

 

• The Table Menu

 

• The Action Bar of the Table Menu

 

• The Input Forms

 

• The Action Bar of the Input Forms

 

• The Column List

 

• Generating a Single Table Application

 

• Generating a Single Table Application

 

• Data Input for a Single Table Application

 

• Generated Single Table Application

 

• Generating a Master-Detail Application

 

• Generating a Master-Detail Application

 

• Data Input for a Master-Detail Application

 

• Generated Master-Detail Application

 

• Generating an Additional Detail

 

• Generating an Additional Detail

 

• Data Input for an Additional Detail

 

• Generated Additional Detail

 

• Generating a Default Form

 

• Generating a Default Form

 

• Data Input for a Default Form

 

• Generated Default Form

 

• Calling SQL-PL from Precompiled Programs

 

• Calling SQL-PL from Precompiled Programs

 

• EXEC SQLPL

 

• EXEC SQL PROC

 

• Examples

 

• Examples

 

• Restrictions

 

• Restrictions