ADVICE: >> SQL vs. DDS -- The good, the bad and the downright ugly TIP :What does DDL offer over DDS and vice versa? Let's take a look. >> Use SQL views to transfer packed data using FTP TIP :Here's an easy way to transfer packed data from an iSeries to an ASCII system. >> Use SQL to SELECT data directly to a CSV file TIP :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 TIP :Here's a quick way to evaluate information, such as mathematical formulas or file content, etc. >> SQL recursive REPLACE command TIP :Here's a SQL REPLACE() function that works like TRIM or SUBSTRING. >> Quickly find SQL error message descriptions TIP :Here's an easy method to learn details about those pesky and cryptic SQL error message codes. >> Use SQL to delete duplicate records TIP :This short command will delete duplicate keys in SQL. >> Find the maximum record count using SQL TIP :Retrieve the maximum count of the record using SQL. >> SQL: One SELECT for one or several row, same WHERE. TIP :select several rows or a row from a table. >> Use the SQL Rename command to make everyone happy TIP :Working with the SQL Rename command. >> How to update iSeries databases using JDBC, SQL TIP :The techniques detailed here will help you develop more efficient Java database applications. >> Using "exception join" in SQL TIP :SQL's "exception join" syntax is rarely understood and even more rarely used. >> Yet another SQL program TIP :Execute SQL via a standard command interface. >> Why do I keep getting SQL error SQL0204? ASK THE EXPERTS :I have written a user SQL function in which I make a call to a C program. When I try to use it, I obtain an SQL error ... >> SQL has stopped selecting records ASK THE EXPERTS :We have an application that uses SQL to select the records for a report. The application has been working with over 50 ... >> Possible to improve SQL query speed? ASK THE EXPERTS :SQL query is faster at second run because files are already loaded into memory and thus there is no I/O. How ... >> Advantages of SQL on 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? >> Interactive SQL statements ASK THE EXPERTS :I have written a front-end program to run interactive SQL statements. I am using a technique that executes the SQL statement ... >> Creating a date field using SQL ASK THE EXPERTS : I've created a table using SQL with a date field. I've used STRPDM to view the data in the date field and found ... >> Create a table using SQL ASK THE EXPERTS :I am trying to create a table using SQL. I would like the dates to be of the *USA (mm/dd/yyyy) format. All of our files have ...

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

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