Database schema extractor

Before compiling .4gl or .per files with Four Js Business Development Suite (BDS) or with Genero Business Development Language (BDS), you need to extract the database schema as a .sch file.

In DBS, the name of the schema extraction tool fglschema, while Genero BDL provides the fgldbsch tool. The fglschema tool could only extract schemas from Informix® databases; fgldbsch can extract database schemas from Informix, and from other databases like Oracle, SQL Server, DB2®, PostgreSQL, MySQL and Genero db. The fglschema tool is still supported in Genero BDL for backward compatibility, but fglschema actually calls fgldbsch.

Note that Genero BDL allows you to centralize new widget types and attributes in the .val file.