|
Do you need area codes?
Do you need ZIP Codes?
Do you need ZIP+4?
Do you need city or county names?
Do you need a dealer locator system?
We can HELP! We have affordable AS/400 software and data to do all of the above. Call us for 30 days FREE.
WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com
|
|
|
SEQUEL ViewPoint®--Data Access & Analysis for Power Systems Servers
· Easy to use by IT and end users
· Real-time data access and analysis
· Queries, reports, pivot tables, drill-down analysis, kpi dashboards
· IBM i-centric with multiplatform data access
· Expert support and training
· Secure data access
· GUI, Web & green screen interface
SEQUEL--Fast, efficient & cost-effective data analysis
Click here for a FREE Information Kit!
|
|
|
|
|
Distinctly Speeding Up DISTINCT
by Ted Holt
The DISTINCT keyword is a great example of the power of the SQL SELECT statement. Add this powerful word to any SELECT command and voilą! Duplicate rows magically disappear. Comments from readers have alerted me to the fact that some people find use of this feature confusing. Here are a brief discussion of DISTINCT and a performance tip. READ MORE >
|
|
|
~ ASK PAT ~
Free Security Advice from Patrick Botz
Need advice you can trust on security audits, PCI, HIPAA or SOX requirements, 3rd party software, rational password management, public authority or Security Level 40?
Spend an hour with Patrick Botz - FREE - and get actionable info and tips to get you started. Custom, 100% independent advice from the guy who helped architect Power Systems / IBM i security.
Click to set up your free session with Pat. World-class security expertise is no longer just for the big guys!
|

|
|
|
Hey! What Happened To My Last Used Dates
Hey, Joe:
After we upgraded our production system to new Power i hardware, the Last used date on all our system objects was reset to zeros. While this isn't a major problem, it does mean that we are no longer able to identify obsolete objects and files on our system. If we can't identify them, then we can't remove them. Is there any way to get this information back? READ MORE >
|
|
Reader Feedback and Insights
We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >
|
Senior Technical Editor: Ted Holt
Technical Editor: Joe Hertvik
Contributing Technical Editors: Erwin Earley, Brian Kelly, Michael Sansoterra
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
|
IT Jungle Store Top Book Picks
Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95
|
May 22, 2010: Volume 12, Number 21
May 15, 2010: Volume 12, Number 20
May 8, 2010: Volume 12, Number 19
May 1, 2010: Volume 12, Number 18
April 24, 2010: Volume 12, Number 17
April 17, 2010: Volume 12, Number 16
|
|
|
|
|