Fast guide to iSeries SQL

  Get familiar with 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 ...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT iSeries SQL commands and statements Enhancing RPG with external SQL stored procedures Tracking data changes on IBM i with triggers Introduction to SQLRPGLE on IBM i: Making a report Making the most of RPG data handling on IBM i When is the YES option for 'reuse deleted files' function the best choice? Monitoring members 'stuck' within a physical file on an EDI system Creating a host variable of the 'where in' statement in SQL SQL server error message -321 Choose which column names are returned via ODBC when working with DB2 files Convert a numeric physical file to a character in SQL without leading zeros iSeries SQL commands and statements Research SQL & Query Expert advice on SQL Audit the interactive SQL session

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

SQL into RPG LE programs on an iSeries running V5R3.

  SQL commands and statments 

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.