1
  • Set up DB2 Web Query dashboard

    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?

    Piano510 pointsBadges:
  • Select fields in DB2 query without having them appear in ‘sort by’ window pane

    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 click on any field, the field automatically appears in the sort by window...

    Piano510 pointsBadges:
  • DB2 file names cause SQL error

    Hello I created metadata over 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 an SQL error...

    Piano510 pointsBadges:
  • DB2 WebQuery for System i problem

    Hi! Our server has already installed with DB2 web query. I have checked the basic things in licensed programs like QWEBQRC77(*lib) , MRADMIN(*usrprf)...everything is there. But when I try to start web query, the command is not available and also in license programs the web query shown like...

    Sureyz2,375 pointsBadges:
  • 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 The...

    Dlanor20 pointsBadges:
  • DB2 Web Query – Active Report Show Unreadbale Data

    I have a report contains some information about customer name. When I save the output type as HTML ,the result is pretty good. The problem is, it is not good when save as Active Report AHTML. In each columns contains customer name in Thai will display as garbage or alian. How do we control this ?...

    Liverpoolfc20 pointsBadges:
  • 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?

    BUEHLER20 pointsBadges:
  • 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?

    PChase5 pointsBadges:
  • 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 "editing". I...

    AS400 - Ask the Expert485 pointsBadges:
  • 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?

    TomS5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following