This section describes the messages you may encounter when you use a client/server query application, such as CA Visual Express, to obtain, update, or delete CA IDMS data, obtained by executing a generated table procedure:
Reason
An IDMS DML statement returned an unexpected error.
Action
Review the table procedure that was executed at the time of the error using the supplied DML statement number and IDMS status code.
Reason
The value of the SQL-COMMAND-CODE parameter is invalid. One reason for this to happen is when a table procedure is out of sync with its table procedure definition.
Action
Make sure the table procedure program is in sync with the table procedure definition.
Reason
The INSERT function performed by the table procedure requires unique keys for all primary path records.
Action
Provide all unique keys required for this function and resubmit the SQL request.
Section
2000-INSERT-ROW
Reason
The function performed could not find a database record or database relationship that matches the data specified by the provided unique key fields. n specifies the key number with n=1 for the primary key (using the entry and path records) or n>=2 for the first, second, … auxiliary record.
Action
Provide a set of unique keys that locate the database record or database relationship and resubmit the SQL request. For primary path relationships the key for any member record must be found within owner of the set relationship.
Section
2000-INSERT-ROW
2100-CONNECT-MANUAL-SETS
3200-UPDATE-RELATIONSHIPS
3210-CHANGE-PATH
Reason
The primary path relationship from the target record to its owner is a mandatory set relationship.
Action
None. Changing the foreign key for the primary path is not allowed.
Section
3100-DISCONNECT-REQ
Reason
The named auxiliary relationship from the target record to its owner is a mandatory set relationship. n>=2 specifies the key number with n=2 for the first auxiliary record.
Action
None. Changing the foreign key for the auxiliary relationship is not allowed.
Section
3100-DISCONNECT-REQ
Reason
Some, but not all key elements of a relation are nulled.
Action
Correct the request: specify either values for all key elements or do not specify any values at all.
Section
3100-DISCONNECT-REQ
Reason
The table procedure does not support INSERT because the INSERT option has not been checked off in the SQL Option dialog.
Action
Do not use INSERT or update the table procedure and check off the INSERT option.
Section
2000-INSERT-ROW
Reason
The table procedure does not support UPDATE because the UPDATE option has not been checked off in the SQL Option dialog.
Action
Do not use UPDATE or update the table procedure and check off the UPDATE option.
Section
3000-UPDATE-ROW
Reason
The table procedure does not support DELETE because the DELETE option has not been checked off in the SQL Option dialog.
Action
Do not use DELETE or update the table procedure and check off the DELETE option.
Section
4000-DELETE-ROW
|
Copyright © 2013 CA.
All rights reserved.
|
|