Specifications

20 – Using PlantScape Data in Other Applications
434 R400
"@ Pointref Pointname 01SQLSTA parameter H1M @"
select distinct testint from testtable where name=’01SQLANA’;
"@ Pointref Pointname 01SQLSTA parameter OP @"
select distinct smallfloat from testtable where name=’01SQLANA’;
"@ Pointref Pointname 01SQLANA parameter SP @"
select distinct name from testtable where name=’01SQLANA’;
"@ Pointref Pointname 01SQLSTA parameter DESC @"
/* read from a user table 4 (file 254) to ODBC-compliant "testtable"*/
insert into testtable
values(
‘New Record’,
‘01-JAN-81 00:00’,
0.000000e+00,
0.000000e+00,
0,
0,
0
);
/* read from user table 4 to ODBC-compliant "testtable" with record offset */
insert into testtable
values(
‘Offset Record’,
‘01-JAN-81 00:00’,
0.000000e+00,
0.000000e+00,
0,
0,
0
);
/* read from ODBC-compliant "testtable" to user table 4*/
select distinct name,name,testdate,smallfloat,testint,
testsmall,testtiny,testtiny
from testtable where name=’01SQLANA’;
"@ tableref tablenum 254 rec 3 word 1 char 10 2 datetime float 2
2int bit 1 size 5 rptbit 2 @"
/* read from ODBC-compliant with record offset to user table */
select distinct name,name,testdate,smallfloat,testint,
testsmall,testtiny,testtiny
from testtable where name=’01SQLANA’;
"@ tableref tablenum 254 rec -3 word 1 char 10 2 datetime float 2
2int bit 1 size 5 rptbit 2 @"
/* read history values into ODBC-compliant */
update testtable set
testint = 0.000000e+00,
plscpcg.book Page 434 Monday, May 28, 2001 10:11 AM