|
|
Sponsored By
ADVANCED SYSTEMS CONCEPTS
|
|
SEQUEL can be used for virtually ALL data access functions on the iSeries.
A Windows-based user interface makes it easy to design queries and reports.
SEQUEL offers executive dashboards, drill-down data analysis and run-time prompts to deliver important iSeries data to managers and other non-technical users.
E-mail and FTP delivery let you deliver information to remote users and servers.
www.asc-iseries.com
|
|
|
Sponsored By
WORKSRIGHT SOFTWARE
|
|
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
|
|
|
Execute SQL Statements on DB2 UDB for Windows from the iSeries
by Michael Sansoterra
With the necessity of tight integration between platforms pervading many IT shops, I wondered what interoperability exists between the DB2 Universal Database (UDB) on the iSeries and DB2 UDB for Windows. After a little investigation, I was pleased to find that DB2 SQL on the iSeries can be used to execute SQL statements on the Windows DB2 platform as easy as it can on a different iSeries using IBM's Distributed Relational Database Architecture (DRDA). READ MORE >
|
|
Case-Insensitive Sorting and Record Selection with Query/400
Hey, Ted:
Thanks for explaining how to ignore case when sorting and selecting records with SQL. Can you tell me how to do the same with Query/400? READ MORE >
|
|
Sponsored By
PATRICK TOWNSEND & ASSOCIATES
|
|
Alliance AES/400
Database Field Encryption
· Encrypt credit card, social security, pin numbers and other
sensitive data.
· Easy to use with RPG or COBOL - sample code included.
· Get compliant - SOX, Privacy notification, GLBA, Etc.
· Free 30 day trial. Fully functional software - Not a demo.
Find out more at www.patownsend.com
Visit us for 30-day trial
Deploy. Run. Manage. Succeed.
|
|
|
|
Turning Off ODBC Journaling Is Not a Good Idea
Hey, Joe
After reading your column on "Curing the ODBC Blues," I came to the same conclusion that you did regarding how to avoid the SQL7008 error: You need to journal your OS/400 files to avoid ODBC update errors. But then someone showed me the ODBC advanced server option in the iSeries Access ODBC driver, where you can set your ODBC drivers' Commit mode to eliminate the need for journaling files updated by ODBC. This seems like a better solution. 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 >
|
|
Technical Editors: Howard Arner, Joe Hertvik, Ted Holt,
Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Marc Logemann, David Morris
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
|
|
|
|
Four Hundred Guru
|
|
