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 Oracle. 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)
`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