Measure Reference Manual

connectionInfo
input
INT(32) .EXT:ref:25
allocated by caller to be at least 100 bytes, this field is filled in by a call to
MEAS_SQL_MAP_INIT_. This value is only needed when the SQL journal is not being used.
Usage Notes
• When used in conjunction with the SQL journal, each ANSI SQL name can correspond to
several instances of the same object.
• If this API is called with a name_len of 0, the pathid, crvsn and uid fields are filled with
wildcard values.
Examples
This a simplified example in pTAL pseudo code of how to use MEAS_SQLNAME_RESOLVE_ and
MEAS_GETDESCINFO_:
STRING .EXT defcat[0:MAXCATLEN] :=["cat_12"];
STRING .EXT inbuf[0:MAXANSINAME] :=["table sch.t"];
STRING .EXT namebuf[0:MAXANSINAME];
INT namelen;
INT inlen;
FIXED index;
INT .EXT dfile^desc(diskfile^ANSI^desc);
! resolve defaults and syntax check
! calculate inlen and catlen
if (error := MEAS_SQLNAME_RESOLVE_ (namebuf,
MAXANSINAME + 1,
namelen,
inbuf,
inlen,
defcat,
catlen ))
! handle error
! we have a syntactically correct fully qualified name
! initialize non SQL fields of the descriptor
index := -1f;
do
begin
if (error := MEAS_GETDESCINFO_ (dfnum,
namebuf,
namelen,
dfile^desc.File^name^MID.pathid,
dfile^desc.File^name^MID.crvsn,
dfile^desc.SQLMX^Obj^Desc,
index )) then
! handle error
else
! use the descriptor, e.g. call measread_diff_
end;
end
until (index < 0f);
MEAS_GETDESCINFO_ 391