Reason:
One of the following has occurred:
Action:
Perform one of the following items:
Reason:
An internal authorization error occurred. This is a system problem.
Action:
Collect as much information as possible from your user including what was being attempted when the error occurred and contact Technical Support for CA Dataquery.
Reason:
You have typed an occurrence number for a repeating field which is either not numeric or too large. The occurrence number cannot exceed the number of times the field repeats.
Action:
Correct your entry for the desired individual occurrence of the repeating field.
Reason:
You have attempted to save the DIALOG variable definition, but you have not specified a valid type. The type can be used to limit the values that are allowed for the variable. The following are valid types:
C - Any character on the keyboard
A - Alphabetic characters only (A-Z)
N - Numeric digits only (0-9)
Action:
Enter a variable type for the variable in the space provided.
Reason:
You have attempted to save the DIALOG/PROC variable definition without specifying a prompt. The prompt will be displayed to the user during validation and execution of the DIALOG or during submission of the PROC. The prompt should explain this variable to the user to help him/her determine what value should be entered.
Action:
Type a prompt for the variable in the space provided. Then you may save the variable definition.
Reason:
You have given two different temporary result fields the same name. Duplicate temporary result field names within one query are not permitted.
Action:
Change the name of one of the temporary result fields to make it unique within your query.
Reason:
You are attempting to use a CA Dataquery reserved word as the name of a temporary result field. This is not allowed. See the CA Dataquery Reference Guide for a list of reserved words that cannot be used.
Action:
Remove the reserved word from your query.
Reason:
You typed a temporary result field name that contains embedded blanks. A temporary result field name may consist of 1 to 32 characters beginning with a letter and containing no embedded blanks.
Action:
Correct the format of the temporary result field name.
Reason:
This is an internal CA Dataquery error.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
Please contact Technical Support for CA Dataquery and describe the error you received.
Reason:
You have chosen either too many columns or too many conditions for your Guided Query. Guided Query limitations are:
Action:
Examine the choices you made for your Guided Query. Where you have exceeded the maximum, remove some of them until the applicable limitation is not exceeded.
Reason:
You have attempted to continue without selecting at least one column or key to appear on your report.
Action:
Select one column or key before continuing.
Reason:
The query you are building under the Guided Query Creation facility is now too large to be stored in the Active Query Area. Guided Query Creation cannot continue unless you shorten the query.
Action:
Use the PF2 key to return to previous steps and reduce the size of your query by removing print columns, selection criteria, or other parts of the query. Another alternative is to leave Guided Query Creation and use the Editor to rearrange the query so that it uses fewer lines.
You can also contact your CA Dataquery Administrator about increasing the System Option Table parameter "QPAGES" which determines the maximum size that your query can be.
CA Dataquery Administrator
Assist the user in rearranging the query so that it uses fewer lines. If this is still not satisfactory, contact your Database Administrator and ask that the QPAGES parameter in the System Option Table be increased. This parameter determines the maximum size of your query.
Database Administrator
Increase the QPAGES parameter of the System Option Table. Its value can be from 1 to 4. The default is 1. Each page has 24 lines. If you are going to use the Guided Query Creation Facility at your site, it is recommended that you specify QPAGES to be at least 2. This parameter does not affect what is stored in the Query Library. If the query uses only one page, only one page will be stored in the library. Once you have changed the value of this parameter, reassemble the System Option Table.
Reason:
You have attempted to continue to the next step of Guided Query without entering a condition statement. You have defined multiple selection criteria for your query, and now you must specify the relationship between the conditions. The condition statement consists of two digit statement numbers separated by logical operators. Logical operators are: AND, OR, ")", "(".
Examples:
01 AND (02 OR 03)
(01 OR 02) AND 03
Action:
Enter the condition statement as described above. Then, you may proceed with the rest of your Guided Query Creation.
Reason:
The condition statement is not valid. The condition statement consists of two digit statement numbers separated by logical operators. Logical operators are: AND, OR, (, ).
Examples:
01 AND (02 OR 03)
(01 OR 02) AND 03
Action:
Enter the condition statement as indicated. You may then proceed with the rest of your Guided Query Creation.
Reason:
You have not entered a table name for the condition. The condition cannot be saved until you enter one. A table name can be from 1 to 32 characters and must be a valid database table name.
Action:
Type in a valid table name for your condition and then save it.
Reason:
You must enter a table name. A table name consists of 1 to 32 characters and must be a valid database table name.
Action:
Type in a valid table name.
Reason:
Your restriction was added or updated successfully. It is now available for use.
Action:
None is required.
Reason:
This restriction name cannot be added because there is another restriction member with this name on the library.
Action:
Pick another name for this restriction and add it.
Reason:
Either no user name has been entered for this restriction or a group2 or group3 name has been entered without a group1 name.
Action:
Either specify a user name or specify group names in hierarchical sequence.
Reason:
You requested that a particular language item (literal, panel, or vocabulary term) be deleted from the CA Dataquery Language Maintenance Library. This request has been completed successfully. The item has been permanently removed.
Action:
None is required.
Reason:
The literal, vocabulary item, or panel translation has been successfully updated.
Action:
None is required.
Reason:
The literal, vocabulary item, or panel translation has been successfully saved.
Action:
None is required.
Reason:
You have attempted to perform some function for the restricted condition, but you have not entered the name of at least one condition. You must enter a condition name on one of the lines provided before you can request a function that uses a restricted condition. If you are saving the new restricted condition definition, enter the names of all the conditions for the user/group and the table.
Action:
Enter at least one condition name on one of the lines provided.
Reason:
CA Datacom/DB has encountered a problem. Your request to create a restriction could not be completed. The information following DB RC relates to the CA Datacom/DB error. The format is:
DB RC xx yyy cccccfffkkkkk
where xx is the CA Datacom/DB return code, yyy is the subcode, and cccccfffkkkkk is the CA Datacom/DB request Area.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
Gather together the information obtained from your user. Contact your Database Administrator for assistance in resolving the problem.
Database Administrator
Using the return code from the error message, look up the message in your CA Datacom/DB Message Reference Guide. Correct the problem as directed.
Reason:
You have attempted to perform a function for a particular restricted condition, but you have not entered the table name. A restricted condition is defined for a particular table and user/group. You must enter a table name on the line provided before you can request any function.
Action:
Enter the table name for which you want the restricted condition defined.
Reason:
You selected a network printer as the destination for your report. This request cannot be processed because either your query has a DISPLAY clause or you selected LIST for the report type. These choices produce output with one row per page. This output type is not produced on a network printer. It can be produced on a video terminal.
Action:
If you want to view the report on your video terminal, change your selection from network print to video terminal on the online execution panel. If you still want the report sent to a network printer, either change your LIST selection to COLUMNAR for report type, or change the DISPLAY verb to the PRINT verb in the query text.
Reason:
You have selected both list and columnar formats for your report. You may choose only one of them.
If you choose the COLUMNAR format, the data will be printed with a single output record appearing on each line. Multiple output records will be shown on a single page. If you choose the list format, then the data will be printed with a single output record appearing on a page.
Action:
Select either the COLUMNAR or the LIST format for your report. Erase the selection mark beside the one you do not want.
Reason:
You have attempted to perform a function on a panel, literal, or vocabulary term that is not allowed for American English (AE). You cannot delete or edit an American English item. You also are not allowed to translate another language item into American English.
Action:
Request another function or language. You can translate American English items into a new primary or secondary language.
Reason:
The panel you selected cannot be displayed on your terminal. It contains 132 columns, and your terminal only supports 80.
Action:
If you want to display this panel or perform maintenance activities on it, you must use a 3270 MOD 5 compatible terminal.
Reason:
You pressed PF2 during the update of a panel, literal, or input vocabulary term. This indicates that you want to return to the list of panels, literals, or vocabulary terms without processing the updates you had started.
Action:
None is required.
Reason:
The users for whom you requested an action are highlighted and marked with an action code. The users are scheduled to:
Action:
No further action is required.
Reason:
You are attempting to translate to another language and have not provided a language code.
Action:
Enter a language code and proceed with the translation.
Reason:
The NUMBER OF ROWS option is not zero or a three-digit number between 018 and 255. This entry tells CA Dataquery the number of rows (lines) down the page of a printed report.
Action:
Correct your entry for NUMBER OF ROWS. Zero indicates that you want to use the system default.
Reason:
The NUMBER OF COLUMNS option is not zero or a three-digit number between 080 and 255. This entry tells CA Dataquery the number of columns (characters) across the page of a printed report.
Action:
Correct your entry for NUMBER OF COLUMNS. Zero indicates that you want to use the system default.
Reason:
Your entry for NUMBER OF ROWS or NUMBER OF COLUMNS is incorrect. The entry for NUMBER OF ROWS must be 000 or a three-digit number between 018 and 255. This entry tells CA Dataquery the number of rows (lines) down the page of a printed report. The entry for NUMBER OF COLUMNS must be 000 or a three-digit number between 080 and 255. This entry tells CA Dataquery the number of columns (characters) across the page of a printed report.
Action:
Correct your entry for NUMBER OF ROWS and/or NUMBER OF COLUMNS. Zero indicates that you want to use the system default.
Reason:
The value you entered for the Datadictionary Database ID was not numeric. The value consists of three digits (0-9). This value specifies the Datadictionary Database from which CA Dataquery extracts database and file definitions.
Action:
Enter the three-digit ID for the Datadictionary Database you want to use. See your CA Dataquery Administrator for a list of Datadictionary Database IDs you may use.
Reason:
The user profile has been updated to reflect the changes you made. The new profile will be in effect the next time the user signs on to CA Dataquery.
Action:
None is required. You may continue to update the profile, or you may use the PF2 key to return to the previous panel.
Reason:
You have defined a temporary result field but have not defined the computation that will be used to assign its value. For the computation you can enter a numeric literal, a numeric column name, or an arithmetic expression. An arithmetic expression can contain the following operators: "+", "-", "*", "/", "(", ")". You can use numeric literals or numeric column names in your arithmetic expression. The following is a sample computation:
(RATE * HOURS) + 10
Action:
Enter a computation for each temporary result field before continuing.
Reason:
Your query executed successfully. The active found set now contains the rows that satisfied your find statement.
Action:
None is required. If your query included a PRINT or DISPLAY statement and a VIDEO TERMINAL destination was selected, the results have already been displayed. If your query included a PRINT or DISPLAY statement and NETWORK/SYSTEM PRINTER was selected, the results have been scheduled to print. You may now execute statements that work with the Found Set such as SORT, EXTRACT, and PRINT.
Reason:
Execution of your query terminated due to an error. Another message accompanies this one which will describe the error that occurred in more detail.
Action:
Use the information provided in the accompanying error message to determine the cause of the error. Take appropriate action to correct the problem. You may also want to use the STATS PF key to view additional information about the query execution and its premature termination.
Reason:
The value of the user name field is blank. User information cannot be added or updated with a blank name field.
Action:
Enter a value in the user name field.
Reason:
The value you entered for DATA AUTHORIZED was not a Y (YES) or an N (NO). This authorization allows a user to view the data in any table accessible by CA Dataquery.
Action:
Enter a value of either a Y (YES) or an N (NO) for the DATA AUTHORIZED authorization.
Reason:
The value you entered for SECURITY MAINT was not Y (YES) or N (NO). This allows the user to perform security maintenance tasks such as field and record security authorization.
Action:
Enter the value Y (YES) or N (NO) for SECURITY MAINT.
Reason:
The value you entered for CONDITIONS was not a Y (YES) or an N (NO). This authorization allows the user to maintain conditions. Conditions are defined for a table and they are, for the most part, used to restrict user access of tables and columns in the system. Maintenance tasks include adding, deleting, and updating conditions.
Action:
Enter the value Y (YES) or N (NO) for CONDITIONS.
Reason:
The value you entered for RESTRICTIONS was not a Y (YES) or an N (NO). This parameter authorizes a user to maintain restricted conditions for users and groups.
Action:
Enter a value of either a Y (YES) or an N (NO) for RESTRICTION authorization.
Reason:
The value you entered for PRINTER CONTROL was not a Y (YES) or an N (NO). This authorization allows a user to perform printer control tasks such as canceling or restarting a print request.
Action:
Enter a value of either a Y (YES) or an N (NO) for PRINTER CONTROL authorization.
Reason:
The value you entered for JCL was not a Y (YES) or an N (NO). This authorization allows a system administrator to maintain CA Dataquery JCL members.
Action:
Enter a value of either a Y (YES) or an N (NO) for JCL authorization.
Reason:
The value you entered for USER MAINT was not a Y (YES) or an N (NO). This authorization allows a system administrator to maintain the user table. The administrator can add, delete, and update users with this authorization.
Note: Once a user has this authorization, the user can authorize anyone, including themselves, to have privileges that the user does not currently have.
Action:
Enter a value of either a Y (YES) or an N (NO) for USER MAINT authorization.
Reason:
The value you entered for LANGUAGE was not a Y (YES) or an N (NO). This authorization determines whether the user can perform language maintenance tasks. Such tasks include translating, updating, and deleting panels, literals, and vocabulary items.
Action:
Enter either Y (YES) or N (NO) for LANGUAGE.
Reason:
The value you entered for DIAGNOSTICS was not a Y (YES) or an N (NO). This authorization specifies whether the user can perform diagnostic tasks including activating the dump facility and viewing the internal request table.
Action:
Enter either Y (YES) or N (NO) for DIAGNOSTICS.
Reason:
The value you entered for MXREQ was not numeric. The value may contain only numeric digits (0-9), and must be in the range from 0 to 99999. The default is set during CA Dataquery installation by the MXREQ parameter in the System Option Table. This value specifies the maximum number of CA Datacom/DB I/O events that are allowed during query execution and the number of I/O events that can occur between FIND IN PROGRESS or SORT STILL IN PROGRESS messages before the task relinquishes control of its resources and reschedules the remainder of the task. This parameter helps to ensure that one query cannot monopolize the system.
Action:
Enter a numeric value for MXREQ. A value of zero indicates that you want to use the value in the System Option Table.
Reason:
The value you entered for FNDBLKS is not numeric. The value may contain only numeric digits (0-9), and must be in the range from 0 to 9999. The default was defined at CA Dataquery installation by the FNDBLKS parameter in the System Option Table. This value specifies the maximum number of physical storage blocks that the user's task can own at one time during query execution, and this limits the number of rows that can be returned during an online query execution.
Action:
Enter a numeric value for FNDBLKS.
Reason:
The value you entered for SORTPAG was not numeric. The value can consist only of digits (0-9), and must be in the range from 0 to 2048. The default is set during CA Dataquery installation by the SORTPAG parameter in the System Option Table. This value determines the maximum number of 4096-byte blocks that can be allocated for a single in-core sort request.
Action:
Enter a numeric value for SORTPAG. A value of zero indicates that you want to use the value in the System Option Table.
Reason:
The value you entered for MXTLR was not numeric. The value may consist only of numeric digits (0-9), and must be in the range from 0 to 99999. The default is set during CA Dataquery installation by the MXTLR parameter in the System Option Table. This value specifies the maximum number of times CA Dataquery will relinquish control to other tasks during query execution and the number of FIND IN PROGRESS or SORT STILL IN PROGRESS messages that will be issued before pausing to allow the user to end the task.
Action:
Enter a numeric value for MXTLR. A value of zero indicates that you want to use the value in the System Option Table.
Reason:
The value you entered for SORTCTG was not numeric. The value may contain only numeric digits (0-9), and must be in the range from 0 to 16. The default is set during CA Dataquery installation by the SORTCTG parameter in the System Option Table. This value specifies the maximum number of contiguous 4096-byte pages of storage that will be requested at one time from the operating system for in-core sorting.
Action:
Enter a numeric value for SORTCTG.
Reason:
The value you entered for QUERY TEXT was not a Y (YES) or an N (NO). This option determines whether the query text will be printed at the beginning of printed reports.
Action:
Enter the value of either a Y (YES) or an N (NO) for the QUERY TEXT option.
Reason:
You have entered a value for PAGES TOGETHER that is not a Y (YES) or an N (NO). When the fields in a print statement cause the report to be too wide to be printed on a single page, PAGES TOGETHER specifies whether all pages for a particular group of records are printed together (YES) or like pages are printed together (NO).
Pages Together Page Sequence
YES 1A, 1B, 2A, 2B, . . .
NO 1A, 2A, 1B, 2B, . . .
Action:
Change the value for PAGES TOGETHER? to either a Y (YES) or an N (NO).
Reason:
The value you entered for STATISTICS was not a Y (YES) or an N (NO). This option specifies whether query statistics will be produced at the beginning of printed reports. Query statistics include information such as the number of rows found and the time of execution.
Action:
Enter a value of either a Y (YES) or an N (NO) for the STATISTICS option.
Reason:
The value you entered for PERSONAL DATABASE was not a Y (YES) or an N (NO). This option specifies whether or not the user may create, update, display, and drop personal database tables.
Action:
Enter a value of either a Y (YES) or an N (NO) for the Personal Database option.
Reason:
The value you entered for BANNER PAGE was not a Y (YES) or an N (NO). This option determines whether or not the user receives a banner page at the beginning of the printed query results when it is produced on a network printer.
Action:
Enter a value of either a Y (YES) or an N (NO) for the BANNER PAGE option.
Reason:
You have entered a value for ASSOCIATE USER that is not a Y (YES) or an N (NO). An Associate User is a user who is permitted only to execute existing queries. This user is not permitted to use any of the other CA Dataquery functions.
Action:
Change the value for the ASSOCIATE USER? to either a Y (YES) or an N (NO).
Reason:
The value you entered for SUBMIT ALLOWED? was not a Y (YES) or an N (NO). This authorization allows the user to submit batch queries.
Action:
Enter a value of either a Y (YES) or an N (NO) for SUBMIT ALLOWED? authorization.
Reason:
The value you entered for QUERY LIBRARY MAINT was not a Y (YES) or an N (NO). This authorization allows a
CA Dataquery Administrator
to maintain the query library: (1) to validate, edit or delete any query, (2) to change dialog variables, and (3) to change any query attributes.
Action:
Enter a value of either a Y (YES) or an N (NO) for QUERY LIBRARY MAINT authorization.
Reason:
The changes you made to the user definition have been successfully written to the User Table. The updated definition may be retrieved.
Action:
None is required.
Reason:
The new user has been successfully added to the CA Dataquery User Table (DQU). This new user can now signon to CA Dataquery.
Action:
None is required.
Reason:
You attempted to enter a group level 3 and nothing has been specified for group level 2.
Action:
Either enter your group level information for level 2 or, enter group level information for both level 2 and level 3.
Note: You cannot enter information for level 2 unless there is an entry for level 1.
Reason:
You attempted to enter a group level 2, and nothing has been specified for group level 1.
Action:
Either enter your group level information for level 1, or enter group level information for both level 1 and level 2.
Reason:
The value you entered for SAVED SET MAINT authorization was not a Y (YES) or an N (NO). This authorization allows a CA Dataquery user to save query results in the CA Dataquery found table.
Action:
Enter a value of either a Y (YES) or an N (NO) for SAVED SET MAINT authorization.
Reason:
The value you entered for QUERY LANGUAGE was not DQL or SQL. This option specifies whether the user can write and execute queries in standard DQL Language syntax (DQL) or SQL Mode. A SQL user has access to relational tables only.
Action:
Enter a value of either DQL or SQL for the QUERY LANGUAGE option.
Reason:
The value you entered for SQL AND DQL ALLOWED was not a Y (YES) or an N (NO). This option specifies whether the user can use both DQL syntax and SQL syntax by altering his user profile.
Action:
Enter a value of either Y (YES) or N (NO) for the SQL AND DQL ALLOWED option.
Reason:
The value you entered for SQL DATA DEF ALLOWED was not a Y (YES) or an N (NO). This option specifies whether the user may use SQL Data Definition Language commands: CREATE, COMMENT, and DROP, in a query created using the CA Dataquery Text Editor.
Action:
Enter a value of either Y (YES) or N (NO) for the SQL DATA DEF ALLOWED option.
Reason:
The value you entered for SQL DATA MAINT ALLOWED was not a Y (YES) or an N (NO). This option specifies whether the user may use SQL Data Maintenance Language commands: DELETE, INSERT, and UPDATE, in a query created using the CA Dataquery Text Editor.
Action:
Enter a value of either Y (YES) or N (NO) for the SQL DATA MAINT ALLOWED option.
Reason:
The value you entered for MAXIO was not numeric. The value may contain only numeric digits (0-9), and must be in the range from 0 to 99999. The default is set during CA Dataquery installation by the MAXIO parameter in the System Option Table. This value specifies the maximum number of DATACOM/DB I/O events that are allowed in comparison to the estimated number of I/O events that DATAQUERY estimates will take place if the query is executed. This parameter allows the user to decide if this query will monopolize the system before the query is executed.
Action:
Enter a numeric value for MAXIO. A value of zero indicates that you want to use the value in the System Option Table.
Reason:
The batch output file could not be opened for batch processing. Either the DD statement was missing, the file was not available, or the file is not in the system or you have already written to DQFIXD this run.
Action:
Determine the reason for the file error and make the appropriate correction. Retry the batch job.
Reason:
An I/O error was encountered when writing to the export batch output file (DQOUT). You may be exporting too many records or you may be exporting an invalid detail row.
Action:
Follow the directions for your job responsibilities:
CA Dataquery Administrator
Contact your systems programmer. Review your JCL and the file size of DQOUT with the systems programmer.
Systems Programmer
Verify that the JCL used to submit the batch job is correct. Verify that the size of DQOUT is adequate. Increase if necessary.
Reason:
You are attempting to export too many columns. The total length of all the columns in your print statement exceeds 4,092 characters.
Action:
Remove some of the columns from your print statement until their total length does not exceed 4,092 characters. To review the sizes of your columns, you can display the Extended Column panel.
Reason:
You requested CA Dataquery to EXTRACT data, but the Active Query did not contain a PRINT or DISPLAY statement. The contents of an extracted file are determined by the columns listed in the PRINT or DISPLAY statement of the Active Query.
Action:
Add a PRINT or DISPLAY statement to the query, and execute it again. Then, you can perform the EXTRACT on the Active Found Set.
|
Copyright © 2014 CA.
All rights reserved.
|
|