Skip to content
Menu
  • Contact
  • Downloads
  • My Account
SQL RegExPosted onJune 26, 2017May 30, 2018

SQL RegEx : Predefined Character classes

Most of RegEx engines support a good number of predefined character classes. These are kind of shortcuts to the widely used character classes. These predefined Character…

Read More
SQL RegExPosted onJune 26, 2017May 30, 2018

SQL RegEx : Character Classes

Character Classes or Character Sets are used to define a list of characters to be used inside a RegEx. Represented using square brackets […] Characters inside the…

Read More
SQL RegExPosted onJune 26, 2017May 30, 2018

SQL RegEx : Meta Characters

RegEx Meta characters are similar to Keywords in programming languages. They have special meaning in RegEx. Here is a list of meta characters- 210-060 questions…

Read More
SQL RegExPosted onJune 26, 2017May 30, 2018

SQL RegEx : Basic

Regular expression (aka RegEx) is a way to define the pattern of any text. This pattern can represent  the complete text or a part of…

Read More
DOWNLOADSPosted onJanuary 29, 2017January 10, 2020

QSql: Browser based SQL client for IBM I

[Q]SQL : Browser based SQL client for IBM I. GitHub REPO

Read More
RPGPosted onDecember 18, 2016December 26, 2016

Numeric Datatypes in RPG : FLOAT

FLOAT is also a type of binary data type. Due to IEEE standards, most of the programming languages handle FLOAT in the same way. INTEGER…

Read More
SQL OLAPPosted onDecember 8, 2016December 16, 2016

DB2 SQL OLAP : GROUPING SETS

With “GROUP BY” clause SQL accept a single set of columns and based on that set final result is produced.

Read More
SQL OLAPPosted onDecember 7, 2016December 16, 2016

DB2 SQL OLAP : ROLLUP and CUBE

ROLLUP and CUBE both are extensions for “GROUP BY”clause.

Read More
SQL OLAPPosted onDecember 7, 2016December 10, 2019

DB2 SQL OLAP : RANK and DENSE_RANK

In any exam how are participants are ranked ? Participant(s) with highest marks got the 1st rank. Participant(s) with 2nd highest marks got the 2nd rank…

Read More
SQL OLAPPosted onDecember 6, 2016June 16, 2017

DB2 SQL OLAP : ROW_NUMBER

ROW_NUMBER is the most basic OLAP function. It is very easy, powerful, and very handy to use function. ROW_NUMBER assigns a temporary number to each row…

Read More
SQL OLAPPosted onDecember 5, 2016December 11, 2019

DB2 SQL OLAP : OnLine Analytical Processing BASIC

OLAP functions : OnLine Analytical Processing functions What is online here? An online algorithm is one that can process its input piece-by-piece in a serial fashion”.…

Read More
RPGPosted onDecember 2, 2016December 16, 2016

Numeric Datatypes in RPG.

RPG has multiple numeric datatype support. Other then  TWO most famous ZONED and PACKED numbers there are BINARY , INTEGER and FLOAT.

Read More
SQL DYNAMIC SQLPosted onNovember 2, 2016December 16, 2016

DB2 DYNAMIC SQL : PREPARE and EXECUTE

If you need to run the same dynamic SQL statement more than once per job use the PREPARE – EXECUTE statements using EXECUTE IMMEDIATE incurs…

Read More
DOWNLOADSPosted onJune 18, 2016July 16, 2020

WrtSFL : Write complete Subfile code in less than 20 seconds.

Description This utility can write Subfile code for any given SQL select statement with little or no user interaction. It takes less than 20 seconds…

Read More
SQL DYNAMIC SQLPosted onApril 5, 2016May 30, 2018

DB2 DYNAMIC SQL : EXECUTE IMMEDIATE

EXECUTE IMMEDIATE is simple option to execute a Dynamic SQL. Here is an example TableName = ‘CUSTOMER’; SQLString = ‘DELETE FROM ‘+ %TRIM(TableName) ; EXECUTE…

Read More

Posts navigation

Previous Page Page 1 Page 2 Page 3 … Page 5 Next Page

Categories

  • ►DOWNLOADS (3)
  • ►Embedded SQL (5)
  • ►Free Format RPG (2)
  • ►IBM i SQL (58)
    • ►Index (4)
    • ►Java (4)
    • ►SQL BASIC (9)
    • ►SQL CURSOR (5)
    • ►SQL DB GENERATED SEQUENCE (4)
    • ►SQL DYNAMIC SQL (3)
    • ►SQL JOINS (5)
    • ►SQL OLAP (5)
    • ►SQL RegEx (7)
    • ►SQL SET OPERATIONS (4)
    • ►SQL TABLE EXPRESSION (3)
    • ►SQL Table Functions (1)
  • ►RPG (4)
  • ►TechTips (3)
  • ►Uncategorized (4)

Featured Downloads

  • Download “QSQL” QSQL.zip – Downloaded 1226 times – 24 MB

  • Download “WrtSFL 1.1.0” WRTSFL-3.zip – Downloaded 6913 times – 4 MB

Recent Comments

  • Sabarish on WrtSFL : Write complete Subfile code in less than 20 seconds.
  • Jorge Terrero on WrtSFL : Write complete Subfile code in less than 20 seconds.
  • Jorge Terrero on WrtSFL : Write complete Subfile code in less than 20 seconds.
  • Robert on WrtSFL : Write complete Subfile code in less than 20 seconds.
  • kapil Tiwari on iAccess: Android app to access IBM I(R)
© Copyright 2020 – QSYS400.com
Allium Theme by TemplateLens ⋅ Powered by WordPress