Specifications

Configuring ODBC Data Exchange Reports
PlantScape Server and Client Configuration Guide 429
Table Reference Type Report
Format
“@ TABLEREF TABLENUM table RECORDNUM record WORDNUM word
NUMRECORDS numrecords datatype @”
Description
This reference type is used to access file data in the PlantScape server database.
table
The server file number to read from or write to
record
First record number to use
word
First word number to use
numrecords
The number of records to read/write
datatype
A data type for each column in the ODBC-compliant database must be
entered. The following data type SQL keywords are available.
Data Type
Keyword
Data Type Description Data Item Following
Keyword
FLOAT Floating point [Optional number of items]
2INT 2 byte integer [Optional number of items]
4INT 4 byte integer [Optional number of items]
CHAR Character string enclosed in ‘...’ Number of characters +
[Optional number of items]
RAWCHAR Character string not enclosed in
‘...’
Number of characters +
[Optional number of items]
BITNUMBER Start bit of partial integer Bit number
SIZE Size of partial integer Number of bits + [RPTBIT
keyword to denote bit repeat]
+ [Optional number of items]
RPTBIT Denotes that successive partial
integer items should be taken
from the same word
Table 20.3
plscpcg.book Page 429 Monday, May 28, 2001 10:11 AM