Specifications

Configuring ODBC Data Exchange Reports
PlantScape Server and Client Configuration Guide 433
‘Offset Record’,
"@ tableref tablenum 254 record -1 word 1 datetime @",
"@ tableref tablenum 254 record -1 word 2 float
double 4int 2int bit 0 size 8@");
/* 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=
"@ history Pointname 01SQLANA type H24H offset 3 @",
smallfloat =
"@history Pointname 01SQLANA type H6M date 15-FEB-94 time 13:48:00 @"
where name=’01SQLANA’
Contents of Report File and Output from SQLCHK
/* insert values from Points "01SQLANA","01SQLSTA" to ODBC-compliant
"testtable"*/
insert into testtable
values(
‘01SQLANA’,
getdate(),
1.200000e+01,
0.000000e+00,
0.000000e+00,
0.000000e+00,
0.000000e+00
);
/* read from ODBC-compliant "testtable" to Points "01SQLANA","01SQLSTA"""*/
select distinct testint from testtable where name=’01SQLANA’;
"@ Pointref Pointname 01SQLSTA parameter PV @"
select distinct testsmall from testtable where name=’01SQLANA’;
"@ Pointref Pointname 01SQLANA parameter A1 @"
select distinct smallfloat from testtable where name=’01SQLANA’;
plscpcg.book Page 433 Monday, May 28, 2001 10:11 AM