YOUR PROJECT CONFIG FILE

SYNTAX

	label: value
	label: value
	..etc.

	varvalue:  PROJDIR=/steve/proj1
	scriptdir: @PROJDIR/pages

Lines beginning with // and blank lines are skipped. Lines may include @variables. Use varvalue to set a variable.

DEFAULTS AND OVERRIDES

PARAMETERS

scriptdir:

Path name of directory where scripts are kept. Default is ./
Example: scriptdir: /steve/proj1/pages

tmpdir:

A directory to be used for temporary files. Default is /tmp.

fdfpath:

Path name of directory where any fdf files are kept. Default is ./

joinprog:

Full path name for psqlj. This is needed because psqlj is executed to perform joins.

dbnull:

Symbol used by external database for a missing or zero length value. Default is null.

dbquote:

Quote character used by external database for quoting alpha values. Default is double quote (").

dbquoteesc:

Character that #dataprep will insert before any embedded dbquote characters, in order to prepare fields for database update. dbquoteesc is not used if htmlqhmode is in effect.

htmlqhmode:

HTML quote handling mode. Default is yes. If yes, #dataprep will convert any embedded double quote (") characters to single quote (') in order to prepare fields for database update. Convenient for use with HTML forms. Your dbquote character must be double quote ("). htmlqhmode may also be set dynamically using #control . When in effect htmlqhmode overrides dbquoteesc.

tabfields:

yes or no. If yes, TDHkit utility programs such as fldfmt(1) expect TAB-delimited fields on standard input and write TAB-delimited fields to standard output. Implies utilfieldterm: tab. Equivalent to the -t option that many of the TDH utilities have.

fieldnameheaders:

yes or no. If yes, TDHkit utility programs such as fldfmt(1) expect the first line of input to be a field name header line. This does not cause a field name header line to be generated on output. May be overridden using the -h or -h- command line options that many of the TDH utilities have.

utilfieldterm:

Character to be used to delimit fields in output from TDH utility programs that output data records. Allowable values are tab, space, or any single character. Default is space.

varvalue:

Preset a variable to a value. This may be used as many times as desired within the config file to set various variables. This may also be used to set a variable that will be referenced later in the config file.
Example: varvalue: MODE=normal

putenv:

Set an environment variable for current process and all subprocesses. This may be used as many times as desired within the config file to set various environment variables. THDkit environment variables are listed here .

decpt:

Set the character to be used as a decimal point. Default is .

DATE-RELATED

dateformat:

Set the default date format . Default is mmddyy.
Example: dateformat: yyyy-mmm-dd

pivotyear:

two digit year that should be used to convert two-digit years to four-digit years. If two-digit years are used, year values that are less than the pivot year are assumed to be 21st century years. Default is 77. See also date format
Example: pivotyear: 70

months:

Set three-character month abbreviations, all lower case.
Example (Spanish):
months: ene feb mar abr pue jun jul ago sep oct nov dic

months.abbrev:

Set three-character month abbreviations, mixed case.
Example (Spanish):
months.abbrev: Ene Feb Mar Abr Pue Jun Jul Ago Sep Oct Nov Dic

months.full

Set full month names.
Example (Spanish):
months.full: Enero Febrero Marcha Abril Pueda Junio Julio Agosto Septiembre Octubre Noviembre Diciembre

weekdays

Set weekday names.
Example (Spanish): weekdays: Dom Lun Mar Mie Jue Vie Sab

omitweekends

omit weekends when doing date calculations, e.g. a Friday will be adjacent to the following Monday. yes or no. Default is no.

strictdatelengths

be strict about date lengths, e.g. an mm/dd/yy date must always be 8 or 10 chars long, otherwise an error will result. yes or no. Default is yes.