Re: few questions

Schaeflein, Paul wrote: > Regarding #1: How would the load command know what columns to create? What > data types? Yup. Good point. > Regarding #3: To see a reduction, you would have to unload/drop/load or run > the ALTER FRAGMENT statement. This I don't agree with. Even though any freed pages are not returned to the free pool, the ti_npdata value should still reflect the number of data pages actually in use. That is, if one deletes all the rows in the table, the ti_npdata should go to 0, even though all the pages allocated to the table are not released. The only reason I can think of why ti_npdata would not go down after deleting a large number of rows is that you have managed to delete all these rows without actually freeing up any data pages. That is, you have managed to leave at least one remaining row on every data page that was allocated. OnLine does not re-organize your rows to fit them onto fewer pages when you have deleted them. If you had 100 data pages used, and delete 99% of your data, but by some fluke managed to do this in a way that leaves one row on each page, then your ti_npdata will not go down. June -- june_t@hotmail.com Grounded in Palo Alto, living on KitKat bars > -----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 > >