Toggle navigation
IBM i
(AS400)
Tutorial
IBM i CHAPTERS
IBM i FAQ
IBM i E-BOOKS
IBM i COURSE
IBM i VIDEOS
Sign-In
Sign-Up
 
×
Sign In
- Registered user
UserId/Email
Password
Remember me
Forgot Password
Register now
or
Login with
Google
Login with
Facebook
×
Sign Up
- New user
Name
Email
Password
Re-Enter Password
or
Login with
Google
Login with
Facebook
As400 basic concepts
11
AS400 introduction
Library
Source Physical File
Physical File
RGZPFM
Multimember Physical File
Logical File
Difference b/w PF and LF
Copy File CPYF
Access Path & Types of Access Path
Important Points to remember
Menu Driven AS400
01
Menu Driven AS400
SEU basic concepts
01
SEU Introduction
Array
01
Array & Types of Array
Data structure
01
Data structure & Types of DS
User Profile & Security
02
User profile & Securitys
Lock status of an obj.
As400 Subsys. & Jobs
05
Subsystem
AS400 Jobs
Activation group
User Defined Opions
Compiler Directive
01
Compiler Directive
Data queue
01
Data queue
FTP & Stream file
03
FTP
SNDNETF
Stream File & Copy From/To PF
Journalling
01
Journalling
Screen Design Aid
06
Design screen with STRSDA
STRSDA for SFLMSG record type
STRSDA for SUBF record type
STRSDA for WDWSFL record type
STRSDA for WINDOW record type
STRSDA Test display file
Display File Keywords
62
ALIAS (Alternative Name)
ALTHELP, HELP & HLPARA
ALTNAME (Alternative Record Name)
ALTPAGEDWN / ALTPAGEUP
ASSUME, OVERLAY & KEEP
CAnn (Command Attention)
CFnn (Command Function)
CHECK (Check)
CHGINPDFT (Change Input Default)
CLRL (Clear line)
CNTFLD (Continued-Entry Field)
COLOR (Color)
COMP (Comparison)
CSRLOC (Cursor Location)
DATE (Date)
DATFMT (Date Format)
DATSEP (Date Separator)
DFT (Default)
DFTVAL (Default Value)
DSPATR (Display Attribute)
DSPMOD (Display Mode)
DSPSIZ (Display Size)
EDTCDE (Edit Code)
EDTWRD (Edit Word)
ERRMSG (Error Message)
ERRMSGID (Error Message Identifier)
ERRSFL (Error Subfile)
FLDCSRPRG (Cursor Progression Field)
INDARA (Indicator Area)
MSGCON (Message Constant)
MSGID (Message Identifier)
OVERLAY (Overlay)
PAGEDOWN & PAGEUP
REF (Reference)
REFFLD (Referenced Field)
ROLLUP & ROLLDOWN
RTNCSRLOC (Return Cursor Location)
SFL (Subfile)
SFLCLR (Subfile Clear)
SFLCSRRRN (Subfile Cursor RRN)
SFLCTL (Subfile Control)
SFLDROP, SFLFOLD & SFLMOD
SFLDSP (Subfile Display)
SFLDSPCTL (Subfile Display Control)
SFLEND (Subfile End)
SFLINZ & SFLRNA
SFLMSG (Subfile Message)
SFLMSGID (Subfile Message ID)
SFLMSGKEY, SFLMSGRCD & SFLPGMQ
SFLNXTCHG (Subfile Next Changed)
SFLPAG (Subfile Page)
SFLRCDNBR (Subfile Record Number)
SFLROLVAL (Subfile Roll Value)
SFLSCROLL (Subfile Scroll)
SFLSIZ (Subfile Size)
SYSNAME (System Name)
TIME (Time)
TIMFMT (Time Format)
TIMSEP (Time Separator)
USER (User)
VALUES (Values)
WDWBORDER, WDWTITLE & WINDOW
Subfile & Types of Subf
06
Subfile & Its types
Load-All Subfile
Expandable Subfile
Single Page subfile
Message Subfile
Session or device error
Help panel design
01
Help panel design
RPG specs
07
H-SPEC
F-SPEC
Access Particular member of a File
D-SPEC
I-SPEC
C-SPEC
O-SPEC
RPGLE op-codes
85
ADD
ADDDUR
ADDXX
BEGSR
CABXX
CALL
CALLB
CALLP
CASExx
CAT
CHAIN
CHECK
CHECKR
CLEAR
CLOSE
COMP
DEFINE
DELETE
DIV
DO
DOU
DOW
DSPLY
DUMP
ENDSR
ENDyy
EVAL
EVALR
EXCEPT
EXFMT
EXSR
EXTRCT
FOR
GOTO
IF
IFxx
IN
ITER
KFLD
KLIST
LEAVE
LEAVESR
LOOKUP
MONITOR
MOVE(P)
MOVE
MOVEL(P)
MOVEL
MULT
MVR
OCCUR
ONERROR
OPEN
ORxx
OTHER
OUT
PARM
PLIST
READ
READC
READE
READP
READPE
RETURN
SCAN
SELECT
SETGT
SETLL
SETOFF
SETON
SORTA
SUB
SUBDUR
SUBST
TAG
TEST
TIME
UNLOCK
UPDATE
WHEN
WRITE
XFOOT
XLATE
Z-ADD
Z-SUB
RPGLE Built-in Function
34
List of Built-In Functions
%ABS
%CHAR
%CHECK
%CHECKR
%DATE
%DAYS
%DEC
%DECH
%DIFF
%EDITC
%EDITW
%ELEM
%EOF
%EQUAL
%ERROR
%FIELDS
%FOUND
%HOURS
%INTH
%MINUTES
%MONTHS
%MSSECONDS
%OPEN
%PARMS
%REPLACE
%SCAN
%SECONDS
%SIZE
%STATUS
%SUBST
%TIMESTAMP
%TRIM
%TRIML
%TRIMR
%YEARS
RPGLE concepts
04
Service prog. & Binding Directory
Nomain module
Procedure Versus Subprocedure
Convert RPG400 source to RPGLE
Debugging-batch job
02
Debugging-batch job
STRDBG Vs. STRISDB
Setll Reade Chain Readc
03
Difference b/w READE & CHAIN
Difference b/w SETLL & CHAIN
Difference b/w READC & CHAIN
RETURN v/s SETON LR
01
Difference b/w RETURN & SETON LR
File/Program exceptions
01
File & Program Exceptions
Printer file concepts
04
Printer file Introduction
Printer file design
EXCEPT/EXCPT op-code
Printer file keywords
CL basic concepts
03
CL Introduction
CL program segments
Limitations of CL
CL programming
08
File OPEN-ID in CL
CAT BCAT TCAT
Handling Indicator in CL
Multiple file read operation
Passing parameter in CL
QCMDEXC API
Example-SNDF,RCVF,SNDRCVF
Example RCVF
CL commands
12
DSPMSGD
OPNQRYF/ODP
OPNQRYF V/S Logical file
OUTFILE
RETURN
RTVDTAARA
RTVJOBA
RTVMBRD
RTVOBJD & CHGOBJD
RTVSYSVAL
OVRDBF
CRTCMD(Create Command)
Other commands list
Data area
01
Data area
Message handling in CL
07
Message & Types of msg
Message queue
SNDMSG
SNDPGMMSG
SNDUSRMSG
SNDBRKMSG
RCVMSG
Monitor messages in CL
02
MONMSG Introduction
MONMSG, cpf0000 Vs. cpf9999
Embedded Sql
13
Embedded sql Introduction
Embedded sql using 2 sequential cursors
Embedded sql Using static sql queries
Embbeded sql with '?' in query string
Embedded sql Using PERPARE STATEMNT
Embedded sql Using EXECUTE IMMEDIATE
Scrollcursor fetch record Top to Bottom
Scrollcursor using FETCH AFTER/PRIOR
Scrollcursor using FETCH LAST/PRIOR
Scrollcursor using FETCH RELATIVE
Error handling in Embedded sql
SQLSTMT with Cursor
SQLSTMT without Cursor
QMQRY/WRKQRY
02
WRKQRY
QMQRY
Navigation list of AS400 chapters:
As400 basic concepts
AS400 introduction
Library
Source Physical File
Physical File
RGZPFM
Multimember Physical File
Logical File
Difference b/w PF and LF
Copy File CPYF
Aceess Path & Types of Access Path
Important Points to remember
Menu Driven AS400
Menu Driven AS400
SEU basic concepts
SEU Introduction
Array
Array & Types of Array
Data structure
Data structure & Types of DS
User Profile & Security
User profile & Securitys
Lock status of an obj.
As400 Subsys. & Jobs
Subsystem
AS400 Jobs
Activation group
User Defined Opions
Compiler Directive
Compiler Directive
Data queue
Data queue
FTP & Stream file
FTP
SNDNETF
Stream File & Copy From/To PF
Journalling
Journalling
Screen Design Aid
Design screen with STRSDA
STRSDA for SFLMSG record type
STRSDA for SUBF record type
STRSDA for WDWSFL record type
STRSDA for WINDOW record type
STRSDA Test display file
Display File Keywords
ALIAS (Alternative Name)
ALTHELP, HELP & HLPARA
ALTNAME (Alternative Record Name)
ALTPAGEDWN / ALTPAGEUP
ASSUME, OVERLAY & KEEP
CAnn (Command Attention)
CFnn (Command Function)
CHECK (Check)
CHGINPDFT (Change Input Default)
CLRL (Clear line)
CNTFLD (Continued-Entry Field)
COLOR (Color)
COMP (Comparison)
CSRLOC (Cursor Location)
DATE (Date)
DATFMT (Date Format)
DATSEP (Date Separator)
DFT (Default)
DFTVAL (Default Value)
DSPATR (Display Attribute)
DSPMOD (Display Mode)
DSPSIZ (Display Size)
EDTCDE (Edit Code)
EDTWRD (Edit Word)
ERRMSG (Error Message)
ERRMSGID (Error Message Identifier)
ERRSFL (Error Subfile)
FLDCSRPRG (Cursor Progression Field)
INDARA (Indicator Area)
MSGCON (Message Constant)
MSGID (Message Identifier)
OVERLAY (Overlay)
PAGEDOWN & PAGEUP
REF (Reference)
REFFLD (Referenced Field)
ROLLUP & ROLLDOWN
RTNCSRLOC (Return Cursor Location)
SFL (Subfile)
SFLCLR (Subfile Clear)
SFLCSRRRN (Subfile Cursor RRN)
SFLCTL (Subfile Control)
SFLDROP, SFLFOLD & SFLMOD
SFLDSP (Subfile Display)
SFLDSPCTL (Subfile Display Control)
SFLEND (Subfile End)
SFLINZ & SFLRNA
SFLMSG (Subfile Message)
SFLMSGID (Subfile Message ID)
SFLMSGKEY, SFLMSGRCD & SFLPGMQ
SFLNXTCHG (Subfile Next Changed)
SFLPAG (Subfile Page)
SFLRCDNBR (Subfile Record Number)
SFLROLVAL (Subfile Roll Value)
SFLSCROLL (Subfile Scroll)
SFLSIZ (Subfile Size)
SYSNAME (System Name)
TIME (Time)
TIMFMT (Time Format)
TIMSEP (Time Separator)
USER (User)
VALUES (Values)
WDWBORDER, WDWTITLE & WINDOW
Subfile & Types of Subf
Subfile & Its types
Load-All Subfile
Expandable Subfile
Single Page subfile
Message Subfile
Session or device error
Help panel design
Help panel design
RPG specs
H-SPEC
F-SPEC
Access Particular member of a File
D-SPEC
I-SPEC
C-SPEC
O-SPEC
RPGLE Built-in Function
List of Built-In Functions
%ABS
%CHAR
%CHECK
%CHECKR
%DATE
%DAYS
%DEC
%DECH
%DIFF
%EDITC
%EDITW
%ELEM
%EOF
%EQUAL
%ERROR
%FIELDS
%FOUND
%HOURS
%INTH
%MINUTES
%MONTHS
%MSSECONDS
%OPEN
%PARMS
%REPLACE
%SCAN
%SECONDS
%SIZE
%STATUS
%SUBST
%TIMESTAMP
%TRIM
%TRIML
%TRIMR
%YEARS
RPGLE op-codes
ADD
ADDDUR
ADDXX
BEGSR
CABXX
CALL
CALLB
CALLP
CASExx
CAT
CHAIN
CHECK
CHECKR
CLEAR
CLOSE
COMP
DEFINE
DELETE
DIV
DO
DOU
DOW
DSPLY
DUMP
ENDSR
ENDyy
EVAL
EVALR
EXCEPT
EXFMT
EXSR
EXTRCT
FOR
GOTO
IF
IFxx
IN
ITER
KFLD
KLIST
LEAVE
LEAVESR
LOOKUP
MONITOR
MOVE(P)
MOVE
MOVEL(P)
MOVEL
MULT
MVR
OCCUR
ONERROR
OPEN
ORxx
OTHER
OUT
PARM
PLIST
READ
READC
READE
READP
READPE
RETURN
SCAN
SELECT
SETGT
SETLL
SETOFF
SETON
SORTA
SUB
SUBDUR
SUBST
TAG
TEST
TIME
UNLOCK
UPDATE
WHEN
WRITE
XFOOT
XLATE
Z-ADD
Z-SUB
RPGLE concepts
Service prog. & Binding Directory
Nomain module
Procedure Versus Subprocedure
Convert RPG400 source to RPGLE
Debugging-batch job
Debugging-batch job
STRDBG Vs. STRISDB
Setll Reade Chain Readc
Difference b/w READE & CHAIN
Difference b/w SETLL & CHAIN
Difference b/w READC & CHAIN
RETURN v/s SETON LR
Difference b/w RETURN & SETON LR
File/Program exceptions
File & Program Exceptions
Printer file concepts
Printer file Introduction
Printer file design
EXCEPT/EXCPT op-code
Printer file keywords
CL basic concepts
CL Introduction
CL program segments
Limitations of CL
CL programming
File OPEN-ID in CL
CAT BCAT TCAT
Handling Indicator in CL
Multiple file read operation
Passing parameter in CL
QCMDEXC API
Example-SNDF RCVF SNDRCVF
Example RCVF
CL commands
DSPMSGD
OPNQRYF/ODP
OPNQRYF V/S Logical file
OUTFILE
RETURN
RTVDTAARA
RTVJOBA
RTVMBRD
RTVOBJD & CHGOBJD
RTVSYSVAL
OVRDBF
CRTCMD(Create Command)
Other commands list
Data area
Data area
Message handling in CL
Message & Types of msg
Message queue
SNDMSG
SNDPGMMSG
SNDUSRMSG
SNDBRKMSG
RCVMSG
Monitor messages in CL
MONMSG Introduction
MONMSG, cpf0000 Vs. cpf9999
Embedded Sql
Embedded sql Introduction
Embedded sql using 2 sequential cursors
Embedded sql Using static sql queries
Embbeded sql with '?' in query string
Embedded sql Using PERPARE STATEMNT
Embedded sql Using EXECUTE IMMEDIATE
Scrollcursor fetch record Top to Bottom
Scrollcursor using FETCH AFTER/PRIOR
Scrollcursor using FETCH LAST/PRIOR
Scrollcursor using FETCH RELATIVE
Error handling in Embedded sql
SQLSTMT with Cursor
SQLSTMT without Cursor
QMQRY/WRKQRY
WRKQRY
QMQRY
AS/400 Interview Questions and Answers
as400 interview questions and answers-Part 1
as400 interview questions and answers-Part 2
as400 interview questions and answers-Part 3
as400 interview questions and answers-Part 4
as400 interview questions and answers-Part 5
as400 interview questions and answers-Part 6
as400 interview questions and answers-Part 7
as400 interview questions and answers-Part 8
as400 interview questions and answers-Part 9
as400 interview questions and answers-Part 10
as400 interview questions and answers-Part 11
as400 interview questions and answers-Part 12
as400 interview questions and answers-Part 13
as400 interview questions and answers-Part 14
as400 interview questions and answers-Part 15
as400 interview questions and answers-Part 16
as400 interview questions and answers-Part 17
as400 interview questions and answers-Part 18
as400 interview questions and answers-Part 19
as400 interview questions and answers-Part 20
as400 interview questions and answers-Part 21
as400 interview questions and answers-Part 22
as400 interview questions and answers-Part 23
as400 interview questions and answers-Part 24
as400 interview questions and answers-Part 25
as400 interview questions and answers-Part 26
as400 interview questions and answers-Part 27
as400 interview questions and answers-Part 28
as400 interview questions and answers-Part 29
as400 interview questions and answers-Part 30
Site Links
Home
AS400 chapters
AS400 FAQ
AS400 E-BOOKS
Contact
Subscribe
Email:
Share
Copyright © www.go4as400.com, 2013-2023.
Copyright notice
Terms of services
Privacy policy