If JavaScript is disabled, please continue to the
sitemap
.
Infor Lawson 4GL Application Program Interfaces--Windows
Home
Home
Back
Back
Forward
Forward
Search
Help
Copy URL
PDF
Print this page
Help
Help
Copy URL
Copy URL
Topic URL copied to clipboard
PDF
PDF
Print
Hide the Table of Contents
Show the Table of Contents
About this guide
Introduction
Overview
What are APIs?
Components of an API
How This Manual Is Organized
Global Data Structures
BEGIN1, BEGIN2
COMMON
CRTWS
DATEWS
JOBWS
STRWS
Global Routines
Error and Message Processing
780-DISPLAY-MSG
780-PRINT-ERROR-MSG
780-PRINT-MSG
790-GET-ERROR-MSG
790-GET-MSG
API Processing
900-GENERIC-API
900-GENERIC-API-VALIDATION
File Processing
900-BUILD-PRINT-FILE-NAME
900-BUILD-TMP-FILE-NAME
900-FILEEXISTS
900-GETLAWDIR
900-GET-UNIQUE-ID
900-MOVEFILES
901-REMOVE-TMP-FILE
Locale Processing
900-ADD-PHRASE
900-GET-LOCALE-PHRASE-XLT
900-GET-LOCALE-COL-PHRASE-XLT
900-GET-NEXT-LOCALE
900-GET-PREV-LOCALE
900-GET-PHRASE-XLT
900-GET-COL-PHRASE-XLT
900-GET-REPORT-LOCALE
900-IS-VALID-LOCALE
Print Processing
Print Routine Considerations
700-PRINT-RPT-GRP
900-DISTRIBUTE-REPORT
User Name Processing
900-EDIT-USER-NAME
900-GET-LONG-USER-NAME
900-GET-USER-DISPLAY-NAME
900-GET-USER-DBUIDKEY
Security Processing
900-ACCT-UNIT-SECURED
900-ACCT-UNIT-SEC-SYS
900-COMPANY-SECURED
900-COMPANY-SEC-SYS
900-IS-HR-EMP-SECURED
900-PROC-LEV-SECURED
900-PROC-LEV-SEC-SYS
String Processing
500-STRING-ALPHA
500-STRING-FIELD
500-STRING-NUMERIC
510-START-STRING
520-STRING-LITERAL
580-STRING-GROUP
580-STRING-TELEPHONE
580-STRING-TIME-HHMMSS
590-COMMON-STRING-FUNCTIONS
590-STRING-COLON
590-STRING-DASH
590-STRING-DD
590-STRING-L-PAREN
590-STRING-MM
590-STRING-PERCENT
590-STRING-R-PAREN
590-STRING-SLASH
590-STRING-YY
590-STRING-YYYY
590-STRING-ZM
900-UPPER-TO-LOWER
900-LOWER-TO-UPPER
905-FORMAT-NUMERIC
Transaction Processing
Managing Transaction State
Commit Frequency
700-GET-TRANSACTION
910-AUDIT-BEGIN
920-AUDIT-END
910-BEGIN-SUB-TRANSACTION
920-END-SUB-TRANSACTION
Date and Time Processing
Date and Time Processing
Century Parameter Processing
900-DATE-ON-CALENDAR
900-DATE-TO-JULIAN
900-DAY-FROM-DATE
900-GET-CALENDAR-DESC
900-GET-DATE-EOM
900-GET-DATE-FROM-NBR-DAYS
900-GET-DATE-LIT
900-GET-NBR-DAYS-IN-CAL-LS
900-GET-NBR-DAYS-ON-CAL
900-GET-WEEKDAY-LIT
900-INCREMENT-DATE
900-IS-DATE-INVALID
900-JULIAN-TO-DATE
900-NBR-DAYS-IN-DATE-RNG
905-FORMAT-DATE
905-GET-DATE-LIT
905-GET-LOCALE-DATE-LIT
905-GET-MONTH-LIT
905-GET-LOCALE-MONTH-LIT
905-GET-WEEKDAY-LIT
905-GET-LOCALE-WEEKDAY-LIT
Batch Processing
Job Creation Processing
900-CREATE-JOB
900-CREATE-AND-SUBMIT-JOB
Job Submission Processing
900-SUBMIT-JOB
900-LOAD-JOB
Job Output Processing
Print Files
CKPOINT and Restart
Save Routines for Batch Print File Recovery on Restart
Placement of Automatic Save Routines
Enabling and Disabling Automatic Save Routines
900 SAVE-WORK-FILES
900-SAVE-OUTPUT-FILES
Job Deletion Processing
900-DELETE-JOB
900-SAVE-PRINT-FILES
Database Input/Output Routines
Using Input/Output Routines
Populating Key Fields and Indexes
Key Fields
Indexes
Populating Record Retrieval Variables
Using a Key Field More Than Once
Identifying Key Fields in an Index
Moving a Key Field Value to Retrieve a Record
Writing PERFORM Statements Using Database Routines
Database Inquiry Processing
840-FIND-<Index>
850-FIND-NLT-<Index>
860-FIND-NEXT-<Index>
870-FIND-PREV-<Index>
Range Find Data Processing
Using Range Find Routines
850-FIND-BEGRNG-<Index>
850-FIND-SUBRNG-<Index>
Name
Description
Using the API in a Program
Input Values
Return Values
Programming Examples
850-FIND-MIDRNG-<Index>
850-FIND-MIDSUBRNG-<Index>
860-FIND-NXTRNG-<Index>
870-FIND-PRVRNG-<Index>
Key Find Data Processing
Using Key Find Routines
840-KFIND-<Index>
850-KFIND-NLT-<Index>
860-KFIND-NEXT-<Index>
850-KFIND-BEGRNG-<Index>
850-KFIND-SUBRNG-<Index>
860-KFIND-NXTRNG-<Index>
Aggregate Range Data Processing
Considerations in Using Aggregate Range Routines
880-INIT-DBAG-<Index> and 880-CALC-DBAG-<Index>
Name
Description
Using the APIs in a Program
Input Values
Return Values
Programming Example
880-CALC-DBAGOF-<Index>
880-FILTER-DBAGOF-<Index>
Database Update and Deletion Routines
Using Update Routines
Initializing the System for Updates
Using Modification Routines
Using Range Modification Routines
Record and Index Creation
800-CREATE-<FileName>
810-RECREATE-<FileName>
Database Modification Processing
820-STORE-<FileName>
820-UPDATE-<FileName>
840-MODIFY-<FileName>
Lock Records in a File for Modification
Description
Using the API in a Program
Input Values
Return Values
Programming Example
860-MODIFY-NEXT-<Index>
850-MODIFY-NLT-<Index>
870-MODIFY-PREV-<Index>
Database Range Modification Processing
850-MODIFY-BEGRNG-<Index>
850-MODIFY-SUBRNG-<Index>
850-MODIFY-MIDRNG-<Index>
850-MODIFY-MIDSUBRNG-<Index>
860-MODIFY-NXTRNG-<Index>
Data Deletion Routines
Using Delete Routines
830-DELETE-<FileName>
Name
Description
Using the API in a Program
Input Values
Programming Example
830-DELETERNG-<Index>
830-DELETESUBRNG-<Index>
830-FULL-DELETE-<FileName>
Name
Description
Using the API in a Program
Input Values
Programming Example
830-FULL-DELETERNG-<Index>
830-FULL-DELETESUBRNG-<Index>
Database Index Filter Routines
Using Index Filter Routines
How Do the Filter Routines Work?
Setting the Filter Parameter Value
Setting the Filter Parameter Value
Index Filter Working Storage Variables
Filter String Formatting Rules and Examples
890-CREATE-FILTER
890-SET-Type-FILTER-VALUE
Using the Filter Database API Routines
850-FILTER-NLT-<Index>
850-FILTER-BEGRNG-<Index>
850-FILTER-SUBRNG-<Index>
850-FILTER-MIDRNG-<Index>
850-FILTER-MIDSUB-<Index>
850-MODFILTER-NLT-<Index>
850-MODFILTER-BEGRNG-<Index>
Reusing A Filter
How Can I Reuse a Filter within a Program?
Update Range and Filter Update Range Routines
Setting the Update Text String
Supplying a Literal Value
Specifying a Field Name
Specifying a Related Field Using Aggregate Functions
Update String Formatting Rules and Examples
820-UPDATERNG-<Index>
820-FILTER-UPDRNG-<Index>
CSV File Processing Routines
Using CSV Routines
CSV Global Variables
CSV File Information (PrefixINFO) Data Structure
Error Return Fields
Use Flag (UF) Fields
CSV File Access
800-OPENOUTPUTCSV
800-OPENINPUTCSV
800-OPENAPPENDCSV
800-CLOSECSV
Setting CSV File Attributes
800-ALLUSEDCSV
800-OVRDESCCSV
CSV Read/Write Processing
800-WRITECSV
800-READCSV
Comment and URL Attachment Processing Routines
Overview of Attachment Processing
Attachment Database Files
Comment Attachment Processing
Comment Attachment Variables
900-CREATE-CMT
900-STORE-CMT
900-GET-TEXT-CMT
900-COPY-CMT
900-APPEND-CMT
Comment Range Processing
900-FIND-BEGRNG-CMT
900-FIND-NXTRNG-CMT
900-COPY-RNG-CMT
Using this Routine
Programming Example
Comment Deletion Processing
Deleting Comment Attachments
900-DELETE-CMT
900-DELETE-RNG
URL Attachment Processing
URL Attachments
URL Working Storage
Create URL Records
Range URL Processing
Read URL Records
Update URL Records
URL Copy Processing
900-COPY-URL and 900-COPY-RNG-URL
URL Deletion Processing
900-DELETE-URL and 900-DELETE-RNG-URL
Vertex Quantum Routines
Vertex Quantum Global Variables
GeoCoder Routines
900-GEO-CONNECT
Input Values
Return Values
Using the Routine
Programming Example
900-GEO-SET-NAME-CRITERIA
Input Fields
Return Values
Using this Routine
Programming Example
900-GEO-SET-GEOCODE-CRITERIA
Input Fields
Return Values
Using the Routine
Programming Example
900-GEO-GET-NEXT-GEOCODE
Return Values
Using the Routine
Programming Example
900-GEO-DISCONNECT
Return Values
Using the Routine
Programming Example
Sales and Use Tax Routines
900-OPEN-VERTEX
Return Values
Using the Routine
Programming Example
900-CALC-VERTEX-TAX
Required Fields
Return Values
Using the Routine
Programming Example
900-CLOSE-VERTEX
Return Values
Using the Routine
Programming Example
Deprecated APIs
Deprecated Date and Time Processing
500-DATE-COMPARE
501-CHECK-LEAP-YEAR
510-DATE-EDIT
515-UPDATE-DATE-TIME
520-COMPUTE-JULIAN
520-DATE-LIT
530-COMPUTE-GREGORIAN
540-COMPUTE-WEEKDAY
580-STRING-DATE-MMDD
580-STRING-DATE-MMDDYY
580-STRING-DATE-MMDDYYYY
580-DATE-MMYYYY
Deprecated Direct Inquiry Data Processing
800-OPEN and 860-READ
Deprecated Database Aggregate Range Routines
880-INIT and 880-FIND Aggregate Range APIs
Aggregate Request Format
Return Values
Using the Aggregate Range APIs
Accessing Database Records
880-FIND-DBAGOF
Open link in new tab
Open link in new window
Copy link to clipboard