[Migrated content. Thread originally posted on 02 February 2012]

Command Line utilities for generating the record layout(STR) File?

Can we generate the Dclgen for all the tables in Oracle ESQL From command line

There is no command line utility to generate STR files automatically.
You must use the Layout Editor to create the STR files.

The only command line DCLGEN tool that I am aware of is for use with the Host Compatibility Option (HCO) and provides this capability for DB2 tables only.

The OpenESQL Assistant allows you to generate the Host Variables for selected tables in a query where you can select multiple tables in a specified database, but this works for databases that have an ODBC DSN defined.

I am not aware of a command line DCLGEN utility for Oracle tables.

Perhaps others have come across one?

---