documentation
.HELP!
LANSA Documentation
DISTINCT
LANSA
previous page
next page
DISTINCT
All about SELECT_SQL
The Things that Make Up this Example
To Execute this Example
Forms/Components for this Example
Function SET189A or form S_189FA
Use DISTINCT to eliminate duplicate field values:
SELECT_SQL FIELDS(#EMPNO) FROM_FILES((PSLSKL)) DISTINCT(*YES)
Type
Name
Code
Description
Function
SET189A
SET189A
SELECT_SQL - Distinct
Form
S_189FA
S_189FA
SELECT_SQL - Distinct
previous page
start
next page
Menu
Homepage
Table of contents
The SET Collection
What Does the SET Collection Contain?
This document
Materials for the iSeries
Materials for the PC
Naming convention
You need these before you start
Install SET materials on the PC
Install SET materials on the iSeries
If you have shared folder access from your PC
If you do not have shared folder access from your PC
If you intend running samples on the Web
IBM HTTP Server
I/NET web server
IIS Path
If Web images were not restored
Edition and Disclaimer
New Editions Override Objects
Example Ratings
New in this Edition
New in Edition 7
New in Edition 6
New in Edition 5
New in Edition 4
New in Edition 3
New in Edition 2
General Purpose Examples
Generic Searching with SQL
The Things that Make Up this Example
To Execute this Example
Converting Numbers to Words
The Things that Make Up this Example
To Execute this Example
A Word Wrapping Technique
The Things that Make Up this Example
To Execute this Example
Calculating Time Differences
The Things that Make Up this Example
To Execute this Example
OV_DATETIME_DIFF
Incrementing Dates
The Things that Make Up this Example
To Execute this Example
OV_INCREMENT_DATE
Finding the Last Day of the Month
The Things that Make Up this Example
To Execute this Example
OV_MONTH_LASTDAY
Changing the Case of a String
The Things that Make Up this Example
To Execute this Example
OV_FORMAT_CASE
Some Pop-up Calendars
The Things that Make Up this Example
To Execute this Example
iSeries Remote Operations
The Things that Make Up this Example
To Execute this Example
Date Manipulation BIFs
The Things that Make Up this Example
To Execute this Example
Utility to Refresh Sample Data
The Things that Make Up this Example
To Execute this Example
All about SELECT_SQL
Forms/Components for this Example
DISTINCT
Calculation
AND and OR
NOT
Join
Auto Join
ANY
ALL
BETWEEN
IN
LIKE
SQUARE ROOT
SUBSTRING
Column Functions
The Things that Make Up this Example
To Execute this Example
Find the length of a string using TCONCAT
The Things that Make Up this Example
To Execute this Example
ISeries (OS/400) Examples
Email a Report
The Things that Make Up this Example
To Execute this Example
Maintain Data Areas DC@A01, DC@A07, DC@OSVEROP
The Things that Make Up this Example
To Execute this Example
Export/Import an Export List
The Things that Make Up this Example
To Execute this Example
Wild Card Searching Using OPNQRYF
The Things that Make Up this Example
To Execute this Example
Case Insensitive Searches Using OPNQRYF
The Things that Make Up this Example
To Execute this Example
Scan for Level Check Errors
The Things that Make Up this Example
To Execute this Example
Access a File with Variable Length Field
The Things that Make Up this Example
To Execute this Example
Access a File with Null Capable Fields
Method A
Method B
The Things that Make Up this Example
To Execute this Example
Web/Internet Examples
Before You Execute Web Functions
Find out the web server port
If Your Web Server is iSeries
If Your Web Server is Windows
Review LANSA for the Web Platform Differences
Host Address and Port Settings
The Things that Make Up this Example
To Execute this Example
Select Multiple Entries in List
The Things that Make Up this Example
To Execute this Example
Checkbox Initial State
The Things that Make Up this Example
To Execute this Example
Data Apportionment
The Things that Make Up this Example
To Execute this Example
Buttons Linking to Same Function
The Things that Make Up this Example
To Execute this Example
Determining Selected Row Number
The Things that Make Up this Example
To Execute this Example
Expandable Menus
The Things that Make Up this Example
To Execute this Example
Customize the Example
List of objects to change
RDML Function SET011A
Component S_011ADDSUBITM
RDML Function SET011B
RDML Function SET011C
Component S_011RBSE
Component S_011EMPLISTHEADER
RDML Function SET011D
Java Script functions and Frame Names
Select a Date from a Calendar
The Things that Make Up this Example
To Execute this Example
Select a Start and End Date from a Calendar
The Things that Make Up this Example
To Execute this Example
Select a Date in Browselist
The Things that Make Up this Example
To Execute this Example
Input/Output Fields in Browselist Column
The Things that Make Up this Example
To Execute this Example
Input/Output Fields in Browselist Row
The Things that Make Up this Example
To Execute this Example
Downloading a File from iSeries IFS to Windows
The Things that Make Up this Example
To Execute this Example
Uploading a File from Windows to iSeries IFS
The Things that Make Up this Example
To Execute this Example
Everything about Browselists
Web Pages for this Example
Positioning a Browselist on Page
Removing Borders and Column Headings
Using a Background Color
Background Color for Alternate Rows
Changing Width, Spacing and Background
Rearranging Row Layout
Changing Column Heading Font and Color
Changing Font Type, Size and Foreground Color
Changing Cell Width and Height ant Background Color
Hyperlinking Fields to Another Function
Hyperlinking Fields to a Static Page
Embedding an Image
Hyperlinked Image to Another Function
Hyperlinked Image to a Static Page
Using Checkbox Selection
Embedding Components in a Browselist
Changing Input/Output Mode in a Column
Changing Input/Output Mode in a Row
Sorting Columns in a Browselist
Page At-a-Time Browselist
A Do-it-Yourself Browselist
More than One Browselist in a Page
The Things that Make Up this Example
To Execute this Example
Handling Enter Key in Web Applications
The Things that Make Up This Example
To Execute this Example
Basic Webevent
The Things that Make Up this Example
To Execute this Example
Webevent Function 1
WebEvent Function 2
Enhancing the User Interface
Imbed Web Component Dynamically
The Things that Make Up this Example
To Execute this Example
Message Presentation in LANSA for the Web
The Things that Make Up this Example
To Execute this Example
Event Logging
The Things that Make Up this Example
To Execute this Example
Integrator/JSM Examples
Setting Up Your JSM Environment
Install the required XSL Style Sheets
Update the HTTP Service Property File
Update the JSM Direct DC@W29 Configuration Table
What to Do if a JSM Based Example Does Not Work
Sending Email Directly over the Internet
The Things that Make Up this Example
To Execute this Example
Accessing a Web Service
The Things that Make Up this Example
To Execute this Example
Handling the Client Side of a B2B XML Transaction
The Things that Make Up this Example
To Execute this Example
Handling the Client Side of a B2B XML Multiple Status Query
The Things that Make Up this Example
To Execute this Example
Handling the Server Side of a B2B XML Transaction
The Things that Make Up this Example
To Execute this Example
Handling the Server Side of a B2B XML Multiple Status Query
The Things that Make Up this Example
To Execute this Example
Transfer File(s) using FTP
The Things that Make Up this Example
To Execute this Example
Using the JSM for Remote Procedure Calls between iSeries Systems
The Things that Make Up this Example
To Execute this Example
LANSA User Agent - Interactive File Conversion and Upload using JSM Direct
The Things that Make Up this Example
To Execute this Example
LANSA User Agent - Batch File Conversion and Upload
The Things that Make Up this Example
To Execute this Example
Windows Examples
Some Ideas
Basic High Speed Data Entry Techniques
The Things that Make Up this Example
To Execute this Example
Advanced High Speed Data Entry Techniques
The Things that Make Up this Example
To Execute this Example
Read Only, Disabled and Input Fields on Forms
The Things that Make Up this Example
To Execute this Example
Enablement and Disablement of Component on Forms
The Things that Make Up this Example
To Execute this Example
Display and Maintenance of Security Information
The Things that Make Up this Example
To Execute this Example
Multi-Form Communication Essentials
The Things that Make Up this Example
To Execute this Example
Using Scope(*Shared)
The Things that Make Up this Example
To Execute this Example
About MVC (Model-View-Controller) Designs
The Things that Make Up this Example
To Execute this Example
Remembering Form Size and Location Details
The Things that Make Up this Example
To Execute this Example
Sorting Grid Columns
The Things that Make Up this Example
To Execute this Example
Dynamically Creating Radio Button Groups
The Things that Make Up this Example
To Execute this Example
Dynamically Creating Drop Down Lists
The Things that Make Up this Example
To Execute this Example
Dynamically Creating Tool Bars
The Things that Make Up this Example
To Execute this Example
Visual Components and Coding Techniques
The Things that Make Up this Example
To Execute this Example
Visual Styles
The Things that Make Up this Example
To Execute this Example
Using Visual Styles for a Grid
The Things that Make Up this Example
To Execute this Example
Using VerticalScroll and HorizontalScroll in a Panel
The Things that Make Up this Example
To Execute this Example
Using CHM files for Online Help Text
The Things that Make Up this Example
To Execute this Example
A Smart Combo Box
The Things that Make Up this Example
To Execute this Example
How Can I?
Position to an Entry in a List View?
The Things that Make Up this Example
To Execute this Example
Load Code Snippets
The Things that Make Up this Example
To Execute this Example
Set Focus to a Specific Cell in a Grid?
The Things that Make Up this Example
To Execute this Example
Handle a Password Field?
The Things that Make Up this Example
To Execute this Example
Handle Long Running Form Initialization Logic?
The Things that Make Up this Example
To Execute this Example
Handle Long and Short Running Form Activities?
The Things that Make Up this Example
To Execute this Example
Start an Independent Instance of Another Form and Pass Information to It?
The Things that Make Up this Example
To Execute this Example
Present and Manage Selectable Items on a Bitmap
The Things that Make Up this Example
To Execute this Example
Use Other Vendor Built-in Functions
BIF Descriptions
OV_POST_CLIPBOARD
OV_PASTE_CLIPBOARD
OV_FILE_DIALOG
OV_MESSAGE_BOX
OV_SOUND_ALARM
OV_PRESENT_GRAPH
OV_QUERY_SYS_INFO
OV_FILE_SERVICE
OV_SYSTEM_SERVICE
OV_INDEXED_SPACE
OV_WINWORD
The Things that Make Up this Example
To Execute this Example
Use a Multi-line Edit Box
The Things that Make Up this Example
To Execute this Example
Dynamically Format Grids
The Things that Make Up this Example
To Execute this Example
Expand a Tree View
The Things that Make Up this Example
To Execute this Example
Advanced List View Features
The Things that Make Up this Example
To Execute this Example
Set Screen Position of Components
The Things that Make Up this Example
To Execute this Example
Communication and Connectivity
General Purpose Super-Server Connector VL_SAM003
The Things that Make Up this Example
To Execute this Example
iSeries Output Queue Browser
The Things that Make Up this Example
To Execute this Example
Chat Session
The Things that Make Up this Example
To Execute this Example
Windows NT and 2000 Server Systems
Essential Concepts
The Things that Make Up this Example
To Execute this Example
Emailing from an iSeries Application via an NT/2000 Email System
The Things that Make Up this Example
To Execute this Example
Accessing an NT/2000 Database Table from an iSeries Application
The Things that Make Up this Example
To Execute this Example
Reading an NT/2000 Database Table into an iSeries Batch Application
The Things that Make Up this Example
To Execute this Example
Reading from an NT/2000 file into an iSeries Application
The Things that Make Up this Example
To Execute this Example
Writing to a NT/2000 file from an iSeries Application
The Things that Make Up this Example
To Execute this Example
Accessing an NT/2000 Database from a L4Web Application
The Things that Make Up this Example
To Execute this Example
Sending Email via NT/2000 from a L4Web Application
The Things that Make Up this Example
To Execute this Example
Using L4Web to Glue Together Information from Multiple Systems
The Things that Make Up this Example
To Execute this Example
Multi-Tiered Applications
Prerequisite -> Implementing a Tier Management Scheme
The Things that Make Up this Example
To Execute this Example
Data Tier Awareness
The Things that Make Up this Example
To Execute this Example
Tier Aware Subroutines
The Things that Make Up this Example
To Execute this Example
Tier Aware Subroutines with List Parameters
The Things that Make Up this Example
To Execute this Example
Tier Aware and Platform Aware Subroutines
The Things that Make Up this Example
To Execute this Example
Tier Aware Batch Processing
The Things that Make Up this Example
To Execute this Example
Tier Aware Reporting
The Things that Make Up this Example
To Execute this Example
Adding Tier Awareness to Existing Applications
The Things that Make Up this Example
To Execute this Example
Tier Aware System Variables
The Things that Make Up this Example
To Execute this Example
Miscellaneous Examples
System Variables Galore
The Things that Make Up this Example
To Execute this Example
A Stopwatch
The Things that Make Up this Example
To Execute this Example
Getting Details of an Associated Super-Server Job or Process
The Things that Make Up this Example
To Execute this Example
Graph Types and Styles
The Things that Make Up this Example
To Execute this Example
Using Explorer Components to Create an Image Viewer
The Things that Make Up this Example
To Execute this Example
Integrating with the Desktop A Favorite/Common Activities Manager
The Things that Make Up this Example
To Execute this Example
Copying an iSeries Folder to a Windows Directory
The Things that Make Up this Example
To Execute this Example
Currency Converter
The Things that Make Up this Example
To Execute this Example
MS-Excel Integration Examples
Putting Detailed and Summarized Information into MS-Excel Spreadsheets
The Things that Make Up this Example
To Execute this Example
Writing and Reading MS-Excel Spreadsheet Information
The Things that Make Up this Example
To Execute this Example
Excel Integration with ActiveX
The Things that Make Up this Example
To Execute this Example
MS-Word Integration Examples
Producing MS Word Documents and Emails from VL applications
The Things that Make Up this Example
To Execute this Example
Producing Batched MS Word Documents and HTML Pages
The Things that Make Up this Example
To Execute this Example
Using Word with ActiveX
The Things that Make Up this Example
To Execute this Example
Web Browser Integration Examples
Causing a Web page to be Displayed in a Browser
The Things that Make Up this Example
To Execute this Example
Using a Web Browser ActiveX Control to Produce Reports
The Things that Make Up this Example
To Execute this Example
Dynamic Web Browser Integration
The Things that Make Up this Example
To Execute this Example
Mass (Re)Generation of Static Web Pages
The Things that Make Up this Example
To Execute this Example
Producing Nested HTML Tables in HTML documents
The Things that Make Up this Example
To Execute this Example
Display Document Objects in Web Browser
The Things that Make Up this Example
To Execute this Example
Visual Basic Integration Examples
Calls to and from Visual Basic
The Things that Make Up this Example
To Execute this Example
Lotus Notes/Domino Integration Examples
Mass Transfer of Information Into and Out of Domino Databases
The Things that Make Up this Example
To Execute this Example
Directly Reading, Updating and Deleting Information in Domino Databases
The Things that Make Up this Example
To Execute this Example
Random and Keyed Access to Information to Multiple Domino Databases
The Things that Make Up this Example
To Execute this Example
Email Integration Examples
Email Integration Fundamentals
The Things that Make Up this Example
To Execute this Example
Free Format Text, Mail Attachments and Multiple Addressing
The Things that Make Up this Example
To Execute this Example
Using Email to Send Reports
The Things that Make Up this Example
To Execute this Example
Email Document Handling System
Documents
New Department Definition Form
Employee Details Update
Mass Employee Salary Update
Employee Information Requisition
The Things that Make Up this Example
To Execute this Example
Using the SPACE Built-In Functions
Space Object Built-in Function Fundamentals
The Things that Make Up this Example
To Execute this Example
Base Forms and Reusable Components
Help About Dialog
The Things that Make Up this Example
To Execute this Example
Logo Display
The Things that Make Up this Example
To Execute this Example
Status Bar
The Things that Make Up this Example
To Execute this Example
Browser / Detailer Form
The Things that Make Up this Example
To Execute this Example
Application Scenarios
Pushing Information
Why Use Push?
Scenario: Credit Limit Exceeded
The Things that Make up this Scenario
To Execute this Scenario
Prepare the Data
Simulate an Order Entry
Work with the Order
Scenario: Obtain Time Sheets
The Things that Make Up this Scenario
To Execute this Scenario
Prepare the Data
Request Time Sheet
Fill in the Time Sheet
Change Personal Details
Static Web Pages
Why Use Static Pages?
Scenario: A Shipping Time Table
The Things that Make Up this Scenario
To Execute this Scenario
Details about this Scenario
How the Static Pages Are Generated
Controlling the Appearance of the Application
Program Flow for the Generated HTML
Data and Database
Scenario: Computer Product Catalog
The Things that Make up This Scenario
To Execute this Scenario
Details about this Scenario
How the Static Pages are Generated
Controlling the Appearance of the Application
Program flow for the Generated HTML
Data and Database
Cross-Product Examples
Choosing the LANSA Product
Scenario: Cross-Product Poll System
The Things that Make Up this Example
To Execute this Example
Create Example Poll
Maintain Polls and Analyse Responses
Respond to Polls
Source Code and Object Definitions
Function SET010 : Select Employee Based on Partial Employee Number
Function SET012A: Convert Number to Words
Function SET014A: Word Wrap a list
Function SET164A - Load Personnel System Data
Function SET164B Load Personnel System Data (PSLSKL)
Function SET165A - Demonstrate OV_DATETIME_DIFF
Function OV@P937 OV_DATETIME_DIFF
Function SET166A - Demonstrate OV_INCREMENT_DATE
Function OV@P936 OV_INCREMENT_DATE
Function SET167A - Demonstrate OV_MONTH_LASTDAY
Function OV@P935 OV_MONTH_LASTDAY
RDML Function OV@P934
RDML Function SET179A
Function SET169A - Demonstrate a prompt calendar
Function SET169B - Calendar
Form S_169FA - Demonstrate a prompt calendar
Form S_169FA1 - Calendar
Form S_185FMF - Main Form
Form S_185RRY - Get Reply
Reusable Component S_185RMQ - Message Object
Function SET185A - Display Message Queue
Function SET185B - Refresh Message List
Function SET185C - Delete a Message
Function SET185D - Reply to a Message
Function SET185E - Delete Answered Messages
Function SET185F - Delete Old Messages
CLP SETGETMSGQ - Handle Message Requests
Function SET1891
Function SET1892
Function SET189A
Function SET189B
Function SET189C
Function SET189D
Function SET189E
Function SET189F
Function SET189G
Function SET189H
Function SET189I
Function SET189J
Function SET189K
Function SET189L
Function SET189M
Function SET189N
Form S_189FA
Form S_189FB
Form S_189FC
Form S_189FD
Form S_189FE
Form S_189FF
Form S_189FG
Form S_189FH
Form S_189FI
Form S_189FJ
Form S_189FK
Form S_189FL
Form S_189FM
Form S_189FN
Function SET001A: Email a report (AS400 only)
Function SET001B: Send a Spool File to an Email Address
Function SET013A: Maintain DC@A01
Function SET013B: Maintain DC@A07
Function SET013C: Maintain DC@OSVEROP
Function SET015A: Export/Import an Export list
Function SET015B: Export/Import Partition Prompt/Maintain
Function SET015C: Export/Import Path Prompt/Maintain
Function SET182A OPNQRYF wildcard search
Function SET183A Use of OPNQRYF XLATE to ignore case
Function SET005A: Handle multi-Select List Box
HTML for SET005A (SET005A001)
Web Component S_005DEPT: List Box
Function SET006A: Checkbox in a Browselist
HTML for S_0006 (SET006A001)
HTML for S_0006 (SET006A002)
HTML for S_0006 (SET006A003)
Web Component S_006CBOX: Check Box
Function SET007A: Using a text Area
HTML for SET007A (SET007A001)
Web Component S_007TX: Text Area
Function SET008A: Determine Button Clicked
HTML for SET008A (SET008A001)
Web Component S_008ALLB: Buttons
Web Component S_008TEXT
Function SET009A: Determine Selected Row
HTML for SET009A (SET009A001)
Web Component S_009RMSG: Message Showing Row Number
Web Component S_009ROWN: Set Row Number
Function SET011A: Populate Working List for Menu
Function SET011B: Populate Browselists Used in Menu
HTML for SET011B (SET011B001)
Function SET011C: Build Browselist Using Radio Button
HTML for SET011C (SET011C001)
Function SET011D: Show Employee Details
HTML for function SET011D (SET011D001)
Function SET011E: Build the URL
HTML for SET011E (SET011E001)
Web Component S_011ADDMNULST: Add Menu Item Layer
Web Component S_011BUILDMNU: Show Layers
Web Component S_011CREATEMNU: Create Entire Menu Layer
Web Component S_011CREATESUB: Build Subitem Options
Web Component S_011ADDSUBITM: Add Submenu Item
Web Component S_011MDIV: Assigns an ID and a Name to Layers
Web Component S_011MSTY: Add Style Sheet Items for Menu Items
Web Component S_011NOSK:
Web Component S_011MCMP: Build the Menu Browselist
Web Component S_011EMPLISTHEADER
Web Component S_011RBSE: Radio Button for Passing Employee Number
RDML Function SET171A
LANSA for the WEB HTML for Function SET171A
LANSA for the WEB Component S_171ACALENDAR
LANSA for the WEB Component S_171ADESC
RDML Function SET171B
LANSA for the WEB HTML for Function SET171B
LANSA for the WEB Component S_171BCALENDAR
LANSA for the WEB Component S_171BDESC
RDML Function SET171C
LANSA for the WEB HTML for Function SET171C
LANSA for the WEB Component S_171CDESC
LANSA for the WEB Component S_171CALI
RDML Function SET173A
LANSA for the WEB HTML for Function SET173A
LANSA for the WEB Component S_173IOC1
LANSA for the WEB Component S_173IOC2
LANSA for the WEB Component S_173IOC3
LANSA for the WEB Component S_173IOC4
LANSA for the WEB Component S_173COL1
LANSA for the WEB Component S_173COL2
LANSA for the WEB Component S_173COL3
LANSA for the WEB Component S_173COL4
LANSA for the WEB Component S_173ADESC
RDML Function SET173B:
LANSA for the WEB HTML for Function SET173B
LANSA for the WEB Component S_173IOC1
LANSA for the WEB Component S_173IOC2
LANSA for the WEB Component S_173IOC3
LANSA for the WEB Component S_173IOC4
LANSA for the WEB Component S_173COL1
LANSA for the WEB Component S_173COL2
LANSA for the WEB Component S_173COL3
LANSA for the WEB Component S_173COL4
LANSA for the WEB Component S_173BDESC
RDML Function SET181A
CLP source of SET181CPYS
HTML Function SET181A
HTML for Component S_181ADESC:
HTML for Component S_GETLOCATIONPORT:
HTML for Component S_181ROWN
HTML for Component S_181LINKS
HTML for Component S_181PATH
RDML Function SET181B
HTML Function SET181B
HTML for Component S_181BDESC
C source of SET181UPLO
Skeleton for process SET_184
Component SET184A (PAGE)
Component SET184B (PAGE)
Component SET184C (PAGE)
Component SET184D (PAGE)
Component SET184E (PAGE)
Component SET184F (PAGE)
Component SET184G (PAGE)
Component SET184H (PAGE)
Component SET184I (PAGE)
Component SET184J (PAGE)
Component SET184K (PAGE)
Component SET184L (PAGE)
Component SET184M (PAGE)
Component SET184N (PAGE)
Component SET184O (PAGE)
Component SET184P (PAGE)
Component SET184Q (PAGE)
Component SET184Q2 (PAGE)
Component SET184R (PAGE)
Component SET184S (PAGE)
Component SET184T (PAGE)
Component SET184U (PAGE)
Component SET184V (PAGE)
Component SET184W (PAGE)
Component SET184X (PAGE)
Component SET184Z (PAGE)
Component SET1841 (PAGE)
Component S_184BCMP (VISUAL INPUT)
Component S_184CBOX (VISUAL INPUT)
Component S_184COLH (PAGE)
Component S_184DATA1 (PAGE)
Component S_184DATA2 (PAGE)
Component S_184DESI (VISUAL OUTPUT)
Component S_184ENDT (PAGE)
Component S_184FDES (VISUAL INPUT)
Component S_184H (VISUAL INPUT)
Component S_184IMG (VISUAL INPUT)
Component S_184K (VISUAL INPUT)
Component S_184L (VISUAL INPUT)
Component S_184LNK (VISUAL INPUT)
Component S_184N (VISUAL INPUT)
Component S_184O (VISUAL INPUT)
Component S_184P (VISUAL INPUT)
Component S_184R (VISUAL INPUT)
Component S_184STRT (PAGE)
Function SET1840
Function SET1841
Function SET184A
Function SET184B
Function SET184C
Function SET184D
Function SET184E
Function SET184F
Function SET184G
Function SET184H
Function SET184I
Function SET184J
Function SET184K
Function SET184L
Function SET184M
Function SET184N
Function SET184O
Function SET184P
Function SET184Q
Function SET184R
Function SET184S
Function SET184T
Function SET184U
Function SET184V
Function SET184W
Function SET184X
Function SET184Y
Function SET184Z
Component S_CHGSPPATH (Page)
Function SET187A Enter Key not handled
Function SET187B Handle Enter Key using javascript
Function SET187C Handle Enter Key using DEFAULT_HIDDEN
Function HTML for SET187B after editing Handle Enter Key using DEFAULT_HIDDEN
Component SET_187A_SCRIPT
Component SET_187B_HIDDEN
Component SET187A
Component SET187B
Component SET187C
Form S_156FDE: High Speed Data Entry
Function SET191A
Function SET191B
Function SET191C
Function SET191D
Function SET191E
Function SET191F
Function SET191G
Function SET191H
Function SET191J
Form S_191FA
Form S_191FB
Form S_157FSS/3: Super-Server Connector
CL Program SETJOBUSER
System Variable *SSERVER_TYPE: Current Super-Server Connection Type
System Variable *SSERVER_SSN: Super-Server Connection SSN
System Variable *SSERVER_CONNECTED: Super-Server Connection Exists
Visual Style VS_FIXED: Fixed Font Displays
Function VSAM004: Get List of iSeries Output Queues
Function VSAM005: Get List of Spool Files on an iSeries Output Queue
Function VSAM006: Get Spool File Content
Form S_158FAS: iSeries Output Queue Browser
Function SET1931: Essential Concepts
Function SET1932: Send Email via NT Server
Function SET1933: Fetch/Update of NT DBMS Table
Function SET1934: Batch Report from NT DBMS Table
Function SET1935: iSeries Batch Printing Function
Function SET1936: Windows NT Side of SET1935
Function SET1937: Read from NT file System
Function SET1938: Windows NT Side of SET1937
Function SET193A: Allocate Next Data Queue from Pool
Function SET193D: Deallocate Data Queue from Pool
Function SET193E: Write to NT File System
Function SET193I: Initialize/Cleanup Logic
Function SET193L: List Exchanger
Function SET193P: Data Queue Polling RPC
Function SET193T: Transaction Interface Manager
Visual Style S_193VYB: Visual Style for Form S_193FMF
Form S_193FMF: Windows NT/2000 Service Manager
Function SET192A: Send Email via NT Server
HTML for Function SET192A: Send Email via NT Server
Function SET192B: Fetch/Update of NT DBMS Table
HTML for Function SET192B: Fetch/Update of NT DBMS Table
Function SET192C: Glue Together iSeries and NT DBMS Data
HTML for Function SET192C: Glue Together iSeries and NT DBMS Data
HTML for Component S_192FCMP
HTML for Component S_192DCMP
HTML for Component S_192ASEM
HTML for Component S_192NTEM
HTML for Component S_192TX
HTML for Component S_192FIND
HTML for Component S_192UPDA
HTML for Component S_192SNDE
Form S_159FSV: System Variable Values Editor
Function VSAM009: Generic Alphanumeric System Variable Evaluator
Function VSAM010: Generic Numeric System Variable Evaluator
Form S_160FRO: Read Only, Disabled and Input Fields
System Variable VS_NOREAD: Read Only or Disabled Fields
Form S_161FED: Dynamic Enablement and Disablement
Form S_162FPL: Positioning to a Value in a List
Visual Style VS_DIGIL: Large Digital Display
Form S_163FWA: Stopwatch
Function VSAM017: Get Server Job or Process Details
Form VL_SAM018: Display Server Job or Process Details
Form VL_SAM019: Displaying and Maintaining Security Details
Form VL_SAM025: Bitmap Display for Extended Form Initialization
Form VL_SAM026: Example of Extended Form Initialization Handling
Form VL_SAM029: Query whether Form Should be Closed
Reusable Part VL_SAM027: Status Bar Details
Form VL_SAM028: Short and Long Activity Visual Feedback
Form VL_SAM031: Multi-Form Essentials 1
Form VL_SAM032: Multi-Form Essentials 2
Form VL_SAM033: Multi-Form Essentials 3
Form VL_SAM034: Remembering Form Size and Location
Form VL_SAM035: Sorting Grid Columns
Form VL_SAM036: Graph Style
Visual Style S_172VFF - Fixed font visual style
Form S_172FSO - Manage details of a snippet
Form S_172FSN - Manage snippets
Form VL_SAM037: Setting Focus to a Grid Cell
Form VL_SAM038: Handling a Password Field
Form VL_SAM044: Using Explorer Components to Create an Image Viewer
Reusable Part VL_SAM064: Dynamic Radio Button Group
Form VL_SAM065: Dynamic Radio Button Groups
Reusable Part VL_SAM066: Dynamic Drop Downs
Form VL_SAM067: Dynamic Drop Down Lists
Reusable Part VL_SAM068: Dynamic Tool Bars
Form VL_SAM069: Dynamic Tool Bars in a Free Floating Window
Form VL_SAM070: Demonstration of Dynamic Tool Bars
Form VL_SAM081: MS-Excel Integration
Form VL_SAM082: MS-Excel Integration
Reusable Part VL_SAM083: Operating System File Handler
Form VL_SAM084: Favorite/Common Activity
Form VL_SAM085: Favorite/Common Activity Example
Form VL_SAM086: Web Browser Page Display
Form VL_SAM090: Independent Instance Form Startup
Form VL_SAM091: Independent Instance Form Startup
Reusable Part VL_SAM092: Interface to MS Word
Form VL_SAM093: MS Word Integration for Documents and Emails
MS Word Document Templates VL_SAMxxx.DOT
Form VL_SAM098: Using MS Word to Batch Documents and HTML Pages
Form VL_SAM099: Space Built-in Function
Form VL_SAM102: Visual Component Coding Techniques
Form VL_SAM103: Advanced High Speed Data Entry Techniques
Reusable Part S_154RIW: Domino Item Wrapper Component
Reusable Part S_154RDW: Domino Database Wrapper
Standard Fields : Fields that you may need in your Data Dictionary
Form S_154FA: Domino Demonstration A
Form S_154FB: Domino Demonstration B
Form S_154FC: Domino Demonstration C
Form S_152FA: HTML Browser Demonstration A
Form S_152FB: HTML Browser Demonstration B
Form S_152FC: HTML Browser Demonstration C
Form S_152FD: HTML Browser Demonstration D
Reusable Part S_152RHT: HTML Generation
ActiveX Control S_152XWB: Web Browser
Reusable Part S_153RML: Email
Form S_153FA: Email Demonstration A
Form S_153FB: Email Demonstration B
Form S_153FC: Email Demonstration C
Form S_155FLG: Application Logo Display
Form S_155FHL: Help About Dialog
Reusable Part S_155RST: Reusable Status Bar
Form S_155FA: Browser/Detailer
Currency Converter: Fields and Files
Reusable Part VL_SAM104 : Currency Converter
Reusable Part VL_SAM106 : Currency Converter
Form VL_SAM105: Currency Converter
Function SET195A: Copy iSeries Folder to Windows Directory
Form S_195FMF: Execution Harness for SET195A
Reusable Part VL_SAM110 : World Map Locations
Form VL_SAM111: World Map
Function VSAM130: Tiered System Variable Evaluation
Function VSAM140: Tiered System Variable Evaluation
System Variable Definitions XXXX_TIER
Function VSAM131 : Example Tier Aware Subroutine
Function VSAM133 : Example Tier Aware Subroutine
Form VL_SAM132 : Tier Aware Subroutines
Form VL_SAM134 : Dynamic Tier Management Configuration
Form VL_SAM135: Tier Aware Employee Enquiry
Form VL_SAM136: Submit Tier Aware Batch Jobs
Function VSAM137: Tier Aware Batch Job
Function VSAM138: Interactive/Batch and Tier Aware Report
Form VL_SAM139 : Submit Interactive/Batch and Tier Aware Report
Function VSAM145: Tier and Platform Aware Subroutines
Function VSAM146: Tier Aware Subroutines with List Parameters
Form VL_SAM147 : Tier Aware Subroutines with List Parameters
Form VL_SAM148 : Tier and Platform Aware Subroutines
Function VSAM141 : Existing Application (Browse/Maintain/Add Employees)
Function VSAM142: Existing Application (10% Employee Salary Update in Batch)
Function VSAM143: INIT= Function for Tier Awareness in Existing Applications
Function VSAM144: TERM= Tier Awareness in Existing Applications
System Variable *CENTRAL_DATETIME
Function VSAM149: Evaluate *CENTRAL_DATETIME on a Tier
Function VSAM150: Evaluate *CENTRAL_DATETIME
Form VL_SAM151: Tier and Platform Aware Subroutines
HTML Skeleton for all functions in process SET_175
HTML Skeleton for all functions in process SET_175B
HTML Skeleton SET_178 Used by all functions in process SET_178
File SETPT1 - Port
File SETPTP - Port Pairs
File SETVVP - Voyage Vessel Port
File SETDEV - Device Type
File SETSUB - Sub-Type
File SETBRD - Brand
File SETPRD - Product (- Subtype)
File SETLNK - Category Links
Component SET175B - Header text for function SET175B
Component SET175C - Header text for function SET175C
Component SET175D - Header text for function SET175D
Component SET175E - Header text for function SET175E
Component SET175F - Header text for function SET175F
Component SET175G - Header text for function SET175G
Component S_175IDP1 - browselist row component used in SET175D - registered to field S_175IDP1
Component S_175IDPP - browselist row component used in SET175E - registered to field S_175IDPP
Component S_175MENU the menu displayed on the left panel (Static)
Component S_175MNUD - the menu displayed on the left panel (Dynamic)
Components SET_175_STDHEADER and SET_175B_STDHEADER Standard header for process SET_175 and process SET_175B
Components SET_175_STDFOOTER and SET_175B_STDFOOTER Standard footer for process SET_175 and process SET_175B
Component SET_175_SCRIPT Standard script for process SET_175
Component SET178B - Header for function SET178B
Component SET178C - Header for function SET178C
Component SET178D - Header for function SET178D
Component SET178E - Header for function SET178E
Component SET178F - Header for function SET178F
Component SET178G - Header for function SET178G
Component SET178H - Header for function SET178H
Component S_178BPG - Used in browselist row in SET178B & C - registered to field S_178BPG
Component S_178DVPG - Used in browselist row in SET178B & E - registered to field S_178DVPG
Component S_178PPG - Used in browselist row in SET178D F & G - registered to field S_178PPG
Component S_178SBPG - Used in browselist row in SET178C & F - registered to field S_178SBPG
Component S_178MENUS - Menu in the left hand panel
Component SET_178_STDHEADER - Standard Header for process SET_178
Component SET_178_STDFOOTER - Standard Footer for process SET_178
Graphical Variables - Images
Graphical Variables - Browselist General Attributes
Graphical Variables - Browselist Cell & Column Heading background & foreground colours
Function SET175 Generate Static Pages
Function SET175B Front Page
Function SET175C Service Schedule (static)
Function SET175D Select the from-port
Function SET175E Select the to-port
Function SET175F Schedule for a port pair
Function SET175G Dynamic Service Schedule - all voyages
Function SET175Y Generate Port Pairs Data from Port Data
Function SET175Z: Add a voyage
Function SET176A
Function SET176B
Function SET176C
HTML for Function SET176C
HTML for Component S_176CDESC
HTML for Component S_HOSTSETTINGS
Function SET176D
HTML for Function SET176D
HTML for Component S_176SHOWORDMSG:
HTML for Component S_176COMPLETIONMSG
HTML for Component S_176DDESC
HTML for Component S_176CUSTDETAILS
Function SET177A
Function SET177B
HTML for Function SET177B
HTML for Component S_177BDESC
HTML for Component S_177CBOX
Function SET177C
HTML for Function SET177C
HTML for Component S_177BCMP
HTML for Component S_177TSTART
HTML for Component S_177COLHDG
HTML for Component S_177TDATA
HTML for Component S_177TEND
HTML for Component S_177EMPD
Function SET177D
HTML Function SET177D
HTML for Component S_177DDESC
Function SET178A Generate Static HTML pages
Function SET178B Front Page
Function SET178C Device Type
Function SET178D Sub-Type
Function SET178E Brand
Function SET178F Device Type - Brand
Function SET178G Sub Type - Brand
Function SET178H Product
Function SET178S Refresh example application data
Function SET178T Prompt (& maintain) Device Type
Function SET178U Prompt (& maintain) Sub-Type
Function SET178V Prompt (& maintain) brand
Function SET178W Maintain Products
Function SET178Y Add Sub-types for a device type
Function SET190A
Function SET190B
Function SET190C
Function SET190D
Function SETWEBN
Function SETWEBP
Function SETWEBS
Form S_190FA
Form S_190FB
Form S_190FF
Form S_190FG
Form S_190FH
Form S_190FI
Form S_190FJ
Reusable Part S_190RPL
Reusable Part S_190RQL
Reusable Part S_190RQN
Reusable Part S_190RQT
Component S_190AFIN
Component S_190ANXT
Component S_190APRV
Component S_190ASBM
Component S_190AYES
Component SET_190_SCRIPT
Component SET_190_STDHEADER
HTML Skeleton SET_190
Component S_190HDR
Component S_190HDRBLANK
Component S_190HDRLAST
Component S_190HDRPASSWORD
Component S_190HDRQUESOPTS
Component S_190HDRQUESSELS
Component S_190HDRUSERDET
Component S_190SE
Component S_190SEAN
Component S_190SEGP
Component S_190SERB
Component S_190SERK
File SETPDF Poll Definition
File SETPQU Question
File SETPQS Question Selections
File SETPRE Poll Respondent
File SETPRA Poll Respondent Answers
Form S_197FA
Form S_197FB
Form S_197FC
Form S_197FD
Form S_197FE
Form S_197FF
Icon S_197I1
Visual Style S_197VDG
Visual Style S_197VDM
Visual Style S_197VFP
Visual Style S_197VFV
Visual Style S_197VL1
Visual Style S_197VL2
Visual Style S_197VNC
Visual Style S_197VNM
Visual Style S_197VU1
Visual Style S_197VU2
Visual Style S_197VW1
Visual Style S_197VW2
Visual Style VS_FIXED
Visual Style VS_NOREAD
Form S_200FA
Form S_200FB
Form S_200FC
File S200NTE Notes
Form S_199FA
Form S_199FB
Reusable Part S_199RFC
Form S_194FTRE
RDML Function Skeleton SET203A
LANSA for the WEB Component Page S_203SUBM
LANSA for the WEB Component Page S_203FIND
LANSA for the WEB Component Page S_203BACK
LANSA for the WEB Component Page S_203B_ENHANCED_LOOK
LANSA for the WEB Component Page S_203C_ENHANCED_LOOK
LANSA for the WEB Component Page S_203D_ENHANCED_LOOK
Form S_202FBR
Form S_202FCR
Form S_202FDL
Form S_202FUP
Form S_202RCO
Form S_202RMO
Form S_201FMF
Reusable S_201RSA
Reusable S_201RSB
Reusable S_201RSO
Form S_174FRB: Display Various Document Types
Reusable Part S_174RWB: Web Browser Active-X Wrapper
S_174XWB: Web Browser ActiveX Control
Form S_198FA: Control Word through ActiveX
Form S_198FB: Word ActiveX Report Writer
Form S_204FA: ActiveX Interface to Excel
RDML for SET205A
HTML for SET205A
Component S_205WEBS
Component S_205DESC
SET_205_LAYOUT
SET208H
SET208L
SET208D
SET208E
SET208Q
SET208S
S_208FMF
S_208RMW
S_208RME
S_208XMO
S_208XSO
Process SET_210
Function SET210A
CL program SET210
CMD SET210
Query Definition SET210QRY
File S210HDR Example Header File
File S210DET Example Detail File
Function SET212A
Component S_212COMP1 Page n/a
Component S_212COMP2 Page n/a
Component S_212COMP3 Page n/a
Component S_212COMP4 Page n/a
Component S_212FLD - Visual Input
Component S_212SUBM Page Output
Component SET_212_STDFOOTER Page n/a
Component SET_212_STDHEADER Page n/a
SET_212_LAYOUT
RDML for SET209E
RDML for SET209W
HTML for SET209W
S_209ATTS: Attachment Browse List Field Web Component
S_209RECP: Recipient Browse List Field Web Component
S_209DESC: Function Description Web Component
S_209SMTP: SMTP Details Web Component
S_209SNDE: Send Email Button Web Component
S_209TX: Data Apportionment Web Component
SET211_RECEIVE-NASDAQ.XSL
RDML for SET211Q
RDMLX for S_211FMF
RDML for SET211B
RDML for SET211G
RDML for SET211W
RDML for SET211S
HTML for SET211W
S_211DESC: Function Description Web Component
S_211REFR: Refresh Prices Web Component
RDML for SET214G
RDML for SET214R
RDML for SET214W
XSL: SET214_ORDER_REQUEST_OUTBOUND
XSL: SET214_ORDER_RESPONSE_INBOUND
HTML for SET214W
HTML for S_214DESC
HTML for S_214CRTO
RDML for SET215G
RDML for SET215R
SET215W
HTML for SET215W
XSL: SET215_ORDERSTATUS_REQUEST_OUTBOUND
XSL: SET215_ORDERSTATUS_RESPONSE_INBOUND
HTML for Component SET_215_MSGPRES
HTML for Component S_215DESC
HTML for Component S_215STSR
RDML for SET216S
XSL: SET216_ORDER_RESPONSE_OUTBOUND
XSL: SET216_ORDER_RESPONSE_INBOUND
RDML for SET217S
XSL: SET217_ORDERSTATUS_REQUEST_INBOUND
XSL: SET217_ORDERSTATUS_RESPONSE_OUTBOUND
XSL: SET217_ORDERSTATUS_FRAGMENT
RDML for SET218A
RDML for SET218W
HTML for SET218W
RDML for SET218G
HTML for S_218DESC
HTML for S_218SEND
HTML for S_218ACTN
SET219A
SET219B
SET219C
SET219D
SET219E
SET219F
SET219G
SET219H
SET219Y
SET219Z
SET219_OUTBOUND_NAMEVALUEMSG.XSL
SET219_OUTBOUND_NAMES_FRAGMENT.XSL
SET219_OUTBOUND_VALUES_FRAGMENT.XSL
SET219_OUTBOUND_MESSAGES_FRAGMENT.XSL
SET219_INBOUND_NAMES_LIST.XSL
SET219_INBOUND_VALUES_LIST.XSL
SET219_INBOUND_MESSAGES_LIST.XSL
SETJSMO to Open/close JSM
Form S_206F01 - Chat Form
Reusable Part S_206F02 - Interface
Form S_206F03 Message Window Form
Function SET206A - Remote Procedure for Form S_206F02
Function SET206B Conversation Manager
S220PFL Virtual Field Logic
S220PFL DDS and CRTPF instructions
Function SET220A Write 1000 X filled records to S220PFL
Function SET220B - Write 1000 blank records to S220PFL
File S231PFA DDS and CRTPF instruction
File S231PFB DDS and CRTPF instruction
File S231PFA Virtual Field Logic
File S231PFB Virtual Field Logic
Function SET231A
Function SET231B
Function SET221A
S_223FA
S_223FB
S_223FC
S_223FD
S_227FA
S_227FB
S_227FC
S_227VN
S_227VB
S_227VG
S_227VR
S_228FA
S_228FB
S_230FA
S_230FB
S_230RH1
S_230RH2
S_230XWB
S_230HELP.DOC
S_230HELP.CHM
S_230HELP.DAT
S_232R
S_232F
S_234R
S_234F
SET224a RDML
SET225a RDML
SET226a RDML
SET224a HTML
SET225a HTML
SET226a HTML
SET_225_MSGPRES
SET_226_MSGPRES
S_224DESC
S_224FIELDS
S_224MGB1
S_224MGB2
S_224MGB3
Function SET233S
LANSA User Agent host configuration file SET_233_CSV.lih
Excel Spreadsheet SET_233_Employee_New_Salary.xls
CSV file SET_233_Employee_New_Salary.csv
Function SET235S
LANSA User Agent host configuration file SET_235_CSV.lih
CSV file SET_235_Employees_to_Report_on.csv
Bat file SET_235_Upload.bat
RDML of SET229A
HTML Component: S_229DESC
HTML Component: S_229DES1
HTML Component: S_229SOFF
HTML Component: S_229MSL
HTML Component: S_229IBML
HTML Component: S_229SEAR
Page Source: SET_229_TRACE
Page Source: SET_229_SCRIPT
Page Source: SET_229_LAYOUT
Visual Basic Form SET_236B.frm
Visual LANSA form S_236FA
Visual LANSA form S_236FB
Visual LANSA form S_236FX
Visual Basic Form SET_236X.frm
Get in touch
Submit feedback about this site to:
[email protected]
