How to read data from IFS file using SQL?
How to read data from IFS file using SQL? We have the stream files available in the IFS(Integrated File System) on IBM i and there are different w…
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
January 2024
*CAT, *BCAT, *TCAT in CL
*CAT, *BCAT, *TCAT in CL *CAT (concatenation, symbol ||) operator The *CAT operator concatenates two character strings. Blanks are also include…
CL command for Timestamp
CL command for Timestamp Sometimes there were the need of fetching the current system timestamp in the CLLE program. So, the question here is that …
Passing Variable Length fields between RPG and CL
Passing Variable Length fields between RPG and CL RPG IV program or procedures supports the variable length fields(using the VARYING keyword), howe…