External stored procedure that reads from a data queue
External stored procedure that reads from a data queue In my previous article we created a stored procedure for writing data to the data queue usin…
AS400 and SQL Tricks posts blog on RPG, CL, ILE RPG, DB2 SQL, AS400 Interview Questions tutorial.
- Home
-
- 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
-
- 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
-
- 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 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 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
- AS400 Introduction
- Public IBM i Server
- AS400 Menu
- AS400 Subsystem
- AS400 Library
- Source PF
- Field Reference File
- RGZPFM
- PF vs LF
- CPYF
- CRTDUPOBJ
- CPYF vs CRTDUPOBJ
- Access Path and Type
- RPG Introduction
- RPG and ILE Specs
- Compiler Directive
-
- 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
- Sign Off
- About
- Contact
stored procedure
SQL stored procedure in IBM i
SQL Stored Procedure in IBM i What is SQL stored procedure in IBM i? The stored procedure in IBM i is the type of program which is written to perf…