Home > Ask the AS/400 Experts > iSeries Systems Management Questions & Answers > Embedding SQL into RPG LE programs
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Embedding SQL into RPG LE programs

Glen H. Bunnell EXPERT RESPONSE FROM: Glen H. Bunnell

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 04 February 2005
We have an iSeries running V5R3. We're working on embedding SQL into RPG LE programs and then creating stored procedures using this or a CLLE program. These stored procedures are then called from VB.NET. The programs on the iSeries create files in the QTEMP library and it is this data that is returned using the result set of SQL. We've got this working, but we've come up with some questions regarding how the iSeries handles it.

The VB.NET app calls the stored procedures on the iSeries by using the QZDASOINIT program in the QUSRWRK subsystem. Should there be a new instance of the QZDASOINIT program for each call of the stored procedure (if two different users make requests)? Are we "asking for trouble" by using files in QTEMP (we make sure they are cleared)? Do we need to worry about closing the QZDASOINIT program when a user closes their Web browser? If so, how?


>
I am not running V5R3 as of yet and have no knowledge of VB.NET, so my answer will be based upon my experiences in V5R2. I do not believe there should be a new instance of QZDASOINIT for each call of the store procedure, but a new instance for each access from the Web browser by user. So if the user "logs in" and runs several applications, logs out, then relogs in later, I would expect two different instances of the QZDASOINIT. As a general rule, using QTEMP is a good way to ensure that each person is getting only the data they request. Therefore, I think using QTEMP is a good idea and will be a way of maintaining data integrity.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: Tips, tutorials and more.

Visit the ITKnowledge Exchange and get answers to your systems management questions fast.

Read this Search400.com Featured Topic: Take control of your iSeries.

Ask the Experts yourself: Our systems management gurus are waiting to answer your technical questions.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
iSeries Systems Management
Transfer files from one environment to another without closing all other AS/400 sessions
Send a *LMSG successfully on AS/400 using the SNDDST command
Extend storage capacity on an IBM i without negatively effecting system performance
Configure the iSeries v5r4 to open the HTTPS port for incoming connections
Changing system CCSID
Changing user password expiration
Detecting system changes made by outside IP address
HIPER PTF installation and cover letters for SF99097
Library QUSRSYS not completely installed
SQL statement history storage

Past Releases
iSeries i5/OS: Top 10 Q&As
iSeries i5/OS: Top 10 Q&As
Error message within the printer file
How often are message queues cleared?
Connect the dots: Get your iSeries servers talking to one another
In search of a table that shows system & O/S release compatibility
V5R3 view disk IOA cache battery expiration
New option within the WRKSYSACT command
See the users with *change or *all authority
Copy a spoolfile (report) into the IFS as a .txt file

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
AS/400  (Search400.com)
i5/OS  (Search400.com)
iSeries  (Search400.com)
OS/400  (Search400.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts