genlplfromdb - Generate LPL files to access an SQL database

genlplfromdb [OPTIONS] dbtype dbname -h HOST:PORT -s SCHEMA -u USER -p PW

genlplfromdb --directives

genlplfromdb generates the Landmark Pattern Language file definition to access an SQL database.

You must specify values for the -h, -s, -u, -p, dbtype, and dbname parameters.

Program Option Description
-D destination or --pl=NAME

Specify the destination name or directory for Landmark Pattern Language source tree.

The default destination is %LARUNDIR%\dbname.
-h HOST:PORT or --host=HOST:PORT

Required for Microsoft SQL Server.

Specify the server or host machine and port where the database is located.
-s SCHEMA or --schema=SCHEMA

Required.

Specify the database schema to use when generating the LPL files.

-u USER or --user=USER

Required.

Specify the database user name for the table owner.

-p PW or --pw=STRING

Required.

Specify the password for the database user.

-e FILE or --excludes=FILE

Exclude tables whose name matches the specified patterns in the FILE.

Pattern examples: PR%, %ITEM, EMPLOYEE

-i FILE or --includes=FILE

Include tables whose name matches the specified patterns in the FILE.

Pattern examples: PR%, %ITEM, EMPLOYEE

-t or --type=NAME Source type to generate: foreign, m3, s3, landmark.
-m

Specify a module to use for generated files.

This will default to fz if not specified.

-P

Specify the starting file prefix.

The prefix will default to ZAA if not specified.
-x

Transform directive file.

Directive examples:

rename file Bdgt to Budget

rename field Frg to Frog in Budget

dbtype

Required.

Specify the type of database that the .lpl files will be generated from. Enter one of the following:

  • ORA (for Oracle)

  • MSF (for Microsoft SQL Server).
dbname Specify the database name.
--directives Print a list of valid directives.
-v displayoptions

errorlevel, tracelevel, and verbose specified in any order, where:

  • errorlevel = {n}one | {f}atal | {e}rror | {w}arning (warning is the default)

  • tracelevel = 0:6 where 0 is no message and 6 is everything

  • verbose = whether to display exception stacktrace