As400 Tutorial

AS400 Tutorial

AS400 chapters
AS400 FAQ
AS400 E-BOOKS
AS400 COURSE
Contact

As400 basic concepts11
- 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 AS40001
- Menu Driven AS400
SEU basic concepts01
- SEU Introduction
Array01
- Array & Types of Array
Data structure01
- 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 queue01
- Data queue
FTP & Stream file03
- FTP
- SNDNETF
- Stream File & Copy From/To PF
Journalling 01
- Journalling
Screen Design Aid06
- 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 Keywords62
- 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 Subf06
- Subfile & Its types
- Load-All Subfile
- Expandable Subfile
- Single Page subfile
- Message Subfile
- Session or device error
Help panel design01
- Help panel design
RPG specs07
- H-SPEC
- F-SPEC
- Access Particular member of a File
- D-SPEC
- I-SPEC
- C-SPEC
- O-SPEC
RPGLE op-codes85
- 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 Function34
- 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 concepts04
- Service prog. & Binding Directory
- Nomain module
- Procedure Versus Subprocedure
- Convert RPG400 source to RPGLE
Debugging-batch job02
- Debugging-batch job
- STRDBG Vs. STRISDB
Setll Reade Chain Readc03
- Difference b/w READE & CHAIN
- Difference b/w SETLL & CHAIN
- Difference b/w READC & CHAIN
RETURN v/s SETON LR01
- Difference b/w RETURN & SETON LR
File/Program exceptions01
- File & Program Exceptions
Printer file concepts04
- Printer file Introduction
- Printer file design
- EXCEPT/EXCPT op-code
- Printer file keywords
CL basic concepts03
- CL Introduction
- CL program segments
- Limitations of CL
CL programming08
- 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 commands12
- DSPMSGD
- OPNQRYF/ODP
- OPNQRYF V/S Logical file
- OUTFILE
- RETURN
- RTVDTAARA
- RTVJOBA
- RTVMBRD
- RTVOBJD & CHGOBJD
- RTVSYSVAL
- OVRDBF
- CRTCMD(Create Command)
- Other commands list
Data area01
- Data area
Message handling in CL07
- Message & Types of msg
- Message queue
- SNDMSG
- SNDPGMMSG
- SNDUSRMSG
- SNDBRKMSG
- RCVMSG
Monitor messages in CL02
- MONMSG Introduction
- MONMSG, cpf0000 Vs. cpf9999
Embedded Sql13
- 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/WRKQRY02
- WRKQRY
- QMQRY

Contact

Founder & Author - www.go4as400.com

Hi, this is Amit Jaiswal, founder/Author of www.go4as400.com. I am working as an IBM i/AS400 consultant. I love to do creative work, have passion to explore new things. I always try to make the things simple. The glimpse of the same, you can find at my website www.go4as400.com

Contact me at contactus@go4as400.com or fill the form below to send mail.

Name
Email
Subject
Message

Site Links

Home
AS400 chapters
AS400 FAQ
AS400 E-BOOKS
Contact

Subscribe

Email: