Prev: Rounding error
Next: Another kind of join?
From: Herb on 1 Sep 2009 11:44
we are still running version 8.3 UDB for LUW. We are planning to
upgrade to 9.5 shortly. I am needing to send email and possible put
some data on MQ from a SQL PL stored proc.. I see where in 9.7 they
have system procs to do some of this, but is there a way to do this
using 8.3 or maybe 9.5.....
From: Serge Rielau on 1 Sep 2009 15:43
Herb wrote:
> we are still running version 8.3 UDB for LUW. We are planning to
> upgrade to 9.5 shortly. I am needing to send email and possible put
> some data on MQ from a SQL PL stored proc.. I see where in 9.7 they
> have system procs to do some of this, but is there a way to do this
> using 8.3 or maybe 9.5.....
Herb,

There is nothing fancy about the DB2 9.7 system defined modules.
For MQ there is built in support in DB2 8 and DB2 9.5.
To send email a simple C-UDF should do the job

Cheers
Serge



--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
From: Mark A on 1 Sep 2009 23:15
"Herb" <HERB_VOGEL(a)JBHUNT.COM> wrote in message
news:609aed21-aa71-45f5-82a1-b99c9cdbdc51(a)n2g2000vba.googlegroups.com...
> we are still running version 8.3 UDB for LUW. We are planning to
> upgrade to 9.5 shortly. I am needing to send email and possible put
> some data on MQ from a SQL PL stored proc.. I see where in 9.7 they
> have system procs to do some of this, but is there a way to do this
> using 8.3 or maybe 9.5.....

Probably not with 8.3 since there is no such DB2 release. There was 8.1 and
8.2 with various fixpacks on these.


 | 
Pages: 1
Prev: Rounding error
Next: Another kind of join?