documentation
.HELP!
LANSA Technical Documentation
8 19 3 SELECT_SQL Free Format References
LANSA Technical
previous page
next page
8.19.3 SELECT_SQL Free Format References
SAA Structured Query Language/400 Reference (SC41-9608)
SAA Structured Query Language/400 Programmers Guide (SC41-9609)
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]