October 2012 - users-list

How to enable Datacell?
by Chang Ge 16 Oct '12

16 Oct '12

Hi, I am using MonetDB 11.11.11, and I am very interested in the data cell externsion. I followed the doc (http://www.monetdb.org/Documentation/Extensions/Streams) but at the first step when I tried to set datacell optimizer, it said sql>set optimizer='datacell_pipe'; SyntaxException:parseError: ';' expected Syntax error detected.See documentation for details Does anyone know how to use datacell? Thanks very much! Best regards, Chang _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 1

Confusion about concurrency with regards to DDL and Insert Into / Select From
by Percy Wegmann 14 Oct '12

14 Oct '12

I'm very new to MonetDB and am just starting to play around with it. One of the things I'm trying to get my head around is the concurrency model. I've observed some things that make sense and others that I don't understand. 1. Concurrent COPY commands into the same table will cause one or the other to roll back. This makes sense as MonetDB seems to lock at the table level. 2. SELECTing data from a table that concurrently has a COPY command running against it doesn't seem to produce any concurrency errors 3. However, if I INSERT INTO table_B (SELECT ... FROM table_A) while a COPY command is running against table_A, I do get concurrency conflicts 4. Also, if I have a COPY command running into table_A and concurrently issue DDL creating a new table_B, I get a concurrency conflict as well Observations 3+4 seem to indicate that DDL operations and INSERT ... SELECT FROM ... use some sort of database-wide lock. This begs the following questions: a) Is there in fact database-wide locking going on here? b) Is there a workaround that would allow me to issue DDL and make also internal copies of tables while concurrently loading data into other tables? c) Is there something fundamental about the architecture of the database that requires database-wide locking for these ops or is this just a detail of the current implementation that could potentially be ironed out? Thanks! Percy _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 2

invalid tuple received from server, got 138 columns, expected 476, ignoring
by Anthony Damico 13 Oct '12

13 Oct '12

Hi everyone, I just wanted to follow-up on a previous post (available at http://mail.monetdb.org/pipermail/users-list/2012-September/005773.html) about an odd 'invalid tuple received' problem with a bit more detail and a simplified way to replicate everything. I've attached the results of PLAN and EXPLAIN in case that's of any value. The behavior of MonetDB seems strange, since I am able to select count(*) from table; and select every individual column from the table, but not select * from table; I am using the alaska household file from the 2010 american community survey. This file can be downloaded from: http://www2.census.gov/acs2010_1yr/pums/csv_hak.zip Out of all of the commands posted below, only sql>select * from household limit 5 ; gives an error. It says: invalid tuple received from server, got 138 columns, expected 202, ignoring I assume this is a windows-related problem? I am using this in windows 7, x64. Any help would be appreciated! Thanks!!! Here are my SQL commands verbatim: drop table household; create table household ( RT VARCHAR(255), SERIALNO INT, DIVISION INT, PUMA INT, REGION INT, ST INT, ADJHSG INT, ADJINC INT, WGTP INT, NP INT, ZZZZ INT, ACR INT, AGS INT, BATH INT, BDSP INT, BLD INT, BUS INT, CONP INT, ELEP INT, FS INT, FULP INT, GASP INT, HFL INT, INSP INT, MHP INT, MRGI INT, MRGP INT, MRGT INT, MRGX INT, REFR INT, RMSP INT, RNTM INT, RNTP INT, RWAT INT, SINK INT, SMP INT, STOV INT, TEL INT, TEN INT, TOIL INT, VACS INT, VALP INT, VEH INT, WATP INT, YBL INT, FES INT, FINCP INT, FPARC INT, GRNTP INT, GRPIP INT, HHL INT, HHT INT, HINCP INT, HUGCL INT, HUPAC INT, HUPAOC INT, HUPARC INT, KIT INT, LNGI INT, MULTG INT, MV INT, NOC INT, NPF INT, NPP INT, NR INT, NRC INT, OCPIP INT, PARTNER INT, PLM INT, PSF INT, R18 INT, R60 INT, R65 INT, RESMODE INT, SMOCP INT, SMX INT, SRNT INT, SVAL INT, TAXP INT, WIF INT, WKEXREL INT, WORKSTAT INT, FACRP INT, FAGSP INT, FBATHP INT, FBDSP INT, FBLDP INT, FBUSP INT, FCONP INT, FELEP INT, FFSP INT, FFULP INT, FGASP INT, FHFLP INT, FINSP INT, FKITP INT, FMHP INT, FMRGIP INT, FMRGP INT, FMRGTP INT, FMRGXP INT, FMVP INT, FPLMP INT, FREFRP INT, FRMSP INT, FRNTMP INT, FRNTP INT, FRWATP INT, FSINKP INT, FSMP INT, FSMXHP INT, FSMXSP INT, FSTOVP INT, FTAXP INT, FTELP INT, FTENP INT, FTOILP INT, FVACSP INT, FVALP INT, FVEHP INT, FWATP INT, FYBLP INT, wgtp1 INT, wgtp2 INT, wgtp3 INT, wgtp4 INT, wgtp5 INT, wgtp6 INT, wgtp7 INT, wgtp8 INT, wgtp9 INT, wgtp10 INT, wgtp11 INT, wgtp12 INT, wgtp13 INT, wgtp14 INT, wgtp15 INT, wgtp16 INT, wgtp17 INT, wgtp18 INT, wgtp19 INT, wgtp20 INT, wgtp21 INT, wgtp22 INT, wgtp23 INT, wgtp24 INT, wgtp25 INT, wgtp26 INT, wgtp27 INT, wgtp28 INT, wgtp29 INT, wgtp30 INT, wgtp31 INT, wgtp32 INT, wgtp33 INT, wgtp34 INT, wgtp35 INT, wgtp36 INT, wgtp37 INT, wgtp38 INT, wgtp39 INT, wgtp40 INT, wgtp41 INT, wgtp42 INT, wgtp43 INT, wgtp44 INT, wgtp45 INT, wgtp46 INT, wgtp47 INT, wgtp48 INT, wgtp49 INT, wgtp50 INT, wgtp51 INT, wgtp52 INT, wgtp53 INT, wgtp54 INT, wgtp55 INT, wgtp56 INT, wgtp57 INT, wgtp58 INT, wgtp59 INT, wgtp60 INT, wgtp61 INT, wgtp62 INT, wgtp63 INT, wgtp64 INT, wgtp65 INT, wgtp66 INT, wgtp67 INT, wgtp68 INT, wgtp69 INT, wgtp70 INT, wgtp71 INT, wgtp72 INT, wgtp73 INT, wgtp74 INT, wgtp75 INT, wgtp76 INT, wgtp77 INT, wgtp78 INT, wgtp79 INT, wgtp80 INT ); copy 5000 offset 2 records into household from 'C:\Users\AnthonyD\Desktop\ss10hak.csv' using delimiters ',','\n','"' NULL as '' ; \w-1 select count(*) from household; select * from household limit 5 ; PLAN select * from household limit 5 ; EXPLAIN select * from household limit 5 ; select RT, SERIALNO, DIVISION, PUMA, REGION, ST, ADJHSG, ADJINC, WGTP, NP, ZZZZ, ACR, AGS, BATH, BDSP, BLD, BUS, CONP, ELEP, FS, FULP, GASP, HFL, INSP, MHP, MRGI, MRGP, MRGT, MRGX, REFR, RMSP, RNTM, RNTP, RWAT, SINK, SMP, STOV, TEL, TEN, TOIL, VACS, VALP, VEH, WATP, YBL, FES, FINCP, FPARC, GRNTP, GRPIP, HHL, HHT, HINCP, HUGCL, HUPAC, HUPAOC, HUPARC, KIT, LNGI, MULTG, MV, NOC, NPF, NPP, NR, NRC, OCPIP, PARTNER, PLM, PSF, R18, R60, R65, RESMODE, SMOCP, SMX, SRNT, SVAL, TAXP, WIF, WKEXREL, WORKSTAT, FACRP, FAGSP, FBATHP, FBDSP, FBLDP, FBUSP, FCONP, FELEP, FFSP, FFULP, FGASP, FHFLP, FINSP, FKITP, FMHP, FMRGIP, FMRGP, FMRGTP, FMRGXP, FMVP, FPLMP, FREFRP, FRMSP, FRNTMP, FRNTP, FRWATP, FSINKP, FSMP, FSMXHP, FSMXSP, FSTOVP, FTAXP, FTELP, FTENP, FTOILP, FVACSP, FVALP, FVEHP, FWATP, FYBLP, wgtp1, wgtp2, wgtp3, wgtp4, wgtp5, wgtp6, wgtp7, wgtp8, wgtp9, wgtp10, wgtp11, wgtp12, wgtp13, wgtp14, wgtp15, wgtp16, wgtp17, wgtp18, wgtp19, wgtp20, wgtp21, wgtp22, wgtp23, wgtp24, wgtp25, wgtp26, wgtp27, wgtp28, wgtp29, wgtp30, wgtp31, wgtp32, wgtp33, wgtp34, wgtp35, wgtp36, wgtp37, wgtp38, wgtp39, wgtp40, wgtp41, wgtp42, wgtp43, wgtp44, wgtp45, wgtp46, wgtp47, wgtp48, wgtp49, wgtp50, wgtp51, wgtp52, wgtp53, wgtp54, wgtp55, wgtp56, wgtp57, wgtp58, wgtp59, wgtp60, wgtp61, wgtp62, wgtp63, wgtp64, wgtp65, wgtp66, wgtp67, wgtp68, wgtp69, wgtp70, wgtp71, wgtp72, wgtp73, wgtp74, wgtp75, wgtp76, wgtp77, wgtp78, wgtp79, wgtp80 from household limit 5; select RT, SERIALNO, DIVISION, PUMA, REGION, ST, ADJHSG, ADJINC, WGTP, NP, ZZZZ, ACR, AGS, BATH, BDSP, BLD, BUS, CONP, ELEP, FS, FULP, GASP, HFL, INSP, MHP, MRGI, MRGP, MRGT, MRGX, REFR, RMSP, RNTM, RNTP, RWAT, SINK, SMP, STOV, TEL, TEN, TOIL, VACS, VALP, VEH, WATP, YBL, FES, FINCP, FPARC, GRNTP, GRPIP, HHL, HHT, HINCP, HUGCL, HUPAC, HUPAOC, HUPARC, KIT, LNGI, MULTG, MV, NOC, NPF, NPP, NR, NRC, OCPIP, PARTNER, PLM, PSF, R18, R60, R65, RESMODE, SMOCP, SMX, SRNT, SVAL, TAXP, WIF, WKEXREL, WORKSTAT, FACRP, FAGSP, FBATHP, FBDSP, FBLDP, FBUSP, FCONP, FELEP, FFSP, FFULP, FGASP, FHFLP, FINSP, FKITP, FMHP, FMRGIP, FMRGP, FMRGTP, FMRGXP, FMVP, FPLMP, FREFRP, FRMSP, FRNTMP, FRNTP, FRWATP, FSINKP, FSMP, FSMXHP, FSMXSP, FSTOVP, FTAXP, FTELP, FTENP, FTOILP, FVACSP, FVALP, FVEHP, FWATP, FYBLP from household limit 5; select wgtp1, wgtp2, wgtp3, wgtp4, wgtp5, wgtp6, wgtp7, wgtp8, wgtp9, wgtp10, wgtp11, wgtp12, wgtp13, wgtp14, wgtp15, wgtp16, wgtp17, wgtp18, wgtp19, wgtp20, wgtp21, wgtp22, wgtp23, wgtp24, wgtp25, wgtp26, wgtp27, wgtp28, wgtp29, wgtp30, wgtp31, wgtp32, wgtp33, wgtp34, wgtp35, wgtp36, wgtp37, wgtp38, wgtp39, wgtp40, wgtp41, wgtp42, wgtp43, wgtp44, wgtp45, wgtp46, wgtp47, wgtp48, wgtp49, wgtp50, wgtp51, wgtp52, wgtp53, wgtp54, wgtp55, wgtp56, wgtp57, wgtp58, wgtp59, wgtp60, wgtp61, wgtp62, wgtp63, wgtp64, wgtp65, wgtp66, wgtp67, wgtp68, wgtp69, wgtp70, wgtp71, wgtp72, wgtp73, wgtp74, wgtp75, wgtp76, wgtp77, wgtp78, wgtp79, wgtp80 from household limit 5; Here's the output of PLAN and EXPLAIN: operation successful (62.733ms) operation successful (88.682ms) 3335 affected rows (21.1s) +------+ | L1 | +======+ | 3335 | +------+ +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ | rt | serialno | division | puma | region | st | adjhsg | adjinc | wgtp | np | zzzz | acr | ags | bath | bdsp | bld | bus | conp | elep | fs | fulp | gasp | hfl | insp | mhp | mrgi | mrgp | mrgt | mrgx | refr | rmsp | rntm | rntp | rwat | sink | smp | stov | tel | ten | toil | vacs | valp | veh | watp | ybl | fes | fincp | fparc | grntp | grpip | hhl | hht | hincp | hugcl | hupac | hupaoc | huparc | kit | lngi | multg | mv | noc | npf | npp | nr | nrc | ocpip | partner | plm | psf | r18 | r60 | r65 | resmode | smocp | smx | srnt | sval | taxp | wif | wkexrel | workstat | facrp | fagsp | fbathp | fbdsp | fbldp | fbusp | fconp | felep | ffsp | ffulp | fgasp | fhflp | finsp | fkitp | fmhp | fmrgip | fmrgp | fmrgtp | fmrgxp | fmvp | fplmp | frefrp | frmsp | frntmp | frntp | frwatp | fsinkp | fsmp | fsmxhp | fsmxsp | fstovp | ftaxp | ftelp | ftenp | ftoilp | fvacsp | fvalp | fvehp | fwatp | fyblp | wgtp1 | wgtp2 | wgtp3 | wgtp4 | wgtp5 | wgtp6 | wgtp7 | wgtp8 | wgtp9 | wgtp10 | wgtp11 | wgtp12 | wgtp13 | wgtp14 | wgtp15 | wgtp16 | wgtp17 | wgtp18 | wgtp19 | wgtp20 | wgtp21 | wgtp22 | wgtp23 | wgtp24 | wgtp25 | wgtp26 | wgtp27 | wgtp28 | wgtp29 | wgtp30 | wgtp31 | wgtp32 | wgtp33 | wgtp34 | wgtp35 | wgtp36 | wgtp37 | wgtp38 | wgtp39 | wgtp40 | wgtp41 | wgtp42 | wgtp43 | wgtp44 | wgtp45 | wgtp46 | wgtp47 | wgtp48 | wgtp49 | wgtp50 | wgtp51 | wgtp52 | wgtp53 | wgtp54 | wgtp55 | wgtp56 | wgtp57 | wgtp58 | wgtp59 | wgtp60 | wgtp61 | wgtp62 | wgtp63 | wgtp64 | wgtp65 | wgtp66 | wgtp67 | wgtp68 | wgtp69 | wgtp70 | wgtp71 | wgtp72 | wgtp73 | wgtp74 | wgtp75 | wgtp76 | wgtp77 | wgtp78 | wgtp79 | wgtp80 | +======+==========+==========+======+========+======+=========+=========+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+========+======+======+======+======+=======+=======+=======+=======+======+======+=======+=======+=======+========+========+======+======+=======+======+======+======+======+======+======+=======+=========+======+======+======+======+======+=========+=======+======+======+======+======+======+=========+==========+=======+=======+========+=======+=======+=======+=======+=======+======+=======+=======+=======+=======+=======+======+========+=======+========+========+======+=======+========+=======+========+=======+========+========+======+========+========+========+=======+=======+=======+========+========+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+ | H | 1890 | 9 | 400 | 4 | 2 | 1000000 | 1007624 | 46 | 2 | 1 | null | null | 1 | 1 | 6 | null | null | 1 | 2 | 1 | 3 | 4 | null | null | null | null | null | null | 1 | 2 | 2 | 600 | 1 | 1 | null | 1 | 1 | 3 | 1 | null | null | 1 | 1 | 3 | null | null | null | 600 | 21 | 1 | 7 | 34700 | 0 | 4 | 4 | 4 | 1 | 1 | 1 | 3 | 0 | null | 0 | 1 | 0 | null | 0 | 1 | 0 | 0 | 0 | 0 | 2 | null | null | 1 | 0 | null | null | null | null | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | 16 | 10 | 42 | 61 | 44 | 54 | 45 | 71 | 67 | 112 | 50 | 15 | 41 | 111 | 79 | 37 | 67 | 38 | 40 | 81 | 95 | 70 | 81 | 51 | 40 | 38 | 47 | 15 | 22 | 18 | 34 | 95 | 55 | 14 | 51 | 48 | 18 | 43 | 12 | 7 | 13 | 15 | 57 | 72 | 55 | 48 | 50 | 75 | 80 | 116 | 51 | 14 | 38 | 126 | 57 | 30 | 93 | 29 | 53 | 80 | 55 | 71 | 46 | 38 | 57 | 39 | 47 | 16 | 16 | 20 | 50 | 91 | 58 | 20 | 72 | 43 | 11 | 48 | 9 | | H | 2029 | 9 | 101 | 4 | 2 | 1000000 | 1007624 | 269 | 4 | 1 | 1 | null | 1 | 4 | 2 | 2 | null | 80 | 2 | 2 | 80 | 1 | 1500 | null | 1 | 920 | 1 | 1 | 1 | 7 | null | null | 1 | 1 | null | 1 | 1 | 1 | 1 | null | 200000 | 1 | 200 | 4 | 8 | 47100 | 2 | null | null | 1 | 3 | 47100 | 1 | 2 | 4 | 2 | 1 | 1 | 2 | 7 | 0 | 4 | 0 | 0 | 2 | 28 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 1097 | 3 | 0 | 1 | 34 | 1 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 252 | 470 | 264 | 430 | 228 | 243 | 192 | 107 | 265 | 79 | 266 | 268 | 68 | 335 | 503 | 116 | 95 | 389 | 228 | 114 | 254 | 71 | 225 | 116 | 289 | 291 | 233 | 539 | 310 | 423 | 262 | 346 | 511 | 235 | 79 | 407 | 420 | 121 | 223 | 90 | 250 | 70 | 240 | 101 | 259 | 326 | 245 | 461 | 241 | 480 | 315 | 275 | 286 | 338 | 118 | 363 | 409 | 87 | 238 | 418 | 278 | 322 | 297 | 486 | 376 | 262 | 198 | 95 | 259 | 104 | 238 | 309 | 135 | 230 | 408 | 117 | 83 | 497 | 244 | 418 | +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | rel | +=========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================+ | top N ( | | | project ( | | | | table(sys.household) [ household.rt, household.serialno, household.division, household.puma, household.region, household.st, household.adjhsg, household.adjinc, household.wgtp, household.np, household.zzzz, household.acr, household.ags, household.bath, household.bdsp, household.bld, household.bus, household.conp, household.elep, household.fs, household.fulp, household.gasp, household.hfl, household.insp, household.mhp, household.mrgi, household.mrgp, household.mrgt, household.mrgx, household.refr, household.rmsp, household.rntm, household.rntp, household.rwat, household.sink, household.smp, household.stov, household.tel, household.ten, household.toil, household.vacs, household.valp, household.veh, household.watp, household.ybl, household.fes, household.fincp, household.fparc, household.grntp, household.grpip, household.hhl, household.hht, household.hincp, household.hugcl, household.hupac, household.hupaoc, household.huparc, household.kit, household.lngi, household.multg, household.mv, household.noc, household.npf, household.npp, household.nr, household.nrc, household.ocpip, household.partner, household.plm, household.psf, household.r18, household.r60, household.r65, household.resmode, household.smocp, household.smx, household.srnt, household.sval, household.taxp, household.wif, household.wkexrel, household.workstat, household.facrp, household.fagsp, household.fbathp, household.fbdsp, household.fbldp, household.fbusp, household.fconp, household.felep, household.ffsp, household.ffulp, household.fgasp, household.fhflp, household.finsp, household.fkitp, household.fmhp, household.fmrgip, household.fmrgp, household.fmrgtp, household.fmrgxp, household.fmvp, household.fplmp, household.frefrp, household.frmsp, household.frntmp, household.frntp, household.frwatp, household.fsinkp, household.fsmp, household.fsmxhp, household.fsmxsp, household.fstovp, household.ftaxp, household.ftelp, household.ftenp, household.ftoilp, household.fvacsp, household.fvalp, household.fvehp, household.fwatp, household.fyblp, household.wgtp1, household.wgtp2, household.wgtp3, household.wgtp4, household.wgtp5, household.wgtp6, household.wgtp7, household.wgtp8, household.wgtp9, household.wgtp10, household.wgtp11, household.wgtp12, household.wgtp13, household.wgtp14, household.wgtp15, household.wgtp16, household.wgtp17, household.wgtp18, household.wgtp19, household.wgtp20, household.wgtp21, household.wgtp22, household.wgtp23, household.wgtp24, household.wgtp25, household.wgtp26, household.wgtp27, household.wgtp28, household.wgtp29, household.wgtp30, household.wgtp31, household.wgtp32, household.wgtp33, household.wgtp34, household.wgtp35, household.wgtp36, household.wgtp37, household.wgtp38, household.wgtp39, household.wgtp40, household.wgtp41, household.wgtp42, household.wgtp43, household.wgtp44, household.wgtp45, household.wgtp46, household.wgtp47, household.wgtp48, household.wgtp49, household.wgtp50, household.wgtp51, household.wgtp52, household.wgtp53, household.wgtp54, household.wgtp55, household.wgtp56, household.wgtp57, household.wgtp58, household.wgtp59, household.wgtp60, household.wgtp61, household.wgtp62, household.wgtp63, household.wgtp64, household.wgtp65, household.wgtp66, household.wgtp67, household.wgtp68, household.wgtp69, household.wgtp70, household.wgtp71, household.wgtp72, household.wgtp73, household.wgtp74, household.wgtp75, household.wgtp76, household.wgtp77, household.wgtp78, household.wgtp79, household.wgtp80, household.%TID% NOT NULL ] COUNT | | | ) [ household.rt, household.serialno, household.division, household.puma, household.region, household.st, household.adjhsg, household.adjinc, household.wgtp, household.np, household.zzzz, household.acr, household.ags, household.bath, household.bdsp, household.bld, household.bus, household.conp, household.elep, household.fs, household.fulp, household.gasp, household.hfl, household.insp, household.mhp, household.mrgi, household.mrgp, household.mrgt, household.mrgx, household.refr, household.rmsp, household.rntm, household.rntp, household.rwat, household.sink, household.smp, household.stov, household.tel, household.ten, household.toil, household.vacs, household.valp, household.veh, household.watp, household.ybl, household.fes, household.fincp, household.fparc, household.grntp, household.grpip, household.hhl, household.hht, household.hincp, household.hugcl, household.hupac, household.hupaoc, household.huparc, household.kit, household.lngi, household.multg, household.mv, household.noc, household.npf, household.npp, household.nr, household.nrc, household.ocpip, household.partner, household.plm, household.psf, household.r18, household.r60, household.r65, household.resmode, household.smocp, household.smx, household.srnt, household.sval, household.taxp, household.wif, household.wkexrel, household.workstat, household.facrp, household.fagsp, household.fbathp, household.fbdsp, household.fbldp, household.fbusp, household.fconp, household.felep, household.ffsp, household.ffulp, household.fgasp, household.fhflp, household.finsp, household.fkitp, household.fmhp, household.fmrgip, household.fmrgp, household.fmrgtp, household.fmrgxp, household.fmvp, household.fplmp, household.frefrp, household.frmsp, household.frntmp, household.frntp, household.frwatp, household.fsinkp, household.fsmp, household.fsmxhp, household.fsmxsp, household.fstovp, household.ftaxp, household.ftelp, household.ftenp, household.ftoilp, household.fvacsp, household.fvalp, household.fvehp, household.fwatp, household.fyblp, household.wgtp1, household.wgtp2, household.wgtp3, household.wgtp4, household.wgtp5, household.wgtp6, household.wgtp7, household.wgtp8, household.wgtp9, household.wgtp10, household.wgtp11, household.wgtp12, household.wgtp13, household.wgtp14, household.wgtp15, household.wgtp16, household.wgtp17, household.wgtp18, household.wgtp19, household.wgtp20, household.wgtp21, household.wgtp22, household.wgtp23, household.wgtp24, household.wgtp25, household.wgtp26, household.wgtp27, household.wgtp28, household.wgtp29, household.wgtp30, household.wgtp31, household.wgtp32, household.wgtp33, household.wgtp34, household.wgtp35, household.wgtp36, household.wgtp37, household.wgtp38, household.wgtp39, household.wgtp40, household.wgtp41, household.wgtp42, household.wgtp43, household.wgtp44, household.wgtp45, household.wgtp46, household.wgtp47, household.wgtp48, household.wgtp49, household.wgtp50, household.wgtp51, household.wgtp52, household.wgtp53, household.wgtp54, household.wgtp55, household.wgtp56, household.wgtp57, household.wgtp58, household.wgtp59, household.wgtp60, household.wgtp61, household.wgtp62, household.wgtp63, household.wgtp64, household.wgtp65, household.wgtp66, household.wgtp67, household.wgtp68, household.wgtp69, household.wgtp70, household.wgtp71, household.wgtp72, household.wgtp73, household.wgtp74, household.wgtp75, household.wgtp76, household.wgtp77, household.wgtp78, household.wgtp79, household.wgtp80 ] | | ) [ wrd "5" ] | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ +----------------------------------------------------------------------------+ | mal | +============================================================================+ | function user.s4_1{autoCommit=true}():void; | | X_16 := nil:bat[:oid,:oid]; | | X_19 := nil:bat[:oid,:oid]; | | X_20 := nil:bat[:oid,:str]; | | barrier X_3105 := language.dataflow(); | | X_2 := sql.mvc(); | | X_3:bat[:oid,:str] := sql.bind(X_2,"sys","household","rt",0); | | X_8:bat[:oid,:str] := sql.bind(X_2,"sys","household","rt",2); | | X_10 := algebra.kdifference(X_3,X_8); | | X_11 := algebra.kunion(X_10,X_8); | | X_12:bat[:oid,:str] := sql.bind(X_2,"sys","household","rt",1); | | X_14 := algebra.kunion(X_11,X_12); | | X_15:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_16 := bat.reverse(X_15); | | X_17 := algebra.kdifference(X_14,X_16); | | X_18 := algebra.slice(X_17,0:wrd,4:wrd); | | X_19 := bat.mirror(X_18); | | X_20 := algebra.leftjoin(X_19,X_17); | | exit X_3105; | | X_2396 := sql.resultSet(202,1,X_20); | | X_31 := nil:bat[:oid,:int]; | | X_43 := nil:bat[:oid,:int]; | | X_54 := nil:bat[:oid,:int]; | | X_67 := nil:bat[:oid,:int]; | | X_77 := nil:bat[:oid,:int]; | | X_90 := nil:bat[:oid,:int]; | | X_100 := nil:bat[:oid,:int]; | | X_115 := nil:bat[:oid,:int]; | | X_125 := nil:bat[:oid,:int]; | | X_138 := nil:bat[:oid,:int]; | | X_149 := nil:bat[:oid,:int]; | | X_161 := nil:bat[:oid,:int]; | | X_172 := nil:bat[:oid,:int]; | | X_184 := nil:bat[:oid,:int]; | | X_195 := nil:bat[:oid,:int]; | | X_210 := nil:bat[:oid,:int]; | | X_220 := nil:bat[:oid,:int]; | | X_233 := nil:bat[:oid,:int]; | | X_243 := nil:bat[:oid,:int]; | | X_256 := nil:bat[:oid,:int]; | | X_266 := nil:bat[:oid,:int]; | | X_279 := nil:bat[:oid,:int]; | | X_289 := nil:bat[:oid,:int]; | | X_304 := nil:bat[:oid,:int]; | | X_315 := nil:bat[:oid,:int]; | | X_327 := nil:bat[:oid,:int]; | | X_338 := nil:bat[:oid,:int]; | | X_350 := nil:bat[:oid,:int]; | | X_361 := nil:bat[:oid,:int]; | | X_374 := nil:bat[:oid,:int]; | | X_384 := nil:bat[:oid,:int]; | | X_399 := nil:bat[:oid,:int]; | | X_409 := nil:bat[:oid,:int]; | | X_422 := nil:bat[:oid,:int]; | | X_432 := nil:bat[:oid,:int]; | | X_445 := nil:bat[:oid,:int]; | | X_455 := nil:bat[:oid,:int]; | | X_468 := nil:bat[:oid,:int]; | | X_479 := nil:bat[:oid,:int]; | | X_493 := nil:bat[:oid,:int]; | | X_504 := nil:bat[:oid,:int]; | | X_516 := nil:bat[:oid,:int]; | | X_527 := nil:bat[:oid,:int]; | | X_540 := nil:bat[:oid,:int]; | | X_550 := nil:bat[:oid,:int]; | | X_563 := nil:bat[:oid,:int]; | | X_573 := nil:bat[:oid,:int]; | | X_588 := nil:bat[:oid,:int]; | | X_598 := nil:bat[:oid,:int]; | | X_611 := nil:bat[:oid,:int]; | | X_621 := nil:bat[:oid,:int]; | | X_634 := nil:bat[:oid,:int]; | | X_645 := nil:bat[:oid,:int]; | | X_657 := nil:bat[:oid,:int]; | | X_668 := nil:bat[:oid,:int]; | | X_682 := nil:bat[:oid,:int]; | | X_693 := nil:bat[:oid,:int]; | | X_706 := nil:bat[:oid,:int]; | | X_716 := nil:bat[:oid,:int]; | | X_729 := nil:bat[:oid,:int]; | | X_739 := nil:bat[:oid,:int]; | | X_752 := nil:bat[:oid,:int]; | | X_762 := nil:bat[:oid,:int]; | | X_777 := nil:bat[:oid,:int]; | | X_787 := nil:bat[:oid,:int]; | | X_800 := nil:bat[:oid,:int]; | | X_811 := nil:bat[:oid,:int]; | | X_823 := nil:bat[:oid,:int]; | | X_834 := nil:bat[:oid,:int]; | | X_846 := nil:bat[:oid,:int]; | | X_857 := nil:bat[:oid,:int]; | | X_872 := nil:bat[:oid,:int]; | | X_882 := nil:bat[:oid,:int]; | | X_895 := nil:bat[:oid,:int]; | | X_905 := nil:bat[:oid,:int]; | | X_918 := nil:bat[:oid,:int]; | | X_928 := nil:bat[:oid,:int]; | | X_941 := nil:bat[:oid,:int]; | | X_951 := nil:bat[:oid,:int]; | | X_966 := nil:bat[:oid,:int]; | | X_977 := nil:bat[:oid,:int]; | | X_989 := nil:bat[:oid,:int]; | | X_1000 := nil:bat[:oid,:int]; | | X_1012 := nil:bat[:oid,:int]; | | X_1023 := nil:bat[:oid,:int]; | | X_1036 := nil:bat[:oid,:int]; | | X_1046 := nil:bat[:oid,:int]; | | X_1061 := nil:bat[:oid,:int]; | | X_1071 := nil:bat[:oid,:int]; | | X_1084 := nil:bat[:oid,:int]; | | X_1094 := nil:bat[:oid,:int]; | | X_1107 := nil:bat[:oid,:int]; | | X_1117 := nil:bat[:oid,:int]; | | X_1130 := nil:bat[:oid,:int]; | | X_1141 := nil:bat[:oid,:int]; | | X_1155 := nil:bat[:oid,:int]; | | X_1166 := nil:bat[:oid,:int]; | | X_1178 := nil:bat[:oid,:int]; | | X_1189 := nil:bat[:oid,:int]; | | X_1202 := nil:bat[:oid,:int]; | | X_1212 := nil:bat[:oid,:int]; | | X_1225 := nil:bat[:oid,:int]; | | X_1235 := nil:bat[:oid,:int]; | | X_1250 := nil:bat[:oid,:int]; | | X_1260 := nil:bat[:oid,:int]; | | X_1273 := nil:bat[:oid,:int]; | | X_1283 := nil:bat[:oid,:int]; | | X_1296 := nil:bat[:oid,:int]; | | X_1307 := nil:bat[:oid,:int]; | | X_1319 := nil:bat[:oid,:int]; | | X_1330 := nil:bat[:oid,:int]; | | X_1344 := nil:bat[:oid,:int]; | | X_1355 := nil:bat[:oid,:int]; | | X_1368 := nil:bat[:oid,:int]; | | X_1378 := nil:bat[:oid,:int]; | | X_1391 := nil:bat[:oid,:int]; | | X_1401 := nil:bat[:oid,:int]; | | X_1414 := nil:bat[:oid,:int]; | | X_1424 := nil:bat[:oid,:int]; | | X_1439 := nil:bat[:oid,:int]; | | X_1449 := nil:bat[:oid,:int]; | | X_1462 := nil:bat[:oid,:int]; | | X_1473 := nil:bat[:oid,:int]; | | X_1485 := nil:bat[:oid,:int]; | | X_1496 := nil:bat[:oid,:int]; | | X_1508 := nil:bat[:oid,:int]; | | X_1519 := nil:bat[:oid,:int]; | | X_1534 := nil:bat[:oid,:int]; | | X_1544 := nil:bat[:oid,:int]; | | X_1557 := nil:bat[:oid,:int]; | | X_1567 := nil:bat[:oid,:int]; | | X_1580 := nil:bat[:oid,:int]; | | X_1590 := nil:bat[:oid,:int]; | | X_1603 := nil:bat[:oid,:int]; | | X_1613 := nil:bat[:oid,:int]; | | X_1628 := nil:bat[:oid,:int]; | | X_1639 := nil:bat[:oid,:int]; | | X_1651 := nil:bat[:oid,:int]; | | X_1662 := nil:bat[:oid,:int]; | | X_1674 := nil:bat[:oid,:int]; | | X_1685 := nil:bat[:oid,:int]; | | X_1698 := nil:bat[:oid,:int]; | | X_1708 := nil:bat[:oid,:int]; | | X_1723 := nil:bat[:oid,:int]; | | X_1733 := nil:bat[:oid,:int]; | | X_1746 := nil:bat[:oid,:int]; | | X_1756 := nil:bat[:oid,:int]; | | X_1769 := nil:bat[:oid,:int]; | | X_1779 := nil:bat[:oid,:int]; | | X_1792 := nil:bat[:oid,:int]; | | X_1803 := nil:bat[:oid,:int]; | | X_1817 := nil:bat[:oid,:int]; | | X_1828 := nil:bat[:oid,:int]; | | X_1840 := nil:bat[:oid,:int]; | | X_1851 := nil:bat[:oid,:int]; | | X_1864 := nil:bat[:oid,:int]; | | X_1874 := nil:bat[:oid,:int]; | | X_1887 := nil:bat[:oid,:int]; | | X_1897 := nil:bat[:oid,:int]; | | X_1912 := nil:bat[:oid,:int]; | | X_1922 := nil:bat[:oid,:int]; | | X_1935 := nil:bat[:oid,:int]; | | X_1945 := nil:bat[:oid,:int]; | | X_1958 := nil:bat[:oid,:int]; | | X_1969 := nil:bat[:oid,:int]; | | X_1981 := nil:bat[:oid,:int]; | | X_1992 := nil:bat[:oid,:int]; | | X_2006 := nil:bat[:oid,:int]; | | X_2017 := nil:bat[:oid,:int]; | | X_2030 := nil:bat[:oid,:int]; | | X_2040 := nil:bat[:oid,:int]; | | X_2053 := nil:bat[:oid,:int]; | | X_2063 := nil:bat[:oid,:int]; | | X_2076 := nil:bat[:oid,:int]; | | X_2086 := nil:bat[:oid,:int]; | | X_2101 := nil:bat[:oid,:int]; | | X_2111 := nil:bat[:oid,:int]; | | X_2124 := nil:bat[:oid,:int]; | | X_2135 := nil:bat[:oid,:int]; | | X_2147 := nil:bat[:oid,:int]; | | X_2158 := nil:bat[:oid,:int]; | | X_2170 := nil:bat[:oid,:int]; | | X_2181 := nil:bat[:oid,:int]; | | X_2196 := nil:bat[:oid,:int]; | | X_2206 := nil:bat[:oid,:int]; | | X_2219 := nil:bat[:oid,:int]; | | X_2229 := nil:bat[:oid,:int]; | | X_2242 := nil:bat[:oid,:int]; | | X_2252 := nil:bat[:oid,:int]; | | X_2265 := nil:bat[:oid,:int]; | | X_2275 := nil:bat[:oid,:int]; | | X_2290 := nil:bat[:oid,:int]; | | X_2301 := nil:bat[:oid,:int]; | | X_2313 := nil:bat[:oid,:int]; | | X_2324 := nil:bat[:oid,:int]; | | X_2336 := nil:bat[:oid,:int]; | | X_2347 := nil:bat[:oid,:int]; | | X_2360 := nil:bat[:oid,:int]; | | X_2370 := nil:bat[:oid,:int]; | | X_2385 := nil:bat[:oid,:int]; | | X_2395 := nil:bat[:oid,:int]; | | barrier X_3114 := language.dataflow(); | | X_21:bat[:oid,:int] := sql.bind(X_2,"sys","household","serialno",0); | | X_23:bat[:oid,:int] := sql.bind(X_2,"sys","household","serialno",2); | | X_26 := algebra.kdifference(X_21,X_23); | | X_27 := algebra.kunion(X_26,X_23); | | X_28:bat[:oid,:int] := sql.bind(X_2,"sys","household","serialno",1); | | X_29 := algebra.kunion(X_27,X_28); | | X_30 := algebra.kdifference(X_29,X_16); | | X_31 := algebra.leftjoin(X_19,X_30); | | X_32:bat[:oid,:int] := sql.bind(X_2,"sys","household","division",0); | | X_35:bat[:oid,:int] := sql.bind(X_2,"sys","household","division",2); | | X_37 := algebra.kdifference(X_32,X_35); | | X_38 := algebra.kunion(X_37,X_35); | | X_39:bat[:oid,:int] := sql.bind(X_2,"sys","household","division",1); | | X_41 := algebra.kunion(X_38,X_39); | | X_42 := algebra.kdifference(X_41,X_16); | | X_43 := algebra.leftjoin(X_19,X_42); | | X_45:bat[:oid,:int] := sql.bind(X_2,"sys","household","puma",0); | | X_48:bat[:oid,:int] := sql.bind(X_2,"sys","household","puma",2); | | X_49 := algebra.kdifference(X_45,X_48); | | X_50 := algebra.kunion(X_49,X_48); | | X_51:bat[:oid,:int] := sql.bind(X_2,"sys","household","puma",1); | | X_52 := algebra.kunion(X_50,X_51); | | X_53 := algebra.kdifference(X_52,X_16); | | X_54 := algebra.leftjoin(X_19,X_53); | | X_55:bat[:oid,:int] := sql.bind(X_2,"sys","household","region",0); | | X_58:bat[:oid,:int] := sql.bind(X_2,"sys","household","region",2); | | X_60 := algebra.kdifference(X_55,X_58); | | X_61 := algebra.kunion(X_60,X_58); | | X_62:bat[:oid,:int] := sql.bind(X_2,"sys","household","region",1); | | X_64 := algebra.kunion(X_61,X_62); | | X_65 := algebra.kdifference(X_64,X_16); | | X_67 := algebra.leftjoin(X_19,X_65); | | X_68:bat[:oid,:int] := sql.bind(X_2,"sys","household","st",0); | | X_71:bat[:oid,:int] := sql.bind(X_2,"sys","household","st",2); | | X_72 := algebra.kdifference(X_68,X_71); | | X_73 := algebra.kunion(X_72,X_71); | | X_74:bat[:oid,:int] := sql.bind(X_2,"sys","household","st",1); | | X_75 := algebra.kunion(X_73,X_74); | | X_76 := algebra.kdifference(X_75,X_16); | | X_77 := algebra.leftjoin(X_19,X_76); | | X_78:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjhsg",0); | | X_81:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjhsg",2); | | X_83 := algebra.kdifference(X_78,X_81); | | X_84 := algebra.kunion(X_83,X_81); | | X_85:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjhsg",1); | | X_88 := algebra.kunion(X_84,X_85); | | X_89 := algebra.kdifference(X_88,X_16); | | X_90 := algebra.leftjoin(X_19,X_89); | | X_91:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjinc",0); | | X_94:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjinc",2); | | X_95 := algebra.kdifference(X_91,X_94); | | X_96 := algebra.kunion(X_95,X_94); | | X_97:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjinc",1); | | X_98 := algebra.kunion(X_96,X_97); | | X_99 := algebra.kdifference(X_98,X_16); | | X_100 := algebra.leftjoin(X_19,X_99); | | X_101:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp",0); | | X_104:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp",2); | | X_107 := algebra.kdifference(X_101,X_104); | | X_108 := algebra.kunion(X_107,X_104); | | X_109:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp",1); | | X_111 := algebra.kunion(X_108,X_109); | | X_112:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_113 := bat.reverse(X_112); | | X_114 := algebra.kdifference(X_111,X_113); | | X_115 := algebra.leftjoin(X_19,X_114); | | X_116:bat[:oid,:int] := sql.bind(X_2,"sys","household","np",0); | | X_119:bat[:oid,:int] := sql.bind(X_2,"sys","household","np",2); | | X_120 := algebra.kdifference(X_116,X_119); | | X_121 := algebra.kunion(X_120,X_119); | | X_122:bat[:oid,:int] := sql.bind(X_2,"sys","household","np",1); | | X_123 := algebra.kunion(X_121,X_122); | | X_124 := algebra.kdifference(X_123,X_113); | | X_125 := algebra.leftjoin(X_19,X_124); | | X_127:bat[:oid,:int] := sql.bind(X_2,"sys","household","zzzz",0); | | X_130:bat[:oid,:int] := sql.bind(X_2,"sys","household","zzzz",2); | | X_132 := algebra.kdifference(X_127,X_130); | | X_133 := algebra.kunion(X_132,X_130); | | X_134:bat[:oid,:int] := sql.bind(X_2,"sys","household","zzzz",1); | | X_136 := algebra.kunion(X_133,X_134); | | X_137 := algebra.kdifference(X_136,X_113); | | X_138 := algebra.leftjoin(X_19,X_137); | | X_139:bat[:oid,:int] := sql.bind(X_2,"sys","household","acr",0); | | X_142:bat[:oid,:int] := sql.bind(X_2,"sys","household","acr",2); | | X_143 := algebra.kdifference(X_139,X_142); | | X_144 := algebra.kunion(X_143,X_142); | | X_145:bat[:oid,:int] := sql.bind(X_2,"sys","household","acr",1); | | X_146 := algebra.kunion(X_144,X_145); | | X_147 := algebra.kdifference(X_146,X_113); | | X_149 := algebra.leftjoin(X_19,X_147); | | X_150:bat[:oid,:int] := sql.bind(X_2,"sys","household","ags",0); | | X_153:bat[:oid,:int] := sql.bind(X_2,"sys","household","ags",2); | | X_155 := algebra.kdifference(X_150,X_153); | | X_156 := algebra.kunion(X_155,X_153); | | X_157:bat[:oid,:int] := sql.bind(X_2,"sys","household","ags",1); | | X_159 := algebra.kunion(X_156,X_157); | | X_160 := algebra.kdifference(X_159,X_113); | | X_161 := algebra.leftjoin(X_19,X_160); | | X_162:bat[:oid,:int] := sql.bind(X_2,"sys","household","bath",0); | | X_165:bat[:oid,:int] := sql.bind(X_2,"sys","household","bath",2); | | X_166 := algebra.kdifference(X_162,X_165); | | X_167 := algebra.kunion(X_166,X_165); | | X_168:bat[:oid,:int] := sql.bind(X_2,"sys","household","bath",1); | | X_170 := algebra.kunion(X_167,X_168); | | X_171 := algebra.kdifference(X_170,X_113); | | X_172 := algebra.leftjoin(X_19,X_171); | | X_173:bat[:oid,:int] := sql.bind(X_2,"sys","household","bdsp",0); | | X_176:bat[:oid,:int] := sql.bind(X_2,"sys","household","bdsp",2); | | X_178 := algebra.kdifference(X_173,X_176); | | X_179 := algebra.kunion(X_178,X_176); | | X_180:bat[:oid,:int] := sql.bind(X_2,"sys","household","bdsp",1); | | X_182 := algebra.kunion(X_179,X_180); | | X_183 := algebra.kdifference(X_182,X_113); | | X_184 := algebra.leftjoin(X_19,X_183); | | X_185:bat[:oid,:int] := sql.bind(X_2,"sys","household","bld",0); | | X_189:bat[:oid,:int] := sql.bind(X_2,"sys","household","bld",2); | | X_190 := algebra.kdifference(X_185,X_189); | | X_191 := algebra.kunion(X_190,X_189); | | X_192:bat[:oid,:int] := sql.bind(X_2,"sys","household","bld",1); | | X_193 := algebra.kunion(X_191,X_192); | | X_194 := algebra.kdifference(X_193,X_113); | | X_195 := algebra.leftjoin(X_19,X_194); | | X_196:bat[:oid,:int] := sql.bind(X_2,"sys","household","bus",0); | | X_199:bat[:oid,:int] := sql.bind(X_2,"sys","household","bus",2); | | X_201 := algebra.kdifference(X_196,X_199); | | X_202 := algebra.kunion(X_201,X_199); | | X_203:bat[:oid,:int] := sql.bind(X_2,"sys","household","bus",1); | | X_205 := algebra.kunion(X_202,X_203); | | X_206:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_207 := bat.reverse(X_206); | | X_208 := algebra.kdifference(X_205,X_207); | | X_210 := algebra.leftjoin(X_19,X_208); | | X_211:bat[:oid,:int] := sql.bind(X_2,"sys","household","conp",0); | | X_214:bat[:oid,:int] := sql.bind(X_2,"sys","household","conp",2); | | X_215 := algebra.kdifference(X_211,X_214); | | X_216 := algebra.kunion(X_215,X_214); | | X_217:bat[:oid,:int] := sql.bind(X_2,"sys","household","conp",1); | | X_218 := algebra.kunion(X_216,X_217); | | X_219 := algebra.kdifference(X_218,X_207); | | X_220 := algebra.leftjoin(X_19,X_219); | | X_221:bat[:oid,:int] := sql.bind(X_2,"sys","household","elep",0); | | X_224:bat[:oid,:int] := sql.bind(X_2,"sys","household","elep",2); | | X_226 := algebra.kdifference(X_221,X_224); | | X_227 := algebra.kunion(X_226,X_224); | | X_228:bat[:oid,:int] := sql.bind(X_2,"sys","household","elep",1); | | X_230 := algebra.kunion(X_227,X_228); | | X_232 := algebra.kdifference(X_230,X_207); | | X_233 := algebra.leftjoin(X_19,X_232); | | X_234:bat[:oid,:int] := sql.bind(X_2,"sys","household","fs",0); | | X_237:bat[:oid,:int] := sql.bind(X_2,"sys","household","fs",2); | | X_238 := algebra.kdifference(X_234,X_237); | | X_239 := algebra.kunion(X_238,X_237); | | X_240:bat[:oid,:int] := sql.bind(X_2,"sys","household","fs",1); | | X_241 := algebra.kunion(X_239,X_240); | | X_242 := algebra.kdifference(X_241,X_207); | | X_243 := algebra.leftjoin(X_19,X_242); | | X_244:bat[:oid,:int] := sql.bind(X_2,"sys","household","fulp",0); | | X_247:bat[:oid,:int] := sql.bind(X_2,"sys","household","fulp",2); | | X_249 := algebra.kdifference(X_244,X_247); | | X_250 := algebra.kunion(X_249,X_247); | | X_251:bat[:oid,:int] := sql.bind(X_2,"sys","household","fulp",1); | | X_254 := algebra.kunion(X_250,X_251); | | X_255 := algebra.kdifference(X_254,X_207); | | X_256 := algebra.leftjoin(X_19,X_255); | | X_257:bat[:oid,:int] := sql.bind(X_2,"sys","household","gasp",0); | | X_260:bat[:oid,:int] := sql.bind(X_2,"sys","household","gasp",2); | | X_261 := algebra.kdifference(X_257,X_260); | | X_262 := algebra.kunion(X_261,X_260); | | X_263:bat[:oid,:int] := sql.bind(X_2,"sys","household","gasp",1); | | X_264 := algebra.kunion(X_262,X_263); | | X_265 := algebra.kdifference(X_264,X_207); | | X_266 := algebra.leftjoin(X_19,X_265); | | X_267:bat[:oid,:int] := sql.bind(X_2,"sys","household","hfl",0); | | X_270:bat[:oid,:int] := sql.bind(X_2,"sys","household","hfl",2); | | X_273 := algebra.kdifference(X_267,X_270); | | X_274 := algebra.kunion(X_273,X_270); | | X_275:bat[:oid,:int] := sql.bind(X_2,"sys","household","hfl",1); | | X_277 := algebra.kunion(X_274,X_275); | | X_278 := algebra.kdifference(X_277,X_207); | | X_279 := algebra.leftjoin(X_19,X_278); | | X_280:bat[:oid,:int] := sql.bind(X_2,"sys","household","insp",0); | | X_283:bat[:oid,:int] := sql.bind(X_2,"sys","household","insp",2); | | X_284 := algebra.kdifference(X_280,X_283); | | X_285 := algebra.kunion(X_284,X_283); | | X_286:bat[:oid,:int] := sql.bind(X_2,"sys","household","insp",1); | | X_287 := algebra.kunion(X_285,X_286); | | X_288 := algebra.kdifference(X_287,X_207); | | X_289 := algebra.leftjoin(X_19,X_288); | | X_291:bat[:oid,:int] := sql.bind(X_2,"sys","household","mhp",0); | | X_294:bat[:oid,:int] := sql.bind(X_2,"sys","household","mhp",2); | | X_296 := algebra.kdifference(X_291,X_294); | | X_297 := algebra.kunion(X_296,X_294); | | X_298:bat[:oid,:int] := sql.bind(X_2,"sys","household","mhp",1); | | X_300 := algebra.kunion(X_297,X_298); | | X_301:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_302 := bat.reverse(X_301); | | X_303 := algebra.kdifference(X_300,X_302); | | X_304 := algebra.leftjoin(X_19,X_303); | | X_305:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgi",0); | | X_308:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgi",2); | | X_309 := algebra.kdifference(X_305,X_308); | | X_310 := algebra.kunion(X_309,X_308); | | X_311:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgi",1); | | X_312 := algebra.kunion(X_310,X_311); | | X_313 := algebra.kdifference(X_312,X_302); | | X_315 := algebra.leftjoin(X_19,X_313); | | X_316:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgp",0); | | X_319:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgp",2); | | X_321 := algebra.kdifference(X_316,X_319); | | X_322 := algebra.kunion(X_321,X_319); | | X_323:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgp",1); | | X_325 := algebra.kunion(X_322,X_323); | | X_326 := algebra.kdifference(X_325,X_302); | | X_327 := algebra.leftjoin(X_19,X_326); | | X_328:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgt",0); | | X_331:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgt",2); | | X_332 := algebra.kdifference(X_328,X_331); | | X_333 := algebra.kunion(X_332,X_331); | | X_334:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgt",1); | | X_336 := algebra.kunion(X_333,X_334); | | X_337 := algebra.kdifference(X_336,X_302); | | X_338 := algebra.leftjoin(X_19,X_337); | | X_339:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgx",0); | | X_342:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgx",2); | | X_344 := algebra.kdifference(X_339,X_342); | | X_345 := algebra.kunion(X_344,X_342); | | X_346:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgx",1); | | X_348 := algebra.kunion(X_345,X_346); | | X_349 := algebra.kdifference(X_348,X_302); | | X_350 := algebra.leftjoin(X_19,X_349); | | X_351:bat[:oid,:int] := sql.bind(X_2,"sys","household","refr",0); | | X_355:bat[:oid,:int] := sql.bind(X_2,"sys","household","refr",2); | | X_356 := algebra.kdifference(X_351,X_355); | | X_357 := algebra.kunion(X_356,X_355); | | X_358:bat[:oid,:int] := sql.bind(X_2,"sys","household","refr",1); | | X_359 := algebra.kunion(X_357,X_358); | | X_360 := algebra.kdifference(X_359,X_302); | | X_361 := algebra.leftjoin(X_19,X_360); | | X_362:bat[:oid,:int] := sql.bind(X_2,"sys","household","rmsp",0); | | X_365:bat[:oid,:int] := sql.bind(X_2,"sys","household","rmsp",2); | | X_367 := algebra.kdifference(X_362,X_365); | | X_368 := algebra.kunion(X_367,X_365); | | X_369:bat[:oid,:int] := sql.bind(X_2,"sys","household","rmsp",1); | | X_371 := algebra.kunion(X_368,X_369); | | X_372 := algebra.kdifference(X_371,X_302); | | X_374 := algebra.leftjoin(X_19,X_372); | | X_375:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntm",0); | | X_378:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntm",2); | | X_379 := algebra.kdifference(X_375,X_378); | | X_380 := algebra.kunion(X_379,X_378); | | X_381:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntm",1); | | X_382 := algebra.kunion(X_380,X_381); | | X_383 := algebra.kdifference(X_382,X_302); | | X_384 := algebra.leftjoin(X_19,X_383); | | X_385:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntp",0); | | X_388:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntp",2); | | X_390 := algebra.kdifference(X_385,X_388); | | X_391 := algebra.kunion(X_390,X_388); | | X_392:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntp",1); | | X_394 := algebra.kunion(X_391,X_392); | | X_395:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_397 := bat.reverse(X_395); | | X_398 := algebra.kdifference(X_394,X_397); | | X_399 := algebra.leftjoin(X_19,X_398); | | X_400:bat[:oid,:int] := sql.bind(X_2,"sys","household","rwat",0); | | X_403:bat[:oid,:int] := sql.bind(X_2,"sys","household","rwat",2); | | X_404 := algebra.kdifference(X_400,X_403); | | X_405 := algebra.kunion(X_404,X_403); | | X_406:bat[:oid,:int] := sql.bind(X_2,"sys","household","rwat",1); | | X_407 := algebra.kunion(X_405,X_406); | | X_408 := algebra.kdifference(X_407,X_397); | | X_409 := algebra.leftjoin(X_19,X_408); | | X_410:bat[:oid,:int] := sql.bind(X_2,"sys","household","sink",0); | | X_413:bat[:oid,:int] := sql.bind(X_2,"sys","household","sink",2); | | X_415 := algebra.kdifference(X_410,X_413); | | X_416 := algebra.kunion(X_415,X_413); | | X_417:bat[:oid,:int] := sql.bind(X_2,"sys","household","sink",1); | | X_420 := algebra.kunion(X_416,X_417); | | X_421 := algebra.kdifference(X_420,X_397); | | X_422 := algebra.leftjoin(X_19,X_421); | | X_423:bat[:oid,:int] := sql.bind(X_2,"sys","household","smp",0); | | X_426:bat[:oid,:int] := sql.bind(X_2,"sys","household","smp",2); | | X_427 := algebra.kdifference(X_423,X_426); | | X_428 := algebra.kunion(X_427,X_426); | | X_429:bat[:oid,:int] := sql.bind(X_2,"sys","household","smp",1); | | X_430 := algebra.kunion(X_428,X_429); | | X_431 := algebra.kdifference(X_430,X_397); | | X_432 := algebra.leftjoin(X_19,X_431); | | X_433:bat[:oid,:int] := sql.bind(X_2,"sys","household","stov",0); | | X_436:bat[:oid,:int] := sql.bind(X_2,"sys","household","stov",2); | | X_439 := algebra.kdifference(X_433,X_436); | | X_440 := algebra.kunion(X_439,X_436); | | X_441:bat[:oid,:int] := sql.bind(X_2,"sys","household","stov",1); | | X_443 := algebra.kunion(X_440,X_441); | | X_444 := algebra.kdifference(X_443,X_397); | | X_445 := algebra.leftjoin(X_19,X_444); | | X_446:bat[:oid,:int] := sql.bind(X_2,"sys","household","tel",0); | | X_449:bat[:oid,:int] := sql.bind(X_2,"sys","household","tel",2); | | X_450 := algebra.kdifference(X_446,X_449); | | X_451 := algebra.kunion(X_450,X_449); | | X_452:bat[:oid,:int] := sql.bind(X_2,"sys","household","tel",1); | | X_453 := algebra.kunion(X_451,X_452); | | X_454 := algebra.kdifference(X_453,X_397); | | X_455 := algebra.leftjoin(X_19,X_454); | | X_457:bat[:oid,:int] := sql.bind(X_2,"sys","household","ten",0); | | X_460:bat[:oid,:int] := sql.bind(X_2,"sys","household","ten",2); | | X_462 := algebra.kdifference(X_457,X_460); | | X_463 := algebra.kunion(X_462,X_460); | | X_464:bat[:oid,:int] := sql.bind(X_2,"sys","household","ten",1); | | X_466 := algebra.kunion(X_463,X_464); | | X_467 := algebra.kdifference(X_466,X_397); | | X_468 := algebra.leftjoin(X_19,X_467); | | X_469:bat[:oid,:int] := sql.bind(X_2,"sys","household","toil",0); | | X_472:bat[:oid,:int] := sql.bind(X_2,"sys","household","toil",2); | | X_473 := algebra.kdifference(X_469,X_472); | | X_474 := algebra.kunion(X_473,X_472); | | X_475:bat[:oid,:int] := sql.bind(X_2,"sys","household","toil",1); | | X_476 := algebra.kunion(X_474,X_475); | | X_477 := algebra.kdifference(X_476,X_397); | | X_479 := algebra.leftjoin(X_19,X_477); | | X_480:bat[:oid,:int] := sql.bind(X_2,"sys","household","vacs",0); | | X_483:bat[:oid,:int] := sql.bind(X_2,"sys","household","vacs",2); | | X_485 := algebra.kdifference(X_480,X_483); | | X_486 := algebra.kunion(X_485,X_483); | | X_487:bat[:oid,:int] := sql.bind(X_2,"sys","household","vacs",1); | | X_489 := algebra.kunion(X_486,X_487); | | X_490:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_491 := bat.reverse(X_490); | | X_492 := algebra.kdifference(X_489,X_491); | | X_493 := algebra.leftjoin(X_19,X_492); | | X_494:bat[:oid,:int] := sql.bind(X_2,"sys","household","valp",0); | | X_497:bat[:oid,:int] := sql.bind(X_2,"sys","household","valp",2); | | X_498 := algebra.kdifference(X_494,X_497); | | X_499 := algebra.kunion(X_498,X_497); | | X_500:bat[:oid,:int] := sql.bind(X_2,"sys","household","valp",1); | | X_502 := algebra.kunion(X_499,X_500); | | X_503 := algebra.kdifference(X_502,X_491); | | X_504 := algebra.leftjoin(X_19,X_503); | | X_505:bat[:oid,:int] := sql.bind(X_2,"sys","household","veh",0); | | X_508:bat[:oid,:int] := sql.bind(X_2,"sys","household","veh",2); | | X_510 := algebra.kdifference(X_505,X_508); | | X_511 := algebra.kunion(X_510,X_508); | | X_512:bat[:oid,:int] := sql.bind(X_2,"sys","household","veh",1); | | X_514 := algebra.kunion(X_511,X_512); | | X_515 := algebra.kdifference(X_514,X_491); | | X_516 := algebra.leftjoin(X_19,X_515); | | X_517:bat[:oid,:int] := sql.bind(X_2,"sys","household","watp",0); | | X_521:bat[:oid,:int] := sql.bind(X_2,"sys","household","watp",2); | | X_522 := algebra.kdifference(X_517,X_521); | | X_523 := algebra.kunion(X_522,X_521); | | X_524:bat[:oid,:int] := sql.bind(X_2,"sys","household","watp",1); | | X_525 := algebra.kunion(X_523,X_524); | | X_526 := algebra.kdifference(X_525,X_491); | | X_527 := algebra.leftjoin(X_19,X_526); | | X_528:bat[:oid,:int] := sql.bind(X_2,"sys","household","ybl",0); | | X_531:bat[:oid,:int] := sql.bind(X_2,"sys","household","ybl",2); | | X_533 := algebra.kdifference(X_528,X_531); | | X_534 := algebra.kunion(X_533,X_531); | | X_535:bat[:oid,:int] := sql.bind(X_2,"sys","household","ybl",1); | | X_537 := algebra.kunion(X_534,X_535); | | X_538 := algebra.kdifference(X_537,X_491); | | X_540 := algebra.leftjoin(X_19,X_538); | | X_541:bat[:oid,:int] := sql.bind(X_2,"sys","household","fes",0); | | X_544:bat[:oid,:int] := sql.bind(X_2,"sys","household","fes",2); | | X_545 := algebra.kdifference(X_541,X_544); | | X_546 := algebra.kunion(X_545,X_544); | | X_547:bat[:oid,:int] := sql.bind(X_2,"sys","household","fes",1); | | X_548 := algebra.kunion(X_546,X_547); | | X_549 := algebra.kdifference(X_548,X_491); | | X_550 := algebra.leftjoin(X_19,X_549); | | X_551:bat[:oid,:int] := sql.bind(X_2,"sys","household","fincp",0); | | X_554:bat[:oid,:int] := sql.bind(X_2,"sys","household","fincp",2); | | X_556 := algebra.kdifference(X_551,X_554); | | X_557 := algebra.kunion(X_556,X_554); | | X_558:bat[:oid,:int] := sql.bind(X_2,"sys","household","fincp",1); | | X_560 := algebra.kunion(X_557,X_558); | | X_562 := algebra.kdifference(X_560,X_491); | | X_563 := algebra.leftjoin(X_19,X_562); | | X_564:bat[:oid,:int] := sql.bind(X_2,"sys","household","fparc",0); | | X_567:bat[:oid,:int] := sql.bind(X_2,"sys","household","fparc",2); | | X_568 := algebra.kdifference(X_564,X_567); | | X_569 := algebra.kunion(X_568,X_567); | | X_570:bat[:oid,:int] := sql.bind(X_2,"sys","household","fparc",1); | | X_571 := algebra.kunion(X_569,X_570); | | X_572 := algebra.kdifference(X_571,X_491); | | X_573 := algebra.leftjoin(X_19,X_572); | | X_574:bat[:oid,:int] := sql.bind(X_2,"sys","household","grntp",0); | | X_577:bat[:oid,:int] := sql.bind(X_2,"sys","household","grntp",2); | | X_579 := algebra.kdifference(X_574,X_577); | | X_580 := algebra.kunion(X_579,X_577); | | X_581:bat[:oid,:int] := sql.bind(X_2,"sys","household","grntp",1); | | X_584 := algebra.kunion(X_580,X_581); | | X_585:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_586 := bat.reverse(X_585); | | X_587 := algebra.kdifference(X_584,X_586); | | X_588 := algebra.leftjoin(X_19,X_587); | | X_589:bat[:oid,:int] := sql.bind(X_2,"sys","household","grpip",0); | | X_592:bat[:oid,:int] := sql.bind(X_2,"sys","household","grpip",2); | | X_593 := algebra.kdifference(X_589,X_592); | | X_594 := algebra.kunion(X_593,X_592); | | X_595:bat[:oid,:int] := sql.bind(X_2,"sys","household","grpip",1); | | X_596 := algebra.kunion(X_594,X_595); | | X_597 := algebra.kdifference(X_596,X_586); | | X_598 := algebra.leftjoin(X_19,X_597); | | X_599:bat[:oid,:int] := sql.bind(X_2,"sys","household","hhl",0); | | X_602:bat[:oid,:int] := sql.bind(X_2,"sys","household","hhl",2); | | X_605 := algebra.kdifference(X_599,X_602); | | X_606 := algebra.kunion(X_605,X_602); | | X_607:bat[:oid,:int] := sql.bind(X_2,"sys","household","hhl",1); | | X_609 := algebra.kunion(X_606,X_607); | | X_610 := algebra.kdifference(X_609,X_586); | | X_611 := algebra.leftjoin(X_19,X_610); | | X_612:bat[:oid,:int] := sql.bind(X_2,"sys","household","hht",0); | | X_615:bat[:oid,:int] := sql.bind(X_2,"sys","household","hht",2); | | X_616 := algebra.kdifference(X_612,X_615); | | X_617 := algebra.kunion(X_616,X_615); | | X_618:bat[:oid,:int] := sql.bind(X_2,"sys","household","hht",1); | | X_619 := algebra.kunion(X_617,X_618); | | X_620 := algebra.kdifference(X_619,X_586); | | X_621 := algebra.leftjoin(X_19,X_620); | | X_623:bat[:oid,:int] := sql.bind(X_2,"sys","household","hincp",0); | | X_626:bat[:oid,:int] := sql.bind(X_2,"sys","household","hincp",2); | | X_628 := algebra.kdifference(X_623,X_626); | | X_629 := algebra.kunion(X_628,X_626); | | X_630:bat[:oid,:int] := sql.bind(X_2,"sys","household","hincp",1); | | X_632 := algebra.kunion(X_629,X_630); | | X_633 := algebra.kdifference(X_632,X_586); | | X_634 := algebra.leftjoin(X_19,X_633); | | X_635:bat[:oid,:int] := sql.bind(X_2,"sys","household","hugcl",0); | | X_638:bat[:oid,:int] := sql.bind(X_2,"sys","household","hugcl",2); | | X_639 := algebra.kdifference(X_635,X_638); | | X_640 := algebra.kunion(X_639,X_638); | | X_641:bat[:oid,:int] := sql.bind(X_2,"sys","household","hugcl",1); | | X_642 := algebra.kunion(X_640,X_641); | | X_643 := algebra.kdifference(X_642,X_586); | | X_645 := algebra.leftjoin(X_19,X_643); | | X_646:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupac",0); | | X_649:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupac",2); | | X_651 := algebra.kdifference(X_646,X_649); | | X_652 := algebra.kunion(X_651,X_649); | | X_653:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupac",1); | | X_655 := algebra.kunion(X_652,X_653); | | X_656 := algebra.kdifference(X_655,X_586); | | X_657 := algebra.leftjoin(X_19,X_656); | | X_658:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupaoc",0); | | X_661:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupaoc",2); | | X_662 := algebra.kdifference(X_658,X_661); | | X_663 := algebra.kunion(X_662,X_661); | | X_664:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupaoc",1); | | X_666 := algebra.kunion(X_663,X_664); | | X_667 := algebra.kdifference(X_666,X_586); | | X_668 := algebra.leftjoin(X_19,X_667); | | X_669:bat[:oid,:int] := sql.bind(X_2,"sys","household","huparc",0); | | X_672:bat[:oid,:int] := sql.bind(X_2,"sys","household","huparc",2); | | X_674 := algebra.kdifference(X_669,X_672); | | X_675 := algebra.kunion(X_674,X_672); | | X_676:bat[:oid,:int] := sql.bind(X_2,"sys","household","huparc",1); | | X_678 := algebra.kunion(X_675,X_676); | | X_679:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_680 := bat.reverse(X_679); | | X_681 := algebra.kdifference(X_678,X_680); | | X_682 := algebra.leftjoin(X_19,X_681); | | X_683:bat[:oid,:int] := sql.bind(X_2,"sys","household","kit",0); | | X_687:bat[:oid,:int] := sql.bind(X_2,"sys","household","kit",2); | | X_688 := algebra.kdifference(X_683,X_687); | | X_689 := algebra.kunion(X_688,X_687); | | X_690:bat[:oid,:int] := sql.bind(X_2,"sys","household","kit",1); | | X_691 := algebra.kunion(X_689,X_690); | | X_692 := algebra.kdifference(X_691,X_680); | | X_693 := algebra.leftjoin(X_19,X_692); | | X_694:bat[:oid,:int] := sql.bind(X_2,"sys","household","lngi",0); | | X_697:bat[:oid,:int] := sql.bind(X_2,"sys","household","lngi",2); | | X_699 := algebra.kdifference(X_694,X_697); | | X_700 := algebra.kunion(X_699,X_697); | | X_701:bat[:oid,:int] := sql.bind(X_2,"sys","household","lngi",1); | | X_703 := algebra.kunion(X_700,X_701); | | X_704 := algebra.kdifference(X_703,X_680); | | X_706 := algebra.leftjoin(X_19,X_704); | | X_707:bat[:oid,:int] := sql.bind(X_2,"sys","household","multg",0); | | X_710:bat[:oid,:int] := sql.bind(X_2,"sys","household","multg",2); | | X_711 := algebra.kdifference(X_707,X_710); | | X_712 := algebra.kunion(X_711,X_710); | | X_713:bat[:oid,:int] := sql.bind(X_2,"sys","household","multg",1); | | X_714 := algebra.kunion(X_712,X_713); | | X_715 := algebra.kdifference(X_714,X_680); | | X_716 := algebra.leftjoin(X_19,X_715); | | X_717:bat[:oid,:int] := sql.bind(X_2,"sys","household","mv",0); | | X_720:bat[:oid,:int] := sql.bind(X_2,"sys","household","mv",2); | | X_722 := algebra.kdifference(X_717,X_720); | | X_723 := algebra.kunion(X_722,X_720); | | X_724:bat[:oid,:int] := sql.bind(X_2,"sys","household","mv",1); | | X_726 := algebra.kunion(X_723,X_724); | | X_728 := algebra.kdifference(X_726,X_680); | | X_729 := algebra.leftjoin(X_19,X_728); | | X_730:bat[:oid,:int] := sql.bind(X_2,"sys","household","noc",0); | | X_733:bat[:oid,:int] := sql.bind(X_2,"sys","household","noc",2); | | X_734 := algebra.kdifference(X_730,X_733); | | X_735 := algebra.kunion(X_734,X_733); | | X_736:bat[:oid,:int] := sql.bind(X_2,"sys","household","noc",1); | | X_737 := algebra.kunion(X_735,X_736); | | X_738 := algebra.kdifference(X_737,X_680); | | X_739 := algebra.leftjoin(X_19,X_738); | | X_740:bat[:oid,:int] := sql.bind(X_2,"sys","household","npf",0); | | X_743:bat[:oid,:int] := sql.bind(X_2,"sys","household","npf",2); | | X_745 := algebra.kdifference(X_740,X_743); | | X_746 := algebra.kunion(X_745,X_743); | | X_747:bat[:oid,:int] := sql.bind(X_2,"sys","household","npf",1); | | X_750 := algebra.kunion(X_746,X_747); | | X_751 := algebra.kdifference(X_750,X_680); | | X_752 := algebra.leftjoin(X_19,X_751); | | X_753:bat[:oid,:int] := sql.bind(X_2,"sys","household","npp",0); | | X_756:bat[:oid,:int] := sql.bind(X_2,"sys","household","npp",2); | | X_757 := algebra.kdifference(X_753,X_756); | | X_758 := algebra.kunion(X_757,X_756); | | X_759:bat[:oid,:int] := sql.bind(X_2,"sys","household","npp",1); | | X_760 := algebra.kunion(X_758,X_759); | | X_761 := algebra.kdifference(X_760,X_680); | | X_762 := algebra.leftjoin(X_19,X_761); | | X_763:bat[:oid,:int] := sql.bind(X_2,"sys","household","nr",0); | | X_766:bat[:oid,:int] := sql.bind(X_2,"sys","household","nr",2); | | X_769 := algebra.kdifference(X_763,X_766); | | X_770 := algebra.kunion(X_769,X_766); | | X_771:bat[:oid,:int] := sql.bind(X_2,"sys","household","nr",1); | | X_773 := algebra.kunion(X_770,X_771); | | X_774:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_775 := bat.reverse(X_774); | | X_776 := algebra.kdifference(X_773,X_775); | | X_777 := algebra.leftjoin(X_19,X_776); | | X_778:bat[:oid,:int] := sql.bind(X_2,"sys","household","nrc",0); | | X_781:bat[:oid,:int] := sql.bind(X_2,"sys","household","nrc",2); | | X_782 := algebra.kdifference(X_778,X_781); | | X_783 := algebra.kunion(X_782,X_781); | | X_784:bat[:oid,:int] := sql.bind(X_2,"sys","household","nrc",1); | | X_785 := algebra.kunion(X_783,X_784); | | X_786 := algebra.kdifference(X_785,X_775); | | X_787 := algebra.leftjoin(X_19,X_786); | | X_789:bat[:oid,:int] := sql.bind(X_2,"sys","household","ocpip",0); | | X_792:bat[:oid,:int] := sql.bind(X_2,"sys","household","ocpip",2); | | X_794 := algebra.kdifference(X_789,X_792); | | X_795 := algebra.kunion(X_794,X_792); | | X_796:bat[:oid,:int] := sql.bind(X_2,"sys","household","ocpip",1); | | X_798 := algebra.kunion(X_795,X_796); | | X_799 := algebra.kdifference(X_798,X_775); | | X_800 := algebra.leftjoin(X_19,X_799); | | X_801:bat[:oid,:int] := sql.bind(X_2,"sys","household","partner",0); | | X_804:bat[:oid,:int] := sql.bind(X_2,"sys","household","partner",2); | | X_805 := algebra.kdifference(X_801,X_804); | | X_806 := algebra.kunion(X_805,X_804); | | X_807:bat[:oid,:int] := sql.bind(X_2,"sys","household","partner",1); | | X_808 := algebra.kunion(X_806,X_807); | | X_809 := algebra.kdifference(X_808,X_775); | | X_811 := algebra.leftjoin(X_19,X_809); | | X_812:bat[:oid,:int] := sql.bind(X_2,"sys","household","plm",0); | | X_815:bat[:oid,:int] := sql.bind(X_2,"sys","household","plm",2); | | X_817 := algebra.kdifference(X_812,X_815); | | X_818 := algebra.kunion(X_817,X_815); | | X_819:bat[:oid,:int] := sql.bind(X_2,"sys","household","plm",1); | | X_821 := algebra.kunion(X_818,X_819); | | X_822 := algebra.kdifference(X_821,X_775); | | X_823 := algebra.leftjoin(X_19,X_822); | | X_824:bat[:oid,:int] := sql.bind(X_2,"sys","household","psf",0); | | X_827:bat[:oid,:int] := sql.bind(X_2,"sys","household","psf",2); | | X_828 := algebra.kdifference(X_824,X_827); | | X_829 := algebra.kunion(X_828,X_827); | | X_830:bat[:oid,:int] := sql.bind(X_2,"sys","household","psf",1); | | X_832 := algebra.kunion(X_829,X_830); | | X_833 := algebra.kdifference(X_832,X_775); | | X_834 := algebra.leftjoin(X_19,X_833); | | X_835:bat[:oid,:int] := sql.bind(X_2,"sys","household","r18",0); | | X_838:bat[:oid,:int] := sql.bind(X_2,"sys","household","r18",2); | | X_840 := algebra.kdifference(X_835,X_838); | | X_841 := algebra.kunion(X_840,X_838); | | X_842:bat[:oid,:int] := sql.bind(X_2,"sys","household","r18",1); | | X_844 := algebra.kunion(X_841,X_842); | | X_845 := algebra.kdifference(X_844,X_775); | | X_846 := algebra.leftjoin(X_19,X_845); | | X_847:bat[:oid,:int] := sql.bind(X_2,"sys","household","r60",0); | | X_851:bat[:oid,:int] := sql.bind(X_2,"sys","household","r60",2); | | X_852 := algebra.kdifference(X_847,X_851); | | X_853 := algebra.kunion(X_852,X_851); | | X_854:bat[:oid,:int] := sql.bind(X_2,"sys","household","r60",1); | | X_855 := algebra.kunion(X_853,X_854); | | X_856 := algebra.kdifference(X_855,X_775); | | X_857 := algebra.leftjoin(X_19,X_856); | | X_858:bat[:oid,:int] := sql.bind(X_2,"sys","household","r65",0); | | X_861:bat[:oid,:int] := sql.bind(X_2,"sys","household","r65",2); | | X_863 := algebra.kdifference(X_858,X_861); | | X_864 := algebra.kunion(X_863,X_861); | | X_865:bat[:oid,:int] := sql.bind(X_2,"sys","household","r65",1); | | X_867 := algebra.kunion(X_864,X_865); | | X_868:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_869 := bat.reverse(X_868); | | X_870 := algebra.kdifference(X_867,X_869); | | X_872 := algebra.leftjoin(X_19,X_870); | | X_873:bat[:oid,:int] := sql.bind(X_2,"sys","household","resmode",0); | | X_876:bat[:oid,:int] := sql.bind(X_2,"sys","household","resmode",2); | | X_877 := algebra.kdifference(X_873,X_876); | | X_878 := algebra.kunion(X_877,X_876); | | X_879:bat[:oid,:int] := sql.bind(X_2,"sys","household","resmode",1); | | X_880 := algebra.kunion(X_878,X_879); | | X_881 := algebra.kdifference(X_880,X_869); | | X_882 := algebra.leftjoin(X_19,X_881); | | X_883:bat[:oid,:int] := sql.bind(X_2,"sys","household","smocp",0); | | X_886:bat[:oid,:int] := sql.bind(X_2,"sys","household","smocp",2); | | X_888 := algebra.kdifference(X_883,X_886); | | X_889 := algebra.kunion(X_888,X_886); | | X_890:bat[:oid,:int] := sql.bind(X_2,"sys","household","smocp",1); | | X_892 := algebra.kunion(X_889,X_890); | | X_894 := algebra.kdifference(X_892,X_869); | | X_895 := algebra.leftjoin(X_19,X_894); | | X_896:bat[:oid,:int] := sql.bind(X_2,"sys","household","smx",0); | | X_899:bat[:oid,:int] := sql.bind(X_2,"sys","household","smx",2); | | X_900 := algebra.kdifference(X_896,X_899); | | X_901 := algebra.kunion(X_900,X_899); | | X_902:bat[:oid,:int] := sql.bind(X_2,"sys","household","smx",1); | | X_903 := algebra.kunion(X_901,X_902); | | X_904 := algebra.kdifference(X_903,X_869); | | X_905 := algebra.leftjoin(X_19,X_904); | | X_906:bat[:oid,:int] := sql.bind(X_2,"sys","household","srnt",0); | | X_909:bat[:oid,:int] := sql.bind(X_2,"sys","household","srnt",2); | | X_911 := algebra.kdifference(X_906,X_909); | | X_912 := algebra.kunion(X_911,X_909); | | X_913:bat[:oid,:int] := sql.bind(X_2,"sys","household","srnt",1); | | X_916 := algebra.kunion(X_912,X_913); | | X_917 := algebra.kdifference(X_916,X_869); | | X_918 := algebra.leftjoin(X_19,X_917); | | X_919:bat[:oid,:int] := sql.bind(X_2,"sys","household","sval",0); | | X_922:bat[:oid,:int] := sql.bind(X_2,"sys","household","sval",2); | | X_923 := algebra.kdifference(X_919,X_922); | | X_924 := algebra.kunion(X_923,X_922); | | X_925:bat[:oid,:int] := sql.bind(X_2,"sys","household","sval",1); | | X_926 := algebra.kunion(X_924,X_925); | | X_927 := algebra.kdifference(X_926,X_869); | | X_928 := algebra.leftjoin(X_19,X_927); | | X_929:bat[:oid,:int] := sql.bind(X_2,"sys","household","taxp",0); | | X_932:bat[:oid,:int] := sql.bind(X_2,"sys","household","taxp",2); | | X_935 := algebra.kdifference(X_929,X_932); | | X_936 := algebra.kunion(X_935,X_932); | | X_937:bat[:oid,:int] := sql.bind(X_2,"sys","household","taxp",1); | | X_939 := algebra.kunion(X_936,X_937); | | X_940 := algebra.kdifference(X_939,X_869); | | X_941 := algebra.leftjoin(X_19,X_940); | | X_942:bat[:oid,:int] := sql.bind(X_2,"sys","household","wif",0); | | X_945:bat[:oid,:int] := sql.bind(X_2,"sys","household","wif",2); | | X_946 := algebra.kdifference(X_942,X_945); | | X_947 := algebra.kunion(X_946,X_945); | | X_948:bat[:oid,:int] := sql.bind(X_2,"sys","household","wif",1); | | X_949 := algebra.kunion(X_947,X_948); | | X_950 := algebra.kdifference(X_949,X_869); | | X_951 := algebra.leftjoin(X_19,X_950); | | X_953:bat[:oid,:int] := sql.bind(X_2,"sys","household","wkexrel",0); | | X_956:bat[:oid,:int] := sql.bind(X_2,"sys","household","wkexrel",2); | | X_958 := algebra.kdifference(X_953,X_956); | | X_959 := algebra.kunion(X_958,X_956); | | X_960:bat[:oid,:int] := sql.bind(X_2,"sys","household","wkexrel",1); | | X_962 := algebra.kunion(X_959,X_960); | | X_963:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_964 := bat.reverse(X_963); | | X_965 := algebra.kdifference(X_962,X_964); | | X_966 := algebra.leftjoin(X_19,X_965); | | X_967:bat[:oid,:int] := sql.bind(X_2,"sys","household","workstat",0); | | X_970:bat[:oid,:int] := sql.bind(X_2,"sys","household","workstat",2); | | X_971 := algebra.kdifference(X_967,X_970); | | X_972 := algebra.kunion(X_971,X_970); | | X_973:bat[:oid,:int] := sql.bind(X_2,"sys","household","workstat",1); | | X_974 := algebra.kunion(X_972,X_973); | | X_975 := algebra.kdifference(X_974,X_964); | | X_977 := algebra.leftjoin(X_19,X_975); | | X_978:bat[:oid,:int] := sql.bind(X_2,"sys","household","facrp",0); | | X_981:bat[:oid,:int] := sql.bind(X_2,"sys","household","facrp",2); | | X_983 := algebra.kdifference(X_978,X_981); | | X_984 := algebra.kunion(X_983,X_981); | | X_985:bat[:oid,:int] := sql.bind(X_2,"sys","household","facrp",1); | | X_987 := algebra.kunion(X_984,X_985); | | X_988 := algebra.kdifference(X_987,X_964); | | X_989 := algebra.leftjoin(X_19,X_988); | | X_990:bat[:oid,:int] := sql.bind(X_2,"sys","household","fagsp",0); | | X_993:bat[:oid,:int] := sql.bind(X_2,"sys","household","fagsp",2); | | X_994 := algebra.kdifference(X_990,X_993); | | X_995 := algebra.kunion(X_994,X_993); | | X_996:bat[:oid,:int] := sql.bind(X_2,"sys","household","fagsp",1); | | X_998 := algebra.kunion(X_995,X_996); | | X_999 := algebra.kdifference(X_998,X_964); | | X_1000 := algebra.leftjoin(X_19,X_999); | | X_1001:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbathp",0); | | X_1004:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbathp",2); | | X_1006 := algebra.kdifference(X_1001,X_1004); | | X_1007 := algebra.kunion(X_1006,X_1004); | | X_1008:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbathp",1); | | X_1010 := algebra.kunion(X_1007,X_1008); | | X_1011 := algebra.kdifference(X_1010,X_964); | | X_1012 := algebra.leftjoin(X_19,X_1011); | | X_1013:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbdsp",0); | | X_1017:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbdsp",2); | | X_1018 := algebra.kdifference(X_1013,X_1017); | | X_1019 := algebra.kunion(X_1018,X_1017); | | X_1020:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbdsp",1); | | X_1021 := algebra.kunion(X_1019,X_1020); | | X_1022 := algebra.kdifference(X_1021,X_964); | | X_1023 := algebra.leftjoin(X_19,X_1022); | | X_1024:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbldp",0); | | X_1027:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbldp",2); | | X_1029 := algebra.kdifference(X_1024,X_1027); | | X_1030 := algebra.kunion(X_1029,X_1027); | | X_1031:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbldp",1); | | X_1033 := algebra.kunion(X_1030,X_1031); | | X_1034 := algebra.kdifference(X_1033,X_964); | | X_1036 := algebra.leftjoin(X_19,X_1034); | | X_1037:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbusp",0); | | X_1040:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbusp",2); | | X_1041 := algebra.kdifference(X_1037,X_1040); | | X_1042 := algebra.kunion(X_1041,X_1040); | | X_1043:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbusp",1); | | X_1044 := algebra.kunion(X_1042,X_1043); | | X_1045 := algebra.kdifference(X_1044,X_964); | | X_1046 := algebra.leftjoin(X_19,X_1045); | | X_1047:bat[:oid,:int] := sql.bind(X_2,"sys","household","fconp",0); | | X_1050:bat[:oid,:int] := sql.bind(X_2,"sys","household","fconp",2); | | X_1052 := algebra.kdifference(X_1047,X_1050); | | X_1053 := algebra.kunion(X_1052,X_1050); | | X_1054:bat[:oid,:int] := sql.bind(X_2,"sys","household","fconp",1); | | X_1056 := algebra.kunion(X_1053,X_1054); | | X_1057:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1059 := bat.reverse(X_1057); | | X_1060 := algebra.kdifference(X_1056,X_1059); | | X_1061 := algebra.leftjoin(X_19,X_1060); | | X_1062:bat[:oid,:int] := sql.bind(X_2,"sys","household","felep",0); | | X_1065:bat[:oid,:int] := sql.bind(X_2,"sys","household","felep",2); | | X_1066 := algebra.kdifference(X_1062,X_1065); | | X_1067 := algebra.kunion(X_1066,X_1065); | | X_1068:bat[:oid,:int] := sql.bind(X_2,"sys","household","felep",1); | | X_1069 := algebra.kunion(X_1067,X_1068); | | X_1070 := algebra.kdifference(X_1069,X_1059); | | X_1071 := algebra.leftjoin(X_19,X_1070); | | X_1072:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffsp",0); | | X_1075:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffsp",2); | | X_1077 := algebra.kdifference(X_1072,X_1075); | | X_1078 := algebra.kunion(X_1077,X_1075); | | X_1079:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffsp",1); | | X_1082 := algebra.kunion(X_1078,X_1079); | | X_1083 := algebra.kdifference(X_1082,X_1059); | | X_1084 := algebra.leftjoin(X_19,X_1083); | | X_1085:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffulp",0); | | X_1088:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffulp",2); | | X_1089 := algebra.kdifference(X_1085,X_1088); | | X_1090 := algebra.kunion(X_1089,X_1088); | | X_1091:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffulp",1); | | X_1092 := algebra.kunion(X_1090,X_1091); | | X_1093 := algebra.kdifference(X_1092,X_1059); | | X_1094 := algebra.leftjoin(X_19,X_1093); | | X_1095:bat[:oid,:int] := sql.bind(X_2,"sys","household","fgasp",0); | | X_1098:bat[:oid,:int] := sql.bind(X_2,"sys","household","fgasp",2); | | X_1101 := algebra.kdifference(X_1095,X_1098); | | X_1102 := algebra.kunion(X_1101,X_1098); | | X_1103:bat[:oid,:int] := sql.bind(X_2,"sys","household","fgasp",1); | | X_1105 := algebra.kunion(X_1102,X_1103); | | X_1106 := algebra.kdifference(X_1105,X_1059); | | X_1107 := algebra.leftjoin(X_19,X_1106); | | X_1108:bat[:oid,:int] := sql.bind(X_2,"sys","household","fhflp",0); | | X_1111:bat[:oid,:int] := sql.bind(X_2,"sys","household","fhflp",2); | | X_1112 := algebra.kdifference(X_1108,X_1111); | | X_1113 := algebra.kunion(X_1112,X_1111); | | X_1114:bat[:oid,:int] := sql.bind(X_2,"sys","household","fhflp",1); | | X_1115 := algebra.kunion(X_1113,X_1114); | | X_1116 := algebra.kdifference(X_1115,X_1059); | | X_1117 := algebra.leftjoin(X_19,X_1116); | | X_1119:bat[:oid,:int] := sql.bind(X_2,"sys","household","finsp",0); | | X_1122:bat[:oid,:int] := sql.bind(X_2,"sys","household","finsp",2); | | X_1124 := algebra.kdifference(X_1119,X_1122); | | X_1125 := algebra.kunion(X_1124,X_1122); | | X_1126:bat[:oid,:int] := sql.bind(X_2,"sys","household","finsp",1); | | X_1128 := algebra.kunion(X_1125,X_1126); | | X_1129 := algebra.kdifference(X_1128,X_1059); | | X_1130 := algebra.leftjoin(X_19,X_1129); | | X_1131:bat[:oid,:int] := sql.bind(X_2,"sys","household","fkitp",0); | | X_1134:bat[:oid,:int] := sql.bind(X_2,"sys","household","fkitp",2); | | X_1135 := algebra.kdifference(X_1131,X_1134); | | X_1136 := algebra.kunion(X_1135,X_1134); | | X_1137:bat[:oid,:int] := sql.bind(X_2,"sys","household","fkitp",1); | | X_1138 := algebra.kunion(X_1136,X_1137); | | X_1139 := algebra.kdifference(X_1138,X_1059); | | X_1141 := algebra.leftjoin(X_19,X_1139); | | X_1142:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmhp",0); | | X_1145:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmhp",2); | | X_1147 := algebra.kdifference(X_1142,X_1145); | | X_1148 := algebra.kunion(X_1147,X_1145); | | X_1149:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmhp",1); | | X_1151 := algebra.kunion(X_1148,X_1149); | | X_1152:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1153 := bat.reverse(X_1152); | | X_1154 := algebra.kdifference(X_1151,X_1153); | | X_1155 := algebra.leftjoin(X_19,X_1154); | | X_1156:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgip",0); | | X_1159:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgip",2); | | X_1160 := algebra.kdifference(X_1156,X_1159); | | X_1161 := algebra.kunion(X_1160,X_1159); | | X_1162:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgip",1); | | X_1164 := algebra.kunion(X_1161,X_1162); | | X_1165 := algebra.kdifference(X_1164,X_1153); | | X_1166 := algebra.leftjoin(X_19,X_1165); | | X_1167:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgp",0); | | X_1170:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgp",2); | | X_1172 := algebra.kdifference(X_1167,X_1170); | | X_1173 := algebra.kunion(X_1172,X_1170); | | X_1174:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgp",1); | | X_1176 := algebra.kunion(X_1173,X_1174); | | X_1177 := algebra.kdifference(X_1176,X_1153); | | X_1178 := algebra.leftjoin(X_19,X_1177); | | X_1179:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgtp",0); | | X_1183:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgtp",2); | | X_1184 := algebra.kdifference(X_1179,X_1183); | | X_1185 := algebra.kunion(X_1184,X_1183); | | X_1186:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgtp",1); | | X_1187 := algebra.kunion(X_1185,X_1186); | | X_1188 := algebra.kdifference(X_1187,X_1153); | | X_1189 := algebra.leftjoin(X_19,X_1188); | | X_1190:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgxp",0); | | X_1193:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgxp",2); | | X_1195 := algebra.kdifference(X_1190,X_1193); | | X_1196 := algebra.kunion(X_1195,X_1193); | | X_1197:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgxp",1); | | X_1199 := algebra.kunion(X_1196,X_1197); | | X_1200 := algebra.kdifference(X_1199,X_1153); | | X_1202 := algebra.leftjoin(X_19,X_1200); | | X_1203:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmvp",0); | | X_1206:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmvp",2); | | X_1207 := algebra.kdifference(X_1203,X_1206); | | X_1208 := algebra.kunion(X_1207,X_1206); | | X_1209:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmvp",1); | | X_1210 := algebra.kunion(X_1208,X_1209); | | X_1211 := algebra.kdifference(X_1210,X_1153); | | X_1212 := algebra.leftjoin(X_19,X_1211); | | X_1213:bat[:oid,:int] := sql.bind(X_2,"sys","household","fplmp",0); | | X_1216:bat[:oid,:int] := sql.bind(X_2,"sys","household","fplmp",2); | | X_1218 := algebra.kdifference(X_1213,X_1216); | | X_1219 := algebra.kunion(X_1218,X_1216); | | X_1220:bat[:oid,:int] := sql.bind(X_2,"sys","household","fplmp",1); | | X_1222 := algebra.kunion(X_1219,X_1220); | | X_1224 := algebra.kdifference(X_1222,X_1153); | | X_1225 := algebra.leftjoin(X_19,X_1224); | | X_1226:bat[:oid,:int] := sql.bind(X_2,"sys","household","frefrp",0); | | X_1229:bat[:oid,:int] := sql.bind(X_2,"sys","household","frefrp",2); | | X_1230 := algebra.kdifference(X_1226,X_1229); | | X_1231 := algebra.kunion(X_1230,X_1229); | | X_1232:bat[:oid,:int] := sql.bind(X_2,"sys","household","frefrp",1); | | X_1233 := algebra.kunion(X_1231,X_1232); | | X_1234 := algebra.kdifference(X_1233,X_1153); | | X_1235 := algebra.leftjoin(X_19,X_1234); | | X_1236:bat[:oid,:int] := sql.bind(X_2,"sys","household","frmsp",0); | | X_1239:bat[:oid,:int] := sql.bind(X_2,"sys","household","frmsp",2); | | X_1241 := algebra.kdifference(X_1236,X_1239); | | X_1242 := algebra.kunion(X_1241,X_1239); | | X_1243:bat[:oid,:int] := sql.bind(X_2,"sys","household","frmsp",1); | | X_1246 := algebra.kunion(X_1242,X_1243); | | X_1247:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1248 := bat.reverse(X_1247); | | X_1249 := algebra.kdifference(X_1246,X_1248); | | X_1250 := algebra.leftjoin(X_19,X_1249); | | X_1251:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntmp",0); | | X_1254:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntmp",2); | | X_1255 := algebra.kdifference(X_1251,X_1254); | | X_1256 := algebra.kunion(X_1255,X_1254); | | X_1257:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntmp",1); | | X_1258 := algebra.kunion(X_1256,X_1257); | | X_1259 := algebra.kdifference(X_1258,X_1248); | | X_1260 := algebra.leftjoin(X_19,X_1259); | | X_1261:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntp",0); | | X_1264:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntp",2); | | X_1267 := algebra.kdifference(X_1261,X_1264); | | X_1268 := algebra.kunion(X_1267,X_1264); | | X_1269:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntp",1); | | X_1271 := algebra.kunion(X_1268,X_1269); | | X_1272 := algebra.kdifference(X_1271,X_1248); | | X_1273 := algebra.leftjoin(X_19,X_1272); | | X_1274:bat[:oid,:int] := sql.bind(X_2,"sys","household","frwatp",0); | | X_1277:bat[:oid,:int] := sql.bind(X_2,"sys","household","frwatp",2); | | X_1278 := algebra.kdifference(X_1274,X_1277); | | X_1279 := algebra.kunion(X_1278,X_1277); | | X_1280:bat[:oid,:int] := sql.bind(X_2,"sys","household","frwatp",1); | | X_1281 := algebra.kunion(X_1279,X_1280); | | X_1282 := algebra.kdifference(X_1281,X_1248); | | X_1283 := algebra.leftjoin(X_19,X_1282); | | X_1285:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsinkp",0); | | X_1288:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsinkp",2); | | X_1290 := algebra.kdifference(X_1285,X_1288); | | X_1291 := algebra.kunion(X_1290,X_1288); | | X_1292:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsinkp",1); | | X_1294 := algebra.kunion(X_1291,X_1292); | | X_1295 := algebra.kdifference(X_1294,X_1248); | | X_1296 := algebra.leftjoin(X_19,X_1295); | | X_1297:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmp",0); | | X_1300:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmp",2); | | X_1301 := algebra.kdifference(X_1297,X_1300); | | X_1302 := algebra.kunion(X_1301,X_1300); | | X_1303:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmp",1); | | X_1304 := algebra.kunion(X_1302,X_1303); | | X_1305 := algebra.kdifference(X_1304,X_1248); | | X_1307 := algebra.leftjoin(X_19,X_1305); | | X_1308:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxhp",0); | | X_1311:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxhp",2); | | X_1313 := algebra.kdifference(X_1308,X_1311); | | X_1314 := algebra.kunion(X_1313,X_1311); | | X_1315:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxhp",1); | | X_1317 := algebra.kunion(X_1314,X_1315); | | X_1318 := algebra.kdifference(X_1317,X_1248); | | X_1319 := algebra.leftjoin(X_19,X_1318); | | X_1320:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxsp",0); | | X_1323:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxsp",2); | | X_1324 := algebra.kdifference(X_1320,X_1323); | | X_1325 := algebra.kunion(X_1324,X_1323); | | X_1326:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxsp",1); | | X_1328 := algebra.kunion(X_1325,X_1326); | | X_1329 := algebra.kdifference(X_1328,X_1248); | | X_1330 := algebra.leftjoin(X_19,X_1329); | | X_1331:bat[:oid,:int] := sql.bind(X_2,"sys","household","fstovp",0); | | X_1334:bat[:oid,:int] := sql.bind(X_2,"sys","household","fstovp",2); | | X_1336 := algebra.kdifference(X_1331,X_1334); | | X_1337 := algebra.kunion(X_1336,X_1334); | | X_1338:bat[:oid,:int] := sql.bind(X_2,"sys","household","fstovp",1); | | X_1340 := algebra.kunion(X_1337,X_1338); | | X_1341:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1342 := bat.reverse(X_1341); | | X_1343 := algebra.kdifference(X_1340,X_1342); | | X_1344 := algebra.leftjoin(X_19,X_1343); | | X_1345:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftaxp",0); | | X_1349:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftaxp",2); | | X_1350 := algebra.kdifference(X_1345,X_1349); | | X_1351 := algebra.kunion(X_1350,X_1349); | | X_1352:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftaxp",1); | | X_1353 := algebra.kunion(X_1351,X_1352); | | X_1354 := algebra.kdifference(X_1353,X_1342); | | X_1355 := algebra.leftjoin(X_19,X_1354); | | X_1356:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftelp",0); | | X_1359:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftelp",2); | | X_1361 := algebra.kdifference(X_1356,X_1359); | | X_1362 := algebra.kunion(X_1361,X_1359); | | X_1363:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftelp",1); | | X_1365 := algebra.kunion(X_1362,X_1363); | | X_1366 := algebra.kdifference(X_1365,X_1342); | | X_1368 := algebra.leftjoin(X_19,X_1366); | | X_1369:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftenp",0); | | X_1372:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftenp",2); | | X_1373 := algebra.kdifference(X_1369,X_1372); | | X_1374 := algebra.kunion(X_1373,X_1372); | | X_1375:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftenp",1); | | X_1376 := algebra.kunion(X_1374,X_1375); | | X_1377 := algebra.kdifference(X_1376,X_1342); | | X_1378 := algebra.leftjoin(X_19,X_1377); | | X_1379:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftoilp",0); | | X_1382:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftoilp",2); | | X_1384 := algebra.kdifference(X_1379,X_1382); | | X_1385 := algebra.kunion(X_1384,X_1382); | | X_1386:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftoilp",1); | | X_1388 := algebra.kunion(X_1385,X_1386); | | X_1390 := algebra.kdifference(X_1388,X_1342); | | X_1391 := algebra.leftjoin(X_19,X_1390); | | X_1392:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvacsp",0); | | X_1395:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvacsp",2); | | X_1396 := algebra.kdifference(X_1392,X_1395); | | X_1397 := algebra.kunion(X_1396,X_1395); | | X_1398:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvacsp",1); | | X_1399 := algebra.kunion(X_1397,X_1398); | | X_1400 := algebra.kdifference(X_1399,X_1342); | | X_1401 := algebra.leftjoin(X_19,X_1400); | | X_1402:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvalp",0); | | X_1405:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvalp",2); | | X_1407 := algebra.kdifference(X_1402,X_1405); | | X_1408 := algebra.kunion(X_1407,X_1405); | | X_1409:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvalp",1); | | X_1412 := algebra.kunion(X_1408,X_1409); | | X_1413 := algebra.kdifference(X_1412,X_1342); | | X_1414 := algebra.leftjoin(X_19,X_1413); | | X_1415:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvehp",0); | | X_1418:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvehp",2); | | X_1419 := algebra.kdifference(X_1415,X_1418); | | X_1420 := algebra.kunion(X_1419,X_1418); | | X_1421:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvehp",1); | | X_1422 := algebra.kunion(X_1420,X_1421); | | X_1423 := algebra.kdifference(X_1422,X_1342); | | X_1424 := algebra.leftjoin(X_19,X_1423); | | X_1425:bat[:oid,:int] := sql.bind(X_2,"sys","household","fwatp",0); | | X_1428:bat[:oid,:int] := sql.bind(X_2,"sys","household","fwatp",2); | | X_1431 := algebra.kdifference(X_1425,X_1428); | | X_1432 := algebra.kunion(X_1431,X_1428); | | X_1433:bat[:oid,:int] := sql.bind(X_2,"sys","household","fwatp",1); | | X_1435 := algebra.kunion(X_1432,X_1433); | | X_1436:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1437 := bat.reverse(X_1436); | | X_1438 := algebra.kdifference(X_1435,X_1437); | | X_1439 := algebra.leftjoin(X_19,X_1438); | | X_1440:bat[:oid,:int] := sql.bind(X_2,"sys","household","fyblp",0); | | X_1443:bat[:oid,:int] := sql.bind(X_2,"sys","household","fyblp",2); | | X_1444 := algebra.kdifference(X_1440,X_1443); | | X_1445 := algebra.kunion(X_1444,X_1443); | | X_1446:bat[:oid,:int] := sql.bind(X_2,"sys","household","fyblp",1); | | X_1447 := algebra.kunion(X_1445,X_1446); | | X_1448 := algebra.kdifference(X_1447,X_1437); | | X_1449 := algebra.leftjoin(X_19,X_1448); | | X_1451:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp1",0); | | X_1454:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp1",2); | | X_1456 := algebra.kdifference(X_1451,X_1454); | | X_1457 := algebra.kunion(X_1456,X_1454); | | X_1458:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp1",1); | | X_1460 := algebra.kunion(X_1457,X_1458); | | X_1461 := algebra.kdifference(X_1460,X_1437); | | X_1462 := algebra.leftjoin(X_19,X_1461); | | X_1463:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp2",0); | | X_1466:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp2",2); | | X_1467 := algebra.kdifference(X_1463,X_1466); | | X_1468 := algebra.kunion(X_1467,X_1466); | | X_1469:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp2",1); | | X_1470 := algebra.kunion(X_1468,X_1469); | | X_1471 := algebra.kdifference(X_1470,X_1437); | | X_1473 := algebra.leftjoin(X_19,X_1471); | | X_1474:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp3",0); | | X_1477:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp3",2); | | X_1479 := algebra.kdifference(X_1474,X_1477); | | X_1480 := algebra.kunion(X_1479,X_1477); | | X_1481:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp3",1); | | X_1483 := algebra.kunion(X_1480,X_1481); | | X_1484 := algebra.kdifference(X_1483,X_1437); | | X_1485 := algebra.leftjoin(X_19,X_1484); | | X_1486:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp4",0); | | X_1489:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp4",2); | | X_1490 := algebra.kdifference(X_1486,X_1489); | | X_1491 := algebra.kunion(X_1490,X_1489); | | X_1492:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp4",1); | | X_1494 := algebra.kunion(X_1491,X_1492); | | X_1495 := algebra.kdifference(X_1494,X_1437); | | X_1496 := algebra.leftjoin(X_19,X_1495); | | X_1497:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp5",0); | | X_1500:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp5",2); | | X_1502 := algebra.kdifference(X_1497,X_1500); | | X_1503 := algebra.kunion(X_1502,X_1500); | | X_1504:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp5",1); | | X_1506 := algebra.kunion(X_1503,X_1504); | | X_1507 := algebra.kdifference(X_1506,X_1437); | | X_1508 := algebra.leftjoin(X_19,X_1507); | | X_1509:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp6",0); | | X_1513:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp6",2); | | X_1514 := algebra.kdifference(X_1509,X_1513); | | X_1515 := algebra.kunion(X_1514,X_1513); | | X_1516:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp6",1); | | X_1517 := algebra.kunion(X_1515,X_1516); | | X_1518 := algebra.kdifference(X_1517,X_1437); | | X_1519 := algebra.leftjoin(X_19,X_1518); | | X_1520:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp7",0); | | X_1523:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp7",2); | | X_1525 := algebra.kdifference(X_1520,X_1523); | | X_1526 := algebra.kunion(X_1525,X_1523); | | X_1527:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp7",1); | | X_1529 := algebra.kunion(X_1526,X_1527); | | X_1530:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1531 := bat.reverse(X_1530); | | X_1532 := algebra.kdifference(X_1529,X_1531); | | X_1534 := algebra.leftjoin(X_19,X_1532); | | X_1535:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp8",0); | | X_1538:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp8",2); | | X_1539 := algebra.kdifference(X_1535,X_1538); | | X_1540 := algebra.kunion(X_1539,X_1538); | | X_1541:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp8",1); | | X_1542 := algebra.kunion(X_1540,X_1541); | | X_1543 := algebra.kdifference(X_1542,X_1531); | | X_1544 := algebra.leftjoin(X_19,X_1543); | | X_1545:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp9",0); | | X_1548:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp9",2); | | X_1550 := algebra.kdifference(X_1545,X_1548); | | X_1551 := algebra.kunion(X_1550,X_1548); | | X_1552:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp9",1); | | X_1554 := algebra.kunion(X_1551,X_1552); | | X_1556 := algebra.kdifference(X_1554,X_1531); | | X_1557 := algebra.leftjoin(X_19,X_1556); | | X_1558:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp10",0); | | X_1561:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp10",2); | | X_1562 := algebra.kdifference(X_1558,X_1561); | | X_1563 := algebra.kunion(X_1562,X_1561); | | X_1564:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp10",1); | | X_1565 := algebra.kunion(X_1563,X_1564); | | X_1566 := algebra.kdifference(X_1565,X_1531); | | X_1567 := algebra.leftjoin(X_19,X_1566); | | X_1568:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp11",0); | | X_1571:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp11",2); | | X_1573 := algebra.kdifference(X_1568,X_1571); | | X_1574 := algebra.kunion(X_1573,X_1571); | | X_1575:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp11",1); | | X_1578 := algebra.kunion(X_1574,X_1575); | | X_1579 := algebra.kdifference(X_1578,X_1531); | | X_1580 := algebra.leftjoin(X_19,X_1579); | | X_1581:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp12",0); | | X_1584:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp12",2); | | X_1585 := algebra.kdifference(X_1581,X_1584); | | X_1586 := algebra.kunion(X_1585,X_1584); | | X_1587:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp12",1); | | X_1588 := algebra.kunion(X_1586,X_1587); | | X_1589 := algebra.kdifference(X_1588,X_1531); | | X_1590 := algebra.leftjoin(X_19,X_1589); | | X_1591:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp13",0); | | X_1594:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp13",2); | | X_1597 := algebra.kdifference(X_1591,X_1594); | | X_1598 := algebra.kunion(X_1597,X_1594); | | X_1599:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp13",1); | | X_1601 := algebra.kunion(X_1598,X_1599); | | X_1602 := algebra.kdifference(X_1601,X_1531); | | X_1603 := algebra.leftjoin(X_19,X_1602); | | X_1604:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp14",0); | | X_1607:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp14",2); | | X_1608 := algebra.kdifference(X_1604,X_1607); | | X_1609 := algebra.kunion(X_1608,X_1607); | | X_1610:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp14",1); | | X_1611 := algebra.kunion(X_1609,X_1610); | | X_1612 := algebra.kdifference(X_1611,X_1531); | | X_1613 := algebra.leftjoin(X_19,X_1612); | | X_1615:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp15",0); | | X_1618:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp15",2); | | X_1620 := algebra.kdifference(X_1615,X_1618); | | X_1621 := algebra.kunion(X_1620,X_1618); | | X_1622:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp15",1); | | X_1624 := algebra.kunion(X_1621,X_1622); | | X_1625:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1626 := bat.reverse(X_1625); | | X_1627 := algebra.kdifference(X_1624,X_1626); | | X_1628 := algebra.leftjoin(X_19,X_1627); | | X_1629:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp16",0); | | X_1632:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp16",2); | | X_1633 := algebra.kdifference(X_1629,X_1632); | | X_1634 := algebra.kunion(X_1633,X_1632); | | X_1635:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp16",1); | | X_1636 := algebra.kunion(X_1634,X_1635); | | X_1637 := algebra.kdifference(X_1636,X_1626); | | X_1639 := algebra.leftjoin(X_19,X_1637); | | X_1640:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp17",0); | | X_1643:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp17",2); | | X_1645 := algebra.kdifference(X_1640,X_1643); | | X_1646 := algebra.kunion(X_1645,X_1643); | | X_1647:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp17",1); | | X_1649 := algebra.kunion(X_1646,X_1647); | | X_1650 := algebra.kdifference(X_1649,X_1626); | | X_1651 := algebra.leftjoin(X_19,X_1650); | | X_1652:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp18",0); | | X_1655:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp18",2); | | X_1656 := algebra.kdifference(X_1652,X_1655); | | X_1657 := algebra.kunion(X_1656,X_1655); | | X_1658:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp18",1); | | X_1660 := algebra.kunion(X_1657,X_1658); | | X_1661 := algebra.kdifference(X_1660,X_1626); | | X_1662 := algebra.leftjoin(X_19,X_1661); | | X_1663:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp19",0); | | X_1666:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp19",2); | | X_1668 := algebra.kdifference(X_1663,X_1666); | | X_1669 := algebra.kunion(X_1668,X_1666); | | X_1670:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp19",1); | | X_1672 := algebra.kunion(X_1669,X_1670); | | X_1673 := algebra.kdifference(X_1672,X_1626); | | X_1674 := algebra.leftjoin(X_19,X_1673); | | X_1675:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp20",0); | | X_1679:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp20",2); | | X_1680 := algebra.kdifference(X_1675,X_1679); | | X_1681 := algebra.kunion(X_1680,X_1679); | | X_1682:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp20",1); | | X_1683 := algebra.kunion(X_1681,X_1682); | | X_1684 := algebra.kdifference(X_1683,X_1626); | | X_1685 := algebra.leftjoin(X_19,X_1684); | | X_1686:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp21",0); | | X_1689:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp21",2); | | X_1691 := algebra.kdifference(X_1686,X_1689); | | X_1692 := algebra.kunion(X_1691,X_1689); | | X_1693:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp21",1); | | X_1695 := algebra.kunion(X_1692,X_1693); | | X_1696 := algebra.kdifference(X_1695,X_1626); | | X_1698 := algebra.leftjoin(X_19,X_1696); | | X_1699:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp22",0); | | X_1702:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp22",2); | | X_1703 := algebra.kdifference(X_1699,X_1702); | | X_1704 := algebra.kunion(X_1703,X_1702); | | X_1705:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp22",1); | | X_1706 := algebra.kunion(X_1704,X_1705); | | X_1707 := algebra.kdifference(X_1706,X_1626); | | X_1708 := algebra.leftjoin(X_19,X_1707); | | X_1709:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp23",0); | | X_1712:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp23",2); | | X_1714 := algebra.kdifference(X_1709,X_1712); | | X_1715 := algebra.kunion(X_1714,X_1712); | | X_1716:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp23",1); | | X_1718 := algebra.kunion(X_1715,X_1716); | | X_1719:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1721 := bat.reverse(X_1719); | | X_1722 := algebra.kdifference(X_1718,X_1721); | | X_1723 := algebra.leftjoin(X_19,X_1722); | | X_1724:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp24",0); | | X_1727:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp24",2); | | X_1728 := algebra.kdifference(X_1724,X_1727); | | X_1729 := algebra.kunion(X_1728,X_1727); | | X_1730:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp24",1); | | X_1731 := algebra.kunion(X_1729,X_1730); | | X_1732 := algebra.kdifference(X_1731,X_1721); | | X_1733 := algebra.leftjoin(X_19,X_1732); | | X_1734:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp25",0); | | X_1737:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp25",2); | | X_1739 := algebra.kdifference(X_1734,X_1737); | | X_1740 := algebra.kunion(X_1739,X_1737); | | X_1741:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp25",1); | | X_1744 := algebra.kunion(X_1740,X_1741); | | X_1745 := algebra.kdifference(X_1744,X_1721); | | X_1746 := algebra.leftjoin(X_19,X_1745); | | X_1747:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp26",0); | | X_1750:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp26",2); | | X_1751 := algebra.kdifference(X_1747,X_1750); | | X_1752 := algebra.kunion(X_1751,X_1750); | | X_1753:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp26",1); | | X_1754 := algebra.kunion(X_1752,X_1753); | | X_1755 := algebra.kdifference(X_1754,X_1721); | | X_1756 := algebra.leftjoin(X_19,X_1755); | | X_1757:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp27",0); | | X_1760:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp27",2); | | X_1763 := algebra.kdifference(X_1757,X_1760); | | X_1764 := algebra.kunion(X_1763,X_1760); | | X_1765:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp27",1); | | X_1767 := algebra.kunion(X_1764,X_1765); | | X_1768 := algebra.kdifference(X_1767,X_1721); | | X_1769 := algebra.leftjoin(X_19,X_1768); | | X_1770:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp28",0); | | X_1773:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp28",2); | | X_1774 := algebra.kdifference(X_1770,X_1773); | | X_1775 := algebra.kunion(X_1774,X_1773); | | X_1776:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp28",1); | | X_1777 := algebra.kunion(X_1775,X_1776); | | X_1778 := algebra.kdifference(X_1777,X_1721); | | X_1779 := algebra.leftjoin(X_19,X_1778); | | X_1781:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp29",0); | | X_1784:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp29",2); | | X_1786 := algebra.kdifference(X_1781,X_1784); | | X_1787 := algebra.kunion(X_1786,X_1784); | | X_1788:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp29",1); | | X_1790 := algebra.kunion(X_1787,X_1788); | | X_1791 := algebra.kdifference(X_1790,X_1721); | | X_1792 := algebra.leftjoin(X_19,X_1791); | | X_1793:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp30",0); | | X_1796:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp30",2); | | X_1797 := algebra.kdifference(X_1793,X_1796); | | X_1798 := algebra.kunion(X_1797,X_1796); | | X_1799:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp30",1); | | X_1800 := algebra.kunion(X_1798,X_1799); | | X_1801 := algebra.kdifference(X_1800,X_1721); | | X_1803 := algebra.leftjoin(X_19,X_1801); | | X_1804:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp31",0); | | X_1807:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp31",2); | | X_1809 := algebra.kdifference(X_1804,X_1807); | | X_1810 := algebra.kunion(X_1809,X_1807); | | X_1811:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp31",1); | | X_1813 := algebra.kunion(X_1810,X_1811); | | X_1814:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1815 := bat.reverse(X_1814); | | X_1816 := algebra.kdifference(X_1813,X_1815); | | X_1817 := algebra.leftjoin(X_19,X_1816); | | X_1818:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp32",0); | | X_1821:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp32",2); | | X_1822 := algebra.kdifference(X_1818,X_1821); | | X_1823 := algebra.kunion(X_1822,X_1821); | | X_1824:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp32",1); | | X_1826 := algebra.kunion(X_1823,X_1824); | | X_1827 := algebra.kdifference(X_1826,X_1815); | | X_1828 := algebra.leftjoin(X_19,X_1827); | | X_1829:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp33",0); | | X_1832:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp33",2); | | X_1834 := algebra.kdifference(X_1829,X_1832); | | X_1835 := algebra.kunion(X_1834,X_1832); | | X_1836:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp33",1); | | X_1838 := algebra.kunion(X_1835,X_1836); | | X_1839 := algebra.kdifference(X_1838,X_1815); | | X_1840 := algebra.leftjoin(X_19,X_1839); | | X_1841:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp34",0); | | X_1845:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp34",2); | | X_1846 := algebra.kdifference(X_1841,X_1845); | | X_1847 := algebra.kunion(X_1846,X_1845); | | X_1848:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp34",1); | | X_1849 := algebra.kunion(X_1847,X_1848); | | X_1850 := algebra.kdifference(X_1849,X_1815); | | X_1851 := algebra.leftjoin(X_19,X_1850); | | X_1852:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp35",0); | | X_1855:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp35",2); | | X_1857 := algebra.kdifference(X_1852,X_1855); | | X_1858 := algebra.kunion(X_1857,X_1855); | | X_1859:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp35",1); | | X_1861 := algebra.kunion(X_1858,X_1859); | | X_1862 := algebra.kdifference(X_1861,X_1815); | | X_1864 := algebra.leftjoin(X_19,X_1862); | | X_1865:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp36",0); | | X_1868:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp36",2); | | X_1869 := algebra.kdifference(X_1865,X_1868); | | X_1870 := algebra.kunion(X_1869,X_1868); | | X_1871:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp36",1); | | X_1872 := algebra.kunion(X_1870,X_1871); | | X_1873 := algebra.kdifference(X_1872,X_1815); | | X_1874 := algebra.leftjoin(X_19,X_1873); | | X_1875:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp37",0); | | X_1878:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp37",2); | | X_1880 := algebra.kdifference(X_1875,X_1878); | | X_1881 := algebra.kunion(X_1880,X_1878); | | X_1882:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp37",1); | | X_1884 := algebra.kunion(X_1881,X_1882); | | X_1886 := algebra.kdifference(X_1884,X_1815); | | X_1887 := algebra.leftjoin(X_19,X_1886); | | X_1888:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp38",0); | | X_1891:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp38",2); | | X_1892 := algebra.kdifference(X_1888,X_1891); | | X_1893 := algebra.kunion(X_1892,X_1891); | | X_1894:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp38",1); | | X_1895 := algebra.kunion(X_1893,X_1894); | | X_1896 := algebra.kdifference(X_1895,X_1815); | | X_1897 := algebra.leftjoin(X_19,X_1896); | | X_1898:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp39",0); | | X_1901:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp39",2); | | X_1903 := algebra.kdifference(X_1898,X_1901); | | X_1904 := algebra.kunion(X_1903,X_1901); | | X_1905:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp39",1); | | X_1908 := algebra.kunion(X_1904,X_1905); | | X_1909:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1910 := bat.reverse(X_1909); | | X_1911 := algebra.kdifference(X_1908,X_1910); | | X_1912 := algebra.leftjoin(X_19,X_1911); | | X_1913:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp40",0); | | X_1916:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp40",2); | | X_1917 := algebra.kdifference(X_1913,X_1916); | | X_1918 := algebra.kunion(X_1917,X_1916); | | X_1919:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp40",1); | | X_1920 := algebra.kunion(X_1918,X_1919); | | X_1921 := algebra.kdifference(X_1920,X_1910); | | X_1922 := algebra.leftjoin(X_19,X_1921); | | X_1923:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp41",0); | | X_1926:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp41",2); | | X_1929 := algebra.kdifference(X_1923,X_1926); | | X_1930 := algebra.kunion(X_1929,X_1926); | | X_1931:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp41",1); | | X_1933 := algebra.kunion(X_1930,X_1931); | | X_1934 := algebra.kdifference(X_1933,X_1910); | | X_1935 := algebra.leftjoin(X_19,X_1934); | | X_1936:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp42",0); | | X_1939:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp42",2); | | X_1940 := algebra.kdifference(X_1936,X_1939); | | X_1941 := algebra.kunion(X_1940,X_1939); | | X_1942:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp42",1); | | X_1943 := algebra.kunion(X_1941,X_1942); | | X_1944 := algebra.kdifference(X_1943,X_1910); | | X_1945 := algebra.leftjoin(X_19,X_1944); | | X_1947:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp43",0); | | X_1950:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp43",2); | | X_1952 := algebra.kdifference(X_1947,X_1950); | | X_1953 := algebra.kunion(X_1952,X_1950); | | X_1954:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp43",1); | | X_1956 := algebra.kunion(X_1953,X_1954); | | X_1957 := algebra.kdifference(X_1956,X_1910); | | X_1958 := algebra.leftjoin(X_19,X_1957); | | X_1959:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp44",0); | | X_1962:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp44",2); | | X_1963 := algebra.kdifference(X_1959,X_1962); | | X_1964 := algebra.kunion(X_1963,X_1962); | | X_1965:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp44",1); | | X_1966 := algebra.kunion(X_1964,X_1965); | | X_1967 := algebra.kdifference(X_1966,X_1910); | | X_1969 := algebra.leftjoin(X_19,X_1967); | | X_1970:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp45",0); | | X_1973:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp45",2); | | X_1975 := algebra.kdifference(X_1970,X_1973); | | X_1976 := algebra.kunion(X_1975,X_1973); | | X_1977:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp45",1); | | X_1979 := algebra.kunion(X_1976,X_1977); | | X_1980 := algebra.kdifference(X_1979,X_1910); | | X_1981 := algebra.leftjoin(X_19,X_1980); | | X_1982:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp46",0); | | X_1985:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp46",2); | | X_1986 := algebra.kdifference(X_1982,X_1985); | | X_1987 := algebra.kunion(X_1986,X_1985); | | X_1988:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp46",1); | | X_1990 := algebra.kunion(X_1987,X_1988); | | X_1991 := algebra.kdifference(X_1990,X_1910); | | X_1992 := algebra.leftjoin(X_19,X_1991); | | X_1993:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp47",0); | | X_1996:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp47",2); | | X_1998 := algebra.kdifference(X_1993,X_1996); | | X_1999 := algebra.kunion(X_1998,X_1996); | | X_2000:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp47",1); | | X_2002 := algebra.kunion(X_1999,X_2000); | | X_2003:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2004 := bat.reverse(X_2003); | | X_2005 := algebra.kdifference(X_2002,X_2004); | | X_2006 := algebra.leftjoin(X_19,X_2005); | | X_2007:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp48",0); | | X_2011:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp48",2); | | X_2012 := algebra.kdifference(X_2007,X_2011); | | X_2013 := algebra.kunion(X_2012,X_2011); | | X_2014:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp48",1); | | X_2015 := algebra.kunion(X_2013,X_2014); | | X_2016 := algebra.kdifference(X_2015,X_2004); | | X_2017 := algebra.leftjoin(X_19,X_2016); | | X_2018:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp49",0); | | X_2021:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp49",2); | | X_2023 := algebra.kdifference(X_2018,X_2021); | | X_2024 := algebra.kunion(X_2023,X_2021); | | X_2025:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp49",1); | | X_2027 := algebra.kunion(X_2024,X_2025); | | X_2028 := algebra.kdifference(X_2027,X_2004); | | X_2030 := algebra.leftjoin(X_19,X_2028); | | X_2031:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp50",0); | | X_2034:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp50",2); | | X_2035 := algebra.kdifference(X_2031,X_2034); | | X_2036 := algebra.kunion(X_2035,X_2034); | | X_2037:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp50",1); | | X_2038 := algebra.kunion(X_2036,X_2037); | | X_2039 := algebra.kdifference(X_2038,X_2004); | | X_2040 := algebra.leftjoin(X_19,X_2039); | | X_2041:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp51",0); | | X_2044:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp51",2); | | X_2046 := algebra.kdifference(X_2041,X_2044); | | X_2047 := algebra.kunion(X_2046,X_2044); | | X_2048:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp51",1); | | X_2050 := algebra.kunion(X_2047,X_2048); | | X_2052 := algebra.kdifference(X_2050,X_2004); | | X_2053 := algebra.leftjoin(X_19,X_2052); | | X_2054:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp52",0); | | X_2057:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp52",2); | | X_2058 := algebra.kdifference(X_2054,X_2057); | | X_2059 := algebra.kunion(X_2058,X_2057); | | X_2060:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp52",1); | | X_2061 := algebra.kunion(X_2059,X_2060); | | X_2062 := algebra.kdifference(X_2061,X_2004); | | X_2063 := algebra.leftjoin(X_19,X_2062); | | X_2064:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp53",0); | | X_2067:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp53",2); | | X_2069 := algebra.kdifference(X_2064,X_2067); | | X_2070 := algebra.kunion(X_2069,X_2067); | | X_2071:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp53",1); | | X_2074 := algebra.kunion(X_2070,X_2071); | | X_2075 := algebra.kdifference(X_2074,X_2004); | | X_2076 := algebra.leftjoin(X_19,X_2075); | | X_2077:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp54",0); | | X_2080:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp54",2); | | X_2081 := algebra.kdifference(X_2077,X_2080); | | X_2082 := algebra.kunion(X_2081,X_2080); | | X_2083:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp54",1); | | X_2084 := algebra.kunion(X_2082,X_2083); | | X_2085 := algebra.kdifference(X_2084,X_2004); | | X_2086 := algebra.leftjoin(X_19,X_2085); | | X_2087:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp55",0); | | X_2090:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp55",2); | | X_2093 := algebra.kdifference(X_2087,X_2090); | | X_2094 := algebra.kunion(X_2093,X_2090); | | X_2095:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp55",1); | | X_2097 := algebra.kunion(X_2094,X_2095); | | X_2098:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2099 := bat.reverse(X_2098); | | X_2100 := algebra.kdifference(X_2097,X_2099); | | X_2101 := algebra.leftjoin(X_19,X_2100); | | X_2102:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp56",0); | | X_2105:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp56",2); | | X_2106 := algebra.kdifference(X_2102,X_2105); | | X_2107 := algebra.kunion(X_2106,X_2105); | | X_2108:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp56",1); | | X_2109 := algebra.kunion(X_2107,X_2108); | | X_2110 := algebra.kdifference(X_2109,X_2099); | | X_2111 := algebra.leftjoin(X_19,X_2110); | | X_2113:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp57",0); | | X_2116:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp57",2); | | X_2118 := algebra.kdifference(X_2113,X_2116); | | X_2119 := algebra.kunion(X_2118,X_2116); | | X_2120:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp57",1); | | X_2122 := algebra.kunion(X_2119,X_2120); | | X_2123 := algebra.kdifference(X_2122,X_2099); | | X_2124 := algebra.leftjoin(X_19,X_2123); | | X_2125:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp58",0); | | X_2128:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp58",2); | | X_2129 := algebra.kdifference(X_2125,X_2128); | | X_2130 := algebra.kunion(X_2129,X_2128); | | X_2131:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp58",1); | | X_2132 := algebra.kunion(X_2130,X_2131); | | X_2133 := algebra.kdifference(X_2132,X_2099); | | X_2135 := algebra.leftjoin(X_19,X_2133); | | X_2136:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp59",0); | | X_2139:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp59",2); | | X_2141 := algebra.kdifference(X_2136,X_2139); | | X_2142 := algebra.kunion(X_2141,X_2139); | | X_2143:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp59",1); | | X_2145 := algebra.kunion(X_2142,X_2143); | | X_2146 := algebra.kdifference(X_2145,X_2099); | | X_2147 := algebra.leftjoin(X_19,X_2146); | | X_2148:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp60",0); | | X_2151:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp60",2); | | X_2152 := algebra.kdifference(X_2148,X_2151); | | X_2153 := algebra.kunion(X_2152,X_2151); | | X_2154:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp60",1); | | X_2156 := algebra.kunion(X_2153,X_2154); | | X_2157 := algebra.kdifference(X_2156,X_2099); | | X_2158 := algebra.leftjoin(X_19,X_2157); | | X_2159:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp61",0); | | X_2162:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp61",2); | | X_2164 := algebra.kdifference(X_2159,X_2162); | | X_2165 := algebra.kunion(X_2164,X_2162); | | X_2166:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp61",1); | | X_2168 := algebra.kunion(X_2165,X_2166); | | X_2169 := algebra.kdifference(X_2168,X_2099); | | X_2170 := algebra.leftjoin(X_19,X_2169); | | X_2171:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp62",0); | | X_2175:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp62",2); | | X_2176 := algebra.kdifference(X_2171,X_2175); | | X_2177 := algebra.kunion(X_2176,X_2175); | | X_2178:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp62",1); | | X_2179 := algebra.kunion(X_2177,X_2178); | | X_2180 := algebra.kdifference(X_2179,X_2099); | | X_2181 := algebra.leftjoin(X_19,X_2180); | | X_2182:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp63",0); | | X_2185:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp63",2); | | X_2187 := algebra.kdifference(X_2182,X_2185); | | X_2188 := algebra.kunion(X_2187,X_2185); | | X_2189:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp63",1); | | X_2191 := algebra.kunion(X_2188,X_2189); | | X_2192:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2193 := bat.reverse(X_2192); | | X_2194 := algebra.kdifference(X_2191,X_2193); | | X_2196 := algebra.leftjoin(X_19,X_2194); | | X_2197:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp64",0); | | X_2200:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp64",2); | | X_2201 := algebra.kdifference(X_2197,X_2200); | | X_2202 := algebra.kunion(X_2201,X_2200); | | X_2203:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp64",1); | | X_2204 := algebra.kunion(X_2202,X_2203); | | X_2205 := algebra.kdifference(X_2204,X_2193); | | X_2206 := algebra.leftjoin(X_19,X_2205); | | X_2207:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp65",0); | | X_2210:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp65",2); | | X_2212 := algebra.kdifference(X_2207,X_2210); | | X_2213 := algebra.kunion(X_2212,X_2210); | | X_2214:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp65",1); | | X_2216 := algebra.kunion(X_2213,X_2214); | | X_2218 := algebra.kdifference(X_2216,X_2193); | | X_2219 := algebra.leftjoin(X_19,X_2218); | | X_2220:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp66",0); | | X_2223:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp66",2); | | X_2224 := algebra.kdifference(X_2220,X_2223); | | X_2225 := algebra.kunion(X_2224,X_2223); | | X_2226:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp66",1); | | X_2227 := algebra.kunion(X_2225,X_2226); | | X_2228 := algebra.kdifference(X_2227,X_2193); | | X_2229 := algebra.leftjoin(X_19,X_2228); | | X_2230:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp67",0); | | X_2233:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp67",2); | | X_2235 := algebra.kdifference(X_2230,X_2233); | | X_2236 := algebra.kunion(X_2235,X_2233); | | X_2237:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp67",1); | | X_2240 := algebra.kunion(X_2236,X_2237); | | X_2241 := algebra.kdifference(X_2240,X_2193); | | X_2242 := algebra.leftjoin(X_19,X_2241); | | X_2243:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp68",0); | | X_2246:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp68",2); | | X_2247 := algebra.kdifference(X_2243,X_2246); | | X_2248 := algebra.kunion(X_2247,X_2246); | | X_2249:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp68",1); | | X_2250 := algebra.kunion(X_2248,X_2249); | | X_2251 := algebra.kdifference(X_2250,X_2193); | | X_2252 := algebra.leftjoin(X_19,X_2251); | | X_2253:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp69",0); | | X_2256:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp69",2); | | X_2259 := algebra.kdifference(X_2253,X_2256); | | X_2260 := algebra.kunion(X_2259,X_2256); | | X_2261:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp69",1); | | X_2263 := algebra.kunion(X_2260,X_2261); | | X_2264 := algebra.kdifference(X_2263,X_2193); | | X_2265 := algebra.leftjoin(X_19,X_2264); | | X_2266:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp70",0); | | X_2269:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp70",2); | | X_2270 := algebra.kdifference(X_2266,X_2269); | | X_2271 := algebra.kunion(X_2270,X_2269); | | X_2272:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp70",1); | | X_2273 := algebra.kunion(X_2271,X_2272); | | X_2274 := algebra.kdifference(X_2273,X_2193); | | X_2275 := algebra.leftjoin(X_19,X_2274); | | X_2277:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp71",0); | | X_2280:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp71",2); | | X_2282 := algebra.kdifference(X_2277,X_2280); | | X_2283 := algebra.kunion(X_2282,X_2280); | | X_2284:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp71",1); | | X_2286 := algebra.kunion(X_2283,X_2284); | | X_2287:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2288 := bat.reverse(X_2287); | | X_2289 := algebra.kdifference(X_2286,X_2288); | | X_2290 := algebra.leftjoin(X_19,X_2289); | | X_2291:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp72",0); | | X_2294:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp72",2); | | X_2295 := algebra.kdifference(X_2291,X_2294); | | X_2296 := algebra.kunion(X_2295,X_2294); | | X_2297:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp72",1); | | X_2298 := algebra.kunion(X_2296,X_2297); | | X_2299 := algebra.kdifference(X_2298,X_2288); | | X_2301 := algebra.leftjoin(X_19,X_2299); | | X_2302:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp73",0); | | X_2305:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp73",2); | | X_2307 := algebra.kdifference(X_2302,X_2305); | | X_2308 := algebra.kunion(X_2307,X_2305); | | X_2309:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp73",1); | | X_2311 := algebra.kunion(X_2308,X_2309); | | X_2312 := algebra.kdifference(X_2311,X_2288); | | X_2313 := algebra.leftjoin(X_19,X_2312); | | X_2314:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp74",0); | | X_2317:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp74",2); | | X_2318 := algebra.kdifference(X_2314,X_2317); | | X_2319 := algebra.kunion(X_2318,X_2317); | | X_2320:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp74",1); | | X_2322 := algebra.kunion(X_2319,X_2320); | | X_2323 := algebra.kdifference(X_2322,X_2288); | | X_2324 := algebra.leftjoin(X_19,X_2323); | | X_2325:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp75",0); | | X_2328:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp75",2); | | X_2330 := algebra.kdifference(X_2325,X_2328); | | X_2331 := algebra.kunion(X_2330,X_2328); | | X_2332:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp75",1); | | X_2334 := algebra.kunion(X_2331,X_2332); | | X_2335 := algebra.kdifference(X_2334,X_2288); | | X_2336 := algebra.leftjoin(X_19,X_2335); | | X_2337:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp76",0); | | X_2341:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp76",2); | | X_2342 := algebra.kdifference(X_2337,X_2341); | | X_2343 := algebra.kunion(X_2342,X_2341); | | X_2344:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp76",1); | | X_2345 := algebra.kunion(X_2343,X_2344); | | X_2346 := algebra.kdifference(X_2345,X_2288); | | X_2347 := algebra.leftjoin(X_19,X_2346); | | X_2348:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp77",0); | | X_2351:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp77",2); | | X_2353 := algebra.kdifference(X_2348,X_2351); | | X_2354 := algebra.kunion(X_2353,X_2351); | | X_2355:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp77",1); | | X_2357 := algebra.kunion(X_2354,X_2355); | | X_2358 := algebra.kdifference(X_2357,X_2288); | | X_2360 := algebra.leftjoin(X_19,X_2358); | | X_2361:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp78",0); | | X_2364:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp78",2); | | X_2365 := algebra.kdifference(X_2361,X_2364); | | X_2366 := algebra.kunion(X_2365,X_2364); | | X_2367:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp78",1); | | X_2368 := algebra.kunion(X_2366,X_2367); | | X_2369 := algebra.kdifference(X_2368,X_2288); | | X_2370 := algebra.leftjoin(X_19,X_2369); | | X_2371:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp79",0); | | X_2374:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp79",2); | | X_2376 := algebra.kdifference(X_2371,X_2374); | | X_2377 := algebra.kunion(X_2376,X_2374); | | X_2378:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp79",1); | | X_2380 := algebra.kunion(X_2377,X_2378); | | X_2381:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2383 := bat.reverse(X_2381); | | X_2384 := algebra.kdifference(X_2380,X_2383); | | X_2385 := algebra.leftjoin(X_19,X_2384); | | X_2386:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp80",0); | | X_2389:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp80",2); | | X_2390 := algebra.kdifference(X_2386,X_2389); | | X_2391 := algebra.kunion(X_2390,X_2389); | | X_2392:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp80",1); | | X_2393 := algebra.kunion(X_2391,X_2392); | | X_2394 := algebra.kdifference(X_2393,X_2383); | | X_2395 := algebra.leftjoin(X_19,X_2394); | | exit X_3114; | | sql.rsColumn(X_2396,"sys.household","rt","varchar",255,0,X_20); | | sql.rsColumn(X_2396,"sys.household","serialno","int",32,0,X_31); | | sql.rsColumn(X_2396,"sys.household","division","int",32,0,X_43); | | sql.rsColumn(X_2396,"sys.household","puma","int",32,0,X_54); | | sql.rsColumn(X_2396,"sys.household","region","int",32,0,X_67); | | sql.rsColumn(X_2396,"sys.household","st","int",32,0,X_77); | | sql.rsColumn(X_2396,"sys.household","adjhsg","int",32,0,X_90); | | sql.rsColumn(X_2396,"sys.household","adjinc","int",32,0,X_100); | | sql.rsColumn(X_2396,"sys.household","wgtp","int",32,0,X_115); | | sql.rsColumn(X_2396,"sys.household","np","int",32,0,X_125); | | sql.rsColumn(X_2396,"sys.household","zzzz","int",32,0,X_138); | | sql.rsColumn(X_2396,"sys.household","acr","int",32,0,X_149); | | sql.rsColumn(X_2396,"sys.household","ags","int",32,0,X_161); | | sql.rsColumn(X_2396,"sys.household","bath","int",32,0,X_172); | | sql.rsColumn(X_2396,"sys.household","bdsp","int",32,0,X_184); | | sql.rsColumn(X_2396,"sys.household","bld","int",32,0,X_195); | | sql.rsColumn(X_2396,"sys.household","bus","int",32,0,X_210); | | sql.rsColumn(X_2396,"sys.household","conp","int",32,0,X_220); | | sql.rsColumn(X_2396,"sys.household","elep","int",32,0,X_233); | | sql.rsColumn(X_2396,"sys.household","fs","int",32,0,X_243); | | sql.rsColumn(X_2396,"sys.household","fulp","int",32,0,X_256); | | sql.rsColumn(X_2396,"sys.household","gasp","int",32,0,X_266); | | sql.rsColumn(X_2396,"sys.household","hfl","int",32,0,X_279); | | sql.rsColumn(X_2396,"sys.household","insp","int",32,0,X_289); | | sql.rsColumn(X_2396,"sys.household","mhp","int",32,0,X_304); | | sql.rsColumn(X_2396,"sys.household","mrgi","int",32,0,X_315); | | sql.rsColumn(X_2396,"sys.household","mrgp","int",32,0,X_327); | | sql.rsColumn(X_2396,"sys.household","mrgt","int",32,0,X_338); | | sql.rsColumn(X_2396,"sys.household","mrgx","int",32,0,X_350); | | sql.rsColumn(X_2396,"sys.household","refr","int",32,0,X_361); | | sql.rsColumn(X_2396,"sys.household","rmsp","int",32,0,X_374); | | sql.rsColumn(X_2396,"sys.household","rntm","int",32,0,X_384); | | sql.rsColumn(X_2396,"sys.household","rntp","int",32,0,X_399); | | sql.rsColumn(X_2396,"sys.household","rwat","int",32,0,X_409); | | sql.rsColumn(X_2396,"sys.household","sink","int",32,0,X_422); | | sql.rsColumn(X_2396,"sys.household","smp","int",32,0,X_432); | | sql.rsColumn(X_2396,"sys.household","stov","int",32,0,X_445); | | sql.rsColumn(X_2396,"sys.household","tel","int",32,0,X_455); | | sql.rsColumn(X_2396,"sys.household","ten","int",32,0,X_468); | | sql.rsColumn(X_2396,"sys.household","toil","int",32,0,X_479); | | sql.rsColumn(X_2396,"sys.household","vacs","int",32,0,X_493); | | sql.rsColumn(X_2396,"sys.household","valp","int",32,0,X_504); | | sql.rsColumn(X_2396,"sys.household","veh","int",32,0,X_516); | | sql.rsColumn(X_2396,"sys.household","watp","int",32,0,X_527); | | sql.rsColumn(X_2396,"sys.household","ybl","int",32,0,X_540); | | sql.rsColumn(X_2396,"sys.household","fes","int",32,0,X_550); | | sql.rsColumn(X_2396,"sys.household","fincp","int",32,0,X_563); | | sql.rsColumn(X_2396,"sys.household","fparc","int",32,0,X_573); | | sql.rsColumn(X_2396,"sys.household","grntp","int",32,0,X_588); | | sql.rsColumn(X_2396,"sys.household","grpip","int",32,0,X_598); | | sql.rsColumn(X_2396,"sys.household","hhl","int",32,0,X_611); | | sql.rsColumn(X_2396,"sys.household","hht","int",32,0,X_621); | | sql.rsColumn(X_2396,"sys.household","hincp","int",32,0,X_634); | | sql.rsColumn(X_2396,"sys.household","hugcl","int",32,0,X_645); | | sql.rsColumn(X_2396,"sys.household","hupac","int",32,0,X_657); | | sql.rsColumn(X_2396,"sys.household","hupaoc","int",32,0,X_668); | | sql.rsColumn(X_2396,"sys.household","huparc","int",32,0,X_682); | | sql.rsColumn(X_2396,"sys.household","kit","int",32,0,X_693); | | sql.rsColumn(X_2396,"sys.household","lngi","int",32,0,X_706); | | sql.rsColumn(X_2396,"sys.household","multg","int",32,0,X_716); | | sql.rsColumn(X_2396,"sys.household","mv","int",32,0,X_729); | | sql.rsColumn(X_2396,"sys.household","noc","int",32,0,X_739); | | sql.rsColumn(X_2396,"sys.household","npf","int",32,0,X_752); | | sql.rsColumn(X_2396,"sys.household","npp","int",32,0,X_762); | | sql.rsColumn(X_2396,"sys.household","nr","int",32,0,X_777); | | sql.rsColumn(X_2396,"sys.household","nrc","int",32,0,X_787); | | sql.rsColumn(X_2396,"sys.household","ocpip","int",32,0,X_800); | | sql.rsColumn(X_2396,"sys.household","partner","int",32,0,X_811); | | sql.rsColumn(X_2396,"sys.household","plm","int",32,0,X_823); | | sql.rsColumn(X_2396,"sys.household","psf","int",32,0,X_834); | | sql.rsColumn(X_2396,"sys.household","r18","int",32,0,X_846); | | sql.rsColumn(X_2396,"sys.household","r60","int",32,0,X_857); | | sql.rsColumn(X_2396,"sys.household","r65","int",32,0,X_872); | | sql.rsColumn(X_2396,"sys.household","resmode","int",32,0,X_882); | | sql.rsColumn(X_2396,"sys.household","smocp","int",32,0,X_895); | | sql.rsColumn(X_2396,"sys.household","smx","int",32,0,X_905); | | sql.rsColumn(X_2396,"sys.household","srnt","int",32,0,X_918); | | sql.rsColumn(X_2396,"sys.household","sval","int",32,0,X_928); | | sql.rsColumn(X_2396,"sys.household","taxp","int",32,0,X_941); | | sql.rsColumn(X_2396,"sys.household","wif","int",32,0,X_951); | | sql.rsColumn(X_2396,"sys.household","wkexrel","int",32,0,X_966); | | sql.rsColumn(X_2396,"sys.household","workstat","int",32,0,X_977); | | sql.rsColumn(X_2396,"sys.household","facrp","int",32,0,X_989); | | sql.rsColumn(X_2396,"sys.household","fagsp","int",32,0,X_1000); | | sql.rsColumn(X_2396,"sys.household","fbathp","int",32,0,X_1012); | | sql.rsColumn(X_2396,"sys.household","fbdsp","int",32,0,X_1023); | | sql.rsColumn(X_2396,"sys.household","fbldp","int",32,0,X_1036); | | sql.rsColumn(X_2396,"sys.household","fbusp","int",32,0,X_1046); | | sql.rsColumn(X_2396,"sys.household","fconp","int",32,0,X_1061); | | sql.rsColumn(X_2396,"sys.household","felep","int",32,0,X_1071); | | sql.rsColumn(X_2396,"sys.household","ffsp","int",32,0,X_1084); | | sql.rsColumn(X_2396,"sys.household","ffulp","int",32,0,X_1094); | | sql.rsColumn(X_2396,"sys.household","fgasp","int",32,0,X_1107); | | sql.rsColumn(X_2396,"sys.household","fhflp","int",32,0,X_1117); | | sql.rsColumn(X_2396,"sys.household","finsp","int",32,0,X_1130); | | sql.rsColumn(X_2396,"sys.household","fkitp","int",32,0,X_1141); | | sql.rsColumn(X_2396,"sys.household","fmhp","int",32,0,X_1155); | | sql.rsColumn(X_2396,"sys.household","fmrgip","int",32,0,X_1166); | | sql.rsColumn(X_2396,"sys.household","fmrgp","int",32,0,X_1178); | | sql.rsColumn(X_2396,"sys.household","fmrgtp","int",32,0,X_1189); | | sql.rsColumn(X_2396,"sys.household","fmrgxp","int",32,0,X_1202); | | sql.rsColumn(X_2396,"sys.household","fmvp","int",32,0,X_1212); | | sql.rsColumn(X_2396,"sys.household","fplmp","int",32,0,X_1225); | | sql.rsColumn(X_2396,"sys.household","frefrp","int",32,0,X_1235); | | sql.rsColumn(X_2396,"sys.household","frmsp","int",32,0,X_1250); | | sql.rsColumn(X_2396,"sys.household","frntmp","int",32,0,X_1260); | | sql.rsColumn(X_2396,"sys.household","frntp","int",32,0,X_1273); | | sql.rsColumn(X_2396,"sys.household","frwatp","int",32,0,X_1283); | | sql.rsColumn(X_2396,"sys.household","fsinkp","int",32,0,X_1296); | | sql.rsColumn(X_2396,"sys.household","fsmp","int",32,0,X_1307); | | sql.rsColumn(X_2396,"sys.household","fsmxhp","int",32,0,X_1319); | | sql.rsColumn(X_2396,"sys.household","fsmxsp","int",32,0,X_1330); | | sql.rsColumn(X_2396,"sys.household","fstovp","int",32,0,X_1344); | | sql.rsColumn(X_2396,"sys.household","ftaxp","int",32,0,X_1355); | | sql.rsColumn(X_2396,"sys.household","ftelp","int",32,0,X_1368); | | sql.rsColumn(X_2396,"sys.household","ftenp","int",32,0,X_1378); | | sql.rsColumn(X_2396,"sys.household","ftoilp","int",32,0,X_1391); | | sql.rsColumn(X_2396,"sys.household","fvacsp","int",32,0,X_1401); | | sql.rsColumn(X_2396,"sys.household","fvalp","int",32,0,X_1414); | | sql.rsColumn(X_2396,"sys.household","fvehp","int",32,0,X_1424); | | sql.rsColumn(X_2396,"sys.household","fwatp","int",32,0,X_1439); | | sql.rsColumn(X_2396,"sys.household","fyblp","int",32,0,X_1449); | | sql.rsColumn(X_2396,"sys.household","wgtp1","int",32,0,X_1462); | | sql.rsColumn(X_2396,"sys.household","wgtp2","int",32,0,X_1473); | | sql.rsColumn(X_2396,"sys.household","wgtp3","int",32,0,X_1485); | | sql.rsColumn(X_2396,"sys.household","wgtp4","int",32,0,X_1496); | | sql.rsColumn(X_2396,"sys.household","wgtp5","int",32,0,X_1508); | | sql.rsColumn(X_2396,"sys.household","wgtp6","int",32,0,X_1519); | | sql.rsColumn(X_2396,"sys.household","wgtp7","int",32,0,X_1534); | | sql.rsColumn(X_2396,"sys.household","wgtp8","int",32,0,X_1544); | | sql.rsColumn(X_2396,"sys.household","wgtp9","int",32,0,X_1557); | | sql.rsColumn(X_2396,"sys.household","wgtp10","int",32,0,X_1567); | | sql.rsColumn(X_2396,"sys.household","wgtp11","int",32,0,X_1580); | | sql.rsColumn(X_2396,"sys.household","wgtp12","int",32,0,X_1590); | | sql.rsColumn(X_2396,"sys.household","wgtp13","int",32,0,X_1603); | | sql.rsColumn(X_2396,"sys.household","wgtp14","int",32,0,X_1613); | | sql.rsColumn(X_2396,"sys.household","wgtp15","int",32,0,X_1628); | | sql.rsColumn(X_2396,"sys.household","wgtp16","int",32,0,X_1639); | | sql.rsColumn(X_2396,"sys.household","wgtp17","int",32,0,X_1651); | | sql.rsColumn(X_2396,"sys.household","wgtp18","int",32,0,X_1662); | | sql.rsColumn(X_2396,"sys.household","wgtp19","int",32,0,X_1674); | | sql.rsColumn(X_2396,"sys.household","wgtp20","int",32,0,X_1685); | | sql.rsColumn(X_2396,"sys.household","wgtp21","int",32,0,X_1698); | | sql.rsColumn(X_2396,"sys.household","wgtp22","int",32,0,X_1708); | | sql.rsColumn(X_2396,"sys.household","wgtp23","int",32,0,X_1723); | | sql.rsColumn(X_2396,"sys.household","wgtp24","int",32,0,X_1733); | | sql.rsColumn(X_2396,"sys.household","wgtp25","int",32,0,X_1746); | | sql.rsColumn(X_2396,"sys.household","wgtp26","int",32,0,X_1756); | | sql.rsColumn(X_2396,"sys.household","wgtp27","int",32,0,X_1769); | | sql.rsColumn(X_2396,"sys.household","wgtp28","int",32,0,X_1779); | | sql.rsColumn(X_2396,"sys.household","wgtp29","int",32,0,X_1792); | | sql.rsColumn(X_2396,"sys.household","wgtp30","int",32,0,X_1803); | | sql.rsColumn(X_2396,"sys.household","wgtp31","int",32,0,X_1817); | | sql.rsColumn(X_2396,"sys.household","wgtp32","int",32,0,X_1828); | | sql.rsColumn(X_2396,"sys.household","wgtp33","int",32,0,X_1840); | | sql.rsColumn(X_2396,"sys.household","wgtp34","int",32,0,X_1851); | | sql.rsColumn(X_2396,"sys.household","wgtp35","int",32,0,X_1864); | | sql.rsColumn(X_2396,"sys.household","wgtp36","int",32,0,X_1874); | | sql.rsColumn(X_2396,"sys.household","wgtp37","int",32,0,X_1887); | | sql.rsColumn(X_2396,"sys.household","wgtp38","int",32,0,X_1897); | | sql.rsColumn(X_2396,"sys.household","wgtp39","int",32,0,X_1912); | | sql.rsColumn(X_2396,"sys.household","wgtp40","int",32,0,X_1922); | | sql.rsColumn(X_2396,"sys.household","wgtp41","int",32,0,X_1935); | | sql.rsColumn(X_2396,"sys.household","wgtp42","int",32,0,X_1945); | | sql.rsColumn(X_2396,"sys.household","wgtp43","int",32,0,X_1958); | | sql.rsColumn(X_2396,"sys.household","wgtp44","int",32,0,X_1969); | | sql.rsColumn(X_2396,"sys.household","wgtp45","int",32,0,X_1981); | | sql.rsColumn(X_2396,"sys.household","wgtp46","int",32,0,X_1992); | | sql.rsColumn(X_2396,"sys.household","wgtp47","int",32,0,X_2006); | | sql.rsColumn(X_2396,"sys.household","wgtp48","int",32,0,X_2017); | | sql.rsColumn(X_2396,"sys.household","wgtp49","int",32,0,X_2030); | | sql.rsColumn(X_2396,"sys.household","wgtp50","int",32,0,X_2040); | | sql.rsColumn(X_2396,"sys.household","wgtp51","int",32,0,X_2053); | | sql.rsColumn(X_2396,"sys.household","wgtp52","int",32,0,X_2063); | | sql.rsColumn(X_2396,"sys.household","wgtp53","int",32,0,X_2076); | | sql.rsColumn(X_2396,"sys.household","wgtp54","int",32,0,X_2086); | | sql.rsColumn(X_2396,"sys.household","wgtp55","int",32,0,X_2101); | | sql.rsColumn(X_2396,"sys.household","wgtp56","int",32,0,X_2111); | | sql.rsColumn(X_2396,"sys.household","wgtp57","int",32,0,X_2124); | | sql.rsColumn(X_2396,"sys.household","wgtp58","int",32,0,X_2135); | | sql.rsColumn(X_2396,"sys.household","wgtp59","int",32,0,X_2147); | | sql.rsColumn(X_2396,"sys.household","wgtp60","int",32,0,X_2158); | | sql.rsColumn(X_2396,"sys.household","wgtp61","int",32,0,X_2170); | | sql.rsColumn(X_2396,"sys.household","wgtp62","int",32,0,X_2181); | | sql.rsColumn(X_2396,"sys.household","wgtp63","int",32,0,X_2196); | | sql.rsColumn(X_2396,"sys.household","wgtp64","int",32,0,X_2206); | | sql.rsColumn(X_2396,"sys.household","wgtp65","int",32,0,X_2219); | | sql.rsColumn(X_2396,"sys.household","wgtp66","int",32,0,X_2229); | | sql.rsColumn(X_2396,"sys.household","wgtp67","int",32,0,X_2242); | | sql.rsColumn(X_2396,"sys.household","wgtp68","int",32,0,X_2252); | | sql.rsColumn(X_2396,"sys.household","wgtp69","int",32,0,X_2265); | | sql.rsColumn(X_2396,"sys.household","wgtp70","int",32,0,X_2275); | | sql.rsColumn(X_2396,"sys.household","wgtp71","int",32,0,X_2290); | | sql.rsColumn(X_2396,"sys.household","wgtp72","int",32,0,X_2301); | | sql.rsColumn(X_2396,"sys.household","wgtp73","int",32,0,X_2313); | | sql.rsColumn(X_2396,"sys.household","wgtp74","int",32,0,X_2324); | | sql.rsColumn(X_2396,"sys.household","wgtp75","int",32,0,X_2336); | | sql.rsColumn(X_2396,"sys.household","wgtp76","int",32,0,X_2347); | | sql.rsColumn(X_2396,"sys.household","wgtp77","int",32,0,X_2360); | | sql.rsColumn(X_2396,"sys.household","wgtp78","int",32,0,X_2370); | | sql.rsColumn(X_2396,"sys.household","wgtp79","int",32,0,X_2385); | | sql.rsColumn(X_2396,"sys.household","wgtp80","int",32,0,X_2395); | | X_2861 := io.stdout(); | | sql.exportResult(X_2861,X_2396); | | end s4_1; | +----------------------------------------------------------------------------+ +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ | rt | serialno | division | puma | region | st | adjhsg | adjinc | wgtp | np | zzzz | acr | ags | bath | bdsp | bld | bus | conp | elep | fs | fulp | gasp | hfl | insp | mhp | mrgi | mrgp | mrgt | mrgx | refr | rmsp | rntm | rntp | rwat | sink | smp | stov | tel | ten | toil | vacs | valp | veh | watp | ybl | fes | fincp | fparc | grntp | grpip | hhl | hht | hincp | hugcl | hupac | hupaoc | huparc | kit | lngi | multg | mv | noc | npf | npp | nr | nrc | ocpip | partner | plm | psf | r18 | r60 | r65 | resmode | smocp | smx | srnt | sval | taxp | wif | wkexrel | workstat | facrp | fagsp | fbathp | fbdsp | fbldp | fbusp | fconp | felep | ffsp | ffulp | fgasp | fhflp | finsp | fkitp | fmhp | fmrgip | fmrgp | fmrgtp | fmrgxp | fmvp | fplmp | frefrp | frmsp | frntmp | frntp | frwatp | fsinkp | fsmp | fsmxhp | fsmxsp | fstovp | ftaxp | ftelp | ftenp | ftoilp | fvacsp | fvalp | fvehp | fwatp | fyblp | wgtp1 | wgtp2 | wgtp3 | wgtp4 | wgtp5 | wgtp6 | wgtp7 | wgtp8 | wgtp9 | wgtp10 | wgtp11 | wgtp12 | wgtp13 | wgtp14 | wgtp15 | wgtp16 | wgtp17 | wgtp18 | wgtp19 | wgtp20 | wgtp21 | wgtp22 | wgtp23 | wgtp24 | wgtp25 | wgtp26 | wgtp27 | wgtp28 | wgtp29 | wgtp30 | wgtp31 | wgtp32 | wgtp33 | wgtp34 | wgtp35 | wgtp36 | wgtp37 | wgtp38 | wgtp39 | wgtp40 | wgtp41 | wgtp42 | wgtp43 | wgtp44 | wgtp45 | wgtp46 | wgtp47 | wgtp48 | wgtp49 | wgtp50 | wgtp51 | wgtp52 | wgtp53 | wgtp54 | wgtp55 | wgtp56 | wgtp57 | wgtp58 | wgtp59 | wgtp60 | wgtp61 | wgtp62 | wgtp63 | wgtp64 | wgtp65 | wgtp66 | wgtp67 | wgtp68 | wgtp69 | wgtp70 | wgtp71 | wgtp72 | wgtp73 | wgtp74 | wgtp75 | wgtp76 | wgtp77 | wgtp78 | wgtp79 | wgtp80 | +======+==========+==========+======+========+======+=========+=========+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+========+======+======+======+======+=======+=======+=======+=======+======+======+=======+=======+=======+========+========+======+======+=======+======+======+======+======+======+======+=======+=========+======+======+======+======+======+=========+=======+======+======+======+======+======+=========+==========+=======+=======+========+=======+=======+=======+=======+=======+======+=======+=======+=======+=======+=======+======+========+=======+========+========+======+=======+========+=======+========+=======+========+========+======+========+========+========+=======+=======+=======+========+========+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+ | H | 1890 | 9 | 400 | 4 | 2 | 1000000 | 1007624 | 46 | 2 | 1 | null | null | 1 | 1 | 6 | null | null | 1 | 2 | 1 | 3 | 4 | null | null | null | null | null | null | 1 | 2 | 2 | 600 | 1 | 1 | null | 1 | 1 | 3 | 1 | null | null | 1 | 1 | 3 | null | null | null | 600 | 21 | 1 | 7 | 34700 | 0 | 4 | 4 | 4 | 1 | 1 | 1 | 3 | 0 | null | 0 | 1 | 0 | null | 0 | 1 | 0 | 0 | 0 | 0 | 2 | null | null | 1 | 0 | null | null | null | null | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | 16 | 10 | 42 | 61 | 44 | 54 | 45 | 71 | 67 | 112 | 50 | 15 | 41 | 111 | 79 | 37 | 67 | 38 | 40 | 81 | 95 | 70 | 81 | 51 | 40 | 38 | 47 | 15 | 22 | 18 | 34 | 95 | 55 | 14 | 51 | 48 | 18 | 43 | 12 | 7 | 13 | 15 | 57 | 72 | 55 | 48 | 50 | 75 | 80 | 116 | 51 | 14 | 38 | 126 | 57 | 30 | 93 | 29 | 53 | 80 | 55 | 71 | 46 | 38 | 57 | 39 | 47 | 16 | 16 | 20 | 50 | 91 | 58 | 20 | 72 | 43 | 11 | 48 | 9 | | H | 2029 | 9 | 101 | 4 | 2 | 1000000 | 1007624 | 269 | 4 | 1 | 1 | null | 1 | 4 | 2 | 2 | null | 80 | 2 | 2 | 80 | 1 | 1500 | null | 1 | 920 | 1 | 1 | 1 | 7 | null | null | 1 | 1 | null | 1 | 1 | 1 | 1 | null | 200000 | 1 | 200 | 4 | 8 | 47100 | 2 | null | null | 1 | 3 | 47100 | 1 | 2 | 4 | 2 | 1 | 1 | 2 | 7 | 0 | 4 | 0 | 0 | 2 | 28 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 1097 | 3 | 0 | 1 | 34 | 1 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 252 | 470 | 264 | 430 | 228 | 243 | 192 | 107 | 265 | 79 | 266 | 268 | 68 | 335 | 503 | 116 | 95 | 389 | 228 | 114 | 254 | 71 | 225 | 116 | 289 | 291 | 233 | 539 | 310 | 423 | 262 | 346 | 511 | 235 | 79 | 407 | 420 | 121 | 223 | 90 | 250 | 70 | 240 | 101 | 259 | 326 | 245 | 461 | 241 | 480 | 315 | 275 | 286 | 338 | 118 | 363 | 409 | 87 | 238 | 418 | 278 | 322 | 297 | 486 | 376 | 262 | 198 | 95 | 259 | 104 | 238 | 309 | 135 | 230 | 408 | 117 | 83 | 497 | 244 | 418 | +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+ | rt | serialno | division | puma | region | st | adjhsg | adjinc | wgtp | np | zzzz | acr | ags | bath | bdsp | bld | bus | conp | elep | fs | fulp | gasp | hfl | insp | mhp | mrgi | mrgp | mrgt | mrgx | refr | rmsp | rntm | rntp | rwat | sink | smp | stov | tel | ten | toil | vacs | valp | veh | watp | ybl | fes | fincp | fparc | grntp | grpip | hhl | hht | hincp | hugcl | hupac | hupaoc | huparc | kit | lngi | multg | mv | noc | npf | npp | nr | nrc | ocpip | partner | plm | psf | r18 | r60 | r65 | resmode | smocp | smx | srnt | sval | taxp | wif | wkexrel | workstat | facrp | fagsp | fbathp | fbdsp | fbldp | fbusp | fconp | felep | ffsp | ffulp | fgasp | fhflp | finsp | fkitp | fmhp | fmrgip | fmrgp | fmrgtp | fmrgxp | fmvp | fplmp | frefrp | frmsp | frntmp | frntp | frwatp | fsinkp | fsmp | fsmxhp | fsmxsp | fstovp | ftaxp | ftelp | ftenp | ftoilp | fvacsp | fvalp | fvehp | fwatp | fyblp | +======+==========+==========+======+========+======+=========+=========+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+========+======+======+======+======+=======+=======+=======+=======+======+======+=======+=======+=======+========+========+======+======+=======+======+======+======+======+======+======+=======+=========+======+======+======+======+======+=========+=======+======+======+======+======+======+=========+==========+=======+=======+========+=======+=======+=======+=======+=======+======+=======+=======+=======+=======+=======+======+========+=======+========+========+======+=======+========+=======+========+=======+========+========+======+========+========+========+=======+=======+=======+========+========+=======+=======+=======+=======+ | H | 168 | 9 | 300 | 4 | 2 | 1000000 | 1007624 | 56 | 3 | 1 | 1 | null | 1 | 3 | 2 | 2 | null | 200 | 2 | 3500 | 3 | 4 | 760 | null | 1 | 1800 | 1 | 1 | 1 | 7 | null | null | 1 | 1 | null | 1 | 1 | 1 | 1 | null | 235000 | 2 | 1600 | 5 | 7 | 89500 | 4 | null | null | 1 | 3 | 89500 | 0 | 4 | 4 | 4 | 1 | 1 | 1 | 6 | 0 | 3 | 0 | 0 | 0 | 33 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2425 | 3 | 0 | 1 | 43 | 3 | 14 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | H | 433 | 9 | 200 | 4 | 2 | 1000000 | 1007624 | 0 | 1 | 2 | null | null | null | null | null | null | null | null | 2 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 0 | null | null | null | null | null | null | null | null | null | null | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | | H | 650 | 9 | 200 | 4 | 2 | 1000000 | 1007624 | 57 | 0 | 1 | 2 | null | 1 | 2 | 2 | 2 | null | null | null | null | null | null | null | null | null | null | null | null | 1 | 6 | null | null | 1 | 1 | null | 1 | null | null | 1 | 5 | null | null | null | 7 | null | null | null | null | null | null | null | null | null | null | null | null | 1 | null | null | null | null | null | null | null | null | null | null | 1 | null | null | null | null | 2 | null | null | 0 | 0 | null | null | null | null | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | H | 1890 | 9 | 400 | 4 | 2 | 1000000 | 1007624 | 46 | 2 | 1 | null | null | 1 | 1 | 6 | null | null | 1 | 2 | 1 | 3 | 4 | null | null | null | null | null | null | 1 | 2 | 2 | 600 | 1 | 1 | null | 1 | 1 | 3 | 1 | null | null | 1 | 1 | 3 | null | null | null | 600 | 21 | 1 | 7 | 34700 | 0 | 4 | 4 | 4 | 1 | 1 | 1 | 3 | 0 | null | 0 | 1 | 0 | null | 0 | 1 | 0 | 0 | 0 | 0 | 2 | null | null | 1 | 0 | null | null | null | null | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | | H | 2029 | 9 | 101 | 4 | 2 | 1000000 | 1007624 | 269 | 4 | 1 | 1 | null | 1 | 4 | 2 | 2 | null | 80 | 2 | 2 | 80 | 1 | 1500 | null | 1 | 920 | 1 | 1 | 1 | 7 | null | null | 1 | 1 | null | 1 | 1 | 1 | 1 | null | 200000 | 1 | 200 | 4 | 8 | 47100 | 2 | null | null | 1 | 3 | 47100 | 1 | 2 | 4 | 2 | 1 | 1 | 2 | 7 | 0 | 4 | 0 | 0 | 2 | 28 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 1097 | 3 | 0 | 1 | 34 | 1 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+ +-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ | wgtp1 | wgtp2 | wgtp3 | wgtp4 | wgtp5 | wgtp6 | wgtp7 | wgtp8 | wgtp9 | wgtp10 | wgtp11 | wgtp12 | wgtp13 | wgtp14 | wgtp15 | wgtp16 | wgtp17 | wgtp18 | wgtp19 | wgtp20 | wgtp21 | wgtp22 | wgtp23 | wgtp24 | wgtp25 | wgtp26 | wgtp27 | wgtp28 | wgtp29 | wgtp30 | wgtp31 | wgtp32 | wgtp33 | wgtp34 | wgtp35 | wgtp36 | wgtp37 | wgtp38 | wgtp39 | wgtp40 | wgtp41 | wgtp42 | wgtp43 | wgtp44 | wgtp45 | wgtp46 | wgtp47 | wgtp48 | wgtp49 | wgtp50 | wgtp51 | wgtp52 | wgtp53 | wgtp54 | wgtp55 | wgtp56 | wgtp57 | wgtp58 | wgtp59 | wgtp60 | wgtp61 | wgtp62 | wgtp63 | wgtp64 | wgtp65 | wgtp66 | wgtp67 | wgtp68 | wgtp69 | wgtp70 | wgtp71 | wgtp72 | wgtp73 | wgtp74 | wgtp75 | wgtp76 | wgtp77 | wgtp78 | wgtp79 | wgtp80 | +=======+=======+=======+=======+=======+=======+=======+=======+=======+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+ | 74 | 14 | 62 | 94 | 47 | 55 | 45 | 72 | 60 | 120 | 18 | 58 | 31 | 61 | 54 | 52 | 15 | 20 | 88 | 58 | 20 | 60 | 107 | 57 | 110 | 115 | 16 | 47 | 17 | 72 | 55 | 18 | 63 | 19 | 89 | 70 | 47 | 43 | 56 | 86 | 81 | 20 | 70 | 94 | 68 | 47 | 57 | 94 | 80 | 78 | 39 | 61 | 12 | 51 | 63 | 47 | 21 | 14 | 95 | 72 | 16 | 50 | 79 | 73 | 82 | 79 | 16 | 53 | 24 | 35 | 54 | 16 | 39 | 12 | 118 | 135 | 66 | 47 | 50 | 76 | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | 60 | 17 | 57 | 16 | 93 | 106 | 59 | 58 | 58 | 17 | 56 | 101 | 54 | 116 | 96 | 18 | 72 | 15 | 61 | 55 | 54 | 18 | 54 | 15 | 96 | 97 | 57 | 65 | 55 | 17 | 49 | 94 | 59 | 113 | 88 | 18 | 59 | 13 | 56 | 50 | 60 | 17 | 59 | 17 | 96 | 98 | 52 | 50 | 50 | 17 | 60 | 93 | 57 | 102 | 101 | 17 | 68 | 20 | 53 | 54 | 66 | 18 | 63 | 19 | 91 | 106 | 56 | 56 | 57 | 20 | 57 | 90 | 54 | 98 | 101 | 16 | 51 | 17 | 61 | 61 | | 10 | 16 | 10 | 42 | 61 | 44 | 54 | 45 | 71 | 67 | 112 | 50 | 15 | 41 | 111 | 79 | 37 | 67 | 38 | 40 | 81 | 95 | 70 | 81 | 51 | 40 | 38 | 47 | 15 | 22 | 18 | 34 | 95 | 55 | 14 | 51 | 48 | 18 | 43 | 12 | 7 | 13 | 15 | 57 | 72 | 55 | 48 | 50 | 75 | 80 | 116 | 51 | 14 | 38 | 126 | 57 | 30 | 93 | 29 | 53 | 80 | 55 | 71 | 46 | 38 | 57 | 39 | 47 | 16 | 16 | 20 | 50 | 91 | 58 | 20 | 72 | 43 | 11 | 48 | 9 | | 252 | 470 | 264 | 430 | 228 | 243 | 192 | 107 | 265 | 79 | 266 | 268 | 68 | 335 | 503 | 116 | 95 | 389 | 228 | 114 | 254 | 71 | 225 | 116 | 289 | 291 | 233 | 539 | 310 | 423 | 262 | 346 | 511 | 235 | 79 | 407 | 420 | 121 | 223 | 90 | 250 | 70 | 240 | 101 | 259 | 326 | 245 | 461 | 241 | 480 | 315 | 275 | 286 | 338 | 118 | 363 | 409 | 87 | 238 | 418 | 278 | 322 | 297 | 486 | 376 | 262 | 198 | 95 | 259 | 104 | 238 | 309 | 135 | 230 | 408 | 117 | 83 | 497 | 244 | 418 | +-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

3 5

Insufficient priveleges while calling vaccum
by Ashish Kumar Singh 12 Oct '12

12 Oct '12

HI List, I have created a schema test user user testuser. While calling vacuum on one of its tables I am getting error : call vacuum(test,'testtable'); insufficient privileges Any examples on how to elevate priveleges for test user will be helpful! Regards, Ashish _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

1 0

Lock monetdb funnel behaviour
by Tapomay Dey 10 Oct '12

10 Oct '12

Hi, I have created two databases db1 and db2 and created a user "tapomay" on both with dedicated schema as given in the Getting Started page - http://www.monetdb.org/Downloads/Tutorial I have created a monetdb multiplex-funnel "testfunnel" pointing to them. When I do monetdb lock db1, I can access db1 using user "monetdb"(as expected) but not through user tapomay(as expected). But when I do monetdb lock testfunnel, I can still access it using user tapomay. I need it to stay unavailable. Also when I follow it by monetdb stop testfunnel and then try to access it using user tapomay, then it says that it's under maintenance. FYI, Regards, Tapomay _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 2

Question: How well does Monetdb support incremental updates?
by David Sisk 05 Oct '12

05 Oct '12

Question for you kind folks. I've tested another open source column-store database (Infinidb)...the query performance was very good, the bulk load performance was good, but where it fell down was on refreshing the data by updating a small percentage of the existing values. Bulk loads processed about 1000 rows/second...updating existing rows processed only about 1 row/second. We have growing 60-70Gb data warehouse, and we don't want to drop and re-load it every night, we want to just apply incremental updates at very short intervals throughout the day (say, every 5 mins). So, how well will Monetdb handle updates to existing rows in this scenario? One additional question: Are there any sources of commercial support for Monetdb? Thanks and best regards, -- Dave Sisk | Senior DBA dsisk(a)lulu.com | www.lulu.com [m] 919-744-1885 _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

1 0

Is there a MonetDB wiki ?
by Assaf Gordon 03 Oct '12

03 Oct '12

Hello, I'm new to MonetDB, and I find the documentation very terse. Is there a wiki for MonetDB ? Or perhaps a possibility to add comments on each of the manual-pages (like the PHP manual website, where users can elaborate and add examples on each function) ? Even a search on the mailing list archive would be helpful (but not the SourceForge search, it's very unfriendly). Thanks, -gordon _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 1

How to repair a database?
by Assaf Gordon 03 Oct '12

03 Oct '12

Hello, While loading a large file into a MonetDB database, my server crashed (the physical machine, not the MonetDB server process). After rebooting the machine and restarting MonetDB, almost every query crashes the MonetDB server: == $ mclient -d voc Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.14.0 (unreleased), 'mapi:monetdb://chachacha.cshl.edu:50000/voc' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select * from bc251 limit 10 ; Connection terminated $ tail merovingian.log <snip> 2012-10-03 15:53:51 MSG merovingian[4001]: proxying client (local) for database 'voc' to mapi:monetdb:///localdata/gordon/monetdb/testdb4/voc/.mapi.sock?database=voc 2012-10-03 15:53:51 MSG merovingian[4001]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying 2012-10-03 15:53:58 MSG merovingian[4001]: database 'voc' (4043) was killed by signal SIGSEGV == The database contains several tables, and queries on all of them result in monetdb server crash. How do I fix the database ? I tried "monetdbd stop + start", and also "monetdb lock + release", but to no avail. Thanks, -gordon BTW, It is likely that some of the database files are corrupted (due to the physical server crash). _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 1

Need name of columns in unique key of a table
by Tapomay Dey 03 Oct '12

03 Oct '12

I have following table: CREATE TABLE "sys"."tapomay3" ( "id" INTEGER, "val" VARCHAR(20), "valnum" INTEGER NOT NULL, CONSTRAINT "pk3" PRIMARY KEY ("valnum"), CONSTRAINT "tapomay3_id_val_unique" UNIQUE ("id", "val") ); I need to get the list of column names that are part of any unique key. sql>select o.name from keys k, objects o where k.id in (select id from keys where table_id = (select id from tables where name='tapomay3') and name like '%unique') and o.id = k.id; +---------+ | name | +=========+ | id | | val | +---------+ select o.name from keys k, objects o where k.id in (select id from keys where table_id = (select id from tables where name='tapomay3') and name like '%unique') and o.id = k.id Is this the right approach? Thanks and Regards, Tapomay. _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

1 0

Question about temporary tables - empty data?
by Assaf Gordon 01 Oct '12

01 Oct '12

Hello, I need to create temporary tables, but using the statement "create temporary table AS select XXX WITH DATA" results in an empty table; ==== sql>CREATE TABLE table1 (a INTEGER); operation successful (1.320ms) sql>INSERT INTO table1 VALUES(1); 1 affected row (0.693ms) sql>INSERT INTO table1 VALUES(2); 1 affected row (0.511ms) sql> sql>CREATE TEMPORARY TABLE temp1 AS SELECT * FROM table1 WITH DATA ; operation successful (0.735ms) sql>SELECT * FROM temp1; +---+ | a | +===+ +---+ 0 tuples (1.032ms) === Whereas if I don't use "temporary" for the table creation, it works fine: === sql>CREATE TABLE temp2 AS SELECT * FROM table1 WITH DATA ; operation successful (1.842ms) sql>SELECT * FROM temp2; +------+ | a | +======+ | 1 | | 2 | +------+ 2 tuples (1.898ms) === The example above is contrived, but I need to create two temporary tables to facilitate a join. Does the "temporary" keyword have different meaning than in other databases ? I couldn't find a good explanation in the on-line documentation... I'm using MonetDB v11.14.0, compiled from source with revision 45564:14983b3e103e . Thanks, -gordon _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 2