Reason:
The row for which you supplied column values has been inserted successfully in the requested table.
Action:
None is required.
Reason:
The table you requested has been dropped successfully from the database.
Action:
None is required.
Reason:
The row displayed on this panel has been updated with the display values.
Action:
None is required.
Reason:
There are too many columns in this table, or the values you are supplying for the columns are too long, and the capacity of an internal processing area has been exceeded.
Action:
If you are defining data for your personal database, try to use shorter values for your character columns, or try to do the data entry in two parts: insert, followed by update, for example. Or, use the DRAW command to construct an SQL statement for doing the data entry for this table.
Reason:
The term shown in the error message has been defined improperly. The code indicates the particular error found.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
Using the error code presented in the message, look up the error in this manual. For example, if the code is "DQ810," look up error message DQ810 in the manual. Then, look up the erroneous term in the Admin Directory of Terms to determine who the author of the term is. Review the term and either correct the problem or ask the author to make the necessary corrections.
Reason:
There is no active found set, or the query in the active query area does not contain an SQL Select Statement, so a table cannot be created.
Action:
Execute an SQL query which selects some output rows. Then, retry the STORE command.
Reason:
You must supply a name for your new table as an operand of the STORE command. This name must be unique for your private Authorization ID, and it must be no more than 18 characters long, begin with a letter, and contain only letters, digits, and underscores.
Action:
Reenter the STORE command, supplying the name for the new table as an operand. If you would like to see a list of the tables that exist in your private Authorization ID, change the Authorization ID item in your Profile to your private Authorization ID and view a directory of tables (DIR command, LIST TABLES command, or select DIRECTORIES from the Main Menu). You may reissue your STORE command from the directory display. EXAMPLE: STORE mynewtable
Reason:
The name for the new table is a duplicate of the name of another table, view, or synonym within your private SQL Authorization ID and cannot be used to create a new table.
Action:
Reenter the STORE command, supplying a different name for the new table. You can display a list of the tables within your private Authorization ID by changing the SQL AUTHORIZATION ID item in your profile and requesting a Directory of Tables (DIR command, LIST TABLES command, or selecting DIRECTORIES on the Main Menu).
Reason:
An unrecoverable error has been detected while accessing the CA Dataquery SQL Found Table (DQE). There may also be a problem with the SQL Recovery Table (DQR). A return code is shown at the end of the message text.
Action:
Contact your CA Dataquery Administrator and describe the error you have received, including the message number, text, and the return code that appears at the end of the text, and what you were attempting to do when you received the error.
Reason:
The sum of the sizes of all columns in your SQL query is too large to fit in the CA Dataquery SQL Found Table (DQE).
Action:
Reduce the number of columns in your query. If the problem persists, contact your CA Dataquery Administrator and describe the error you have received, including the message number and text, and what you were attempting to do when you received the error. The CA Dataquery Administrator may increase the size of the DQESIZE parameter in the CA Dataquery System Option Table to handle the query.
Reason:
The printer you requested for your query output is not available.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
Contact the systems programmer to report the error. Describe the error message number and the printer ID.
Systems Programmer
Use the monitor diagnostics to determine the cause of the error, and make the printer available if possible. The following causes may produce this message:
There is no entry in the TCT for the printer The device is not a printer The device is not a supported printer The printer is not in service
Reason:
The saved set to be used by this print request is no longer available because its retention time limit has expired. Too much time has elapsed between the creation of the saved set and the execution of the print request. Therefore, your print request could not be completed.
Action:
If this occurs frequently at your site, contact your CA Dataquery Administrator and request that the RTIMDQE System Option Table parameter be increased.
Follow the directions for your job responsibilities:
CA Dataquery Administrator
If this becomes a problem, contact your Database Administrator and request that the RTIMDQE System Option Table parameter be increased.
Database Administrator
Increase the RTIMDQE System Option Table Parameter if possible. Consider the ramifications of increasing this parameter: sets will be saved longer. Too long a retention period may result in a delay of space reclamation, and space may not be available to store new sets.
Reason:
You requested that the results of your query be sent to a network printer. Your request has been processed, and it was sent to the printer indicated in the message.
Action:
Pick up your printed query results at the distribution location for the printer you specified. If you do not know where to pick up your output, contact your CA Dataquery Administrator for assistance.
Reason:
You requested a printer control function that cannot be performed successfully. The query results being printed are no longer accessible. For example, you may have requested that the query results be flushed but the results had already finished printing.
Action:
None is required.
Reason:
CA Dataquery encountered an unexpected error while your report was being prepared for printing. Your print request could not be completed.
Action:
Try your print request again later when the system is less busy. If this is a frequent occurrence at your site, contact your CA Dataquery Administrator and describe the error message, including the message number and the text, and what you were attempting to do when you received the error. Follow the directions for your job responsibilities:
CA Dataquery Administrator
If this is a frequent occurrence at your site, contact your systems programmer and request that the CA Dataquery Found Table (DQF) be enlarged.
Systems Programmer
Enlarge the CA Dataquery Found Table (DQF) about 10 percent at a time to see if the problem is resolved. After increasing the extents for the file, null load both the DQF and the DQS tables using the CA Datacom/DB Utility (DBUTLTY) and then run the DQWFINIT utility.
Note: Executing DQWFINIT completely reinitializes the table and destroys any KEEP or EXTRACT Saved Sets currently on table. Queued network print requests, deferred batch requests, and pending OFFLINE PRINT requests are also lost.
Reason:
The logical page size of your report exceeds 64K. The logical page size consists of all the page segments without the title and PF key lines. A page segment is the portion of a page that fits on the current output media such as a terminal screen or a sheet of printer paper.
Action:
You can use a device with fewer rows or, for a hardcopy or printer device, you can reduce the Number of Rows in your User Profile. You can also remove some of the columns from your PRINT statement.
Reason:
The value you entered for STATUS was not PUBLIC or PRIVATE. Only these values can be used.
Action:
Enter a value of either PUBLIC or PRIVATE for STATUS and retry your request.
Reason:
The Defer execution time must be numeric HH:MM. HH must be 00 thru 24 and MM must be 00 thru 59.
Action:
Correct and retry.
Reason:
The SQL authorization ID you entered is not in the correct format. It must be 1 to 18 characters in length, beginning with a letter followed by any combination of letters, digits or underscores.
Action:
Correct the format of the authorization ID and try again.
Reason:
If the user is authorized to use the Personal Database Facility (PDB), a private SQL authorization ID is required.
Action:
Enter an SQL authorization ID which will be the user's private SQL authorization ID. Retry the add or update request.
Reason:
The value you specified for either the LOW or HIGH value for the range is not a number. The value can contain the digits 0 through 9, a sign (+, -), and a decimal point.
Action:
Enter a number between -999,999,999 and 999,999,999 in place of the incorrect range value.
Reason:
You entered a value that is greater than 999,999,999 or less than -999,999,999. CA Dataquery has a limit of nine digits for the range of a histogram.
Action:
Change the value to a number between -999,999,999 and 999,999,999.
Reason:
You specified a RANGE for your histogram without both the LOW and HIGH values. A range is an interval of X values which will be grouped together as one bar. You can specify up to five ranges, but you must specify at least one range. Values from -999,999,999 to 999,999,999 may be used. Signs and decimal points may also be entered. The range is specified by giving the LOW value, which is the lowest value of X to be included, and the high value, which is the largest value for X to be included.
Action:
Enter both the LOW and HIGH values for the range.
Reason:
You cannot draw your histogram until you specify at least one range. A range is an interval of X values which will be grouped together as one bar. You can specify up to five ranges. Values from -999,999,999 to 999,999,999 may be used. Signs and decimal points may also be entered. The range is specified by giving the LOW value, which is the lowest value for X to be included, and the HIGH value, which is the largest value for X to be included.
Action:
Enter the LOW and HIGH values for at least one range.
Reason:
You entered an erroneous value for the key box location orientation to the selected margin.
Action:
Enter the number of your choice from 1 to 3.
Reason:
The row which is displayed on the panel has been deleted by the Personal Database Facility.
Action:
This message is informational only. No action is required.
Reason:
You entered an incorrect value for your background grid color selection. A valid entry is a number from 1 to 7.
Action:
Enter a number from 1 to 7 that corresponds to your color choice.
Reason:
You entered an incorrect value for the Key Box Location Base Margin. A correct entry is a number from 1 to 4.
Action:
Enter the number that corresponds to the preferred base margin.
Reason:
You entered a table name which is not the name of an existing table or which you are not authorized to use or you may have failed to enter any table name to be used by the DRAW command.
Action:
Reenter the command with a valid table name and retry.
Reason:
You have entered a DRAW command requesting an invalid statement type. Valid types are INSERT, UPDATE, DELETE, or SELECT. The format for the command is:
.DRAW tablename type
The default for the statement type is SELECT. A SELECT statement has been created.
Action:
If you did not want a select statement to be created, delete the current statement and reenter the DRAW command using the correct statement type.
Reason:
There is no authorization on your CA Dataquery system to use the STORE command.
Action:
Contact your CA Dataquery Administrator for assistance if you require use of the STORE command.
Reason:
With the STORE command, you requested that a table be created along with the rows chosen by a SELECT query. The table was created and the data rows added successfully.
Action:
None is required. The table may now be used in Queries.
Reason:
A column in the table you selected from your personal database has a data type which is not supported by the Personal Database Facility or has a length that exceeds the maximum supported by the Personal Database Facility. Data types which are valid in PDB are integer, smallint, numeric, decimal, float, and character.
Action:
This table may be maintained using data maintenance statements through the CA Dataquery Editor.
Reason:
The data row displayed has invalid data in the field named in the error message. The update or delete function you requested cannot be performed. A character field may contain binary zeros or a numeric field may contain non-numeric data.
Action:
Contact your Database Administrator about getting the data in the row corrected.
Reason:
Batch CA Dataquery has attempted to use the system sort program, but received an unexpected return code. The CA Dataquery Index sort is being used as an alternative.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
Contact your systems programmer to report the error.
Systems Programmer
Check the output in the system sort message file for the specific error message, and correct the error.
Reason:
CA Dataquery cannot allocate enough storage to perform an in-core sort. The CA Datacom/DB index sort is being used as an alternative. Following the message is a numeric code indicating the reason the storage cannot be used:
001 - MAX PAGES FOR A SINGLE SORT EXCEEDED (SORTPAG) 002 - TOTAL SORT PAGES EXCEEDED (SORTSYS) 003 - STORAGE ALLOCATION FAILED
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
If the numeric code following the message is 001 or 002, report the error to the Database Administrator. If the numeric code following the message is 003, report the error to the systems programmer.
Database Administrator
If the code following the message is 001, increase the SORTPAG parameter in the System Option Table and reassemble the table. If the code following the message is 002, increase the SORTSYS parameter in the System Option Table and reassemble the table.
Systems Programmer
If the code following the message is 003, increase the OSCOR for your CICS region.
Reason:
You have requested to scroll forward in this report, but the maximum number of pages which are viewable online have already been viewed. The first 2000 pages may be viewed online.
Action:
To view the entire report, you should produce the report in CA Dataquery batch mode, or route this report from the online system to the system printer.
Reason:
The language you specified on the Language Maintenance menu has no items of the type you specified (panel, literal, or vocabulary).
Action:
Verify the two-character code that you specified for the language. You can use the default, by leaving the language code blank, to view a listing of the type you specify (panel, literal, or vocabulary) for all languages currently defined on your CA Dataquery system. To add a new language, start with a language that is already defined and use the Language Maintenance Facility.
Reason:
The FIND statement in your query did not retrieve any rows. Execution stopped after the FIND statement since there was not any data to process. No rows in the table satisfied the WITH and RELATED clauses of your FIND statement. Your FIND statement may be too restrictive or may contain an error. For example, typing 1887 instead of 1987 when searching for the current year would probably cause this message to occur.
Action:
You can modify the WITH clause so it is less restrictive. This may allow some rows to qualify for selection. You can check the conditions in your WITH clause to ensure that the values and logical operators are correct. After you make any necessary corrections, save and validate the query before you execute it.
Reason:
You have selected the NETWORK PRINTER option, but either:
or,
Action:
For (1), select the VIDEO TERMINAL destination option, or add a PRINT statement to your query text.
For (2), select the COLUMNAR print option on the Online Execution panel.
Reason:
You have selected the SYSTEM PRINTER option, but either:
or,
Action:
For (1), select the VIDEO TERMINAL destination option, or add a PRINT statement to your query text.
For (2), select the COLUMNAR print option. Or, if a DISPLAY statement was used, use batch execution.
Reason:
The combination of the steps defined in your query and the steps you selected to execute result in no steps to execute. This could happen if you try to start execution with the REPORTING step, and the query itself contains only a SELECTION step.
Action:
Review the verbs in the query text and choose the appropriate beginning step.
Reason:
A severe CA Datacom/DB error occurred in the preprocessor program while translating a command. Further attempts at translation will probably fail. The two characters after DB ERROR are the CA Datacom/DB return code.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
Contact your Database Administrator and describe the error, including the error message number and text and the DB ERROR information provided in the error message.
Database Administrator
Look up the error in the CA Datacom/DB Message Reference Guide by using the return code presented in the error message. Take the appropriate action, as specified, for the CA Datacom/DB error.
Reason:
The preprocessor program did not have enough space to hold the translated version of the command you entered. The command was not processed.
Action:
Verify that the total length of the commands entered on the command line, when translated into American English, does not exceed 76 characters. If this situation occurs, contact Technical Support for CA Dataquery.
Reason:
CA Dataquery could not locate the signon panel. This is a CA Dataquery system problem.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
Contact your Database Administrator and describe the error, including the error message number and text.
Database Administrator
Verify that the DQP table in the DQM area is open and contains records. Verify that the DQP table is the correct one for this version of CA Dataquery.
If the DQP table has no records, reload it from a backup with DBUTLTY or from the installation tape with DQLANGMT. If you still receive this message, contact Technical Support for CA Dataquery.
Reason:
The JCL or PROC member named on the batch execution panel did not contain a card "/* DQ INPUT" following the SYSIN card. This card must be present in the named JCL before a query may be submitted.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
Edit the JCL or PROC member to include the "/* DQ INPUT" card, or contact your systems programmer for assistance.
Systems Programmer
Assist your CA Dataquery Administrator in correcting the JCL.
Reason:
The CA Dataquery session on this terminal was terminated automatically by CA Dataquery. This can occur when the time that has elapsed since the last request has exceeded the limit set by the ETMSO parameter in the System Option Table. It also can occur when the user signed onto another terminal and requested that CA Dataquery sign off this terminal.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
If too many users are automatically signed off, you might want to have the ETMSO parameter in the System Option Table increased. If this is the case, contact your Database Administrator and request that the ETMSO parameter be increased.
Database Administrator
The ETMSO parameter in the System Option Table specifies the number of minutes that may elapse between terminal requests to CA Dataquery. If the specified time limit is reached, CA Dataquery will automatically sign off the user the next time that the user attempts to access CA Dataquery from his terminal. The valid entries are 1 through 1440 and the default is 1440. After you change the parameter value, reassemble the CA Dataquery System Option Table.
Reason:
The CA Dataquery session on this terminal is over. Press the Enter key to initiate the signon process.
Action:
None is required.
Reason:
The security code you entered is misspelled or incorrect.
Action:
Try again with the correct spelling. If you cannot remember your password, contact your CA Dataquery Administrator.
Reason:
You have attempted to sign on with an identification that is being used on another terminal. That terminal is identified at the end of the message. CA Dataquery does not permit the same user to be signed on to two terminals at the same time.
Action:
Sign off from the other terminal by entering Y on the command line. If you want to locate the terminal in question, check with your CA Dataquery Administrator.
Reason:
The user identification you typed is not known to CA Dataquery. You may have misspelled it.
Action:
Check the spelling of your user identification. If it is incorrect, make the necessary corrections. If you do not know your user identification, contact your CA Dataquery Administrator.
Reason:
You have either entered "OFF" on the signon panel in the name field or the command line, or you pressed the Clear key after seeing the signon panel without having signed on to CA Dataquery.
Action:
None is required.
Reason:
The selection you requested is not listed as a valid choice on the menu. You can choose only a number that appears on the menu list.
Action:
Choose a selection number that appears on the displayed menu. Type that number in the menu selection field and press Enter.
|
Copyright © 2014 CA.
All rights reserved.
|
|