Unix Technical Forum

SQL Reporting Services (SRS) and DB2

This is a discussion on SQL Reporting Services (SRS) and DB2 within the DB2 forums, part of the Database Server Software category; --> In case anyone finds this helpful: Microsoft SQL Reporting Services (SRS) works with DB2, but parameters for stored PROCEDUREs ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:35 AM
Brian Tkatch
 
Posts: n/a
Default SQL Reporting Services (SRS) and DB2

In case anyone finds this helpful:

Microsoft SQL Reporting Services (SRS) works with DB2, but parameters
for stored PROCEDUREs do not, as It does not pull a list of them from
DB2. The problem, IIRC, is that SRS sends a query to the system
catalog, and quotes the PROCEDURE's name (as it must) but the
PROCEDURE's name is in smallcaps. Which means, unless the PROCEDURE is
CREATEd in quoted-smallcaps, SRS's query will return no parameters.

The solution someone here provided was to hack the XML manually. Using
a SELECT statement that does the equivalent of the stored PROCEDURE, it
will generate a report. Then, the XML report file can be editted adding
the two section of parameters, and changing the SELECT statement to a
CALL statement.

HTH,
B.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:56 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com