JDBC_VIEWNAME
|
Syntax: |
JDBC_VIEWNAME[(<Name of Index
File>)] = <Affix>,<Position>
|
||||||
|
|
|
||||||
|
Meaning: |
With JDBC Index Files all data fields of the Index
File are stored as alphanumeric data fields in the SQL database. JDBC_VIEWNAME
specifies whether a VIEW is created when the Index File is created or the
structure of the Index File has changed. The VIEW specifies numeric data
fields with datatype DECIMAL and date fields with datatype DATE. <Affix>
and <Position> specify the name of the VIEW. If <Position> = 0
the name of the VIEW is <Affix> + <Name
of Index File>, otherwise the name is <Name of Index File> + <Affix>. If
<Affix> = "" no VIEW will be created. If no Index File is specified, the
instruction applies to all Index Files of the program. |
||||||
|
Parameter: |
|
||||||
|
Sample: |
JDBC_VIEWNAME(CUSTOMER)
= "_view",1 /*
The name of the VIEW is: customer_view |
||||||
|
See also: |
|