Skip to main content

PartnerWorld > Products > Systems, servers, and storage > Technical >

Moving from OPNQRYF to SQL

by Gene Cobb

Last updated: 2012-10-01

PDF iconDownload the white paper (532 KB)
Links to external URLGet Adobe® Reader®

 
Rate this article
  Feedback

© Copyright IBM Corporation, 2008. All Rights Reserved.
All trademarks or registered trademarks mentioned herein are the property of their respective holders.

Abstract
This white paper discusses the major advantages that SQL has in comparison to the IBM i5/OS Open Query File (OPNQRYF) command. It also provides a methodology for converting OPNQRYF applications to an SQL-based model, as well as some key points to consider during the conversion process.
Introduction
This white paper discusses the major advantages that SQL has in comparison to the IBM i5/OS Open Query File (OPNQRYF) command. It also provides a methodology for converting OPNQRYF applications to an SQL-based model, as well as some key points to consider during the conversion process.