Forum: SQL

You should only do the declare once and only once. Take it out of this subroutine, and put it in your program initialization routine, or somewhere...

For better performance, I'd suggest a couple things: 1) Review the syntax of your SQL statement. There might be a more efficient way to write it. 2)...

** This thread discusses the article: TechTip: SQL and i5/OS Record Format Names ** ** This thread discusses the Content article: TechTip: SQL and...

You are on the right track. As IBM support once told me..."There is open, and there is open". The cursor you "close" in your RPG code is not really...

This has baffled me for a while. I will run an SQL statement using the DB Monitor and see what indexes are suggested. I will create that index by...

If I understood you, the VB code calls the CL, and the CL calls the RPG, which returns the Result set. Yes?

'JO%SEPH%' or 'JO_EPH%' for just a single character. The extra % at the end makes all the difference. I can't tell you exactly why, it just works. I...

So there is no need to build the first view ahead of time, you can define it on the fly, as you create sqlview2. <hr width=50 align=left>Code

** This thread discusses the article: Access Your iSeries Data Quickly and Simply ** ** This thread discusses the Content article: Access Your...

If this query is to be a permanent report you may want to try Query Manager, (STRQM) and imbed your SQL statements there and define a QM Form for it....

** This thread discusses the Content article: Partner TechTip: Work with Non-iSeries Data in iSeries Applications ** 0

** This thread discusses the article: Embedded SQL and Dynamic Sorting Subfiles ** Hi Kevin I have been given a project that requires the need to...

I did not get a chance to test the whole thing but try this... update test1 a set a.zona12 = (select coalesce(b.zona22,a.zona12) from test2 b where...