|
Advanced Query/400: Learn the Secrets
When it comes to Query/400, "advanced" is in the eye of the beholder.
While it is true that the tool can handle functions beyond static queries, the dependent variable functions we detail in this guide represent the limits of Query/400's ability to perform more in-depth tasks. However, many shops still rely on basic query tools, for better or worse, and we want to help you make the most of them.
Download the free Advanced Query/400 Pack.
|
|
|
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
|
|
|
Accessing Multiple DB2 Relational Databases In A Single Query
by Michael Sansoterra
In my prior tip, I covered a new feature provided in the i7.1 technology refresh 4 update that allows a INSERT/SELECT statement to insert data into a local DB2 for i table from a query against a remote DB2 database. In this tip, I will cover a method that can be used to query multiple DB2 relational databases in a single statement. READ MORE >
|
|
|
Composing An XML Document From Relational Data, Part 1
Hey, Mike:
My boss asked me if I know of a cheap or free tool that can automatically export a DB2 (for i) table to an XML file. I told him that I could write a Java program pretty easily that could accomplish this for a specific table, but I'm not aware of any way to generically do it for any table. READ MORE >
|
|
|
Upgrade Your Skills at the Summit!
Rise to the i can . . . can you? challenge at the RPG & DB2 Summit Oct 23-25 in Minneapolis.
Learn the latest in practical, use-it-today tips and techniques on RPG IV, embedded SQL, PHP, RPG & the Web, RSE/RDP, Web Services, mobile apps, DB2 for i, SQL tuning & more!
Plus get 1-on-1 advice from top experts Susan Gantner, Jon Paris, Paul Tuohy, Scott Klement, Mike Cain, Kent Milligan in a highly interactive, fun environment.
Check out the sessions and register by August 31 for just $1095 - save $300!
|
|
|
|
Admin Alert: The Right Way To Delete User Profiles, Part 2
by Joe Hertvik
Last issue, I introduced a two-part article discussing techniques for deleting user profiles. Part one focused on prepping a user profile for deletion. In part two this week, I discuss how to determine whether the user is a critical user and what to do about it, and I demonstrate three techniques for deleting users. After reading both articles, you will have a good template for creating an IBM i user deletion procedure in your organization. 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: Edwin Earley, Brian Kelly, Michael Sansoterra
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
August 4, 2012: Volume 14, Number 31
July 28, 2012: Volume 14, Number 30
July 21, 2012: Volume 14, Number 29
July 14, 2012: Volume 14, Number 28
July 7, 2012: Volume 14, Number 27
June 30, 2012: Volume 14, Number 26
|
|
|
|
|
