Specifications

20 – Using PlantScape Data in Other Applications
430 R400
Notes
1 All SQL keywords may be abbreviated to the first two letters.
2 For table data being extracted from the PlantScape server, any database file
can be accessed.
3 For table data being inserted into the PlantScape server database, only user
files can be accessed.
4 If the BITNUMBER keyword is used, then the SIZE keyword must appear
after the bit number (that is, BITNUMBER
bitnumber SIZE
num-of-bits ).
5 The RPTBIT keyword must appear after the BITNUMBER/SIZE reference
and will denote that successive BITNUMBER items will be read/written from
the same word rather than successive words, which is the default.
In addition, the number of bits specified cannot extend over a word
boundary. For example, if BITNUMBER = 2, then the data can only extend
from bits 2 to 15 for that word. Bit counting starts from 0. Thus, the number
of bits must be limited to a value 14. Otherwise, an error will occur during
validation. In general, the BITNUMBER must be
≤
16.
6 If a number of items appear without one of the data type SQL keywords,
then the data type will default to 2INT.
Example The following example will extract a floating point number, a 2-byte integer and
3 strings 10 characters long from an ODBC-compliant database, and store the
values in record 5 of the file 256 starting at word 1.
select floatnum,intnum,string1,string2,string3 from rwb
where name_id=‘Fred Smith’;
"@ TABLEREF TABLENUM 256 RECORDNUM 5 WORDNUM 1 NUMRECORDS 1
FLOAT 2INT CHAR 10 3 @"
JULDATE Date in Julian format [Optional number of items]
TIME Time in seconds since midnight [Optional number of items]
DATETIME Date and time in the format
DD-MMM_YY HH:MM
[Optional number of items]
Data Type
Keyword
Data Type Description Data Item Following
Keyword
Table 20.3
plscpcg.book Page 430 Monday, May 28, 2001 10:11 AM