Analyze the FunctionEmulation Project

Analyze EXEC SQL in FunctionEmulation.cbl

1. From the Eclipse IDE, click File > Import.
2. Expand General, and select Existing Projects into Workspace; then click Next.
3. Select Select root directory; then browse to the %PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\Mainframe\SQL\hcopg\FunctionEmulation directory, and click Select Folder.
4. On the Projects list, check FunctionEmulation.
5. Check Copy projects into workspace.
6. Click Finish. Eclipse loads the project and builds it automatically.
7. From the COBOL Explorer, expand FunctionEmulation > COBOL Programs; then double-click the FunctionEmulation.cbl file to view its contents. Pay particular attention to the EXEC SQL statement that references the user-defined functions.
8. Close the code editor.

Analyze FunctionEmulation project properties

1. Open the project properties for the FunctionEmulation project.
2. Expand Micro Focus > Project Settings > COBOL; then select SQL Preprocessor. Several OpenESQL compiler directives have been set for you. The following table offers a brief description of each:

   SQL(TARGETDB=POSTGRESQL)	Target database is PostgreSQL
   SQL(DB=HCODemo)	PostgreSQL connection name is HCODemo
   SQL(PASS=userid.password)	Database login credentials
   SQL(DIALECT=MAINFRAME)	HCOPG database syntax conversion is enabled
   SQL(DBRMLIB)	EXEC-SQL commands are extracted and placed in database request module (DBRM)
   SQL(INIT)	Initiates the database connection
   SQL(NOCHECK)	No SQL compile-time checking performed
   SQL(BEHAVIOR=OPTIMIZED)	Optimizes migration process