DB2 Web Query Questions and Answers

Recent IT Questions

1 - 8 of 8
<<PREVIOUS 1 NEXT>>

DB2 Web Query record count

Is there a simple way to show a count of the rows printed in DB2 Web Query, such as you can to in Query/400?

View Answer   |  Sep 30 2009  3:59 PM GMT
DB2 Web Query, DB2
asked by BUEHLER

  15 pts.

DB2 Web Query

Hello Does anyone know how to select fields in the DB2 Query for report purposes, and yet not have them appear in the sort by window pane. Seem simple enough, but, when I have the field select tab highlighted, and double clik on any field, the field automatically appears in the sort by...

View Answer   |  Oct 13 2008  9:28 PM GMT
DB2, DB2 Web Query
asked by Piano

  250 pts.

DB2 Web Query

Hello I created metadata over a a "set" of files. My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database. Unfortunately, when I attempt to define my primary key over the main file, I receive...

Answer Question   |  Oct 10 2008  8:30 PM GMT
DB2, Metadata, DB2 Web Query
asked by Piano

  250 pts.

Field editing for DB2 WebQuery

How can I provide field editing for DB2 WebQuery? For example: phone number(length 10, decimals 0) as (123)456-7890 and Customer Id# (length 6, decimals 0) as 1234-56 . DB2 WebQuery doesn't seem to pay attention to the edit words/edit codes of the PF DDS, so I am trying to do my own...

Answer Question   |  Oct 3 2008  5:54 PM GMT
AS/400, DB2, DB2 Web Query
asked by AS400 - Ask the Expert

  395 pts.

DB2 WebQuery: Metadata Error FOC1567

I'm new to DB2 Web Query. Just starting with the product. In metadata, I'm trying to pull in a DB2 SQL derived Table. I keep getting an error FOC1567. *LOCAL, <create synonym>, Table <only>, library / filename Error FOC1567 Create Synonym Data Source 'StockKeepingUnit' is not unique...

Answer Question   |  Aug 26 2008  9:02 PM GMT
DB2, DB2 Web Query, FOC1567
asked by Dlanor

  20 pts.

DB2 Web Query

I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this ? Alternatively, are there any books on the market that someone would recommend...

View Answer   |  Jun 18 2008  9:04 PM GMT
DB2, Dashboards, DB2 Web Query
asked by Piano

  250 pts.

DB2 Web Query Login

I log into DB2 Web Query, do what I am going to do and end the session. Come back the next day and login again. I then ger the message "An active session for this user id already exists." Why do I get this msg each time I start Web Query?

View Answer   |  Jun 17 2008  4:08 PM GMT
DB2, DB2 Web Query
asked by PChase

  5 pts.

DB2 Web Query- Change Report Layout

I have a report which contains all the information I require. The problem is, there are two totals (automatically produced after a break) that I would like to move down to another section of the report. Any way of doing this?

View Answer   |  Mar 19 2008  6:17 PM GMT
DB2, DB2 Web Query
asked by TomS

  5 pts.

1 - 8 of 8
<<PREVIOUS 1 NEXT>>