|
In This Issue
|
|
You Have Questions. The Gurus at Guild Companies Have Answers.
Sponsored By
 ADVANCED SYSTEMS CONCEPTS
|
|
Dramatically Improve Data Access at Your AS/400 or iSeries Site.
Learn how in just 6 short minutes!
Download a SEQUEL ViewPoint ScreenCam movie and find out how simple AS/400 and iSeries data access can be.
In just a few short minutes, you can find out ways to make your job easier and improve data access throughout your organization!
Download Here
|
|
Sponsored By
 COMMON
|
|
REGISTER FOR COMMON IN DENVER,
OCT. 13-17
Get the IT training you need by attending COMMON Users Group's Fall 2002 IT Education Conference & Expo, October 13-17 in Denver.
Early Bird registration $1,150 until September 4.
Choose from over 720 sessions and labs covering a wide range of industry topics. Also receive training from J.D. Edwards, MAPICS, and other vendors.
Don't miss out!
Go to www.common.org
|
|
|
Make an SQL UDF Return Null
Hey, Ted:
In the October 19, 2001 Midrange Guru, OS/400 Edition, you showed how to use an RPG subprocedure in a service program as an SQL user-defined function . Can you tell me how to write a similar function that can return a null value?
-- Marty
READ MORE >
|
SQL Functions for Mashing Characters
Hey, Howard:
I have a field that has embedded '-' characters that I want to remove. For example, if the field contains 01-111-3345, I want to return it as 001113345. However, the translate function does not accept an empty string. Can you tell me how to remove characters from a string in SQL?
-- Mike
READ MORE >
|
Reader Feedback and Insights: Using Timestamps as Unique Keys
In response to your article in the July 17 Midrange Guru, OS/400 Edition, the short answer is this: You can't get there from here. I posed this same question to IBM several months back and got some ridiculous suggestion about writing a record to a dummy file with a timestamp in it, then read it back and use the timestamp of that record. Huh?
-- Abe
READ MORE >
|
|
|
Subscription Information: To unsubscribe, change your email address, or sign up for any of Guild Companies's free e-newsletters, visit http://www.itjungle.com/sub/subscribe.html
This page is best viewed at 800x600 with Netscape or IE browsers 4 or higher.
|
|
Editors
Howard Arner
Joe Hertvik
Ted Holt
David Morris
Managing Editor
Mari Barrett
Contact the Editors
Do you have a gripe, inside dope or an opinion?
Email the editors:
editors@itjungle.com
|
