Learning Guide

Fast guide to iSeries SQL

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: