<<

Contents

Search

>>

 

JDBC_VIEWNAME

 

 

Instruction

 

 

Syntax:

JDBC_VIEWNAME[(<Name of Index File>)] = <Affix>,<Position>

 

<Name of Index File>

= <INDEX FILE NAME>

<Affix>

= <NUM-EXPRESSION>

<Position>

= <NUM-EXPRESSION>

 

 

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:

Name of Index File

Name of Index File

Affix

Name affix

Position

Position of affix

 

Sample:

JDBC_VIEWNAME(CUSTOMER) = "_view",1

/* The name of the VIEW is: customer_view

 

See also:

JDBC_DRIVER

JDBC_CONNECT

JDBC_MODE

JDBC_DATABASE

JDBC_TABLE

JDBC_PASSWORD

JDBC_USERID

JDBC_SET_ISOLATION

JDBC_SET_CONCURRENCY

JDBC_SET_AUTOCOMMIT

JDBC_GET_DATABASE_NAME$