Internet Application Framework Data Manipulation Language ManualVersion 8.0

IAF 8.0 DML

The information contained in this document is subject to change without notice. Except as may otherwise be provided in a written agreement with a licensee, CDC Software makes no warranty of any kind with regard to this material, either expressed or implied, including, but not limited to, the documentation, function, and performance of these programs. CDC Software disclaims all implied warranties, including, but not limited to, any implied warranty of merchantability or fitness for a particular purpose. Except as may otherwise be provided in a written agreement with a licensee, CDC Software shall not be liable for any errors contained herein or for incidental, special, or consequential damages in connection with the furnishing, performance, or use of this material, and liability for direct damages is limited to the cost of the materials. This document contains proprietary information which is protected by copyright. No part of this document may be reproduced in any manner or translated into another program language without the prior written consent of CDC Software. Copyright 2009 CDC Software Corporation. All Rights Reserved CDC Software, Ross ERP, Strategic Application Modeler (SAM) are registered trademarks of CDC Software Corporation and/or its wholly owned subsidiaries. Ross ERP, Ross APS, Ross SCM, Ross CRM, Ross EPM, Ross Localization and Customer Portal are trademarks of CDC Software Corporation and/or its wholly owned subsidiaries. Other trademarks mentioned herein are the property of their respective companies. CDC Software, Inc. Corporate Headquarters 2002 Summit Blvd. Suite 700 Atlanta, Georgia 30319 (770) 351-9600

ContentsOverview IAF Data Manipulation Language Manual Purpose .................................................................................................xlii Intended Audience................................................................................xlii Related Documents ..............................................................................xlii Language Elements ............................................................................ xliii Language Statements and Constructs...................................................xlv Chapter 1 Program-Data Independence Achieving ProgramData Independence............................................1-3 Advantages of ProgramData Independence .....................................1-4 ProgramData Independence Illustration...........................................1-5 Chapter 2 Title Declarations TITLE Declaration Syntax ...................................................................2-3 Examples: ...........................................................................2-3 Chapter 3 Forms and Form Qualifiers Introduction ..........................................................................................3-4 Form Header Statement Syntax...................................................3-4 Form Arguments..........................................................................3-5 Example: .............................................................................3-5 Passing Arguments ......................................................................3-5 Examples: ...........................................................................3-5 Argument Scope ..........................................................................3-6 Example: .............................................................................3-7 Performing Forms........................................................................3-8 Return Status................................................................................3-8 Example: .............................................................................3-9 MENU Forms.....................................................................................3-10 Form Header Statement Syntax.................................................3-10 Implicit Form Actions ...............................................................3-10 Applicable Qualifiers.................................................................3-11 Example ............................................................................3-11 NORMAL Forms ...............................................................................3-12 General Purpose.........................................................................3-12 Form Header Statement Syntax.................................................3-12 Implicit Form Actions ...............................................................3-13

iii IAF 8.0 DML

Applicable Qualifiers ................................................................ 3-14 Example............................................................................ 3-14 PROCEDURE Forms ........................................................................ 3-15 General Purpose ........................................................................ 3-15 Form Header Statement Syntax ................................................ 3-15 Implicit Form Actions............................................................... 3-15 Applicable Qualifiers ................................................................ 3-16 Example:........................................................................... 3-16 QUERY Forms................................................................................... 3-17 General Purpose ........................................................................ 3-17 Form Header Statement Syntax ................................................ 3-17 Implicit Form Actions............................................................... 3-17 Applicable Qualifiers ................................................................ 3-20 Example:........................................................................... 3-21 REPORT Forms ................................................................................. 3-22 General Purpose ........................................................................ 3-22 Form Header Statement Syntax ................................................ 3-22 Implicit Form Actions............................................................... 3-22 Applicable Qualifiers ................................................................ 3-23 Example:........................................................................... 3-23 TABLE_EDIT Forms......................................................................... 3-24 General Purpose ........................................................................ 3-24 Form Header Statement Syntax ................................................ 3-24 Implicit Form Actions............................................................... 3-24 Applicable Qualifiers ................................................................ 3-28 Example............................................................................ 3-28 Form Qualifiers.................................................................................. 3-29 /ADD_FORM .................................................................................... 3-33 Syntax........................................................................................ 3-33 Description ................................................................................ 3-33 Example............................................................................ 3-33 /ALTERNATE_FORM ...................................................................... 3-34 Syntax........................................................................................ 3-34 Description ................................................................................ 3-34 Example............................................................................ 3-34 /ATTRIBUTES .................................................................................. 3-35 Syntax........................................................................................ 3-35 Description ................................................................................ 3-35 Example............................................................................ 3-35 /BASE ................................................................................................ 3-36 Syntax........................................................................................ 3-36 Description ................................................................................ 3-36 /BEGIN_ROW................................................................................... 3-37 Syntax........................................................................................ 3-37

iv IAF 8.0 DML

