few questions
Posted in 1998
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