467,189 Members | 1,280 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

Parsing arrays parameters in DB2

Hi, I am working on creating reports for which I want to make a single
stored procedure call to the DB. In order to do so, I need to be able
to parse an array of parameters containing elements as follows:

'20-30, 100--200, 400-500'

I would like to create a function that parses this out and inserts the
results into a temp table with a structure similar to the following:

Min Max
20 30
100 200
400 500

That way I can create a SQL joining my table (MYTABLE) with the
temporary table (TEMP) as follows:

select mytable.*
from MYTABLE mt,
TEMP t
where mt.field between t.min and t.max

Please, help

Apr 27 '06 #1
  • viewed: 1532
Share:
1 Reply
Check out

http://www-128.ibm.com/developerwork...03stolze1.html

Credits to Knut Stulze

Regards,

Mehmet Baserdem

Apr 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by harry | last post: by
8 posts views Thread by Gerrit Holl | last post: by
15 posts views Thread by John Smith | last post: by
21 posts views Thread by utab | last post: by
3 posts views Thread by aspineux | last post: by
2 posts views Thread by gdczinan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.