Description ................................................................................3-37 For REPORT forms: .........................................................3-37 For TABLE_EDIT forms:.................................................3-37 Examples...........................................................................3-37 /BREAK .............................................................................................3-38 Syntax ........................................................................................3-38 Description ................................................................................3-38 break_expression ..............................................................3-38 begin_form_name .............................................................3-38 end_form_name ................................................................3-38 break_option[,break_option[,...]]......................................3-39 Examples...........................................................................3-42 /BREAK0 ...........................................................................................3-44 Syntax ........................................................................................3-44 Description ................................................................................3-44 Examples...........................................................................3-44 /CHEADING......................................................................................3-45 Syntax ........................................................................................3-45 Description ................................................................................3-45 /COL...................................................................................................3-46 Syntax ........................................................................................3-46 Description ................................................................................3-46 Examples...........................................................................3-46 /COLUMN_HEADINGS ...................................................................3-47 Syntax ........................................................................................3-47 Description ................................................................................3-47 Example ............................................................................3-47 /COLUMN_HEADING_ROW..........................................................3-48 Syntax ........................................................................................3-48 Description ................................................................................3-48 Example ............................................................................3-48 /COLUMN_SPACING.......................................................................3-49 Syntax ........................................................................................3-49 Description ................................................................................3-49 Example ............................................................................3-49 /COMMIT_RATE ..............................................................................3-50 Syntax ........................................................................................3-50 Description ................................................................................3-50 Examples...........................................................................3-50 /DEFAULT_TAG ...............................................................................3-51 Syntax ........................................................................................3-51 Description........................................................................3-51 Example ............................................................................3-51 /DELETE_FORM ..............................................................................3-52

v IAF 8.0 DML

Syntax........................................................................................ 3-52 Description ................................................................................ 3-52 For QUERY forms: .......................................................... 3-52 For TABLE_EDIT forms: ................................................ 3-52 Example............................................................................ 3-53 /END_ROW....................................................................................... 3-54 Syntax........................................................................................ 3-54 Description ................................................................................ 3-54 For REPORT forms:......................................................... 3-54 For TABLE_EDIT forms: ................................................ 3-54 Example............................................................................ 3-54 /FIND_FORM.................................................................................... 3-55 Syntax........................................................................................ 3-55 Description ................................................................................ 3-55 For QUERY forms: .......................................................... 3-55 For REPORT forms:......................................................... 3-55 For TABLE_EDIT forms: ................................................ 3-56 Example............................................................................ 3-56 /FIRST ............................................................................................... 3-57 Syntax........................................................................................ 3-57 Description ................................................................................ 3-57 Example............................................................................ 3-57 /FOOTING......................................................................................... 3-58 Syntax........................................................................................ 3-58 Description ................................................................................ 3-58 Example............................................................................ 3-58 /FOOTING_FORM ........................................................................... 3-59 Syntax........................................................................................ 3-59 Description ................................................................................ 3-59 Examples .......................................................................... 3-59 /GROUPED_BY................................................................................ 3-61 Syntax........................................................................................ 3-61 Description ................................................................................ 3-61 Sub-group Clauses............................................................ 3-62 Examples .......................................................................... 3-64 /HEADING ........................................................................................ 3-66 Syntax........................................................................................ 3-66 Description ................................................................................ 3-66 iBrowser Note .................................................................. 3-66 Example............................................................................ 3-66 /HEADING_FORM........................................................................... 3-67 Syntax........................................................................................ 3-67 Description ................................................................................ 3-67 Example............................................................................ 3-67

vi IAF 8.0 DML

/HEIGHT............................................................................................3-68 Syntax ........................................................................................3-68 Description ................................................................................3-68 Examples...........................................................................3-68 /INPUT_ROW_HEIGHT...................................................................3-69 Syntax ........................................................................................3-69 Description ................................................................................3-69 Example ............................................................................3-69 /JOINED_TO .....................................................................................3-70 Syntax ........................................................................................3-70 Description ................................................................................3-70 Example ............................................................................3-70 /LFOOTING.......................................................................................3-71 Syntax ........................................................................................3-71 Description ................................................................................3-71 Example ............................................................................3-71 /LHEADING ......................................................................................3-72 Syntax ........................................................................................3-72 Description ................................................................................3-72 iBrowser Note ...................................................................3-72 Example ............................................................................3-72 /LINES_AFTER.................................................................................3-73 Syntax ........................................................................................3-73 Description ................................................................................3-73 Examples...........................................................................3-73 /LINES_BEFORE ..............................................................................3-74 Syntax ........................................................................................3-74 Description ................................................................................3-74 Examples..........................................................................3-74 /LOCK................................................................................................3-75 Syntax ........................................................................................3-75 Description ................................................................................3-75 Examples...........................................................................3-76 /MODIFY_FORM..............................................................................3-77 Syntax ........................................................................................3-77 Description ................................................................................3-77 Examples...........................................................................3-77 /NOERROR........................................................................................3-78 Syntax ........................................................................................3-78 Description ................................................................................3-78 Example.....................................................................................3-78 /NOEXIT_FORWARD.......................................................................3-79 Syntax ........................................................................................3-79 Description ................................................................................3-79

