Search results for query: *

WOW!!! That works too... Since the mo field is char datatype in my "Production" db, I tried the following and it seemed to work OK... The (mo) field will always be 6 characters long, but what would you need to do if the field were variable in length? Just make sure that the constant in the...

Thanks for your response. It worked perfectly. Unfortunately, I am querying some very large tables and performance is a huge issue. Since I only want to read the table once, the following works more efficiently: with TESTB (MO, NUM) as (select 1, 8 from sysibm.sysdummy1 union all select 2...

I have what seems like a simple problem, but I can't seem to figure it out. As an example, I have the following db2 table: Table = TESTB MO NUM 1 8 2 40 3 16 4 25 5 36 6 2 I need to find the following values in a single query: min(num) = 2 max(num) = 40 sum(num) =...

Thanks, Great idea!!! I hadn't thought about consolidating the worksheets using vba, but I think I can work out a solution going that route. Will post my soulution after I've worked through it. Thanks again.

Thanks for your response. Report Center is currently set up to execute a QMF query (DB2) at regular intervals and automatically save the data into an Excel workbook. A new worksheet (tab) in the same workbook is created with each run. I want to have 1 worksheet that will contain the data from...

DB2 v8.1.10.812 FixPak 10 Windows XP Professional 2002 Service Pack 2 I want to be able to append data each time a QMF query is automatically run from QMF Report Center to a specific Excel worksheet in a specific Excel workbook so that previously existing data in the worksheet is added to and...

Thanks a million!!! This does exactly what I needed. Can you explain how it works. It give me 143 rows (weeks) through 1/1/2007 thru 9/21/2009. Thanks again...

I have a DB2 query that lists the first day of each week in a year. I need to be able to convert this to an Access query. Here's the DB2 query: with all_days(dt) as (select (date('2007-01-01')) from sysibm.sysdummy1 union all select dt + 1 day from all_days...