Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

SQLCA does not appear in an SQL project automatically

SQLCA does not appear in an SQL project automatically

Problem:

When an SQL project is created in Revolve, SQLCA does not appear as a copybook without manual intervention.  Why is this and how can this be avoided..?

Resolution:

SQLCA is not added automatically into a Revolve Project as it does in MFE.

MFE has functionality within it to know where to look for the SQLCA.  This functionality is not included in Revolve, the directory for the SQLCA has to be manually added.

To do this, a SEARCH DIRECTORIES has to be created in Revolve to tell it where to look for these kind of system items.

From the UTILITIES menu, choose OPTIONS.

Go to the SEARCH DIRECTORIES tab.

Create a new search directory.

Use the browse button next to the directory name, and find the MFE installation source directory.  In a standard installation, it is in     c:\MFE\SOURCE

Now using the DIRECTORY TYPE drop down list, choose COPYBOOK by single clicking.

NOTE :- If the project is not using the SQLCA provided with MFE,  but are using a special one created outside of MFE, the directory that contains the special SQLCA should be substituted in place of the c:\MFE\SOURCE\ entry

Now use the ADD button.  This entry will appear in the CURRENT DIRECTORIES window / list.  Then click OK.

If this is a new project, add any components and the parser will find the SQLCA.

If it is an existing project, click on the MAKE icon (green triangle with a red tick).

The project will be re-parsed and the SQLCA member should be found and loaded.

Old KB# 5101

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 17:22
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.