Hi,
1) Are temp tables not supported in a Load statement ?
eg:- Load from "abc.unl" insert into temp tab_a ;
I have several tables to load into temp tables and the format of the load
file varies from file to
file and Its cumbersome to do a "create temp table ... " for each of
these.
2) When I tried to compile esql/c code calling 4GL functions , It complained
about not finding the
"fglapi.h" , Do I set any parameters to set in the environment ? or are
there any specific
compile options ?
3) After I run a delete statement deleting a large number of rows , I
select
ti_npused pagused , ti_npdata datapage , ti_nrows numrows
from
sysdbspaces , systabinfo where .....
But , I do not see a reduction in 'datapage' even after I run update
statistics high , Is this expected behaviour ?
Platform 7.14 UD1 on MP-RAS.
TIA
Sathish Sadagopan