For the last 6 months or so, I have been working on a project with our web application development team to integrate SSRS reporting into our client facing Java web site.
When I first proposed this project, I knew that in theory this should work fine. But, it did take a bit of research and a lot of work to bring it to fruition.
We are moving into the testing phase this week, and I am happy to say that it works very well! The Java developer working on this is doing a great job of translating all of my Microsoft talk to java :)
We are using the Web Services provided by SSRS with a custom security extension that authenticates against our web site security.
Since we are only rendering one page at a time, rendering is pretty quick, taking less than a second a page to render.
Once we go thru testing and release, I am going to write more on this, including some details.
Monday, April 16, 2012
Wednesday, April 11, 2012
Retrieve Table List in DB2/400 via SQL Statement
Again, mainly to remind myself, the query to retrieve a list of tables in DB2/400 is:
If you want a list of views, table_type would = 'V'
peace
select * from qsys2.systables where table_type='T';
If you want a list of views, table_type would = 'V'
peace
Subscribe to:
Posts (Atom)