|
In This Issue
|
|
You Have Questions. The Gurus at Guild Companies Have Answers.
Sponsored By
ADVANCED SYSTEMS CONCEPTS
|
|
TOP TEN REASONS
Why You Should
Retire Query/400
Yes, there is a much better way!
Learn how you can access and present
AS/400 and iSeries
database information
without jumping through hoops.
Read More
|
|
Sponsored By
CLIENT SERVER DEVELOPMENT
|
|
LEARN SQL BY EXAMPLE!
Buy your copy of iSeries and AS/400 SQL at Work direct from the author, Howard F. Arner, Jr. This is THE BOOK to teach you SQL on the iSeries.
Howard takes you through SQL by example. The book comes with a CD that has all of the sample data and queries used in the book and a FREE copy of SQLThing that you can use to work through the examples.
Learn by doing! Order your copy at SQLThing.com today!
|
|
|
Uploading a Fixed-Length Record File
Hey, David:
Occasionally, I receive a fixed-length data file from our engineering department. I upload that file to our iSeries system and place it in a database file of 48-byte records. The file I receive contains a 48-byte ASCII record containing nine numeric fields that are 5 long with 2 decimal places. There are three unused characters at the end of each record. This file is one long string of characters and doesn't contain any carriage returns or line breaks.
READ MORE >
|
Recovering Client Access Sessions Quickly
In the March 19 issue, I answered a question about recovering disconnected Client Access sessions ["Recover Client Access Sessions More Quickly"]. Two readers suggested a better approach. Here is what one of them had to say.
--Ted
READ MORE >
|
Reader Feedback and Insights: More on "Why Java?"
Hey, Ted:
I'd like to comment on Gary's question ["Reader Feedback and Insights: Why Java?"]. For the past 18 months my shop has mastered eRPG (or CGI) programming on our iSeries. Instead of creating 25x80 green-screen applications, we now create killer browser apps that are fast, include graphics (both artwork-like icons and pictures and dynamic graphical representation of data, such as bar and line charts), and run off our "legacy" database. The users are extremely pleased; they've got a very robust, easy-to-use interface. On the back end, the RPG programmers are also very pleased because they are doing something mainstream--somewhat. I can't stress enough how incredible this journey has been. Our browser-based applications are a trillion times better than what was capable using a 5250 interface, and everyone knows it.
READ MORE >
|
Editors: Howard Arner, Joe Hertvik, Ted Holt, David Morris
Managing Editor: Shannon Pastore
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
|
|
|
|