Fast guide to iSeries SQL

[TABLE]

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.

[TABLE]

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.

[TABLE]

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 RE

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT iSeries SQL commands and statements When is the YES option for 'reuse deleted files' function the best choice? Convert a numeric physical file to a character in SQL without leading zeros Inserting data from a CTE into a file in SQL Implement variables in SQL when creating an alias Control and fix date format problems on AS/400 SQL Disable SQL query optimizer tool that removes trailing blanks Database drivers on the i: MySQL vs. IBM Toolbox How to: Output SQL script to a text file from an AS/400 IBM DB2 Connect allows SQL data sharing Size limit of DB2 table in V6R1 on IBM i 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

PLACE 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.

[TABLE]

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.