Programming / SQL


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 
 
User Rating: / 14
PoorBest 
 
User Rating: / 15
PoorBest 
 
User Rating: / 4
PoorBest 
 
User Rating: / 12
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 6 of 13

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