If JavaScript is disabled, please continue to the
sitemap
.
Infor Lawson RPG Application Program Interfaces
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
BEGIN17
COMMON
CRTWS
DATEWS
JOBWS
STRWS
Global Routines
Error and Message Processing
U@PRINTLOGMSG
U@PRINTERRMSG
U@PRINTMSG
U@GETERRORMSG
U@GETMSG
API Processing
U@GENERICAPI
U@GENERICAPIVL
File Processing
U@BLDPRTFILENM
U@BLDTMPFILEN
U@FILEEXISTS
U@GETLAWDIR
U@GETUNIQUEID
U@MOVEFILES
U@@REMOVEFILE
Locale Processing
U@ADDPHRASE
U@GETLOCPHRXL
U@GETLOCCLPHRX
U@GETNEXTLOC
U@GETPREVLOC
U@GETPHRASEXL
U@GETCOLPHRXLT
U@GETRPTLOC
U@ISVALLOCALE
Print Processing
Print Routine Considerations
U@PRINTRPTGRP
U@DISTREPORT
User Name Processing
U@EDITUSERNM
U@GETLONGUNAM
U@GETUSRDSPNM
U@GETUSRDBUDKY
Security Processing
U@AUSECURED
U@AUSECSYS
U@COSECURED
U@COSECSYS
U@ISHREMPSEC
U@PLSECURED
U@PLSECSYS
String Processing
U@STRINGALPHA
U@STRINGFLD
U@STRINGNUM
U@STRINGSTRING
U@STRINGLIT
U@STRINGGRP
U@STRINGPHONE
U@STRINGHMS
Common String Functions
U@STRINGCOLON
U@STRINGDASH
U@STRINGDD
U@STRINGLPAREN
U@STRINGMM
U@STRINGPRCNT
U@STRINGRPAREN
U@STRINGSLASH
U@STRINGYY
U@STRINGYYYY
U@STRINGZM
U@UPPERTOLOWER
U@LOWERTOUPPER
U@FORMATNBR
Transaction Processing
Managing Transaction State
Commit Frequency
U@AUDITBEGIN
U@AUDITEND
U@BEGSUBTRAN
U@ENDSUBTRAN
Date and Time Processing
Century Parameter Processing
U@DATEONCAL
U@DATETOJUL
U@DAYFRDATE
U@GETCALDESC
U@GETDATEEOM
U@GETDTFRNBDY
U@GETDATELIT
U@GETNBDYINCL
U@GETNBDYOCAL
U@GETWEEKDLIT
U@INCRDATE
U@ISVALIDDATE
U@JULIANTODT
U@NBDYINDTRNG
U@FORMATDATE
U@GETDATELIT2
U@GETLCLDTLIT
U@GETMNTHLIT
U@GETLCLMNLIT
U@GETWEEKDLIT2
U@GETLCLWKDLIT
Batch Processing
Job Creation Processing
U@CRTJOB
U@CRTSBMJOB
Job Submission Processing
U@SUBMITJOB
U@LOADJOB
Job Output Processing
Print Files
Job Deletion Processing
U@DELETEJOB
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 CALLP Statements Using Database Routines
Database Inquiry Processing
E@DBFINDEQ
E@DBFINDGE
E@DBFINDNXT
E@DBFINDPRV
Range Find Data Processing
Using Range Find Routines
E@DBFINDBEGRNG
E@DBFINDSUBRNG
Name
Description
Using the API in a Program
Input Values
Return Values
Programming Examples
E@DBFINDMIDRNG
E@DBFINDMIDSUB
E@DBFINDNXTRNG
E@DBFINDPRVRNG
Key Find Data Processing
Using Key Find Routines
E@DBKFNDEQ
E@DBKFNDGE
E@DBKFNDNXT
E@DBKFNDBEGRNG
E@DBKFNDSUBRNG
E@DBKFNDNXTRNG
Aggregate Range Data Processing
Considerations in Using Aggregate Range Routines
U@DB@AGINIT and E@DBCALCAGGRGT
Name
Description
Using the APIs in a Program
Input Values
Return Values
Protecting against Overflow Values
Programming Example
Database Update and Deletion Routines
Using Update Routines
Initializing the System for Updates
Using Modification Routines
Using Range Modification Routines
Record and Index Creation
E@DBCREATE
E@DBRECREATE
Database Modification Processing
E@DBSTORE
E@DBUPDATE
E@DBLOCKEQ
Lock Records in a File for Modification
Description
Using the API in a Program
Input Values
Return Values
Programming Example
E@DBLOCKNXT
E@DBLOCKGE
E@DBLOCKPRV
Database Range Modification Processing
E@DBLOCKBEGRNG
E@DBLOCKSUBRNG
E@DBLOCKMIDRNG
E@DBLOCKMIDSUB
E@DBLOCKNXTRNG
Data Deletion Routines
Using Delete Routines
E@DBDELETE
Name
Description
Using the API in a Program
Input Values
Programming Example
E@DBDELETERNG
E@DBDELSUBRNG
E@DBFULLDELETE
Name
Description
Using the API in a Program
Input Values
Programming Example
E@DBFULLDELRNG
E@DBFULLDELSUB
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
U@FLTCREATE
U@FLTS<Type>
Using the Filter Database API Routines
E@DBFILTERGE
E@DBFILTERBEGR
E@DBFILTERSUBR
E@DBFINDFLTMID
E@DBFINDFLMDSB
E@DBLOCKFLTGE
E@DBLOCKFLTBEG
Reusing A Filter
How Can I Reuse a Filter within a Program?
Update Range and Filter Update Range Routines
E@DBUPDRNG
E@DBFLTUPDRNG
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
S@CSVOPOUT@
S@CSVOPINP@
S@CSVOPAPP@
S@CSVCLOSE@
Setting CSV File Attributes
S@CSVALLUS@
S@CSVOVRID@
CSV Read/Write Processing
S@CSVWRITE@
S@CSVREAD@
Comment and URL Attachment Processing Routines
Overview of Attachment Processing
Attachment Database Files
Attachment Routine Syntax
Comment Attachment Processing
Comment Attachment Variables
CCREATE
CSTORE
CGETTXT
CCOPY
CAPPEND
Comment Range Processing
CFNDBEG
CFNDNXT
CCPYRNG
Using this Routine
Programming Example
Comment Deletion Processing
Deleting Comment Attachments
CDELETE
CDELRNG
URL Attachment Processing
URL Attachments
URL Working Storage
Create URL Records
Range URL Processing
Read URL Records
Update URL Records
URL Copy Processing
UCOPY and UCPYRNG
URL Deletion Processing
UDELETE and UDELRNG
Vertex Quantum Routines
Vertex Quantum Global Variables
GeoCoder Routines
U@GEOCONNECT
Input Values
Return Values
Using the Routine
Programming Example
U@GEOSETNMCRI
Input Fields
Return Values
Using this Routine
Programming Example
U@GEOSETGCRIT
Input Fields
Return Values
Using the Routine
Programming Example
U@GEOGETNXTG
Return Values
Using the Routine
Programming Example
U@GEODISCON
Return Values
Using the Routine
Programming Example
Sales and Use Tax Routines
U@OPENVERTEX
Return Values
Using the Routine
Programming Example
U@CALCVTXTAX
Required Fields
Return Values
Using the Routine
Programming Example
U@CLOSEVERTEX
Return Values
Using the Routine
Programming Example
Deprecated APIs
Deprecated Database Aggregate Range Routines
Aggregate Range APIs (Older)
Aggregate Request Format
Return Values
Using the Aggregate Range APIs
Accessing Database Records
Protecting against Overflow Values
Open link in new tab
Open link in new window
Copy link to clipboard