RE: few questions

Regarding #1: How would the load command know what columns to create? What data types? Regarding #3: To see a reduction, you would have to unload/drop/load or run the ALTER FRAGMENT statement. -----Original Message----- From: Sadagopan, Sathish, CFCTR [mailto:sadagop0458@att.com] Sent: Monday, November 09, 1998 10:33 AM To: informix-list@iiug.org Subject: few questions 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