Recent content by v0520

Umm. What do you mean, by "manipulate a report", thats pretty generic.. Can you expand on this? Gilbert M. Vanegas Senior Programmer Analyst County of San Bernardino - ISD

You can do odbc traces by adding entries in the db2cli.ini file. Alternatively, if its running on a pc workstation, you can try the odbc trace option in control panel, that works but it puts out huge trace files. but, you should be able to get the sql out of the trace. If its running on some...

One way is to use explain plans. There is a free tool called visual explain on ibm website where you can explain a query and it will visually create a graph showing what indexes are being used (if any) as opposed to tablespace scans etc..) Also, look into runstats, if it used to run fine and...

No problem, look at regular modules versus class modules. Just want you to know I wasnt trying to be critical, just trying to give you sound advice. Programming is not "memorization or anything like that", its more like getting an understanding of how things like object oriented programming...

Are you sure this isnt an ebcdic format file also? Thats a possibility.. If its mainframe or mini based, its probably ebcdic, you can use ftp to download local and then it should convert ebcdic back to ascii.. Gilbert M. Vanegas Senior Programmer Analyst County of San Bernardino - ISD

Remember http is stateless, so it wouldn be fine to create local variables for strpath and retrieve it from the http request object. However, if you insist on having global variables accessible you could create a module with a global or public variable in scope Since you are writing asp.net...

see below for the line assigning a value to strServerURL Public Class MenuSystem Inherits System.Web.UI.Page Public Shared strPath As String Public Shared strServerURL As String Public Shared Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load strServerURL =...

Sure thing, so are the plans from visual explain useful to you? I find them useful, they are graphical, so are a little different than you would get under spufi or text-based tools residing on the database server. Gilbert M. Vanegas Senior Programmer Analyst County of San Bernardino - ISD

One of the best ways to run explain plans is to download a free ibm tool called visual explain, this tool has a way to graphically create an explain plan of a sql statement and can tell you what type of index the statement is using etc.. I use it all the time to tune up queries that I feel are...

Is your report server database "on another box?", c.0.6.51 is sql server 2000 service pack 1, is is possible your report server which hosts your database has not been updated to sql server 2000 service pack 1? If not, probably update the report server so it has sql server 2000 service pack 1...

if its ssrs2005, why dont you click program files->Microsoft sql server 2005 ->Configuration Tools ->Reporting Services Configuration I believe you should be able to fix that problem by bringing up the configuration screen. Gilbert M. Vanegas Programmer Analyst III County of San Bernardino -...

did you look at the db2adm security group? Can you simply remove his id from the db2adm security group and add your id? Gilbert M. Vanegas Programmer Analyst III County of San Bernardino - ISD Email : gvanegas@isd.sbcounty.gov

It would be easier to simply use the report viewer control and write an asp.net page to invoke the report. In other words, your .asp page would simply do a response.redirect("youraspnetpage.aspx) and it should work. Alternatively, since you are using asp, you could call the ssrs reporting...

I have done so (created a response file for what is known as a "silent install") did you search the install directory for the .rsp file extension? This is documented pretty thorougly in the db2 documentation. And they have a sample response file on the install media... Gilbert M. Vanegas...

Hi all, just recently implemented "dataset extension" for SQLSERVER reporting services. Got most of the ideas from a book called Microsoft Reporting Services in action (Teo Lachev. The way the dataset extension is implemented in my shop allows programmers to programatically create ADO.NET...