AS400 and SQL Tricks

AS400 and SQL Tricks posts blog on RPG, CL, ILE RPG, DB2 SQL, AS400 Interview Questions tutorial.

Terms
Policy
Sitemap

Home
IBM i Interview QnA
- Interview QnA 1
- Interview QnA 2
- Interview QnA 3
- Interview QnA 4
- Interview QnA 5
- Interview QnA 6
- Interview QnA 7
- Interview QnA 8
- Interview QnA 9
- Interview QnA 10
- Interview QnA 11
- Interview QnA 12
- Interview QnA 13
- Interview QnA set
- Interview QnA 14
- Interview QnA 15
- Interview QnA 16
- Interview QnA 17
- Interview QnA 18
- Interview QnA 19
- Interview QnA 20
- Interview QnA 21
- Interview QnA 22
- Interview QnA 23
- Interview QnA 24
- Interview QnA 25
- Interview QnA 26
- Interview QnA 27
- Interview QnA 28
- Interview QnA 29
- Interview QnA 30
- Interview QnA 31
- Interview QnA 32
- Interview QnA 33
- Interview QnA 34
- Interview QnA 35
- Interview QnA 36
DB2 Interview QnA
- DB2 Interview Q1
- DB2 Interview Q2
- DB2 Interview Q3
SQL Interview QnA
- SQL Interview Q1
Compilation Error
- RNF5199
RunTime Error
- Coming soon...
Email on IBM i
- Send Email Program
IFS
- Intro to IFS
- IFS Directories
- IFSPath/Stream file
- CPYTOSTMF
- CPYFRMSTMF
- CPYTOIMPF
- CPYFRMIMPF
- Generate PF -> CSV
- Import CSV -> PF
- open() api in RPG
- write() api in RPG
- read() api in RPG
- close() api in RPG
- ifs write-read RPG
- ifs Hello World App
- ifs error handling
- ifs write Varying
- access() api in RPG
- chmod() api in RPG
- stat() api in RPG
- unlink() api in RPG
- rename() api in RPG
- lseek() api in RPG
- Create IFS TextFile
- Read IFS TextFile
- Create ASCII File
- Create CSV in RPGLE
- Append ifs file RPG
- Create HTML ifsfile
- write unicode ifs
- write Var unicode
- mkdir() in RPGLE
- rmdir() in RPGLE
IFS using SQL
- Read IFS file by SQL
FTP
- Download Lib/Obj
- Upload Lib/Obj
- Download SrcMbr
- Upload SrcMbr
- FTP loopback
- FTP(Local -> Remote)
- FTP(Remote -> Local)
- Download Savefile
- Upload Savefile
- Batch FTP in IBM i
- Submit Batch FTP
- FTP CL Subcommand
- STRTCPFTP
- RemoteFTP STRTCPFTP
- ASCII
- BINARY
- EBCDIC
Fully Free RPG
- Fully Free statement
- H/F/D/P specs
- F Specs
- D Specs
Advanced RPG
- Numeric to char
DDS to DDL
- CRTPF/Create table
- Primary Key
- Data Validation
- Column Heading
- Column Text
- DDL File Attributes
- Auto Update Timestamp
- DDL Constraints
- Index
- View
- Modernization
- Identity Column
- QSQGNDDL API
- QSQGNDDL Example
- SQL/File term
DB2 for i SQL
- Create Schema
- Create Table LIKE
- Create Table AS
- Global Temp Table
- Create table remote
- DDL Audit Columns
- Crt/Alt IdentityCol
- Create/Use Sequences
- SYSTABLES
- SYSCOLUMNS
- CREATE VIEW
- CREATE INDEX
SQL Tutorial (DB2i)
- SQL SELECT
- SQL WHERE
- SQL GROUP BY
- SQL HAVING
- SQL ORDER BY
- SQL NULL Values
- SQL Special Register
- SQL DISTINCT
- SQL BETWEEN
- SQL IN
- SQL EXISTS
- SQL LIKE
- SQL Aliases
- SQL AND
- SQL OR
- SQL NOT
- SQL JOIN
- SQL INNER JOIN
- SQL LEFT OUTER JOIN
- SQL RIGHT OUTER JOIN
- SQL EXCEPTION JOIN
- SQL CROSS JOIN
- SQL FULL OUTER JOIN
- SQL SELF JOIN
- How SQL JOIN works?
- SQL UNION
- SQL EXCEPT
- SQL INTERSECT
- SQL ANY
- SQL ALL
- SQL CASE
- SQL LIMIT
- SQL FETCH FIRST
- SQL INSERT INTO
- SQL INSERTwithSELECT
- SQL UPDATE
- SQL DELETE
SQL Scalar Function
- SQL ABS or ABSVAL
- SQL ADD_MONTHS
- SQL ASCII
- SQL CEILING or CEIL
- SQL CHAR
- SQL COALESCE
- SQL CONCAT
- SQL DATE
- SQL DAY
- SQL DAYOFWEEK
- SQL DAYOFYEAR
- SQL DAYS
- SQL DECIMAL or DEC
- SQL DIGITS
- SQL EXTRACT
- SQL FIRST_DAY
- SQL FLOOR
- SQL GRAPHIC
- SQL GREATEST
- SQL HEX
- SQL HOUR
- IDENTITY_VAL_LOCAL()
- SQL IFNULL
- SQL INSERT(string)
- SQL INTEGER or INT
- SQL LAST_DAY
- SQL LENGTH
- SQL LOCATE
- SQL LOWER/LCASE
- SQL LTRIM
- SQL MAX
- SQL MICROSECOND
- SQL MIN
- SQL MINUTE
- SQL MOD
- SQL MONTH
- SQL NULLIF
- SQL POSITION
- SQL POSSTR
- SQL QUARTER
- SQL RAISE_ERROR
ASCII Table
SQL Trigger
- SQL Trigger Concept
- SQL Trigger Syntax
- Simple Trigger
- Conditional Trigger
- OF CLAUSE Trigger
- Multi Event Trigger
- BEFORE SQL Trigger
- Stored Procedure
- Transition Table
- Error Handling
- Self Referencing
- INSTEAD OF Trigger
- Trigger Limitations
- Trigger Case
- SYSTRIGGERS Catalog
- SYSTRIGDEP
- SYSTRIGUPD
- SYSTRIGCOL
SQL Stored Proc
- SQL Procedure Intro
Ext. Stored Proc
- Proc with no parm
- Proc with In parm
- Proc - InOut parm
- SRVPGM Proc InOut_parm
- Write to Data Queue
- Read from Data Queue
SQL Table function
- SQL to get Job Info
STRSQL Issues
- SQL shows POINTER
ACS
- Run SQL Script Fix
- CCSID 65535Fld Error
CL & RPG Support
- Pass VarLen CL->RPG
AS400 Introduction
Public IBM i Server
AS400 Menu
AS400 Subsystem
AS400 Library
Source PF
SEU
- SEU
- SEU Session Default
- SET Command
- LINE Command
- Display Column Line
- Display Format Line
- Prompt Line Command
- Change Display
- Find And Change
- Browse And Copy
- Command Line Command
Physical File
- Physical file
- PF Data Type
Field Reference File
RGZPFM
Multimember PF
- Multimember PF
- Insert Records
- Display Records
- Copy/Clear/Remove
- SQL Operations
Logical File
- Logical File
- Non-Join LF
- Join LF
- Join LF with two PF
- Multiple PF Join LF
- JDUPSEQ
- JLF Field Attributes
- Field Exception
- Key Fields
- JLF Example
- Self Join
- Select/Omit
PF vs LF
CPYF
CRTDUPOBJ
CPYF vs CRTDUPOBJ
Flat File
- Flat file
- READ Flat File
- User WRITE Flat File
- UPDATE flat File
- DELETE Flat File
Access Path and Type
Data Area
- Data Area
- Remote Data Area
- *LDA/*GDA/PIP DTAARA
Array and Types
- Array and Types
- Compile Time Array
- PERRCD Keyword
- Run Time Array
- Pre-Run Time Array
Array Operations
- LOOKUP
- SORTA
- XFOOT
Data Structure
- DS and type
- Divide DS Fields
- Group DS Fields
- External DS
- EXTFLD
- PREFIX
- LIKEREC
- LIKEREC Vs EXTNAME
- Multi Occur DS
- Data Area DS
- *LDA DS
- INFDS
- Indicator DS
- PSDS
- QUALIFIED,LIKEDS,DIM
- Array DS
- DS As Parameter
RPG Introduction
RPG and ILE Specs
Compiler Directive
RPG Error Handling
- PSDS With *PSSR
- INFDS With INFSR
DSPF Keywords
- ALARM
- ALIAS
- ALTHELP
- ALTNAME
Subfile
- Subfile and Types
- Load-All Subfile
Printer Files
- PRTF Intro
- Internal PRTF
- External PRTF
- SPACEA
- SPACEB
CL Programing
- CL Introduction
- CL Program
- IBM i Objects
- CL Uses/Limitations
- Parts Of CL Source
- Create CL Program
- Using Quotes in CL
- CHKOBJ in CL
- QCMDEXC in CL
- CL Subroutine
- CL Selective Prompt
- Make prompt select
- Using QCMDCHK in CL
- Prompt QCMDCHK in CL
- CL FTP Subcommands
- Using outfiles in CL
- OVRDBF and DLTOVR
- Read by RRN in CL
- Read FlatFile in CL
- Read PF in CL
- Using OPNID in CL
- CALL and CALLPRC
- TRFCTL in CL
- IFS access api in CL
- CL cmd for TIMESTAMP
- *CAT, *BCAT, *TCAT
User-Defined Option
AS400 Limits
AS400 Locks
AS400 Debug
- Debug Batch Job
- STRDBG Vs STRISDB
AS400 Jobs
- AS400 Jobs
- JOBD
- Job Queue
- Output Queue
- WRKSPLF
- WRKJOB
- SBMJOB
- Batch Job
- WRKACTJOB
- WRKUSRJOB
- WRKSMBJOB
- HLDJOB,RLSJOB,ENDJOB
- JOB Status
- Job Log
- DSPJOBLOG
MSGQ and Types
- MSGQ and Types
- Workstation MSGQ
- User Profile MSGQ
- Job MSGQ
- System Operator MSGQ
- History Log MSGQ
- Manage own MSGQ
Data Queue
- Data Queue
- QSNDDTAQ
- QRCVDTAQ
Journaling
- Journaling Intro
Sign Off
About
Contact

Celebration

Welcome to the Launch of redesigned website www.AS400andSQLTricks.com on the new Year 2022. (Happy New Year)

Welcome to the Launch of www.AS400andSQLTricks.com Welcome and Happy New Year First of all a very warm Welcome and a prosperous Happy New Year t…