vii IAF 8.0 DML

/NOSTATUS ...................................................................................... 3-80 Syntax........................................................................................ 3-80 Description ................................................................................ 3-80 /OPTIONS.......................................................................................... 3-81 Syntax........................................................................................ 3-81 Description ................................................................................ 3-81 For QUERY forms: .......................................................... 3-81 For REPORT forms:......................................................... 3-82 NOTE: .............................................................................. 3-82 NOTE: .............................................................................. 3-84 INFINITE ......................................................................... 3-87 MERGED ......................................................................... 3-89 NOTE: .............................................................................. 3-89 NOUNDERLINES ........................................................... 3-92 OVERLAID ..................................................................... 3-92 NOTE: .............................................................................. 3-92 PAGE_BREAK_REPRINT.............................................. 3-95 PRINT .............................................................................. 3-97 SUMMARY ..................................................................... 3-97 ZEROSUPPRESS ............................................................ 3-99 For TABLE_EDIT forms: .............................................. 3-101 /OUTPUT......................................................................................... 3-105 Syntax...................................................................................... 3-105 Description .............................................................................. 3-105 Example.......................................................................... 3-105 /PDF ................................................................................................. 3-106 Syntax...................................................................................... 3-106 Description .............................................................................. 3-106 Options .................................................................................... 3-106 /READ_ONLY................................................................................. 3-123 Syntax...................................................................................... 3-123 Description .............................................................................. 3-123 For TABLE_EDIT forms: .............................................. 3-123 For All Forms: ................................................................ 3-123 /REDUCED_TO .............................................................................. 3-124 Syntax...................................................................................... 3-124 Description .............................................................................. 3-124 Examples ....................................................................... 3-125 /REMAIN......................................................................................... 3-127 Syntax...................................................................................... 3-127 Description .............................................................................. 3-127 Example.......................................................................... 3-128 /REPEAT.......................................................................................... 3-129 Syntax...................................................................................... 3-129

viii IAF 8.0 DML

Description ..............................................................................3-129 /RFOOTING.....................................................................................3-130 Syntax ......................................................................................3-130 Example ..........................................................................3-130 /RHEADING....................................................................................3-131 Syntax ......................................................................................3-131 Description ..............................................................................3-131 iBrowser Note .................................................................3-131 Example ..........................................................................3-131 /ROW ...............................................................................................3-132 Syntax ......................................................................................3-132 Description ..............................................................................3-132 Examples.........................................................................3-132 /ROW_HEIGHT...............................................................................3-133 Syntax ......................................................................................3-133 Description ..............................................................................3-133 Example ..........................................................................3-133 /SECONDARY.................................................................................3-134 Syntax ......................................................................................3-134 Description ..............................................................................3-134 Example ..........................................................................3-134 /SELECTION ...................................................................................3-135 Syntax ......................................................................................3-135 Description ..............................................................................3-135 Operator Precedence .......................................................3-135 Examples.........................................................................3-136 /SEQUENCE....................................................................................3-138 Syntax ......................................................................................3-138 Description ..............................................................................3-138 Example ..........................................................................3-139 /SEQUENCE_INCREMENT...........................................................3-140 Syntax ......................................................................................3-140 Description ..............................................................................3-140 Example ..........................................................................3-140 /SORTED_BY..................................................................................3-141 Syntax ......................................................................................3-141 Description ..............................................................................3-141 Examples.........................................................................3-142 /STATISTIC......................................................................................3-143 Syntax ......................................................................................3-143 Description ..............................................................................3-143 Examples.........................................................................3-145 /STATUS ..........................................................................................3-147 Syntax ......................................................................................3-147

ix IAF 8.0 DML

Description .............................................................................. 3-147 /STREAM_NAME .......................................................................... 3-149 Syntax...................................................................................... 3-149 Description .............................................................................. 3-149 Example.......................................................................... 3-149 /SYSTEM......................................................................................... 3-150 Syntax...................................................................................... 3-150 Description .............................................................................. 3-150 Examples ........................................................................ 3-150 /TABLE............................................................................................ 3-151 Syntax...................................................................................... 3-151 Description .............................................................................. 3-151 Examples ........................................................................ 3-153 /TAG_LENGTH............................................................................... 3-154 Syntax...................................................................................... 3-154 Description .............................................................................. 3-154 Examples ........................................................................ 3-154 /TITLE ............................................................................................. 3-155 Syntax...................................................................................... 3-155 Description .............................................................................. 3-155 Example.......................................................................... 3-155 /WIDTH ........................................................................................... 3-156 Syntax...................................................................................... 3-156 Description .............................................................................. 3-156 Examples ........................................................................ 3-156 /WITH.............................................................................................. 3-157 Syntax...................................................................................... 3-157 Description .............................................................................. 3-157 expression....................................................................... 3-159 Overriding Default Table Joins ...................................... 3-160 NOTE: ............................................................................ 3-161 Comparing Fields within a Table ................................... 3-161 NOTE: ............................................................................ 3-162 Missing Values ............................................................... 3-162 NOTE: ............................................................................ 3-163 Wildcard Character Matching ........................................ 3-163 NOTE: ............................................................................ 3-164 Examples ........................................................................ 3-164 Streams with a /WITH Qualifier ............................................. 3-166 Example 1:...................................................................... 3-166 Example 2:...................................................................... 3-166 Example 3:...................................................................... 3-167

