Search results for query: *

I have something I don't understand. I'm running DB2 Data Warehouse from an NT server and I'm connecting to our AS400. I'm trying to create a link to a Source table on the AS400, when I browse the table list I'm not seeing all of my tables, why is this? Also, on some files when I do connect...

I need some help. I have a pivot table that I'm creating and it has a field for the Columns that I have a Column heading for but for all of the Rows the value is zero. I still want the Column heading to display but the way it works now if there are all zeros in the row it doesn't display...

Hello, I'm trying to retrieve the number of rows that are in a text file via vba. I'm transferring data from one system to another in a series of files and I want to record the number of records I'm transfering in a spreadsheet. Is there an easy way to do this? My first thought is to open...

Hello, Is it possible to code my sql statement so that depending on a selected parameter. Here's my problem: given a selected business I use different fields to extract data from my system. How do I code this? Thanks, Cole

Hello, Is anyone using DB2 Warehouse Manager? Our company is going to install it this month and I was looking for some additional heads up on the product. Pros and cons and tips. Thanks, Cole

Hello, I have a report that I scheduled in CE 4 days ago and it is still showing as "running" when I view history for the report. How can I cancel this report? In a related vein, I have two large reports that I am trying to run and I keep getting a timeout when I try to run the...

Hello, I am runnin CR 8.5 and every month I need to run the same set of reports. Is it possible to run these reports from a command line and then place them in a batch program so that I just supply the date parameters and then all of the reports will run? Thanks, Cole