By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Parsing arrays parameters in DB2

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.