|
To narrow the number of results, you can enter a search term. Page through the results or display all the results by clicking Show all. To see more information about a code listing, click on the title.
To submit, click Submit in the Exchange options box on the right side of this page. |
|
|
|
|
|
|
|
|
|
|
|
|
|
Recursive SQL Example
- Version 1.0
Recursive SQL to generate Fibonacci numbers (1, 1, 2, 3, 5, 8, etc) -- each Fibonacci number is the sum of the two previous Fibonacci numbers; F(1) and F(2) are each defined to be =1. Thus F(3) = 2, F(4) = 3, F(5) = 5, etc. |
|
PhilSevetsonDB2DBA
|
|
Nov 9, 2009 10:46 AM |
|
No ratings
|
|
| |
|
|
|
|
|
|
|
|
|
|
V7SELECT - An easy alternative to using SELECT * and dealing with DB2 V8 wide Catalog column values
- Version 1.0
With DB2 V8 and higher, issuing SELECT * from SPUFI results in a very wide display of output columns due to the increase in width of many system table columns. This REXX Edit Macro generates the equivalent of a SELECT *, but specifies all columns in the select list, and truncates all VARCHAR(128) fields into VARCHAR(18) fields. The net result produces output similar to what was produced in DB2 V7 and prior. |
|
ToddBurchDB2
|
|
Nov 5, 2009 1:18 PM |
|
No ratings
|
|
| |
|
|
|
|
|
|
|
|
|
|
BLDFETCH - A DSNREXX Rexx exec to generate a FETCH INTO statement
- Version 1.0
BLDFETCH is an Edit macro that will take an SQL SELECT statement as input and generate a DSNREXX-style FETCH INTO statement that matches the SELECT. The FETCH statement will be inserted into your Edit session. |
|
ToddBurchDB2
|
|
Nov 2, 2009 6:28 PM |
|
No ratings
|
|
| |
|
|
|
|
|
|
|
|
|
|
DB2 for z/OS UDF examples to wrap values in XML tags.
- Version 1.0
This DB2 for z/OS User Defined Function, named TAG(), is a light-weight means to wrap XML tags around values. |
|
ToddBurchDB2
|
|
Oct 29, 2009 6:05 PM |
|
No ratings
|
|
| |
|
|
|
|
|
|
|
|
|
|
Edit macro to convert SQL statement to Rexx string
SQL2REXX can convert an SQL statement that you prototyped using SPUFI to a Rexx string for execution by DSNREXX.
It eliminates the need to manually add the quotes and commas needed by Rexx. |
|
Don_Leahy
|
|
Sep 16, 2009 11:46 AM |
|
Based on 2 rating(s)
|
|
| |
|
|
 |
|
|