x IAF 8.0 DML

Chapter 4 Fixed Display Declarations TEXT Declarations ..............................................................................4-3 Syntax ..........................................................................................4-3 text ...............................................................................................4-3 token ............................................................................................4-3 NOTE:.................................................................................4-4 /ROW=numeric_expression ...............................................4-4 /COL=numeric_expression.................................................4-4 Examples: ...........................................................................4-4 LINE Declarations................................................................................4-5 Syntax ..........................................................................................4-5 numeric_expression ............................................................4-5 /ROW=numeric_expression ...............................................4-5 /COL=numeric_expression.................................................4-5 /END_ROW=numeric_expression .....................................4-6 /END_COL=numeric_expression.......................................4-6 Examples: ...........................................................................4-6 Chapter 5 Blocks and Block Qualifiers Introduction ..........................................................................................5-4 Block Statement Syntax .......................................................................5-4 block_statement ...........................................................................5-4 block_name..................................................................................5-4 /qualifiers .....................................................................................5-4 BEGIN_BLOCK/END_BLOCK Construct.........................................5-5 Example: .............................................................................5-6 Completion Status ................................................................................5-6 DML Blocks.........................................................................................5-7 General Purpose...........................................................................5-7 Block Statement Syntax...............................................................5-7 Implicit Block Actions ................................................................5-7 Special Considerations ................................................................5-8 Qualifiers .....................................................................................5-8 Examples.............................................................................5-8 INPUT Blocks ......................................................................................5-9 General Purpose...........................................................................5-9 Block Statement Syntax...............................................................5-9 Implicit Block Actions ................................................................5-9 Special Considerations ................................................................5-9 Qualifiers ...................................................................................5-10 Example ............................................................................5-10 ITEM Blocks ......................................................................................5-11

xi IAF 8.0 DML

General Purpose ........................................................................ 5-11 Block Statement Syntax ............................................................ 5-11 Implicit Block Actions .............................................................. 5-11 Special Considerations .............................................................. 5-11 Qualifiers................................................................................... 5-12 Example............................................................................ 5-12 MENU Blocks.................................................................................... 5-13 General Purpose ........................................................................ 5-13 Block Statement Syntax ............................................................ 5-13 Implicit Block Actions .............................................................. 5-13 Special Considerations .............................................................. 5-14 Qualifiers................................................................................... 5-15 Example............................................................................ 5-15 Examples: Applying MENU Block Pulldown Menus....................... 5-16 Examples: Applying Block Button Menus ........................................ 5-18 OUTPUT Blocks................................................................................ 5-19 General Purpose ........................................................................ 5-19 Block Statement Syntax ............................................................ 5-19 Implicit Block Actions .............................................................. 5-19 Special Considerations .............................................................. 5-19 Qualifiers................................................................................... 5-20 Example............................................................................ 5-20 PAUSE Blocks ................................................................................... 5-21 General Purpose ........................................................................ 5-21 Block Statement Syntax ............................................................ 5-21 Implicit Block Actions .............................................................. 5-21 Special Considerations .............................................................. 5-21 Qualifiers................................................................................... 5-22 Example............................................................................ 5-22 SIGNATURE_BLOCK...................................................................... 5-23 General Purpose ........................................................................ 5-23 Block Statement Syntax ............................................................ 5-23 Implicit Block Actions .............................................................. 5-24 Special Considerations .............................................................. 5-24 Specific Qualifiers..................................................................... 5-24 Additional Qualifiers................................................................. 5-25 Exit Status ................................................................................. 5-26 YESNO Blocks .................................................................................. 5-27 General Purpose ........................................................................ 5-27 Block Statement Syntax ............................................................ 5-27 Implicit Block Actions .............................................................. 5-27 Special Considerations .............................................................. 5-27 Qualifiers................................................................................... 5-28 Example............................................................................ 5-28

xii IAF 8.0 DML

