IBM Support

Error referencing a reserved word in SQL, when importing a ClearQuest schema

Troubleshooting


Problem

This technote explains how to resolve an error, "The name is a reserved word in SQL (or at least some dialects of SQL)". This can occur when importing a schema with IBM Rational ClearQuest.

Symptom

You encounter this problem when importing a schema using the cqload importschema command. Here is the full error message:

*********************************************************
Starting importschema
*********************************************************

EntityDef "<RECORD TYPE>", FieldDef "<FIELD NAME>": the DB name of this object ("<FIELD NAME>") is invalid.
The name "<FIELD NAME>" is a reserved word in SQL (or at least some dialects of SQL).

*********************************************************
ERROR: importschema FAILED!

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Command Line Tools - CQLoad","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.0.1;7.1.0.2","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
23 June 2018

UID

swg21405550

Page Feedback