Job Management Partner 1/Performance Management User's Guide
- When you execute a query from Microsoft Excel, you cannot specify strings including question marks (?) for values of the extraction condition fields. If you specify such a string, the KAVE07000-E message is output.
- When you obtain data by using the ODBC Driver from Microsoft Excel (Microsoft Query), you need to perform the following settings before filtering the data by date and time.
- Setting location:
- In Windows
Time tab (Choose Control Panel, Regional and Language Options, and then click the Customize button. The Customize Regional Options dialog box appears. Click the Time tab.)
- Setting contents:
- Display the time in the 12-hour time format.
- Select AM as the symbol to represent morning.
- Select PM as the symbol to represent afternoon.
- You cannot specify extraction conditions based on multiple tables. Make sure that the columns you specify come from a single table.
All Rights Reserved. Copyright (C) 2009, Hitachi, Ltd.