Examples: Applying YESNO Block Checkboxes .............................5-29 Examples: Applying YESNO Block Buttons.....................................5-30 Block Qualifiers .................................................................................5-31 /ABSOLUTE_POSITION..................................................................5-36 Syntax ........................................................................................5-36 Description ................................................................................5-36 Example ............................................................................5-36 /ATTRIBUTES...................................................................................5-37 Syntax ........................................................................................5-37 Description ................................................................................5-37 Example ............................................................................5-38 /AUDIT ..............................................................................................5-39 Syntax ........................................................................................5-39 Description ................................................................................5-39 Example ............................................................................5-39 /BACK................................................................................................5-40 Syntax ........................................................................................5-40 Description ................................................................................5-40 Examples...........................................................................5-40 /BREAK .............................................................................................5-41 Syntax ........................................................................................5-41 Description ................................................................................5-41 Example ...........................................................................5-41 /CHEADING......................................................................................5-42 Syntax ........................................................................................5-42 Description ................................................................................5-42 Example ............................................................................5-42 /COL...................................................................................................5-43 Syntax ........................................................................................5-43 Description ................................................................................5-43 /COL=keyword .................................................................5-44 Examples...........................................................................5-44 /DATETIME.......................................................................................5-45 Syntax ........................................................................................5-45 Description ................................................................................5-45 Example ............................................................................5-45 /DISPLAY_LENGTH.........................................................................5-46 Syntax ........................................................................................5-46 Description ................................................................................5-46 Example ............................................................................5-46 /DISPLAY_ONLY..............................................................................5-47 Syntax ........................................................................................5-47 Description ................................................................................5-47 Example ............................................................................5-47

xiii IAF 8.0 DML

/DOMAIN.......................................................................................... 5-48 Syntax........................................................................................ 5-48 Description ................................................................................ 5-48 Output Block Domain Validation ..................................... 5-49 Examples .......................................................................... 5-49 /DOUBLE .......................................................................................... 5-50 Syntax........................................................................................ 5-50 Description ................................................................................ 5-50 /ERASE.............................................................................................. 5-51 /EXIT ................................................................................................. 5-52 Syntax........................................................................................ 5-52 Description ................................................................................ 5-52 Examples .......................................................................... 5-52 /EXIT_FORWARD............................................................................ 5-53 Syntax........................................................................................ 5-53 Description ................................................................................ 5-53 Example............................................................................ 5-54 /FACILITY ........................................................................................ 5-55 Syntax........................................................................................ 5-55 Description ................................................................................ 5-55 /FAILURE.......................................................................................... 5-56 Syntax........................................................................................ 5-56 Description ................................................................................ 5-56 Example............................................................................ 5-56 /HEADING ........................................................................................ 5-57 Syntax........................................................................................ 5-57 Description ................................................................................ 5-57 Example............................................................................ 5-57 /HEIGHT ........................................................................................... 5-58 Syntax........................................................................................ 5-58 Description ................................................................................ 5-58 For input blocks:............................................................... 5-58 For output blocks:............................................................. 5-58 For menu blocks: .............................................................. 5-60 Example............................................................................ 5-60 /INPUT_MASK ................................................................................. 5-61 Syntax........................................................................................ 5-61 Description ................................................................................ 5-61 Example............................................................................ 5-61 /ITEM................................................................................................. 5-62 Syntax........................................................................................ 5-62 Description ................................................................................ 5-62 Examples .......................................................................... 5-62 /ITEM_IF ........................................................................................... 5-63

xiv IAF 8.0 DML

Syntax ........................................................................................5-63 Description ................................................................................5-63 Example ............................................................................5-63 /LEN ...................................................................................................5-64 Syntax ........................................................................................5-64 Description ................................................................................5-64 Examples...........................................................................5-67 /LHEADING ......................................................................................5-68 Syntax ........................................................................................5-68 Description ................................................................................5-68 Example.....................................................................................5-68 /LOV...................................................................................................5-69 Syntax ........................................................................................5-69 Description........................................................................5-69 Example ............................................................................5-69 /LOV_AUTO_SELECT.....................................................................5-70 Syntax ........................................................................................5-70 Description ................................................................................5-70 Example ............................................................................5-70 /LOV_COL.........................................................................................5-71 Syntax ........................................................................................5-71 Description ................................................................................5-71 Examples...........................................................................5-71 /LOV_DATA ......................................................................................5-72 Syntax ........................................................................................5-72 Description ................................................................................5-72 Example ............................................................................5-72 /LOV_FIRST......................................................................................5-73 Syntax ........................................................................................5-73 Description ................................................................................5-73 Example ............................................................................5-73 /LOV_HEIGHT..................................................................................5-74 Syntax ........................................................................................5-74 Description ................................................................................5-74 Example ............................................................................5-74 /LOV_NOHEADING.........................................................................5-75 Syntax ........................................................................................5-75 Description ................................................................................5-75 /LOV_NOSEARCH ...........................................................................5-76 Syntax ........................................................................................5-76 Description ................................................................................5-76 Example ............................................................................5-76 /LOV_REDUCED_TO ......................................................................5-77 Syntax ........................................................................................5-77

xv IAF 8.0 DML

