documentation.HELP! LANSA Technical Documentation

LANSA Technical Reference

LANSA Technical

Table of contents

• Technical Reference Guide
  • Quick Reference
    • RDML Commands
    • RDMLX Commands
    • Built-In Functions by Category
      • Application Execution Control Built-In Functions
      • Authority Built-In Functions
      • Client/Server Support Built-In Functions
      • Data Area Built-In Functions
      • Data Queue Built-In Functions
      • Date and Time Built-In Functions
      • Domino Integration Built-In Functions
      • Email Handling Built-In Functions
      • Enhanced 5250 User Interface Built-In Functions
      • Exchange List Built-In Functions
      • Export/Import/Deployment Built-In Functions
      • Field and Component Related Built-In Functions
      • File Related Built-In Functions
      • Function Related Built-In Functions
      • LANSA Composer Built-In Functions
      • LANSA Integrator Built-In Functions
      • List Handling Built-In Functions
      • Locking Built-In Functions
      • Mathematical Built-In Functions
      • Messages and Message Handling Built-In Functions
      • Message Box Built-in Functions
      • Miscellaneous Built-In Functions
      • Other Vendor Built-In Functions
      • Process Related Built-In Functions
      • Rule/Trigger Related Built-In Functions
      • Space Built-In Functions
      • Spool File Built-In Functions
      • String Handling Built-In Functions
      • Template Related Built-In Functions
      • Unique Operating System and Platform Access Built-In Functions
      • Web Built-In Functions
      • Zip Built-In Functions
    • System Variables
    • Formats, Values and Codes
  • 1. Fields
    • 1.1 Field Types
      • 1.1.1 Field Type Considerations
        • Field Type Use Recommendations
        • Field Type Conversions
        • RDMLX Enabled Partition
        • SQL Null Handling
          • ASQN (Allow SQL Nulls) attribute
          • *SQLNULL Keyword
          • Intrinsic Property .IsSqlNull
          • Intrinsic Method .AsValue
          • Assignment, Conditions, and Expressions with Fields allowing SQL Null
        • What Classifies a Field as RDML?
      • 1.1.2 Alpha
      • 1.1.3 String
      • 1.1.4 NVarChar
      • 1.1.5 Char
      • 1.1.6 NChar
      • 1.1.7 Packed
      • 1.1.8 Signed
      • 1.1.9 Integer
      • 1.1.10 Float
      • 1.1.11 Date
      • 1.1.12 Time
      • 1.1.13 DateTime
      • 1.1.14 Binary
      • 1.1.15 VarBinary
      • 1.1.16 DBCS Graphic String
      • 1.1.17 BLOB
      • 1.1.18 CLOB
      • 1.1.19 Boolean
    • 1.2 Field Definitions
      • 1.2.1 Field Name
      • 1.2.2 Field Identifier
      • 1.2.3 Field Type
      • 1.2.4 Field Length
      • 1.2.5 Decimals
      • 1.2.6 Default Value
      • 1.2.7 Reference Field
      • 1.2.8 Field Description
      • 1.2.9 Field Label
      • 1.2.10 Field Column Heading
      • 1.2.11 Allocated Length (IBM i only)
      • 1.2.12 Edit Mask
      • 1.2.13 Keyboard Shift
      • 1.2.14 Enable Field for RDMLX
      • 1.2.15 System Field
      • 1.2.16 Field Attributes
      • 1.2.17 Input Attributes
      • 1.2.18 Output Attributes
      • 1.2.19 Prompting
      • 1.2.20 Alias Name
    • 1.3 Field Visualizations
    • 1.4 Field Rules and Triggers
    • 1.5 Field Help Text
  • 2. Rules and Triggers
    • 2.1 Rule Definitions
      • 2.1.1 Rule Sequence
      • 2.1.2 Rule Description
      • 2.1.3 Validation Usage
      • 2.1.4 Define Rules (by type)
      • 2.1.5 Validation Actions
      • 2.1.6 Error Message
    • 2.2 List of Values Checks
      • 2.2.1 Value
      • 2.2.2 List Examples
    • 2.3 Range of Values Checks
      • 2.3.1 Range: From value / To value
      • 2.3.2 Range of Values Examples
    • 2.4 Date Format/Range Check
      • 2.4.1 Date Format
      • 2.4.2 Number of Days Allowed into the Past
      • 2.4.3 Number of Days Allowed into the Future
      • 2.4.4 Date Format/Range Check Examples
    • 2.5 Code File/Table Lookup Checks
      • 2.5.1 Lookup File Name
      • 2.5.2 Key Field or Literal
      • 2.5.3 Code File/Table Lookup Check Examples
    • 2.6 Simple Logic Check
      • 2.6.1 Condition to Check
      • 2.6.2 Simple Logic Check Examples
    • 2.7 Complex Logic Check
      • 2.7.1 Program to Call
      • 2.7.2 Program to Call: Function
      • 2.7.3 Program to Call: 3GL Program
      • 2.7.4 3GL Parameters
      • 2.7.5 Complex Logic Check Examples
    • 2.8 Triggers
      • 2.8.1 Trigger Definition
        • Trigger Description
        • Trigger Function Name
        • Trigger Points
        • Trigger Definition Example
      • 2.8.2 Trigger Condition
        • And/Or Logic
        • Field Name
        • Operator
        • Compare to value
        • Trigger Sequence
      • 2.8.3 Trigger Functions
        • What is a Trigger Function?
        • Create a Trigger Function
        • Activate a Trigger Function
        • Exactly When Are Triggers Invoked?
        • The TRIG_OPER and TRIG_RETC Variables and TRIG_LIST Working List
        • What Codes Are Passed in TRIG_OPER to the Trigger?
        • How Many Entries Are Passed in the TRIG_LIST?
        • What Return Codes Are Used in TRIG_RETC and How Can They Be Set?
        • Triggers - A Classic Example
        • Examples of Trigger use
        • Triggers - Restrictions and Limitations
        • Triggers - Some Do's and Don'ts
  • 3. Files
    • 3.1 File Definition
      • 3.1.1 File Type
      • 3.1.2 File Name
      • 3.1.3 File Identifier
      • 3.1.4 File Library
      • 3.1.5 File Description
    • 3.2 Real Fields in File
      • 3.2.1 Field Name
      • 3.2.2 Field Sequence
      • 3.2.3 Field Key Position
      • 3.2.4 Virtual Field Flag
    • 3.3 Virtual Fields in File
      • 3.3.1 Virtual Field Definition
        • Virtual Field Name
        • Virtual Field Type
        • Virtual Field Sequence
        • Derive value when record is read
        • Populate real field when writing to file
      • 3.3.2 Date Conversion
        • Source Field
        • Source Format
        • Target Format
      • 3.3.3 Substring
        • Substring from Field
        • Start Position
      • 3.3.4 Concatenation
        • Concatenated Field Names
        • Concatenation Example
      • 3.3.5 Mathematical Calculations
        • Factor 1
        • Operator
        • Factor 2
        • Result
        • Mathematical Calculation Example
      • 3.3.6 Code Fragment
        • Code Fragment Virtual Field Derivation
        • Code Fragment Real Field Derivation
    • 3.4 Logical Views
      • 3.4.1 Logical View Definition
        • Logical View Name
        • Logical View Description
        • Unique Key
        • Access Path
        • Dynamic Select
        • Alt. Seq.
        • Record Format
        • CRTLF/CHGLF Parameters
      • 3.4.2 Logical View Keys
        • Key Field Name
        • Key Field Details
        • Numeric Ordering
        • Key Order
        • Key Position
      • 3.4.3 Select/Omit Criterion
        • Select/Omit
        • Select/Omit And/Or
        • Select/Omit Type
        • Select/Omit Field Name
        • S/O Operator
        • S/O Value
        • S/O Range
    • 3.5 Access Routes
      • 3.5.1 Access Route Definitions
        • Access Route Name
        • Access Route Description
        • Accessed File
        • Association Type
        • Association Rule
        • Documentation Only
        • Maximum Records
        • Keep Last
        • Default Action
        • Derivation
        • Key Fields/Values
        • Key Field Details
        • Target Field Details
        • Key Position
      • 3.5.2 Predetermined Join Field Definitions
        • PJF Field
        • PJF Field Details
        • PJF Type
        • PJF Source Field
    • 3.6 File Attributes
      • 3.6.1 File Library
      • 3.6.2 Record Format Name
      • 3.6.3 I/O Module Library
      • 3.6.4 File Uses SQL On IBM i
      • 3.6.5 Alternate Collating Table (ALTSEQ)
      • 3.6.6 Enable Files for RDMLX
      • 3.6.7 Share
      • 3.6.8 Secure
      • 3.6.9 Strip Debug
      • 3.6.10 Suppress IOM0034 Message
      • 3.6.11 Ignore Decimal Errors
      • 3.6.12 IOM Required
      • 3.6.13 Create Batch Control
      • 3.6.14 IBM i High Speed Table
      • 3.6.15 Auto RRN Creation
      • 3.6.16 Create RRNO Column
      • 3.6.17 Convert Special Characters in Field Names
      • 3.6.18 Commitment Control
      • 3.6.19 Auto Commit
      • 3.6.20 CRTPF and CHGPF Parameter
      • 3.6.21 Readonly Access
      • 3.6.22 Database File Trigger
      • 3.6.23 File Description
    • 3.7 The @@UPID Field in LANSA Created Files
    • 3.8 Batch Control
      • 3.8.1 Batch Control Definition
        • Batch Control File Name
        • Batch Control Description
        • Batch Control Key Field
        • Batch Control Key Sequence
        • Batch Control Source Field
        • Batch Control Target Field
        • Batch Control Field Details
    • 3.9 Virtual Derivation
      • 3.9.1 I/O Module Section
      • 3.9.2 Virtual Code
    • 3.10 File Rules and Triggers
    • 3.11 File Compile Options
      • 3.11.1 Compile only if necessary
      • 3.11.2 Rebuild table
      • 3.11.3 Rebuild indexes and views
      • 3.11.4 Rebuild OAMs
      • 3.11.5 Strip debug information
      • 3.11.6 Keep generated source
      • 3.11.7 Keep saved data (DAT file)
      • 3.11.8 Drop existing tables/indexes
      • 3.11.9 Save table data
      • 3.11.10 Reload table data
    • 3.12 Load Other File
      • 3.12.1 Loading IBM i Files
      • 3.12.2 Loading Files From Other Data Sources
      • 3.12.3 IBM i Load Options
      • 3.12.4 Other Data Sources Load Options
  • 4. Components
    • 4.1 Component Concepts
    • 4.2 Component Definition
      • 4.2.1 Component Name
      • 4.2.2 Component Identifier
      • 4.2.3 Component Description
      • 4.2.4 Enable Components for RDMLX
      • 4.2.5 Framework
      • 4.2.6 Group
      • 4.2.7 Open In Editor
      • 4.2.8 Close
      • 4.2.9 Layout Weblet
    • 4.3 Component Types
      • 4.3.1 Form
      • 4.3.2 Reusable Part
      • 4.3.3 WAM
      • 4.3.4 Visual Style
      • 4.3.5 Icon
      • 4.3.6 Bitmap
      • 4.3.7 Cursor
      • 4.3.8 ActiveX
      • 4.3.9 .NET Components
    • 4.4 Component Help Text
    • 4.5 Component Compile Options
      • 4.5.1 Compile Component only if necessary
      • 4.5.2 Keep Generated Source
      • 4.5.3 Debug Enabled
      • 4.5.4 Web Application Module Options
        • Generate XSL
        • Technology Services
    • 4.6 Technology Services
      • 4.6.1 Technology Service Name
      • 4.6.2 Technology Service Provider Name
      • 4.6.3 Technology Service Caption
      • 4.6.4 Technology Service Description
      • 4.6.5 Technology Service Properties
        • MIME Type
        • Document Extension
        • Edit Numeric
        • Designable in Editor
        • Maximum Footprint
        • Device Skin Image
        • Script Location
        • Style Location
  • 5. Weblets
    • 5.1 Weblet Name
    • 5.2 Weblet Description
    • 5.3 Weblet Group
    • 5.4 Layout Weblet
    • 5.5 Webroutine Service Name
  • 6. Processes and Functions
    • 6.1 Process Definition
      • 6.1.1 Process Name
      • 6.1.2 Process Identifier
      • 6.1.3 Process Description
      • 6.1.4 Menu Style
      • 6.1.5 Anticipated Usage
      • 6.1.6 Optimize for remote communications
      • 6.1.7 Enable for Web
      • 6.1.8 Generate XML
    • 6.2 Function Control Table
      • 6.2.1 Function Description
      • 6.2.2 Display on Menu
      • 6.2.3 Menu Sequence
      • 6.2.4 Next Function
      • 6.2.5 Allowable Next Function(s)
    • 6.3 Special Entries
      • 6.3.1 Description
      • 6.3.2 Sequence
      • 6.3.3 Runtime Prompt
      • 6.3.4 Command
    • 6.4 Attached Processes/Functions
      • 6.4.1 Process Name
      • 6.4.2 Function Name
      • 6.4.3 Sequence
      • 6.4.4 Process Parameters
    • 6.5 Action Bar Table
      • 6.5.1 Action Bar Item Description
      • 6.5.2 AB$OPT
      • 6.5.3 Action Bar Item Sequence
      • 6.5.4 Pull Down Item Description
      • 6.5.5 Accelerator Key
      • 6.5.6 PD$OPT
      • 6.5.7 Pull Down Item Sequence
      • 6.5.8 Initially Enabled
      • 6.5.9 Association Type
        • Function Name
        • Attachment
        • Special Entry
        • Undefined
    • 6.6 Process Help Text
    • 6.7 Function Definition
      • 6.7.1 Function Name
      • 6.7.2 Function Identifier
      • 6.7.3 Function Description
      • 6.7.4 Template
      • 6.7.5 Enable Functions for RDMLX
    • 6.8 Function Help Text
    • 6.9 Process/Function Compile Options
      • 6.9.1 Compile Process only if necessary
      • 6.9.2 Compile All Process Functions
      • 6.9.3 Compile Functions Only if Necessary
      • 6.9.4 Keep Generated Source
      • 6.9.5 Debug Enabled
      • 6.9.6 Generate HTML
        • Validate Numeric Values
      • 6.9.7 Generate XML
      • 6.9.8 Use Default Settings
  • 7. RDML Commands
    • 7.1 ABORT
      • 7.1.1 ABORT Parameters
      • 7.1.2 ABORT Examples
    • 7.2 ADD_ENTRY
      • 7.2.1 ADD_ENTRY Parameters
      • 7.2.2 ADD_ENTRY Comments / Warnings
      • 7.2.3 ADD_ENTRY Examples
    • 7.3 BEGIN_LOOP
      • 7.3.1 BEGIN_LOOP Parameters
      • 7.3.2 BEGIN_LOOP Examples
    • 7.4 BEGINCHECK
      • 7.4.1 BEGINCHECK Parameters
      • 7.4.2 BEGINCHECK Examples
    • 7.5 BROWSE
      • 7.5.1 BROWSE Parameters
      • 7.5.2 BROWSE Examples
    • 7.6 CALL
      • 7.6.1 CALL Parameters
      • 7.6.2 CALL Comments / Warnings
      • 7.6.3 CALL Examples
    • 7.7 CALLCHECK
      • 7.7.1 CALLCHECK Parameters
      • 7.7.2 CALLCHECK Comments / Warnings
      • 7.7.3 CALLCHECK Examples
    • 7.8 CASE
      • 7.8.1 CASE Parameters
      • 7.8.2 CASE Comments / Warnings
      • 7.8.3 CASE Examples
    • 7.9 CHANGE
      • 7.9.1 CHANGE Parameters
      • 7.9.2 CHANGE Comments/Warnings
      • 7.9.3 CHANGE Examples
    • 7.10 CHECK_FOR
      • 7.10.1 CHECK_FOR Parameters
      • 7.10.2 CHECK_FOR Comments / Warnings
      • 7.10.3 CHECK_FOR Examples
    • 7.11 CLOSE
      • 7.11.1 CLOSE Parameters
      • 7.11.2 CLOSE Comments / Warnings
      • 7.11.3 CLOSE Examples
    • 7.12 CLR_LIST
      • 7.12.1 CLR_LIST Parameters
      • 7.12.2 CLR_LIST Example
    • 7.13 COMMIT
      • 7.13.1 COMMIT Parameters
      • 7.13.2 COMMIT Example
    • 7.14 CONDCHECK
      • 7.14.1 CONDCHECK Parameters
      • 7.14.2 CONDCHECK Comments / Warnings
      • 7.14.3 CONDCHECK Examples
    • 7.15 CONTINUE
      • 7.15.1 CONTINUE Parameters
      • 7.15.2 CONTINUE Comments / Warnings
      • 7.15.3 CONTINUE Examples
    • 7.16 DATECHECK
      • 7.16.1 DATECHECK Parameters
      • 7.16.2 DATECHECK Comments / Warnings
      • 7.16.3 DATECHECK Examples
    • 7.17 DEF_ARRAY
      • 7.17.1 DEF_ARRAY Parameters
      • 7.17.2 DEF_ARRAY Comments / Warnings
      • 7.17.3 DEF_ARRAY Examples
    • 7.18 DEF_BREAK
      • 7.18.1 DEF_BREAK Parameters
      • 7.18.2 DEF_BREAK Comments / Warnings
      • 7.18.3 DEF_BREAK Example
    • 7.19 DEF_COND
      • 7.19.1 DEF_COND Parameters
      • 7.19.2 DEF_COND Examples
    • 7.20 DEF_FOOT
      • 7.20.1 DEF_FOOT Parameters
      • 7.20.2 DEF_FOOT Comments / Warnings
      • 7.20.3 DEF_FOOT Examples
    • 7.21 DEF_HEAD
      • 7.21.1 DEF_HEAD Parameters
      • 7.21.2 DEF_HEAD Comments / Warnings
      • 7.21.3 DEF_HEAD Examples
    • 7.22 DEF_LINE
      • 7.22.1 DEF_LINE Parameters
      • 7.22.2 DEF_LINE Comments / Warnings
      • 7.22.3 DEF_LINE Examples
    • 7.23 DEF_LIST
      • 7.23.1 DEF_LIST Parameters
      • 7.23.2 DEF_LIST Description
      • 7.23.3 DEF_LIST Comments / Warnings
      • 7.23.4 DEF_LIST Examples
    • 7.24 DEF_REPORT
      • 7.24.1 DEF_REPORT Parameters
      • 7.24.2 DEF_REPORT Comments / Warnings
      • 7.24.3 DEF_REPORT Examples
    • 7.25 DEFINE
      • 7.25.1 DEFINE Parameters
      • 7.25.2 DEFINE Examples
    • 7.26 DELETE
      • 7.26.1 DELETE Parameters
      • 7.26.2 DELETE Comments / Warnings
      • 7.26.3 DELETE Examples
    • 7.27 DISPLAY
      • 7.27.1 DISPLAY Parameters
      • 7.27.2 DISPLAY Comments / Warnings
      • 7.27.3 DISPLAY Examples
    • 7.28 DLT_ENTRY
      • 7.28.1 DLT_ENTRY Parameters
      • 7.28.2 DLT_ENTRY Comments / Warnings
      • 7.28.3 DLT_ENTRY Examples
    • 7.29 DLT_LIST
      • 7.29.1 DLT_LIST Parameters
      • 7.29.2 DLT_LIST Examples
    • 7.30 DOUNTIL
      • 7.30.1 DOUNTIL Parameters
      • 7.30.2 DOUNTIL Examples
    • 7.31 DOWHILE
      • 7.31.1 DOWHILE Parameters
      • 7.31.2 DOWHILE Examples
    • 7.32 ELSE
      • 7.32.1 ELSE Parameters
      • 7.32.2 ELSE Examples
    • 7.33 END_LOOP
      • 7.33.1 END_LOOP Parameters
      • 7.33.2 END_LOOP Examples
    • 7.34 ENDCASE
      • 7.34.1 ENDCASE Parameters
      • 7.34.2 ENDCASE Examples
    • 7.35 ENDCHECK
      • 7.35.1 ENDCHECK Parameters
      • 7.35.2 ENDCHECK Comments / Warnings
      • 7.35.3 ENDCHECK Examples
    • 7.36 ENDIF
      • 7.36.1 ENDIF Parameters
      • 7.36.2 ENDIF Examples
    • 7.37 ENDPRINT
      • 7.37.1 ENDPRINT Parameters
      • 7.37.2 ENDPRINT Examples
    • 7.38 ENDROUTINE
      • 7.38.1 ENDROUTINE Parameters
      • 7.38.2 ENDROUTINE Examples
    • 7.39 ENDSELECT
      • 7.39.1 ENDSELECT Parameters
      • 7.39.2 ENDSELECT Examples
    • 7.40 ENDUNTIL
      • 7.40.1 ENDUNTIL Parameters
      • 7.40.2 ENDUNTIL Examples
    • 7.41 ENDWHILE
      • 7.41.1 ENDWHILE Parameters
      • 7.41.2 ENDWHILE Examples
    • 7.42 EXCHANGE
      • 7.42.1 EXCHANGE Parameters
      • 7.42.2 EXCHANGE Comments / Warnings
      • 7.42.3 EXCHANGE Accessing the Exchange List from RPG/COBOL
      • 7.42.4 EXCHANGE Examples
    • 7.43 EXEC_CPF
    • 7.44 EXEC_OS400
      • 7.44.1 EXEC_OS400 Parameters
      • 7.44.2 EXEC_OS400 Comments / Warnings
      • 7.44.3 EXEC_OS400 Example
    • 7.45 EXECUTE
      • 7.45.1 EXECUTE Parameters
      • 7.45.2 EXECUTE Examples
    • 7.46 EXIT
      • 7.46.1 EXIT Parameters
      • 7.46.2 EXIT Examples
    • 7.47 FETCH
      • 7.47.1 FETCH Parameters
      • 7.47.2 FETCH Examples
    • 7.48 FILECHECK
      • 7.48.1 FILECHECK Parameters
      • 7.48.2 FILECHECK Comments / Warnings
      • 7.48.3 FILECHECK Examples
    • 7.49 FUNCTION
      • 7.49.1 FUNCTION Parameters
      • 7.49.2 FUNCTION Examples
    • 7.50 GET_ENTRY
      • 7.50.1 GET_ENTRY Parameters
      • 7.50.2 GET_ENTRY Examples
    • 7.51 GOTO
      • 7.51.1 GOTO Parameters
      • 7.51.2 GOTO Examples
    • 7.52 GROUP_BY
      • 7.52.1 GROUP_BY Parameters
      • 7.52.2 GROUP_BY Comments / Warnings
      • 7.52.3 GROUP_BY Examples
      • 7.52.4 GROUP_BY Examples of Expandable Groups
    • 7.53 IF
      • 7.53.1 IF Parameters
      • 7.53.2 IF Examples
    • 7.54 IF_ERROR
      • 7.54.1 IF_ERROR Parameters
      • 7.54.2 IF_ERROR Examples
    • 7.55 IF_KEY
      • 7.55.1 IF_KEY Parameters
      • 7.55.2 IF_KEY Comments / Warnings
      • 7.55.3 IF_KEY Examples
    • 7.56 IF_MODE
      • 7.56.1 IF_MODE Parameters
      • 7.56.2 IF_MODE Examples
    • 7.57 IF_NULL
      • 7.57.1 IF_NULL Parameters
      • 7.57.2 IF_NULL Comments / Warnings
      • 7.57.3 IF_NULL Examples
    • 7.58 IF_STATUS
      • 7.58.1 IF_STATUS Parameters
      • 7.58.2 IF_STATUS Comments / Warnings
      • 7.58.3 IF_STATUS Examples
    • 7.59 INCLUDE
      • 7.59.1 INCLUDE Parameters
      • 7.59.2 INCLUDE Comments / Warnings
      • 7.59.3 INCLUDE Examples
    • 7.60 INSERT
      • 7.60.1 INSERT Parameters
      • 7.60.2 INSERT Comments / Warnings
      • 7.60.3 INSERT Examples
    • 7.61 INZ_LIST
      • 7.61.1 INZ_LIST Parameters
      • 7.61.2 INZ_LIST Comments / Warnings
      • 7.61.3 INZ_LIST Examples
    • 7.62 KEEP_AVG
      • 7.62.1 KEEP_AVG Parameters
      • 7.62.2 KEEP_AVG Comments / Warnings
      • 7.62.3 KEEP_AVG Examples
    • 7.63 KEEP_COUNT
      • 7.63.1 KEEP_COUNT Parameters
      • 7.63.2 KEEP_COUNT Comments / Warnings
      • 7.63.3 KEEP_COUNT Example
    • 7.64 KEEP_MAX
      • 7.64.1 KEEP_MAX Parameters
      • 7.64.2 KEEP_MAX Comments / Warnings
      • 7.64.3 KEEP_MAX Example
    • 7.65 KEEP_MIN
      • 7.65.1 KEEP_MIN Parameters
      • 7.65.2 KEEP_MIN Comments / Warnings
      • 7.65.3 KEEP_MIN Example
    • 7.66 KEEP_TOTAL
      • 7.66.1 KEEP_TOTAL Parameters
      • 7.66.2 KEEP_TOTAL Comments / Warnings
      • 7.66.3 KEEP_TOTAL Examples
    • 7.67 LEAVE
      • 7.67.1 LEAVE Parameters
      • 7.67.2 LEAVE Comments / Warnings
      • 7.67.3 LEAVE Examples
    • 7.68 LOC_ENTRY
      • 7.68.1 LOC_ENTRY Parameters
      • 7.68.2 LOC_ENTRY Examples
    • 7.69 MENU
      • 7.69.1 MENU Parameters
      • 7.69.2 MENU Examples
    • 7.70 MESSAGE
      • 7.70.1 MESSAGE Parameters
      • 7.70.2 MESSAGE Comments / Warnings
      • 7.70.3 MESSAGE Examples
    • 7.71 ON_ERROR
      • 7.71.1 ON_ERROR Parameters
      • 7.71.2 ON_ERROR Comments / Warnings
      • 7.71.3 ON_ERROR Examples
    • 7.72 OPEN
      • 7.72.1 OPEN Parameters
      • 7.72.2 OPEN Comments / Warnings
      • 7.72.3 OPEN Examples
    • 7.73 OTHERWISE
      • 7.73.1 OTHERWISE Parameters
      • 7.73.2 OTHERWISE Examples
    • 7.74 OVERRIDE
      • 7.74.1 OVERRIDE Parameters
      • 7.74.2 OVERRIDE Examples
    • 7.75 POINT
      • 7.75.1 POINT Parameters
      • 7.75.2 POINT Comments/Warnings
      • 7.75.3 POINT Examples
    • 7.76 POP_UP
      • 7.76.1 POP_UP Parameters
      • 7.76.2 POP_UP Comments / Warnings
      • 7.76.3 POP_UP Examples
    • 7.77 PRINT
      • 7.77.1 PRINT Parameters
      • 7.77.2 PRINT Examples
    • 7.78 RANGECHECK
      • 7.78.1 RANGECHECK Parameters
      • 7.78.2 RANGECHECK Examples
    • 7.79 RENAME
      • 7.79.1 RENAME Parameters
      • 7.79.2 RENAME Comments / Warnings
      • 7.79.3 RENAME Examples
    • 7.80 REQUEST
      • 7.80.1 REQUEST Parameters
      • 7.80.2 REQUEST Comments / Warnings
      • 7.80.3 REQUEST Examples
    • 7.81 RETURN
      • 7.81.1 RETURN Parameters
      • 7.81.2 RETURN Examples
    • 7.82 ROLLBACK
      • 7.82.1 ROLLBACK Parameters
      • 7.82.2 ROLLBACK Examples
    • 7.83 SELECT
      • 7.83.1 SELECT Parameters
      • 7.83.2 SELECT Comments / Warnings
      • 7.83.3 SELECT Examples
    • 7.84 SELECTLIST
      • 7.84.1 SELECTLIST Parameters
      • 7.84.2 SELECTLIST Examples
    • 7.85 SELECT_SQL
      • 7.85.1 SELECT_SQL Parameters
      • 7.85.2 SELECT_SQL Column Names versus Column Values
      • 7.85.3 SELECT_SQL Examples
      • 7.85.4 SELECT_SQL References
      • 7.85.5 SELECT_SQL Coercions
    • 7.86 SET_ERROR
      • 7.86.1 SET_ERROR Parameters
      • 7.86.2 SET_ERROR Examples
    • 7.87 SET_MODE
      • 7.87.1 SET_MODE Parameters
      • 7.87.2 SET_MODE Examples
    • 7.88 SKIP
      • 7.88.1 SKIP Parameters
      • 7.88.2 SKIP Examples
    • 7.89 SORT_LIST
      • 7.89.1 SORT_LIST Parameters
      • 7.89.2 SORT_LIST Examples
    • 7.90 SPACE
      • 7.90.1 SPACE Parameters
      • 7.90.2 SPACE Examples
    • 7.91 SUBMIT
      • 7.91.1 SUBMIT Parameters
      • 7.91.2 SUBMIT Comments / Warnings
      • 7.91.3 SUBMIT Examples
    • 7.92 SUBROUTINE
      • 7.92.1 SUBROUTINE Parameters
      • 7.92.2 SUBROUTINE Comments / Warnings
      • 7.92.3 SUBROUTINE Examples - Part 1
      • 7.92.4 SUBROUTINE Examples - Part 2
    • 7.93 SUBSTRING
      • 7.93.1 SUBSTRING Parameters
      • 7.93.2 SUBSTRING Examples
    • 7.94 TRANSFER
      • 7.94.1 TRANSFER Parameters
      • 7.94.2 TRANSFER Comments / Warnings
      • 7.94.3 TRANSFER Examples
    • 7.95 UPD_ENTRY
      • 7.95.1 UPD_ENTRY Parameters
      • 7.95.2 UPD_ENTRY Comments / Warnings
      • 7.95.3 UPD_ENTRY Examples
    • 7.96 UPDATE
      • 7.96.1 UPDATE Parameters
      • 7.96.2 UPDATE Comments / Warnings
      • 7.96.3 UPDATE Examples
    • 7.97 UPRINT
      • 7.97.1 UPRINT Parameters
      • 7.97.2 UPRINT Examples
    • 7.98 USE
      • 7.98.1 USE Parameters
      • 7.98.2 USE Examples
    • 7.99 VALUECHECK
      • 7.99.1 VALUECHECK Parameters
      • 7.99.2 VALUECHECK Examples
    • 7.100 WHEN
      • 7.100.1 WHEN Parameters
      • 7.100.2 WHEN Examples
  • 8. RDMLX Commands and RDMLX Features
    • 8.1 ASSIGN
      • 8.1.1 ASSIGN Parameters
      • 8.1.2 ASSIGN Examples
    • 8.2 ATTRIBUTE
      • 8.2.1 ATTRIBUTE Parameters
      • 8.2.2 ATTRIBUTE Examples
    • 8.3 BEGIN_COM
      • 8.3.1 BEGIN_COM Parameters
      • 8.3.2 BEGIN_COM Examples
    • 8.4 DEFINE_COM
      • 8.4.1 DEFINE_COM Parameters
      • 8.4.2 DEFINE_COM Examples
    • 8.5 DEFINE_EVT
      • 8.5.1 DEFINE_EVT Parameters
      • 8.5.2 DEFINE_EVT Examples
    • 8.6 DEFINE_MAP
      • 8.6.1 DEFINE_MAP Parameters
      • 8.6.2 DEFINE_MAP with DEFINE_EVT
      • 8.6.3 DEFINE_MAP in MTHROUTINE
      • 8.6.4 DEFINE_MAP in PTYROUTINE
    • 8.7 DEFINE_PTY
      • 8.7.1 DEFINE_PTY Parameters
      • 8.7.2 DEFINE_PTY Examples
    • 8.8 END_COM
      • 8.8.1 END_COM Parameters
      • 8.8.2 END_COM Examples
    • 8.9 ENDFOR
      • 8.9.1 ENDFOR Parameters
      • 8.9.2 ENDFOR Examples
    • 8.10 ENDROUTINE
      • 8.10.1 ENDROUTINE Parameters
      • 8.10.2 ENDROUTINE Examples
    • 8.11 EVTROUTINE
      • 8.11.1 EVTROUTINE Parameters
      • 8.11.2 EVTROUTINE Examples
    • 8.12 FOR
      • 8.12.1 FOR Parameters
      • 8.12.2 FOR Examples
    • 8.13 IF_REF
      • 8.13.1 IF_REF Parameters
      • 8.13.2 IF_REF Examples
    • 8.14 IMPORT
      • 8.14.1 IMPORT Parameters
      • 8.14.2 IMPORT Examples
    • 8.15 INVOKE
      • 8.15.1 INVOKE Parameters
      • 8.15.2 INVOKE Examples
    • 8.16 MTHROUTINE
      • 8.16.1 MTHROUTINE Parameters
      • 8.16.2 MTHROUTINE Examples
    • 8.17 PERFORM
      • 8.17.1 PERFORM Parameters
      • 8.17.2 PERFORM Examples
    • 8.18 PTYROUTINE
      • 8.18.1 PTYROUTINE Parameters
      • 8.18.2 PTYROUTINE Examples
    • 8.19 SELECT_SQL Free Format
      • 8.19.1 SELECT_SQL Free Format Parameters
      • 8.19.2 SELECT_SQL Free Format Examples
      • 8.19.3 SELECT_SQL Free Format References
      • 8.19.4 SELECT_SQL Free Format Coercions
    • 8.20 SET
      • 8.20.1 SET Parameters
      • 8.20.2 SET Examples
    • 8.21 SET_REF
      • 8.21.1 SET_REF Parameters
      • 8.21.2 SET_REF Examples
    • 8.22 SIGNAL
      • 8.22.1 SIGNAL Parameters
      • 8.22.2 SIGNAL Examples
    • 8.23 WEB_MAP
      • 8.23.1 WEB_MAP Parameters
      • 8.23.2 WEB_MAP Examples
    • 8.24 WEBROUTINE
      • 8.24.1 WEBROUTINE Parameters
      • 8.24.2 WEBROUTINE Examples
    • 8.25 Component Variables and Values
      • 8.25.1 Referring to Property Values
      • 8.25.2 Com_Owner, Com_Ancestor and Com_Self - Generic References to Components
      • 8.25.3 Variant Variable
      • 8.25.4 Qualified Properties
    • 8.26 Function Libraries
    • 8.27 Variant Handling
      • 8.27.1 VarAsBoolean
      • 8.27.2 VarAsDecimal
      • 8.27.3 VarAsInteger
      • 8.27.4 VarAsReference
      • 8.27.5 VarAsString
      • 8.27.6 VarIsBoolean
      • 8.27.7 VarIsEmpty
      • 8.27.8 VarIsNull
      • 8.27.9 VarIsNullReference
      • 8.27.10 VarIsNumber
      • 8.27.11 VarIsReference
      • 8.27.12 VarIsString
      • 8.27.13 VarType
    • 8.28 Enhanced Expressions
      • 8.28.1 Expressions as Values
      • 8.28.2 Methods in Expressions
      • 8.28.3 Method Results
      • 8.28.4 Named Parameters
      • 8.28.5 *Not Operator
      • 8.28.6 *IS and *ISNOT Operator
      • 8.28.7 *IsEqualTo and *IsOfType Operators
      • 8.28.8 *AS Operator
      • 8.28.9 *ANDIF and *ORIF Logical Operators
  • 9. Built-In Functions
    • 9.1 Built-In Function Rules
    • 9.2 Development Environment only Built-In Functions
    • 9.3 ACCESS_FILE
    • 9.4 ACCESS_RTE
    • 9.5 ACCESS_RTE_KEY
    • 9.6 ADD_DD_VALUES
    • 9.7 ALLOW_EXTRA_USER_KEY
    • 9.8 BCONCAT
    • 9.9 BINTOHEX
    • 9.10 BUILD_WORK_OPTIONS
    • 9.11 CALL_SERVER_FUNCTION
    • 9.12 CENTRE
    • 9.13 CHANGE_IBMI_SIGNON
    • 9.14 CHECK_AUTHORITY
    • 9.15 CHECK_IBMI_SIGNON
    • 9.16 CHECKNUMERIC
    • 9.17 CHECKSTRING
    • 9.18 CLR_MESSAGES
    • 9.19 COMPARE_FILE_DEF
    • 9.20 COMPILE_PROCESS
    • 9.21 COMPILE_COMPONENT
    • 9.22 COMPOSER_CALLF
    • 9.23 COMPOSER_RUN
    • 9.24 COMPOSER_USE
    • 9.25 CONCAT
    • 9.26 CONNECT_FILE
    • 9.27 CONNECT_SERVER
    • 9.28 CONVERTDATE
    • 9.29 CONVERTDATE_NUMERIC
    • 9.30 CONVERT_STRING
    • 9.31 CREATE_SPACE
    • 9.32 CREATE_PROMPT_FILE
    • 9.33 DATEDIFFERENCE
    • 9.34 DATEDIFFERENCE_ALPHA
    • 9.35 DECRYPT
    • 9.36 DEFINE_ANY_SERVER
    • 9.37 DEFINE_DB_SERVER
    • 9.38 DEFINE_OVERRIDE_FILE
    • 9.39 DEFINE_OS_400_SERVER
    • 9.40 DEFINE_OTHER_SERVER
    • 9.41 DEFINE_SPACE_CELL
    • 9.42 DELETE_CHECKS
    • 9.43 DELETE_FUNCTION
    • 9.44 DELETE_IN_SPACE
    • 9.45 DELETE_PROCESS
    • 9.46 DELETE_SAVED_LIST
    • 9.47 DELETE_TRIGGERS
    • 9.48 DELETE_WEB_COMPONENT
    • 9.49 DESTROY_SPACE
    • 9.50 DISCONNECT_FILE
    • 9.51 DISCONNECT_SERVER
    • 9.52 DLL
    • 9.53 DLT_FIELD
    • 9.54 DLT_FILE
    • 9.55 DLT_PROCESS_ATTACH
    • 9.56 DOM_ADD_FIELD
    • 9.57 DOM_ADD_ITEM
    • 9.58 DOM_CLOSE_DATABASE
    • 9.59 DOM_CLOSE_DOCUMENT
    • 9.60 DOM_CLOSE_FILE
    • 9.61 DOM_CREATE_DOCUMENT
    • 9.62 DOM_DELETE_DOCUMENT
    • 9.63 DOM_DELETE_FIELD
    • 9.64 DOM_DELETE_ITEM
    • 9.65 DOM_END_SEARCH_DOCS
    • 9.66 DOM_EXECUTE_AGENT
    • 9.67 DOM_GET_FIELD
    • 9.68 DOM_GET_ITEM
    • 9.69 DOM_GET_NXT_DOCUMENT
    • 9.70 DOM_OPEN_DATABASE
    • 9.71 DOM_OPEN_DOCUMENT
    • 9.72 DOM_OPEN_FILE
    • 9.73 DOM_SEARCH_DOCUMENTS
    • 9.74 DOM_UPDATE_DOCUMENT
    • 9.75 DOM_UPDATE_FIELD
    • 9.76 DOM_UPDATE_ITEM
    • 9.77 DROP_DD_VALUES
    • 9.78 DROP_EXTRA_USER_KEYS
    • 9.79 ENCRYPT
    • 9.80 END_FILE_EDIT
    • 9.81 END_FUNCTION_EDIT
    • 9.82 END_PROCESS_EDIT
    • 9.83 END_RTV_SPLF_LIST
    • 9.84 EXCHANGE_ALPHA_VAR
    • 9.85 EXCHANGE_NUMERIC_VAR
    • 9.86 EXCHANGE_VARIABLE
    • 9.87 EXECUTE_TEMPLATE
    • 9.88 EXPONENTIAL
    • 9.89 EXPORT_OBJECTS
    • 9.90 FETCH_IN_SPACE
    • 9.91 FILE_FIELD
    • 9.92 FILE_FIELD_VIRTUAL
    • 9.93 FILLSTRING
    • 9.94 FINDDATE
    • 9.95 FINDDATE_ALPHA
    • 9.96 FORMAT_STRING
    • 9.97 GET_AUTHORITIES
    • 9.98 GET_BIF_LIST
    • 9.99 GET_CHAR_AREA
    • 9.100 GET_COMPONENT_LIST
    • 9.101 GET_COMPOSITION
    • 9.102 GET_ENVIRONMENTS
    • 9.103 GET_FIELD
    • 9.104 GET_FIELD_INFO
    • 9.105 GET_FIELD_LIST
    • 9.106 GET_FILE_INFO
    • 9.107 GET_FUNCTION_ATTR
    • 9.108 GET_FUNCTION_INFO
    • 9.109 GET_FUNCTION_LIST
    • 9.110 GET_FUNCTION_RDML
    • 9.111 GET_HELP
    • 9.112 GET_ILENTRY_LIST
    • 9.113 GET_KEYWORD_STRING
    • 9.114 GET_LICENSE_STATUS
    • 9.115 GET_LOGICAL_LIST
    • 9.116 GET_MESSAGE
    • 9.117 GET_MESSAGE_DESC
    • 9.118 GET_MESSAGE_LIST
    • 9.119 GET_ML_VARIABLE
    • 9.120 GET_MULTVAR_LIST
    • 9.121 GET_NUM_AREA
    • 9.122 GET_PHYSICAL_LIST
    • 9.123 GET_PROCESS_ATTR
    • 9.124 GET_PROCESS_INFO
    • 9.125 GET_PROCESS_LIST
    • 9.126 GET_PRODUCT_ATTRIBS
    • 9.127 GET_PROPERTIES
    • 9.128 GET_REGISTRY_VALUE
    • 9.129 GET_SESSION_VALUE
    • 9.130 GET_SPLF_LIST_ENTRY
    • 9.131 GET_SYSTEM_VARIABLE
    • 9.132 GET_SYSVAR_LIST
    • 9.133 GET_TASK_DETAILS
    • 9.134 GET_TASK_LIST
    • 9.135 GET_TEMPLATE_LIST
    • 9.136 GET_WEB_COMPONENT
    • 9.137 HEXTOBIN
    • 9.138 IMPORT_OBJECTS
    • 9.139 INSERT_IN_SPACE
    • 9.140 ISSUEINQUIRY
    • 9.141 ISSUEMESSAGE
    • 9.142 JSM_CLOSE
    • 9.143 JSM_COMMAND
    • 9.144 JSM_OPEN
    • 9.145 JSMX_CLOSE
    • 9.146 JSMX_COMMAND
    • 9.147 JSMX_OPEN
    • 9.148 LEFT
    • 9.149 LIST_PRINTERS
    • 9.150 LOAD_FILE_DATA
    • 9.151 LOAD_OTHER_FILE
    • 9.152 LOCK_OBJECT
    • 9.153 LOGICAL_KEY
    • 9.154 LOGICAL_VIEW
    • 9.155 MAIL_ADD_ATTACHMENT
    • 9.156 MAIL_ADD_ORIGINATOR
    • 9.157 MAIL_ADD_RECIPIENT
    • 9.158 MAIL_ADD_TEXT
    • 9.159 MAIL_SEND
    • 9.160 MAIL_SET_OPTION
    • 9.161 MAIL_SET_SUBJECT
    • 9.162 MAIL_START
    • 9.163 MAKE_FILE_OPERATIONL
    • 9.164 MAKE_SOUND
    • 9.165 MESSAGE_BOX_ADD
    • 9.166 MESSAGE_BOX_APPEND
    • 9.167 MESSAGE_BOX_CLEAR
    • 9.168 MESSAGE_BOX_SHOW
    • 9.169 MESSAGE_COLLECTOR
    • 9.170 NUMERIC_STRING
    • 9.171 OBJECT_PROPAGATE
    • 9.172 PACKAGE_BUILD
    • 9.173 PACKAGE_CREATE
    • 9.174 PHYSICAL_KEY
    • 9.175 PUT_CHAR_AREA
    • 9.176 PUT_COND_CHECK
    • 9.177 PUT_DATE_CHECK
    • 9.178 PUT_FIELD
    • 9.179 PUT_FIELD_ML
    • 9.180 PUT_FILE_CHECK
    • 9.181 PUT_FILE_ML
    • 9.182 PUT_FUNCTION_ATTR
    • 9.183 PUT_FUNCTION_ML
    • 9.184 PUT_FUNCTION_RDML
    • 9.185 PUT_HELP
    • 9.186 PUT_ML_VARIABLE
    • 9.187 PUT_NUM_AREA
    • 9.188 PUT_PROCESS_ACTIONS
    • 9.189 PUT_PROCESS_ATTACH
    • 9.190 PUT_PROCESS_ATTR
    • 9.191 PUT_PROCESS_ML
    • 9.192 PUT_PROGRAM_CHECK
    • 9.193 PUT_RANGE_CHECK
    • 9.194 PUT_REGISTRY_VALUE
    • 9.195 PUT_SYSTEM_VARIABLE
    • 9.196 PUT_TRIGGER
    • 9.197 PUT_VALUE_CHECK
    • 9.198 PUT_WEB_COMPONENT
    • 9.199 RANDOM_NUM_GENERATOR
    • 9.200 RCV_FROM_DATA_QUEUE
    • 9.201 REBUILD_FILE
    • 9.202 REBUILD_TABLE_INDEX
    • 9.203 RESET_@@UPID
    • 9.204 RESTORE_SAVED_LIST
    • 9.205 REVERSE
    • 9.206 RIGHT
    • 9.207 ROUND
    • 9.208 SAVE_LIST
    • 9.209 SCANSTRING
    • 9.210 SELECT_IN_SPACE
    • 9.211 SELECTNEXT_IN_SPACE
    • 9.212 SET_ACTION_BAR
    • 9.213 SET_AUTHORITY
    • 9.214 SET_DD_ATTRIBUTES
    • 9.215 SET_FILE_ATTRIBUTE
    • 9.216 SET_FOR_HEAVY_USAGE
    • 9.217 SET_FOR_LIGHT_USAGE
    • 9.218 SET_SESSION_VALUE
    • 9.219 SHOW_HELP
    • 9.220 SND_TO_DATA_QUEUE
    • 9.221 SPACE_OPERATION
    • 9.222 SQUARE_ROOT
    • 9.223 START_FILE_EDIT
    • 9.224 START_FUNCTION_EDIT
    • 9.225 START_PROCESS_EDIT
    • 9.226 START_RTV_SPLF_LIST
    • 9.227 STM_FILE_CLOSE
    • 9.228 STM_FILE_OPEN
    • 9.229 STM_FILE_READ
    • 9.230 STM_FILE_WRITE
    • 9.231 STM_FILE_WRITE_CTL
    • 9.232 SYSTEM_COMMAND
    • 9.233 TCONCAT
    • 9.234 TEMPLATE_@@ADD_LST
    • 9.235 TEMPLATE_@@CANSNNN
    • 9.236 TEMPLATE_@@CLR_LST
    • 9.237 TEMPLATE_@@GET_FILS
    • 9.238 TEMPLATE_@@NANSNNN
    • 9.239 TEMPLATE_@@SET_FILS
    • 9.240 TEMPLATE_@@SET_IDX
    • 9.241 TRANSFORM_FILE
    • 9.242 TRANSFORM_LIST
      • 9.242.1 Output File Formats
        • dBASE III PLUS Field Format Supported
      • 9.242.2 Other Parameters
    • 9.243 UNLOAD_FILE_DATA
    • 9.244 UNLOCK_OBJECT
    • 9.245 UPDATE_IN_SPACE
    • 9.246 UPPERCASE
    • 9.247 ZIP_ADD
    • 9.248 ZIP_DELETE
    • 9.249 ZIP_EXTRACT
    • 9.250 ZIP_GET_INFO
    • 9.251 ZIP_MAKE_EXE
  • 10. Intrinsic Functions
    • 10.1 Understanding Intrinsic Functions
    • 10.2 Chaining Multiple Intrinsic Functions
    • 10.3 Isxxxxxx Intrinsic Functions
    • 10.4 Asxxxxxx Intrinsic Functions
    • 10.5 Field Intrinsic Functions
      • 10.5.1 FieldDecimals
      • 10.5.2 FieldLength
      • 10.5.3 FieldType
      • 10.5.4 IsDefault
      • 10.5.5 FieldAttributeAsString
    • 10.6 Alphanumeric/String Intrinsic Functions
      • 10.6.1 AsBoolean
      • 10.6.2 AsDate
      • 10.6.3 AsDateTime
      • 10.6.4 AsDBCSFixedChar
      • 10.6.5 AsDBCSString
      • 10.6.6 AsFixedChar
      • 10.6.7 AsFloat
      • 10.6.8 AsInteger
      • 10.6.9 AsNumber
      • 10.6.10 AsSBCSString
      • 10.6.11 AsTime
      • 10.6.12 AsValue
      • 10.6.13 BlankConcat
      • 10.6.14 ByteTypeAt
      • 10.6.15 Center and Centre
      • 10.6.16 CharTypeAt
      • 10.6.17 Concat
      • 10.6.18 Contains
      • 10.6.19 ContainsOnly
      • 10.6.20 CurChars
      • 10.6.21 CurEbcdicSize
      • 10.6.22 CurSize
      • 10.6.23 DeleteSubstring
      • 10.6.24 FieldDefault
      • 10.6.25 InsertString
      • 10.6.26 IsBoolean
      • 10.6.27 IsDate
      • 10.6.28 IsDateTime
      • 10.6.29 IsDbcs
      • 10.6.30 IsFloat
      • 10.6.31 IsMixed
      • 10.6.32 IsNull
      • 10.6.33 IsNumber
      • 10.6.34 IsSbcs
      • 10.6.35 IsSqlNull
      • 10.6.36 IsTime
      • 10.6.37 LastPositionIn
      • 10.6.38 LastPositionOf
      • 10.6.39 LeftMost
      • 10.6.40 LeftTrim
      • 10.6.41 LowerCase
      • 10.6.42 OccurencesIn
      • 10.6.43 OccurencesOf
      • 10.6.44 PositionIn
      • 10.6.45 PositionOf
      • 10.6.46 Remove
      • 10.6.47 RemoveAll
      • 10.6.48 RemoveCharacters
      • 10.6.49 Repeat
      • 10.6.50 Replace
      • 10.6.51 ReplaceAll
      • 10.6.52 ReplaceSubstring
      • 10.6.53 Reverse
      • 10.6.54 RightAdjust
      • 10.6.55 RightMost
      • 10.6.56 RightTrim
      • 10.6.57 Substitute
      • 10.6.58 Substring
      • 10.6.59 TranslateCharacters
      • 10.6.60 Trim
      • 10.6.61 TrimBlankConcat
      • 10.6.62 TrimConcat
      • 10.6.63 TrimSubstitute
      • 10.6.64 UpperCase
    • 10.7 Boolean Intrinsic Functions
      • 10.7.1 And
      • 10.7.2 AsNumber
      • 10.7.3 AsString
      • 10.7.4 AsValue
      • 10.7.5 IsFalse
      • 10.7.6 IsNull
      • 10.7.7 IsSqlNull
      • 10.7.8 IsTrue
      • 10.7.9 Not
      • 10.7.10 Or
    • 10.8 Date Intrinsic Functions
      • 10.8.1 Adjust
      • 10.8.2 AsDateTime
      • 10.8.3 AsDayofWeek
      • 10.8.4 AsDays
      • 10.8.5 AsDisplayString
      • 10.8.6 AsNumber
      • 10.8.7 AsString
      • 10.8.8 AsValue
      • 10.8.9 Day
      • 10.8.10 Difference
      • 10.8.11 IsNull
      • 10.8.12 IsSqlNull
      • 10.8.13 Month
      • 10.8.14 Now
      • 10.8.15 Year
    • 10.9 DateTime Intrinsic Functions
      • 10.9.1 AsDisplayString
      • 10.9.2 AsCustomDisplayString
      • 10.9.3 AsLocalizedDateTime
      • 10.9.4 AsNumber
      • 10.9.5 AsSeconds
      • 10.9.6 AsString
      • 10.9.7 AsUniversalDateTime
      • 10.9.8 AsValue
      • 10.9.9 Date
      • 10.9.10 FractionalSeconds
      • 10.9.11 IsNull
      • 10.9.12 IsSqlNull
      • 10.9.13 Now
      • 10.9.14 Time
    • 10.10 Time Intrinsic Functions
      • 10.10.1 Adjust
      • 10.10.2 AsDateTime
      • 10.10.3 AsDisplayString
      • 10.10.4 AsNumber
      • 10.10.5 AsSeconds
      • 10.10.6 AsString
      • 10.10.7 AsValue
      • 10.10.8 Difference
      • 10.10.9 Hour
      • 10.10.10 IsNull
      • 10.10.11 IsSqlNull
      • 10.10.12 Minute
      • 10.10.13 Now
      • 10.10.14 Second
    • 10.11 Large Object Intrinsic Functions
      • 10.11.1 AsValue
      • 10.11.2 Filename
      • 10.11.3 IsNull
      • 10.11.4 IsSqlNull
    • 10.12 Binary Intrinsic Functions
      • 10.12.1 AsByte
      • 10.12.2 AsInteger
      • 10.12.3 AsString
      • 10.12.4 CurSize
      • 10.12.5 IsNull
      • 10.12.6 IsSqlNull
      • 10.12.7 AsHexString
      • 10.12.8 AsHexToInt
    • 10.13 Decimal Intrinsic Functions
      • 10.13.1 AsValue
    • 10.14 Fixed Point Intrinsic Functions
      • 10.14.1 AsFloat
      • 10.14.2 AsString
      • 10.14.3 Bound
      • 10.14.4 IsBetween
      • 10.14.5 Max
      • 10.14.6 Min
      • 10.14.7 Pred
      • 10.14.8 Round
      • 10.14.9 Succ
    • 10.15 Floating Point Intrinsic Functions
      • 10.15.1 Add
      • 10.15.2 AsDecimal
      • 10.15.3 AsString
      • 10.15.4 AsValue
      • 10.15.5 Bound
      • 10.15.6 Divide
      • 10.15.7 IsBetween
      • 10.15.8 Max
      • 10.15.9 Min
      • 10.15.10 Multiply
      • 10.15.11 Pred
      • 10.15.12 Subtract
      • 10.15.13 Succ
      • 10.15.14 Sine
      • 10.15.15 ArcSine
      • 10.15.16 SineH
      • 10.15.17 Cosine
      • 10.15.18 ArcCosine
      • 10.15.19 CosineH
      • 10.15.20 Tangent
      • 10.15.21 ArcTangent
      • 10.15.22 TangentH
      • 10.15.23 ArcTangent2
      • 10.15.24 FAbs
      • 10.15.25 FMod
      • 10.15.26 Power
      • 10.15.27 SQRT
      • 10.15.28 Exponential
      • 10.15.29 Logarithm
      • 10.15.30 Logarithm10
      • 10.15.31 IsNANorND
    • 10.16 Integer Intrinsic Functions
      • 10.16.1 BinaryString Conversions
      • 10.16.2 AsBinString
      • 10.16.3 AsByte
      • 10.16.4 AsChar
      • 10.16.5 AsValue
      • 10.16.6 BitAnd
      • 10.16.7 BitNot
      • 10.16.8 BitOr
      • 10.16.9 BitXOr
      • 10.16.10 Mod
      • 10.16.11 Div
      • 10.16.12 AsUnicodeString
    • 10.17 Unicode String Functions
      • 10.17.1 AsCodePoint
      • 10.17.2 AsNativeString
  • 11. System and Multilingual Variables
    • 11.1 System Variable Definition
      • 11.1.1 Variable Name
      • 11.1.2 Description
      • 11.1.3 Derivation Method
      • 11.1.4 Data Type
      • 11.1.5 Length
      • 11.1.6 Decimals
      • 11.1.7 Program Type
      • 11.1.8 Program Name
    • 11.2 Shipped System Variables
      • 11.2.1 General Variables
        • *GUID System Variable
      • 11.2.2 Authenticating User System Variables
      • 11.2.3 Function Only Variables
      • 11.2.4 Special Variables
        • System Variables for use in System Evaluation Programs
        • System Variables to test I/O Status
      • 11.2.5 SuperServer System Variables
      • 11.2.6 Built-In Function Variables
    • 11.3 Multilingual Text Variables
      • 11.3.1 MTXT Variable Name
      • 11.3.2 Maximum Length
      • 11.3.3 Value
  • 12. Formats, Values and Codes
    • 12.1 LANSA Object Names
    • 12.2 Date Formats
    • 12.3 Standard Field Edit Codes
    • 12.4 RDML Field Attributes and their Use
      • 12.4.1 Output Only Attributes
      • 12.4.2 Field Conditioning Attributes
      • 12.4.3 Field Display Attributes
      • 12.4.4 Field Identification Attributes
      • 12.4.5 Field Position Attributes
      • 12.4.6 Hidden Field Attribute and the Select Field Attribute
      • 12.4.7 New Format Attribute and Repeat Attributes
      • 12.4.8 Print Control Attributes
    • 12.5 RDML I/O Return Codes
    • 12.6 Help Text Enhancement & Substitution Values
      • 12.6.1 Substitution/Control Values
      • 12.6.2 Substitution/Control Values - Visual LANSA only
      • 12.6.3 Help Text Attributes
  • 13. Common RDML Parameters & BIF Notes
    • 13.1 RDML Command Parameters
      • 13.1.1 I/O Commands
        • Specifying File Names in I/O Commands
        • Specifying File Key Lists in I/O Commands
        • Specifying WHERE Parameter in I/O Commands
        • I/O Command Return Codes Table
        • I/O Status Record Locked
      • 13.1.2 Field Groups and Expandable Groups
        • Expandable Groups
        • Special Considerations for Expandable Groups
        • Expandable Group Expressions
        • Expandable Group Examples
      • 13.1.3 RDML Screen Modes and Mode Sensitive Commands
        • Modes and Fields that Can Be Changed
        • Modes, Function Keys and Processing Logic
        • Mode Sensitive Commands
      • 13.1.4 Specifying Conditions and Expressions
      • 13.1.5 Arithmetic and Expression Operators
      • 13.1.6 Quotes and Quoted Strings
      • 13.1.7 Prompt_Key Processing
    • 13.2 Built-In Function Notes
      • 13.2.1 Database Connection
      • 13.2.2 Email Built-In Functions Notes
      • 13.2.3 Zip Built-in Functions
  • 14. Template Commands and Variables
    • 14.1 @@CLR_LST Command
    • 14.2 @@CMP_IDX Command
      • 14.2.1 @@CMP_IDX Examples
    • 14.3 @@COMMENT Command
    • 14.4 @@DEC_IDX Command
    • 14.5 @@GET_FILS Command
    • 14.6 @@GOTO Command
    • 14.7 @@IF Command
    • 14.8 @@INC_IDX Command
    • 14.9 @@LABEL Command
    • 14.10 @@MAK_LSTS Command
    • 14.11 @@MRG_LSTS Command
    • 14.12 @@QUESTION Command
    • 14.13 @@RTV_FLDS Command
    • 14.14 @@RTV_KEYS Command
    • 14.15 @@RTV_RELN Command
    • 14.16 @@SET_IDX Command
    • 14.17 General Template Variables
    • 14.18 Question and Answer Template Variables
    • 14.19 File Template Variables
    • 14.20 List Template Variables
    • 14.21 Template Error Messages
    • 14.22 Tips for Template Programming
      • 14.22.1 Accepting Errors On Commands
      • 14.22.2 Forcing EDTSRC/SEU to Update With Errors
      • 14.22.3 The Double Bracket Trap
      • 14.22.4 Testing with an Alternate Session
      • 14.22.5 Special Template Variable Notes
    • 14.23 Sample Application Templates
      • 14.23.1 Simple data entry program
      • 14.23.2 Header/Detail style inquiry program
  • 15. External Resource Definitions
    • 15.1 External Resource Name
    • 15.2 External Resource LANSA Folder
    • 15.3 External Resource File Name
    • 15.4 External Resource Description
    • 15.5 External Resource Content Type
    • 15.6 External Resource Encoding
  • 16. Windows and Linux Considerations
    • 16.1 Reporting Considerations
    • 16.2 "Job" Numbers
    • 16.3 Batch Jobs
    • 16.4 IBM i Job Queue Emulation
      • 16.4.1 Establishing the X_JOBQ.DAT File
      • 16.4.2 Starting, Stopping, Holding and Releasing Job Queues
      • 16.4.3 Job Queue Priorities
      • 16.4.4 Additional Job Queue Monitor Parameters
      • 16.4.5 Submitting Jobs Across a Network
      • 16.4.6 Implementation, Performance and Throughput
      • 16.4.7 Encrypting the Job Queue Details
    • 16.5 The RUNSQL Utility
      • 16.5.1 Configuration Notes - Creating Tables and Indexes
    • 16.6 Font Considerations
    • 16.7 Sizing RDML Windows
    • 16.8 Windows 64-bit Support
    • 16.9 Linux Differences
    • 16.10 Code Page Considerations
    • 16.11 Regional Settings
  • 17. Execution Control
    • 17.1 Using X_START as a Front End to X_RUN
      • 17.1.1 Rules, Limitations and Guidelines
      • 17.1.2 Commands and Special Variables
    • 17.2 The X_RUN Command
    • 17.3 X_RUN Parameter Summary
    • 17.4 X_RUN Parameter Details
      • 17.4.1 User ID and Password Default Values
      • 17.4.2 DBCF Flags
        • Connection Algorithm
        • SQL Anywhere
        • Oracle
        • SQL Server
        • Other Databases
      • 17.4.3 DBID, DBUT, DBII and DBIT Parameters
      • 17.4.4 DBSS Parameter - Performance Tuning
      • 17.4.5 FXQX Parameters
      • 17.4.6 HSKC Parameter
      • 17.4.7 INIT and TERM Parameters
      • 17.4.8 ITxx - Trace Parameters
      • 17.4.9 ODBA Parameter
      • 17.4.10 ODBI Parameter
      • 17.4.11 PROG Parameter
      • 17.4.12 PSxx Server Parameters
        • PSUS Notes (Primary Server User)
        • PSEA Notes (Primary Server Exceptional Arguments)
        • PSRA Notes (Primary Server Route Authority)
        • PSRR Notes (Primary Server Route Repository)
        • PSTC Notes (Primary Server Trusted Connection)
        • PSTY Notes (Primary Server Type)
      • 17.4.13 QUET & FATL Parameters (Quiet Mode of Operation & Fatal)
      • 17.4.14 RRNA and RRNB Parameters - Performance Tuning
      • 17.4.15 TPTH Parameter
      • 17.4.16 WDTM Parameter (Windows Desktop Heap)
      • 17.4.17 WPxx - Windows Printing Extensions
        • WPEN (Windows Printing Enabled)
        • WPPN (Windows Printing Printer Name)
        • WPPS (Windows Printing Setup File)
        • WPPD (Windows Printing Print Dialog)
        • WPFD (Windows Printing Font Dialog)
        • WPDF (Windows Printing Default Font)
        • WPDS (Windows Printing Default Font Size)
        • WPFO (Windows Printing Fixed Pitch Only)
        • WPAS (Windows Printing Automatic Stretching)
        • Questions and Answers
      • 17.4.18 XCMD Parameter
    • 17.5 Permanently Specify X_RUN Parameters
      • 17.5.1 Why not put your X_RUN Commands behind Icons?
      • 17.5.2 Using an Environment Variable
      • 17.5.3 Using an X_LANSA.PRO Profile File
    • 17.6 Database Connections
    • 17.7 The .XQ* Files
      • 17.7.1 Tips for Setting up and Using .XQ* Files
    • 17.8 Lock Timeout
      • 17.8.1 Lock Timeout Configuration
      • 17.8.2 Lock Timeout Behavior Examples
        • Adaptive Server Anywhere 9.0
        • SQL Server 2005
        • Oracle 10.2 - Connection Lock
        • Oracle 10.2 - Statement Lock
        • PC Other Files
      • 17.8.3 Technical Implementation Details
      • 17.8.4 The X_DBMENV.DAT File
    • 17.9 User Instructions for Microsoft Exception or Dr Watson
  • 18. Error Messages
  • Appendix A. Other_Vendor Built-In Functions
    • OV_FILE_DIALOG
    • OV_FILE_SERVICE
    • OV_INDEXED_SPACE
    • OV_MESSAGE_BOX
    • OV_PASTE_CLIPBOARD
    • OV_POST_CLIPBOARD
    • OV_QUERY_SYS_INFO
    • OV_SLEEP
    • OV_SOUND_ALARM
    • OV_SYSTEM_SERVICE

next page

Get in touch

Submit feedback about this site to:

• [email protected]