documentation.HELP! LANSA Technical Documentation

10 Intrinsic Functions

LANSA Technical

previous page next page

10. Intrinsic Functions

Intrinsic Functions provide a series of facilities that can be used to manipulate individual data values. The following sections describes the use of 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.6 Alphanumeric/String Intrinsic Functions

10.7 Boolean Intrinsic Functions

10.8 Date Intrinsic Functions

10.9 DateTime Intrinsic Functions

10.10 Time Intrinsic Functions

10.11 Large Object Intrinsic Functions

10.12 Binary Intrinsic Functions

10.13 Decimal Intrinsic Functions

10.14 Fixed Point Intrinsic Functions

10.15 Floating Point Intrinsic Functions

10.16 Integer Intrinsic Functions

 

 

 

previous page start next page

Menu

  • Homepage

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

Get in touch

Submit feedback about this site to:

  • [email protected]

© documentation.help. Design: rehmann.co.