Description ................................................................................ 5-77 Example............................................................................ 5-77 /LOV_ROW....................................................................................... 5-78 Syntax........................................................................................ 5-78 Description ................................................................................ 5-78 Examples .......................................................................... 5-78 /LOV_SECONDARY........................................................................ 5-79 Syntax........................................................................................ 5-79 Description ................................................................................ 5-79 /LOV_SELECTION .......................................................................... 5-80 Syntax........................................................................................ 5-80 Description ................................................................................ 5-80 Operator Precedence......................................................... 5-81 Examples .......................................................................... 5-82 /LOV_SORTED_BY ......................................................................... 5-83 Syntax........................................................................................ 5-83 Description ................................................................................ 5-83 Example............................................................................ 5-83 /LOV_WIDTH................................................................................... 5-84 Syntax........................................................................................ 5-84 Description ................................................................................ 5-84 Example............................................................................ 5-84 /LOV_WITH...................................................................................... 5-85 Syntax........................................................................................ 5-85 Description ................................................................................ 5-85 field_name ........................................................................ 5-85 operator............................................................................. 5-85 value_expression .............................................................. 5-87 Examples .......................................................................... 5-87 /NEW ................................................................................................. 5-88 Syntax........................................................................................ 5-88 Description ................................................................................ 5-88 Using /NEW with /PROTECT ......................................... 5-88 Example............................................................................ 5-89 /NOAUDIT ........................................................................................ 5-90 Syntax........................................................................................ 5-90 Description ................................................................................ 5-90 Example............................................................................ 5-90 /NOCLEAR_BUFFER ...................................................................... 5-91 Syntax........................................................................................ 5-91 Description ................................................................................ 5-91 /NODOMAIN .................................................................................... 5-92 Syntax........................................................................................ 5-92 Description ................................................................................ 5-92

xvi IAF 8.0 DML

/NOLOV_DATA ................................................................................5-93 Syntax ........................................................................................5-93 Description ................................................................................5-93 Example ............................................................................5-93 /NOHEADING...................................................................................5-93 Syntax ........................................................................................5-93 Description ................................................................................5-93 /NOREPEAT ......................................................................................5-94 Syntax ........................................................................................5-94 Description ................................................................................5-94 /NOUNDERLINES............................................................................5-94 Syntax ........................................................................................5-94 Description ................................................................................5-94 /OPT ...................................................................................................5-95 Syntax ........................................................................................5-95 Description ................................................................................5-95 /OPTIONS ..........................................................................................5-96 Syntax ........................................................................................5-96 Description ................................................................................5-96 /OUTPUT_MASK .............................................................................5-97 Syntax ........................................................................................5-97 Description ................................................................................5-97 Examples...........................................................................5-97 /PDF ...................................................................................................5-98 Syntax ........................................................................................5-98 Description ................................................................................5-98 Options ......................................................................................5-98 Examples...........................................................................5-99 /PROMPT .........................................................................................5-101 Syntax ......................................................................................5-101 Description ..............................................................................5-101 Examples.........................................................................5-102 /PROTECT .......................................................................................5-103 Syntax ......................................................................................5-103 Description ..............................................................................5-103 Using /PROTECT with /NEW........................................5-103 Example ..........................................................................5-104 /PURPOSE .......................................................................................5-105 Syntax ......................................................................................5-105 Description ..............................................................................5-105 Example ..........................................................................5-105 /RECALL .........................................................................................5-106 /RHEADING....................................................................................5-107 Syntax ......................................................................................5-107

xvii IAF 8.0 DML

Description .............................................................................. 5-107 Example.......................................................................... 5-107 /ROW ............................................................................................... 5-108 Syntax...................................................................................... 5-108 Description .............................................................................. 5-108 Example.......................................................................... 5-108 /SAVE .............................................................................................. 5-109 /SOURCE......................................................................................... 5-110 Syntax...................................................................................... 5-110 Description .............................................................................. 5-110 Examples ........................................................................ 5-111 /SOURCE_IF ................................................................................... 5-112 Syntax...................................................................................... 5-112 Description .............................................................................. 5-112 Examples ........................................................................ 5-113 /SUCCESS ....................................................................................... 5-115 Syntax...................................................................................... 5-115 Description .............................................................................. 5-115 Example .................................................................................. 5-115 /TAG ................................................................................................ 5-116 Syntax...................................................................................... 5-116 Description .............................................................................. 5-116 Example.......................................................................... 5-116 /TAG_LENGTH............................................................................... 5-117 Syntax...................................................................................... 5-117 Description .............................................................................. 5-117 Examples ........................................................................ 5-117 /TARGET......................................................................................... 5-118 Syntax...................................................................................... 5-118 Description .............................................................................. 5-118 Examples ........................................................................ 5-119 /TITLE ............................................................................................. 5-120 Syntax...................................................................................... 5-120 Description .............................................................................. 5-120 Example.......................................................................... 5-120 /TOTAL............................................................................................ 5-121 Syntax...................................................................................... 5-121 Description .............................................................................. 5-121 Example.......................................................................... 5-122 /USE_IF ........................................................................................... 5-123 Syntax...................................................................................... 5-123 Description .............................................................................. 5-123 Examples ........................................................................ 5-123 /USERNAME1 ................................................................................ 5-124

