Programming / SQL


Practical SQL: Don't Be Afraid of Recursion PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 21 October 2009 00:00

A word that sometimes strikes fear into the programmers, "recursion" is sometimes the only tool for the job, and this article shows you how to recurse in SQL.

joe_plutaWritten by Joe Pluta

Today's article is very simple and straightforward. I'm going to present you with one of the more complex basic SQL statements you'll run across and then break it down piece by piece. I know that the "complex basic" seems somewhat paradoxical, but it's not. The SQL statement I'll be showing you is basic because it has no frills; pretty much everything in the statement is needed to do what we need to do. At the same time, the statement is complex because even at its minimum the statement requires a lot of moving parts. Fear not, gentle reader, I shall act as your guide through this dangerous territory, and at the end, you'll have yet one more powerful weapon in your programming arsenal.

Add a comment
Last Updated on Friday, 04 December 2009 15:39
Read more...
 
User Rating: / 2
PoorBest 
Practical SQL: More Dynamic Selection Criteria PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 02 September 2009 00:00

One of the most common issues in SQL is dealing with dates. This article will introduce you to the joys of dates, both legacy and date data type.

joe_plutaWritten by Joe Pluta

With the introduction of the date data type (and its siblings, the time and timestamp data types), the i5/OS database took a huge step forward. And although RPG's acceptance was a little more grudging, we eventually got to where we are today. However, if you're like many shops, you may have to deal with both legacy dates and date-type dates. And when you're talking about user-controlled queries, you still have to get those date values from the user via fields on the screen.

Add a comment
Last Updated on Wednesday, 02 September 2009 00:00
Read more...
 
User Rating: / 2
PoorBest 
Practical SQL: Dynamic Selection Criteria PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 05 August 2009 01:00

It's one thing to create a great SQL query; it's another thing entirely to let your users do it dynamically.

joe_plutaWritten by Joe Pluta

SQL is not a difficult syntax; it was designed to be relatively easy to use even for non-programmers, and it lives up to that goal. Selecting and sorting data is pretty straightforward: the WHERE clause and the ORDER BY do the heavy lifting. The harder part comes when the user wants to select a specific part number or a date range or a list of states or a combination of those or none at all. In this article, I'll show you the brute force method and then something a little more elegant and better-performing to boot!

Add a comment
Last Updated on Tuesday, 04 August 2009 09:44
Read more...
 
User Rating: / 2
PoorBest 
Optimize Your SQL Statements with Visual Explain PDF Print E-mail
Programming - SQL
Written by Guest.Visitor   
Wednesday, 05 August 2009 01:00

Learn how to use this GUI tool to improve your SQL statements.

kevin_forsytheWritten by Kevin Forsythe

Writing SQL statements that function correctly and deliver the desired results is only half the battle. We also need to manage the performance of those SQL statements. This might involve things such as how we write the statements, what indexes are in use, and what SQL engine is processing the statement. The Visual Explain tool within System i Navigator helps us manage all that and more.

Add a comment
Last Updated on Wednesday, 05 August 2009 01:00
Read more...
 
User Rating: / 4
PoorBest 
Practical SQL: Archiving Data with SQL PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 01 July 2009 01:00

SQL excels at set-at-a-time processing, and what better application than archiving your data?

joe_plutaWritten by Joe Pluta

No matter how much disk you have, you fill it. It's a corollary to Parkinson's Law, which posits that work expands to fill the time allotted. It's the same with databases; despite the ever-increasing amount of disk available (who could have imagined a 2TB disk for the home computer?), you will always run out, so at some point you will have to reduce the amount of data in your database. As it turns out, though, SQL can provide you with significant help.

Add a comment
Last Updated on Tuesday, 30 June 2009 10:22
Read more...
 
User Rating: / 9
PoorBest 
Run SQL from a Source Member Using RUNSQLSTM PDF Print E-mail
Programming - SQL
Written by Thomas Snyder   
Wednesday, 03 June 2009 01:00

You don't need to write a program to run common SQL statements.

tom_snyder.jpgWritten by Tom Snyder

Do you have common SQL statements that you run on a regular basis but haven't found the time to put into a program? Do you try to remember the SQL statement that you ran last time, or do you keep notes to manually recall those statements interactively every time you need them?

Add a comment
Last Updated on Tuesday, 02 June 2009 12:46
Read more...
 
User Rating: / 9
PoorBest 
 
User Rating: / 17
PoorBest 
 
User Rating: / 20
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 6 of 14

WEBCAST

MC Webcast CenterFEATURED WEBCAST

See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

 

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 

 

Watch the Webinar Now!

 

TRIAL SOFTWARE

MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.

   MC-STORE.COM