|
DBU 9.0 Now Available!
Just when you thought DBU had it all, we've added MORE!
• New DBUSQL command
• Enhanced Audit Logging
• Execute DBUJRN in batch
• Supports DBCS for Chinese, Korean and
Japanese
• Wizard-based DBU security set-up
And MORE!
Download today!
800.228.6318
www.DoDBU.com
|
|
|
Discover how SEQUEL simplifies EnterpriseOne data access
Join SEQUEL Software for a FREE Webinar
on Aug 25 to explore the benefits of using SEQUEL with EnterpriseOne.
By adding SEQUEL to EnterpriseOne, you can simplify access to database files, link to
data dictionary files to create new views of
the data, easily convert dates to
date data types, and more.
Click here to learn more or to register.
|
|
|
Remove Trailing Blanks from Legacy Columns with the IBM OLE DB Providers
by Michael Sansoterra
It's no secret that many legacy tables in DB2 for i contain fixed-width character columns. If you present this legacy data to users using common tools such as Excel, Access, or even an application data grid control, they're likely to be annoyed. Why? Because everyone hates fiddling with trailing spaces that are part and parcel of fixed-width columns. If you have a 50-character address column with only 20 characters filled, that leaves 30 annoying trailing spaces to remove. READ MORE >
|
|
|
How Did I Do That?
Hey, Ted:
Your tip for building spreadsheets from SQL statements is spot on. The problem I used to have is that people would come back to me days, weeks, or even months later, asking for me to rerun my query to give them current data. I no longer have that problem, and here's why. READ MORE >
|
|
|
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
|
|
|
|
Admin Alert: Six Things You May Not Know About i/OS Passwords
by Joe Hertvik
Think you know everything about i/OS passwords? Here's a list of six commonly missed aspects of iSeries, System i, and Power i passwords. If you're a password pro, you may already be aware of three or more of these tips. If not, you may learn something that can help you enhance your i/OS password architecture. 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
|
August 7, 2010: Volume 12, Number 32
July 31, 2010: Volume 12, Number 31
July 24, 2010: Volume 12, Number 30
July 17, 2010: Volume 12, Number 29
July 10, 2010: Volume 12, Number 28
July 3, 2010: Volume 12, Number 27
|
|
|
|
|
