Need SQL tips and advice? We've compiled some some novice iSeries SQL tips and expert advice, as well as more advanced iSeries SQL information in this Fast guide to iSeries SQL. After you've spent somet time with the material, test your knowledge with our quick quiz.
| Get familair with the iSeries SQL |
SQL
FAQ: Common SQL questions, part 1
The introduction to this three-part SQL FAQs from SearchSQL.com begins with some fairly broad
aspects of using SQL.
Advantages
of SQL on the iSeries
How fast is SQL on the iSeries, and what are the advantages and disadvantages of using SQL on the
iSeries?
Access
data on an SQL server from the iSeries
ASK THE EXPERTS :How fast is SQL on the iSeries, and what are the advantages and disadvantages of
using SQL on the iSeries?
Create
a table using SQL
Expert help with creating a table using SQL.
| Using SQL views |
How
do you read a formatted dump of an SQL RPGLE program?
How do you read a formatted dump of an SQL RPGLE program and what do you look for?
Calling
an RPG LE program from a SQL trigger procedure
Is it possible to call an RPG LE program from SQL trigger procedure?
Embedding
SQL into RPG LE programs
Expert help on embedding SQL into RPG LE programs on an iSeries running V5R3.
| SQL commands and statements |
Use SQL to SELECT
data directly to a CSV file
This command will direct the results of any valid SQL SELECT statement directly into a CSV file in
the IFS.
SQL recursive
REPLACE command
Here's a SQL REPLACE() function that works like TRIM or SUBSTRING.
Use SQL to delete
duplicate records
This short command will delete duplicate keys in SQL.
Use the SQL Rename
command to make everyone happy
This command will direct the results of any valid SQL SELECT statement directly into a CSV file in
the IFS.
Run SQL statements
from the command line
Here's a quick way to evaluate information, such as mathematical formulas or file content, etc.
Interactive
SQL statements
Expert help with interactive SQL statements.
| Books on SQL for iSeries |
SQL Built-In
Functions and Stored Procedures -- Chapter 2
This chapter, " Built-In Functions ," from Stored Procedures and Built-In Functions by Mike Faust
(MC Press), will explore the BIFs included in the DB2 implementation of SQL on the iSeries.
SQL For Dummies,
Fifth Edition -- Chapter 1
This chapter, "Relational Database Fundamentals," from SQL For Dummies, Fifth Edition by Allen G.
Traylor (John Wiley & Sons Inc.) discusses data storage, how the relational model compare with
other major models, and the important features of relational databases.
SQL for eServer
i5 and iSeries -- Chapter 2
This chapter, "SQL in iSeries Navigator," from SQL for eServer i5 and iSeries by Kevin Forsythe (MC
Press.) explains how to use the SQL scripting tool included in iSeries Navigator, such as how to
configure the SQL script environment and run multiple SQL scripts.
This was first published in July 2007