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

Using EA to verify DB2 syntax from OS/390 fails, what settings are required?

Using EA to verify DB2 syntax from OS/390 fails, what settings are required?

Problem :

Using EA to verify DB2 syntax from OS/390 fails, what settings are required?

 

Resolution :

1. Configure the tool to recognise Relational Databases

- Open Enterprise Analyzer Administration tool

- From the OPTIONS menu, choose CONFIGURE MICRO FOCUS ENTERPRISE ANALYZER

- Make sure "RELATIONAL DATABASES" option is checked on.

Note : If it is not check it on, check it on and click OK -  REMEMBER to upgrade the workspace.

 

2. Change Workspace options to recognise DB2 for OS/390

- Open Enterprise Analyzer, and the required workspace.

- From the OPTIONS menu, choose WORKSPACE OPTIOONS

- Open the VERIFICATION tab

- Open the LEGACY DIALETS tab

- Click on SQL in the left hand pane ot reveal the options in the right hand pane.        

            - Set SQL Dialect to "DB/2 for OS/390"        

            - Click Apply, then Click OK

 

3.  Add the source files as normal and verify.

Note : By Default, file extension  .DDL refer to OS/390 DB2 SQL and .SQL refer to Oracle PL/SQL, etc.

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-04-22 11:02
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.