xviii IAF 8.0 DML

Syntax ......................................................................................5-124 Description ..............................................................................5-124 Example ..........................................................................5-124 /USERNAME2.................................................................................5-125 Syntax ......................................................................................5-125 Description ..............................................................................5-125 Example...................................................................................5-125 /USER1-5 .........................................................................................5-126 Syntax ......................................................................................5-126 Description ..............................................................................5-126 Example ..........................................................................5-126 /USER_KEYn ..................................................................................5-127 Syntax ......................................................................................5-127 Description ..............................................................................5-127 Examples.........................................................................5-127 /USING.............................................................................................5-128 Syntax ......................................................................................5-128 Description ..............................................................................5-128 For input blocks: .............................................................5-128 For output blocks: ...........................................................5-130 Examples.........................................................................5-130 /VALIDATION.................................................................................5-131 Syntax ......................................................................................5-131 Description ..............................................................................5-131 Example ..........................................................................5-131 Chapter 6 Language Statements Language Statements Table..................................................................6-3 ADD ADMIN_ID ..............................................................................6-21 Syntax ........................................................................................6-21 Category ....................................................................................6-21 Description ................................................................................6-21 Example.....................................................................................6-21 ADD ROLE........................................................................................6-22 Syntax ........................................................................................6-22 Category ....................................................................................6-22 Description ................................................................................6-22 Examples ...................................................................................6-23 ADD ROLE_USER............................................................................6-24 Syntax ........................................................................................6-24 Category ....................................................................................6-24 Description ................................................................................6-24 Example.....................................................................................6-24

xix IAF 8.0 DML

ADD TO ............................................................................................ 6-25 Syntax........................................................................................ 6-25 Category .................................................................................... 6-25 Description ................................................................................ 6-25 Example............................................................................ 6-26 Related Topics .................................................................. 6-26 Qualifiers................................................................................... 6-27 ADD USER_ROLE ........................................................................... 6-28 Syntax........................................................................................ 6-28 Category .................................................................................... 6-28 Description ................................................................................ 6-28 Example .................................................................................... 6-28 Archive............................................................................................... 6-29 Syntax........................................................................................ 6-29 Category .................................................................................... 6-29 Description ................................................................................ 6-29 Qualifiers................................................................................... 6-30 ASSERT............................................................................................. 6-31 Syntax........................................................................................ 6-31 Category .................................................................................... 6-31 Description ................................................................................ 6-31 Qualifiers................................................................................... 6-31 Example 1......................................................................... 6-31 Related Topics .................................................................. 6-32 ASSERT_EQUAL ............................................................................. 6-33 Syntax........................................................................................ 6-33 Category .................................................................................... 6-33 Description ................................................................................ 6-33 Qualifiers................................................................................... 6-33 Example 1......................................................................... 6-33 Example 2......................................................................... 6-34 Related Topics .................................................................. 6-34 ASSERT_FAIL .................................................................................. 6-35 Syntax........................................................................................ 6-35 Category .................................................................................... 6-35 Description ................................................................................ 6-35 Qualifiers................................................................................... 6-35 Example............................................................................ 6-35 Related Topics .................................................................. 6-36 BEGIN_DISABLE_TRIGGER ......................................................... 6-37 Syntax........................................................................................ 6-37 Category .................................................................................... 6-37 Description ................................................................................ 6-37 Example............................................................................ 6-37

xx IAF 8.0 DML

Related Topics...................................................................6-37 BEGIN_SIGNAL_TO_STATUS .......................................................6-38 Syntax ........................................................................................6-38 Category ....................................................................................6-38 Description ................................................................................6-38 Example ............................................................................6-39 Related Topics...................................................................6-39 CALL .................................................................................................6-40 Syntax ........................................................................................6-40 Category ....................................................................................6-40 Description........................................................................6-40 Examples...........................................................................6-41 Related Topics...................................................................6-41 CALL_WEB_SERVICE ....................................................................6-42 Syntax ........................................................................................6-42 Category ....................................................................................6-42 Description ................................................................................6-42 Qualifiers ...................................................................................6-42 Examples ...................................................................................6-43 CASE, BEGIN_CASE, CASE ELSE, and END_CASE ...................6-44 Syntax ........................................................................................6-44 Category ....................................................................................6-44 Description ................................................................................6-44 Example ............................................................................6-46 Related Topics...................................................................6-47 CD ......................................................................................................6-48 Syntax ........................................................................................6-48 Category ....................................................................................6-48 Description ................................................................................6-48 CHECK_DOMAIN............................................................................6-49 Syntax ........................................................................................6-49 Category ....................................................................................6-49 Description ................................................................................6-49 Qualifiers ...................................................................................6-51 Examples...........................................................................6-55 Related Topics...................................................................6-56 CLEAR_ARRAY ...............................................................................6-57 Syntax ........................................................................................6-57 Category ....................................................................................6-57 Description ................................................................................6-57 Examples ...................................................................................6-57 CLEAR_BUFFER..............................................................................6-58 Syntax ........................................................................................6-58 Category ....................................................................................6-58

