ADVICE: >> Stored procedures allow you to balance network loads – Part II TIP :In part two of this series on SQL stored procedures, Ron Turull explores how it can help optimize client/server applications, ... >> Stored procedures: Balance network loads -- part 1 TIP :SQL stored procedures provide an excellent tool to help optimize client/server applications. >> SQL Built-In Functions and Stored Procedures -- Chapter 2 TIP :Built-In Functions will explore the BIFs included in the DB2 implementation of SQL on the iSeries. >> How to generate reports using stored procedures TIP :Third-party reporting tools aren't always the best option when generating reports from data on several types of databases. ... >> Print PDF documents that are stored in IFS ASK THE EXPERTS :How can I print PDF documents that are stored in IFS? The PDF's contain images and text; I want to print them on Laser ... >> Invoking a stored procedure from a COBOL program ASK THE EXPERTS :I am attempting to invoke a stored procedure (SQL) from a COBOL program. The stored procedure returns ONE result set, so the ... >> Copy stored procedures from one library to another ASK THE EXPERTS : I have several Stored Procedures created on the iSeries in which I can view through iSeries Navigator. I need to copy ... >> Removing stored procedures ASK THE EXPERTS :How can I remove some of the stored procedures on my iSeries? >> Transferring stored procedures ASK THE EXPERTS :I have two iSeries machines. I'd like to take the stored procedure that is running on one of them and then select the data ... >> What ports are needed to issue a stored procedure? ASK THE EXPERTS :I want to issue a stored procedure command from an ASP page to an iSeries DB2 database across my firewall. What ports do I ... >> Where is physical data for spooled files stored? ASK THE EXPERTS : I read information a while back that the spool file data is stored in a physical file on the iSeries. Can you please tell ... LEARNING TOOLS: >> Guide to IBM redbooks on iSeries stored procedures

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT iSeries SQL commands and statements Enhancing RPG with external SQL stored procedures Tracking data changes on IBM i with triggers Introduction to SQLRPGLE on IBM i: Making a report Making the most of RPG data handling on IBM i When is the YES option for 'reuse deleted files' function the best choice? Monitoring members 'stuck' within a physical file on an EDI system Creating a host variable of the 'where in' statement in SQL SQL server error message -321 Choose which column names are returned via ODBC when working with DB2 files Convert a numeric physical file to a character in SQL without leading zeros iSeries SQL commands and statements Research

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