xxi IAF 8.0 DML

Description ....................................................................... 6-58 Examples .......................................................................... 6-59 Related Topics .................................................................. 6-59 CLI ..................................................................................................... 6-60 Syntax........................................................................................ 6-60 Category .................................................................................... 6-60 Description ................................................................................ 6-60 Qualifiers................................................................................... 6-60 Related Topics .................................................................. 6-61 CLOSE............................................................................................... 6-62 Syntax........................................................................................ 6-62 Category .................................................................................... 6-62 Description ................................................................................ 6-62 Examples .......................................................................... 6-62 Related Topics .................................................................. 6-62 CLOSE_TABS................................................................................... 6-63 Syntax........................................................................................ 6-63 Optional Qualifiers.................................................................... 6-63 Description ................................................................................ 6-63 Corresponding UIDL ................................................................ 6-63 Description ................................................................................ 6-63 Attributes................................................................................... 6-64 Syntax........................................................................................ 6-64 CLOSE_TEXT................................................................................... 6-65 Syntax........................................................................................ 6-65 Category .................................................................................... 6-65 Description ................................................................................ 6-65 Examples .......................................................................... 6-65 Related Topics .................................................................. 6-65 COCALL ........................................................................................... 6-66 Syntax........................................................................................ 6-66 Category .................................................................................... 6-66 Description ................................................................................ 6-66 Example 1......................................................................... 6-68 Example 2......................................................................... 6-68 Example 3......................................................................... 6-69 Example 4......................................................................... 6-69 Example 5......................................................................... 6-69 Example 6......................................................................... 6-70 Example 7......................................................................... 6-70 Example 8......................................................................... 6-71 Example 9......................................................................... 6-72 Example 10....................................................................... 6-73 COCREATE....................................................................................... 6-74

xxii IAF 8.0 DML

Syntax ........................................................................................6-74 Category ....................................................................................6-74 Description ................................................................................6-74 Example 1 .........................................................................6-77 COM Special Parameter Considerations.......................................6-80 COM Success ............................................................................6-80 COM Warning ...........................................................................6-80 COM Error.................................................................................6-80 Advanced Usage Notes..............................................................6-80 Accessing Windows Server from a remote PC..........................6-80 Running Thin Client/Server on the same PC ............................6-81 Third Party COM Objects .........................................................6-81 COMMIT ...........................................................................................6-82 Syntax ........................................................................................6-82 Category ....................................................................................6-82 Description ................................................................................6-82 Related Topics...................................................................6-83 COMPILE ..........................................................................................6-84 Syntax ........................................................................................6-84 Category ....................................................................................6-84 Description ................................................................................6-84 Qualifiers ...................................................................................6-85 Example ............................................................................6-86 Related Topics...................................................................6-86 CONNECT .........................................................................................6-87 Syntax ........................................................................................6-87 Category ....................................................................................6-87 Description ................................................................................6-87 Parameters .................................................................................6-88 Examples ...................................................................................6-88 Related Topics ...........................................................................6-88 CONTINUE .......................................................................................6-89 Syntax ........................................................................................6-89 Category ....................................................................................6-89 Description ................................................................................6-89 Keywords...................................................................................6-89 Example ............................................................................6-90 Related Topics...................................................................6-90 COPY_FILE.......................................................................................6-91 Syntax ........................................................................................6-91 Description ................................................................................6-91 Parameters.........................................................................6-91 Qualifiers ...................................................................................6-92 Example ............................................................................6-92

xxiii IAF 8.0 DML

CORELEASE .................................................................................... 6-93 Syntax........................................................................................ 6-93 Category .................................................................................... 6-93 Description ................................................................................ 6-93 Example 1......................................................................... 6-93 Example 2......................................................................... 6-94 Example 3......................................................................... 6-95 Example 4....................................................................... 6-100 Example 5....................................................................... 6-102 CPANEL .......................................................................................... 6-105 Introduction............................................................................. 6-105 Syntax...................................................................................... 6-105 Description .............................................................................. 6-105 Qualifiers................................................................................. 6-105 Examples ........................................................................ 6-108 CROSS_REFERENCE.................................................................... 6-109 Syntax...................................................................................... 6-109 Category .................................................................................. 6-109 Description .............................................................................. 6-109 Related Topics ................................................................ 6-110 DCL ................................................................................................. 6-111 Syntax...................................................................................... 6-111 Category ............................................