users-list
Threads by month
- ----- 2024 -----
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2008 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2007 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2006 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2005 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2004 -----
- December
- November
- October
September 2012
- 16 participants
- 19 discussions
Dear Professor/Lecturer
Please excuse us for contacting you directly. We are offering an efficient service to help you ensure your academic and professional work is written in perfect English. We will check the grammar and style of your work and return it to you to meet your requirements and deadlines.
Proof-Reading-Service.com can provide you with a professional proofreading service at a very reasonable rate. All our proofreaders are highly qualified native English speakers. Many work as leading academics in their fields and all have extensive experience of proofreading to the highest standards.
If you are interested in our service, please take a look at our website: www.proof-reading-service.com All you have to do is send us your document as a word attachment with the deadline and we will guarantee delivery of a perfectly written document to give you complete confidence when you submit your work. The fee is worked out on a flat rate (£6.95 per thousand words or 0.695 pence per word), so you know exactly how much the proofreading will cost in advance.
Once we have received your document(s) we will confirm the word count, the price and the deadline. If you have not heard from us within 2 hours during normal business hours after you have sent your work please resend it from a different email account or send the file to proofreadings(a)gmail.com.
We look forward to hearing from you!
Yours faithfully
Proof-Reading-Service.com
2
2
Hello,
Running the same query on the same data leeds to different results
between postgresql and monetdb.
I have not been able to get a simple example to reproduce the problem.
So here is what I observe:
the query:
select temps_mois.rfoperdmo as c1,
sum((case when dwhinv.dwhinv___rfodomide = 'RH' and
dwhinv.dwhinv___rfoindide = 'tech_rh_effectif_rem_reel' then
dwhinv.dwhinvqte else 0 end)) as m0
from rfoper_temps_mois as temps_mois,
dwhinv as dwhinv,
rfovsn as rfovsn_0,
rrhamv as rrhamv_1,
rrhcov as rrhcov_2,
rfoadv as rfoadv_3
where temps_mois.rfoper___rforefide = 'HPLUS'
and dwhinv.dwhinv___rforefide = 'HPLUS'
and dwhinv.dwhinv___rfodomide = 'RH'
and dwhinv.dwhinv___rfoindide = 'tech_rh_effectif_rem_reel'
and dwhinv.dwhinvdtd = temps_mois.rfoperdtd
and temps_mois.rfoperyea = '2011'
and rfovsn___rforefide = 'HPLUS'
and dwhinv.dwhinv___rfovsnide = rfovsn_0.rfovsnide
and rfovsn_0.rfovsnide = '201111_reel'
and rrhamv_1.rrhamv___rrhvemide='GRACOR'
AND rrhamv_1.rrhamvrvs=1
AND rrhamv_1.rrhamv___rforefide= 'HPLUS'
and dwhinv.dwhinv___rrhempide = rrhamv_1.rrhamvinf
and rrhamv_1.rrhamvsup = 'CEMP'
and rrhcov_2.rrhcov___rrhvcoide='CONTRATS'
AND rrhcov_2.rrhcovrvs=1
AND rrhcov_2.rrhcov___rforefide= 'HPLUS'
and dwhinv.dwhinv___rrhcntide = rrhcov_2.rrhcovinf
and rrhcov_2.rrhcovsup = 'CONTRATS'
and rfoadv_3.rfoadv___rfovdeide='STRC'
AND rfoadv_3.rfoadvrvs=1
AND rfoadv_3.rfoadv___rforefide= 'HPLUS'
and dwhinv.dwhinv_p2rfodstide = rfoadv_3.rfoadvinf
and rfoadv_3.rfoadvsup = 'HPLUS'
group by c1
order by c1
Postgresql result:
c1 | m0
----+-----------------
01 | 7111.5376967750
02 | 7100.9108821426
03 | 7150.2597967742
04 | 7151.4283666667
05 | 7109.1641451610
06 | 6976.2108421239
07 | 6329.7404193564
08 | 6302.9823032247
09 | 6426.9459633351
10 | 6519.6889580648
11 | 6549.5235033402
12 | 6492.5477161292
(12 lignes)
Monetdb result:
+------+----------------------+
| c1 | m0 |
+======+======================+
| 12 | 1.000000 |
| 11 | 1.000000 |
| 10 | 2.000000 |
| 09 | 0.366667 |
| 08 | 1.000000 |
| 07 | 1.000000 |
| 06 | 1.000000 |
| 05 | 3.000000 |
| 04 | 4.000000 |
| 03 | 15.000000 |
| 02 | 9.964286 |
| 01 | 1.000000 |
+------+----------------------+
12 tuples (212.346ms)
As you see, all "m0" values are very different.
I have no idea of what is causing this but if I modify the query in
order to simplify the CASE...WHEN...ELSE part of the select, it produce
the expected result:
replacing sum((case when dwhinv.dwhinv___rfodomide = 'RH' and
dwhinv.dwhinv___rfoindide = 'tech_rh_effectif_rem_reel' then
dwhinv.dwhinvqte else 0 end)) as m0
by sum((case when dwhinv.dwhinv___rfoindide =
'tech_rh_effectif_rem_reel' then dwhinv.dwhinvqte else 0 end)) as m0
Its not exactly the same query but it must leeds to the same result due
to my test datas (its the case in postgres)
I join to this email two files with the TRACES, respectively for the
request with bad/correct result (ko.txt/ok.txt)
Config:
Ubuntu Server 11.04 x64
MonetDB v11.7.9 (Dec2011-SP2), MonetDB Database Server v1.6
(Dec2011-SP2), MonetDB Database Server Toolkit v1.0 (Dec2011-SP2)
Thank you very much for your help!!
--
*Matthieu Guamis*
*Logo Axège <http://www.axege.com/>* /Axège//
23,rue Saint-Simon
63000 Clermont-Ferrand/
Tél: +33 (0)4 63 05 95 40
Fax: +33 (0)4.73.70.65.29
Email: matthieu.guamis(a)axege.com <mailto:matthieu.guamis@axege.com>
3
4
invalid tuple received from server, got 138 columns, expected 476, ignoring
by Anthony Damico 13 Oct '12
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
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
users-list post from ajdamico@gmail.com requires approval
by users-list-owner@monetdb.org 28 Sep '12
by users-list-owner@monetdb.org 28 Sep '12
28 Sep '12
As list administrator, your authorization is requested for the
following mailing list posting:
List: users-list(a)monetdb.org
From: ajdamico(a)gmail.com
Subject: invalid tuple received from server, got 138 columns, expected 476, ignoring
Reason: Post by non-member to a members-only list
At your convenience, visit:
http://mail.monetdb.org/mailman/admindb/users-list
to approve or deny the request.
1
0
Hello,
I'm seeing this error when starting a database. Not sure if anyone has
had the same issue and whether anyone had a fix?
The following is what I did
% monetdbd start ~/dbfarm
% monetdbd start ~/dbfarm
% monetdb create voc
% monetdb start voc
starting database 'voc'... FAILED
start: starting 'voc' failed: database 'voc' appears to shut itself
down after starting, check monetdbd's logfile for possible hints
The log says the following
2012-09-27 16:56:04 MSG merovingian[14761]: database 'voc' (14801) has
exited with exit status 1
2012-09-27 16:56:04 ERR control[14761]: (local): failed to fork
mserver: database 'voc' appears to shut itself down after starting,
check monetdbd's logfile for possible hints
Any comments / suggestions?
Thank you,
Peter
_______________________________________________
users-list mailing list
users-list(a)monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
3
7
Hi All,
I just tried monetdb with large tables (600,000 rows by 50,000 columns).
There are two issues:
1. performance was low, it took about 4 seconds to insert a row of record
when the number of columns was large (50,000). However it was pretty fast
(about 100 rows per second) when the column number was small (for example,
10).
2. serious errors occurred very often. For example, after inserting random
number of records (50, for example), monetdb started to report errors, like:
monetdbd: internal error while starting mserver, please refer to the
logs
So I opened the log file, and the error was:
2012-09-14 08:26:36 ERR merovingian[13730]: client error: unknown or
impossible state: 4
The Makefile (it is also contained in the attachments) listed below will
start database server, create a database farm, create a database, create a
big table and then insert records to the big table. Here it is:
#=====start of Makefile=====================
ROW_NUM=600000
COLUMN_NUM=50000
COLUMN_NUM_MINUS_ONE=$(shell echo $(COLUMN_NUM)-1 | bc)
all: clean
monetdbd create ./mydbfarm
monetdbd start ./mydbfarm
monetdb create test_big_db
monetdb release test_big_db
make create_table_sql -s > create_big_table.sql
make insert_data_sql -s > insert_data.sql
mclient -d test_big_db create_big_table.sql
for i in $$(seq 1 $(ROW_NUM)); do \
mclient -d test_big_db insert_data.sql ;\
echo 'done inserting ' $$i ' rows'; \
done;
mclient -d test_big_db -s "select * from test_big_table" >
test_big_table.txt
create_table_sql:
@echo 'START TRANSACTION;'
@echo 'CREATE TABLE "test_big_table" ('
@for i in $$(seq 1 $(COLUMN_NUM_MINUS_ONE)); do \
echo ' "gen'$$i'" DOUBLE,'; \
done
@echo ' "gen$(COLUMN_NUM)" DOUBLE'
@echo ');'
@echo 'COMMIT;'
insert_data_sql:
@echo -n 'INSERT INTO "test_big_table" VALUES (' ;
@for j in $$(seq 1 $(COLUMN_NUM_MINUS_ONE)) ; do \
echo -n '0.323, '; \
done;
@echo '0.324);';
insert_all_data_sql:
@echo 'START TRANSACTION;'
@for i in $$(seq 1 $(ROW_NUM)); do\
echo -n 'INSERT INTO "test_big_table" VALUES (' ;\
for j in $$(seq 1 $(COLUMN_NUM_MINUS_ONE)) ; do \
echo -n '0.323, '; \
done; \
echo '0.324);'; \
done
@echo 'COMMIT;'
clean:
-killall mserver5
-killall monetdbd
rm -rf ./mydbfarm
rm -rf create_big_table.sql test_big_table.txt insert_data.sql
#=====end of Makefile======================
Thank you very much !
Best wishes,
Joshua Shuai Yuan
On Thu, Sep 13, 2012 at 12:43 PM, Joshua Shuai Yuan <
shuaiyuan.emory(a)gmail.com> wrote:
> Sure, I will see what I can do.
>
> Best wishes,
> Joshua Shuai Yuan
>
>
> On Wed, Sep 12, 2012 at 11:40 PM, Wang, Fusheng <fusheng.wang(a)emory.edu>wrote:
>
>> Hi Joshua,****
>>
>> ** **
>>
>> The table we are managing is in the scale of 30K x 5K: 150M cells. If
>> each table cell (double type) needs 8 bytes to represent (ideally), the
>> space needed will be a couple of GB, or at most, in the scale of tens of
>> GB. If that is the case, distributed setup may not be needed, as the data
>> can be mostly cached by the database. MonetDB does support multi-cores
>> and multi-disks, but setup across multiple machines is not supported based
>> on my knowledge. ****
>>
>> ** **
>>
>> Even though MonetDB claims unlimited number of columns, we should still
>> be cautious on what performance we can achieve for the queries we want to
>> provide. A pilot study on this could provide us some guideline. Do you
>> think you can setup MonetDB, and create a benchmark table we can do some
>> performance study?****
>>
>> ** **
>>
>> Interestingly, the large column issue is also discussed in a famous
>> database blog:****
>>
>>
>> http://www.dbms2.com/2011/03/13/so-how-many-columns-can-a-single-table-have…
>> ****
>>
>> ** **
>>
>> One guy commented:****
>>
>> ** **
>>
>> “Genomics models were the primary driver. these folks typically have
>> short but wide datasets of the order of 300,000 columns.”****
>>
>> ** **
>>
>> So we are not alone. And we have only a subset of the columns (30K
>> versus 300K)? Then we are lucky!****
>>
>> ** **
>>
>> ** **
>>
>> Fusheng****
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> *From:* Joshua Shuai Yuan [mailto:shuaiyuan.emory@gmail.com]
>> *Sent:* Wednesday, September 12, 2012 11:14 PM
>> *To:* Wang, Fusheng
>> *Cc:* Qin, Zhaohui
>> *Subject:* Re: Array database for large matrix****
>>
>> ** **
>>
>> Hi Dr. Wang,****
>>
>> That's really a good news. Does it support distributed database? Or do
>> we need distributed one?****
>>
>> ** **
>>
>>
>> Best wishes,
>> Joshua Shuai Yuan
>>
>> ****
>>
>> On Wed, Sep 12, 2012 at 3:54 PM, Wang, Fusheng <fusheng.wang(a)emory.edu>
>> wrote:****
>>
>> Hi guys,****
>>
>> ****
>>
>> It looks like the matrix structure can be nicely supported by array
>> databases, like MonetDB. It supports unlimited number of columns for a
>> table. It’s also open source. ****
>>
>> http://www.monetdb.org/Home/Features****
>>
>> ****
>>
>> I know the group quite well, and I will chat with them on the use case to
>> see if it’s a good fit. ****
>>
>> ****
>>
>> Thanks,****
>>
>> ****
>>
>> Fusheng****
>>
>> ****
>>
>> ****
>>
>> ** **
>> ------------------------------
>>
>>
>> This e-mail message (including any attachments) is for the sole use of
>> the intended recipient(s) and may contain confidential and privileged
>> information. If the reader of this message is not the intended
>> recipient, you are hereby notified that any dissemination, distribution
>> or copying of this message (including any attachments) is strictly
>> prohibited.
>>
>> If you have received this message in error, please contact
>> the sender by reply e-mail message and destroy all copies of the
>> original message (including attachments).****
>>
>> ** **
>>
>
>
2
2
We would like to inform you that as of Januari 2013, the monetdb project
on SourceForge will be removed. All services that SourceForge has
kindly provided us with in the past will be migrated to our monetdb.org
infrastructure.
Currently, the only remaining services hosted on SourceForge are the
three mailing lists monetdb-announce, monetdb-users and
monetdb-developers. As of this message, these lists are migrated to
their equivalents on monetdb.org. The new lists are as follows:
monetdb-announce(a)lists.sourceforge.net -> announce-list(a)monetdb.org
monetdb-users(a)lists.sourceforge.net -> users-list(a)monetdb.org
monetdb-developers(a)lists.sourceforge.net -> developers-list(a)monetdb.org
We invite you to subscribe to the new lists on monetdb.org at your
earliest convenience. Any posts to the old lists are rejected from now
on. Posts to the new lists at monetdb.org are forwarded in batches to
the old lists until the end of this year.
The MonetDB team would like to take this opportunity to thank
SourceForge for the services provided over the past years. We hope to
welcome all current subscribers on our new lists at monetdb.org, see:
http://mail.monetdb.org/mailman/listinfo
The MonetDB team
1
0
[MonetDB-users] invalid tuple received from server, got 138 columns, expected 476, ignoring
by Anthony Damico 26 Sep '12
by Anthony Damico 26 Sep '12
26 Sep '12
Hello, I'm pretty new to MonetDB and I'm trying to perform what seems like
it should be a relatively straightforward inner join between two tables.
I would like to merge the two Alaska files from the American Community
Survey --
http://www2.census.gov/acs2010_1yr/pums/csv_hak.zip contains a CSV file
with one record per household
http://www2.census.gov/acs2010_1yr/pums/csv_pak.zip contains a CSV file
with one record per personThese two files should be merged on the field
"serialno"
I am working on Windows 7 x64. Here's the contents of my mserver5.exe
window:
# MonetDB 5 server v11.11.11 "Jul2012-SP2"
# Serving database 'demo', using 2 threads
# Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
# Found 3.905 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://127.0.0.1:50000/
# MonetDB/SQL module loaded
>
The following commands..
1) create a person-level table
2) create a household-level table
3) read the person-level CSV into the person table
4) read the household-level CSV into the household table
5) attempt to print the first five records with "select * from tablename
limit 5"
-- sometimes these work, sometimes they don't.
6) merge the two tables together
7) attempt to print the first five records of the merged table
Unfortunately, I'm getting an error that I can't find with web searches..
The only place I can even find this error is
http://bugs.monetdb.org/show_bug.cgi?id=2963 -- and that seems both
time-related and fixed long ago.. I doubt it's a bug, I'm probably just
making a beginner's mistake.
invalid tuple received from server, got 138 columns, expected 476, ignoring
+------+------+------+------+-------+------+---------+---------+------+------+
1 tuple (417.984ms) !466 columns dropped!
note: to disable dropping columns and/or truncating fields use \w-1
Even after setting \w to -1, the number of columns returned gets limited,
crashing my program.
I am ultimately trying to work with the new R/MonetDB package (which uses
Java and is available from http://sqlsurvey.r-forge.r-project.org/), but
none of the table interactivity will work until I'm able to return all of
the columns properly.
Any advice would be appreciated! Thanks!!!
Anthony Damico
Kaiser Family Foundation
Here are the SQL commands:
CREATE TABLE person (RT VARCHAR(255), SERIALNO INT, SPORDER INT, PUMA INT,
ST INT, ADJINC INT, PWGTP INT, AGEP INT, CIT INT, CITWP INT, COW INT, DDRS
INT, DEAR INT, DEYE INT, DOUT INT, DPHY INT, DRAT INT, DRATX INT, DREM INT,
ENG INT, FER INT, GCL INT, GCM INT, GCR INT, HINS1 INT, HINS2 INT, HINS3
INT, HINS4 INT, HINS5 INT, HINS6 INT, HINS7 INT, INTP INT, JWMNP INT, JWRIP
INT, JWTR INT, LANX INT, MAR INT, MARHD INT, MARHM INT, MARHT INT, MARHW
INT, MARHYP INT, MIG INT, MIL INT, MLPA INT, MLPB INT, MLPC INT, MLPD INT,
MLPE INT, MLPF INT, MLPG INT, MLPH INT, MLPI INT, MLPJ INT, MLPK INT, NWAB
INT, NWAV INT, NWLA INT, NWLK INT, NWRE INT, OIP INT, PAP INT, RELP INT,
RETP INT, SCH INT, SCHG INT, SCHL INT, SEMP INT, SEX INT, SSIP INT, SSP
INT, WAGP INT, WKHP INT, WKL INT, WKW INT, WRK INT, YOEP INT, ANC INT,
ANC1P INT, ANC2P INT, DECADE INT, DIS INT, DRIVESP INT, ESP INT, ESR INT,
FOD1P INT, FOD2P INT, HICOV INT, HISP INT, INDP INT, JWAP INT, JWDP INT,
LANP INT, MIGPUMA INT, MIGSP INT, MSP INT, NAICSP VARCHAR(255), NATIVITY
INT, NOP INT, OC INT, OCCP INT, PAOC INT, PERNP INT, PINCP INT, POBP INT,
POVPIP INT, POWPUMA INT, POWSP INT, PRIVCOV INT, PUBCOV INT, QTRBIR INT,
RAC1P INT, RAC2P INT, RAC3P INT, RACAIAN INT, RACASN INT, RACBLK INT,
RACNHPI INT, RACNUM INT, RACSOR INT, RACWHT INT, RC INT, SCIENGP INT,
SCIENGRLP INT, SFN INT, SFR INT, SOCP VARCHAR(255), VPS INT, WAOB INT,
FAGEP INT, FANCP INT, FCITP INT, FCITWP INT, FCOWP INT, FDDRSP INT, FDEARP
INT, FDEYEP INT, FDOUTP INT, FDPHYP INT, FDRATP INT, FDRATXP INT, FDREMP
INT, FENGP INT, FESRP INT, FFERP INT, FFODP INT, FGCLP INT, FGCMP INT,
FGCRP INT, FHINS1P INT, FHINS2P INT, FHINS3C INT, FHINS3P INT, FHINS4C INT,
FHINS4P INT, FHINS5C INT, FHINS5P INT, FHINS6P INT, FHINS7P INT, FHISP INT,
FINDP INT, FINTP INT, FJWDP INT, FJWMNP INT, FJWRIP INT, FJWTRP INT, FLANP
INT, FLANXP INT, FMARHDP INT, FMARHMP INT, FMARHTP INT, FMARHWP INT,
FMARHYP INT, FMARP INT, FMIGP INT, FMIGSP INT, FMILPP INT, FMILSP INT,
FOCCP INT, FOIP INT, FPAP INT, FPOBP INT, FPOWSP INT, FRACP INT, FRELP INT,
FRETP INT, FSCHGP INT, FSCHLP INT, FSCHP INT, FSEMP INT, FSEXP INT, FSSIP
INT, FSSP INT, FWAGP INT, FWKHP INT, FWKLP INT, FWKWP INT, FWRKP INT, FYOEP
INT, pwgtp1 INT, pwgtp2 INT, pwgtp3 INT, pwgtp4 INT, pwgtp5 INT, pwgtp6
INT, pwgtp7 INT, pwgtp8 INT, pwgtp9 INT, pwgtp10 INT, pwgtp11 INT, pwgtp12
INT, pwgtp13 INT, pwgtp14 INT, pwgtp15 INT, pwgtp16 INT, pwgtp17 INT,
pwgtp18 INT, pwgtp19 INT, pwgtp20 INT, pwgtp21 INT, pwgtp22 INT, pwgtp23
INT, pwgtp24 INT, pwgtp25 INT, pwgtp26 INT, pwgtp27 INT, pwgtp28 INT,
pwgtp29 INT, pwgtp30 INT, pwgtp31 INT, pwgtp32 INT, pwgtp33 INT, pwgtp34
INT, pwgtp35 INT, pwgtp36 INT, pwgtp37 INT, pwgtp38 INT, pwgtp39 INT,
pwgtp40 INT, pwgtp41 INT, pwgtp42 INT, pwgtp43 INT, pwgtp44 INT, pwgtp45
INT, pwgtp46 INT, pwgtp47 INT, pwgtp48 INT, pwgtp49 INT, pwgtp50 INT,
pwgtp51 INT, pwgtp52 INT, pwgtp53 INT, pwgtp54 INT, pwgtp55 INT, pwgtp56
INT, pwgtp57 INT, pwgtp58 INT, pwgtp59 INT, pwgtp60 INT, pwgtp61 INT,
pwgtp62 INT, pwgtp63 INT, pwgtp64 INT, pwgtp65 INT, pwgtp66 INT, pwgtp67
INT, pwgtp68 INT, pwgtp69 INT, pwgtp70 INT, pwgtp71 INT, pwgtp72 INT,
pwgtp73 INT, pwgtp74 INT, pwgtp75 INT, pwgtp76 INT, pwgtp77 INT, pwgtp78
INT, pwgtp79 INT, pwgtp80 INT);
CREATE TABLE household (RT VARCHAR(255), SERIALNO INT, DIVISION INT, PUMA
INT, REGION INT, ST INT, ADJHSG INT, ADJINC INT, WGTP INT, NP INT, TYPE
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 50000 offset 2 records into person from
'C:\Users\user\desktop\ss10pak.csv' using delimiters ',','\n','"' NULL as
'' ;
copy 25000 offset 2 records into household from
'C:\Users\user\desktop\ss10hak.csv' using delimiters ',','\n','"' NULL as
'' ;
select * from person limit 5;
select * from household limit 5;
create table merged as select 'M' as rt, a.serialno, a.division, a.puma,
a.region, a.st, a.adjhsg, a.adjinc, a.wgtp, a.np, a.type, a.acr, a.ags,
a.bath, a.bdsp, a.bld, a.bus, a.conp, a.elep, a.fs, a.fulp, a.gasp, a.hfl,
a.insp, a.mhp, a.mrgi, a.mrgp, a.mrgt, a.mrgx, a.refr, a.rmsp, a.rntm,
a.rntp, a.rwat, a.sink, a.smp, a.stov, a.tel, a.ten, a.toil, a.vacs,
a.valp, a.veh, a.watp, a.ybl, a.fes, a.fincp, a.fparc, a.grntp, a.grpip,
a.hhl, a.hht, a.hincp, a.hugcl, a.hupac, a.hupaoc, a.huparc, a.kit, a.lngi,
a.multg, a.mv, a.noc, a.npf, a.npp, a.nr, a.nrc, a.ocpip, a.partner, a.plm,
a.psf, a.r18, a.r60, a.r65, a.resmode, a.smocp, a.smx, a.srnt, a.sval,
a.taxp, a.wif, a.wkexrel, a.workstat, a.facrp, a.fagsp, a.fbathp, a.fbdsp,
a.fbldp, a.fbusp, a.fconp, a.felep, a.ffsp, a.ffulp, a.fgasp, a.fhflp,
a.finsp, a.fkitp, a.fmhp, a.fmrgip, a.fmrgp, a.fmrgtp, a.fmrgxp, a.fmvp,
a.fplmp, a.frefrp, a.frmsp, a.frntmp, a.frntp, a.frwatp, a.fsinkp, a.fsmp,
a.fsmxhp, a.fsmxsp, a.fstovp, a.ftaxp, a.ftelp, a.ftenp, a.ftoilp,
a.fvacsp, a.fvalp, a.fvehp, a.fwatp, a.fyblp, a.wgtp1, a.wgtp2, a.wgtp3,
a.wgtp4, a.wgtp5, a.wgtp6, a.wgtp7, a.wgtp8, a.wgtp9, a.wgtp10, a.wgtp11,
a.wgtp12, a.wgtp13, a.wgtp14, a.wgtp15, a.wgtp16, a.wgtp17, a.wgtp18,
a.wgtp19, a.wgtp20, a.wgtp21, a.wgtp22, a.wgtp23, a.wgtp24, a.wgtp25,
a.wgtp26, a.wgtp27, a.wgtp28, a.wgtp29, a.wgtp30, a.wgtp31, a.wgtp32,
a.wgtp33, a.wgtp34, a.wgtp35, a.wgtp36, a.wgtp37, a.wgtp38, a.wgtp39,
a.wgtp40, a.wgtp41, a.wgtp42, a.wgtp43, a.wgtp44, a.wgtp45, a.wgtp46,
a.wgtp47, a.wgtp48, a.wgtp49, a.wgtp50, a.wgtp51, a.wgtp52, a.wgtp53,
a.wgtp54, a.wgtp55, a.wgtp56, a.wgtp57, a.wgtp58, a.wgtp59, a.wgtp60,
a.wgtp61, a.wgtp62, a.wgtp63, a.wgtp64, a.wgtp65, a.wgtp66, a.wgtp67,
a.wgtp68, a.wgtp69, a.wgtp70, a.wgtp71, a.wgtp72, a.wgtp73, a.wgtp74,
a.wgtp75, a.wgtp76, a.wgtp77, a.wgtp78, a.wgtp79, a.wgtp80, sporder, pwgtp,
agep, cit, citwp, cow, ddrs, dear, deye, dout, dphy, drat, dratx, drem,
eng, fer, gcl, gcm, gcr, hins1, hins2, hins3, hins4, hins5, hins6, hins7,
intp, jwmnp, jwrip, jwtr, lanx, mar, marhd, marhm, marht, marhw, marhyp,
mig, mil, mlpa, mlpb, mlpc, mlpd, mlpe, mlpf, mlpg, mlph, mlpi, mlpj, mlpk,
nwab, nwav, nwla, nwlk, nwre, oip, pap, relp, retp, sch, schg, schl, semp,
sex, ssip, ssp, wagp, wkhp, wkl, wkw, wrk, yoep, anc, anc1p, anc2p, decade,
dis, drivesp, esp, esr, fod1p, fod2p, hicov, hisp, indp, jwap, jwdp, lanp,
migpuma, migsp, msp, naicsp, nativity, nop, oc, occp, paoc, pernp, pincp,
pobp, povpip, powpuma, powsp, privcov, pubcov, qtrbir, rac1p, rac2p, rac3p,
racaian, racasn, racblk, racnhpi, racnum, racsor, racwht, rc, sciengp,
sciengrlp, sfn, sfr, socp, vps, waob, fagep, fancp, fcitp, fcitwp, fcowp,
fddrsp, fdearp, fdeyep, fdoutp, fdphyp, fdratp, fdratxp, fdremp, fengp,
fesrp, fferp, ffodp, fgclp, fgcmp, fgcrp, fhins1p, fhins2p, fhins3c,
fhins3p, fhins4c, fhins4p, fhins5c, fhins5p, fhins6p, fhins7p, fhisp,
findp, fintp, fjwdp, fjwmnp, fjwrip, fjwtrp, flanp, flanxp, fmarhdp,
fmarhmp, fmarhtp, fmarhwp, fmarhyp, fmarp, fmigp, fmigsp, fmilpp, fmilsp,
foccp, foip, fpap, fpobp, fpowsp, fracp, frelp, fretp, fschgp, fschlp,
fschp, fsemp, fsexp, fssip, fssp, fwagp, fwkhp, fwklp, fwkwp, fwrkp, fyoep,
pwgtp1, pwgtp2, pwgtp3, pwgtp4, pwgtp5, pwgtp6, pwgtp7, pwgtp8, pwgtp9,
pwgtp10, pwgtp11, pwgtp12, pwgtp13, pwgtp14, pwgtp15, pwgtp16, pwgtp17,
pwgtp18, pwgtp19, pwgtp20, pwgtp21, pwgtp22, pwgtp23, pwgtp24, pwgtp25,
pwgtp26, pwgtp27, pwgtp28, pwgtp29, pwgtp30, pwgtp31, pwgtp32, pwgtp33,
pwgtp34, pwgtp35, pwgtp36, pwgtp37, pwgtp38, pwgtp39, pwgtp40, pwgtp41,
pwgtp42, pwgtp43, pwgtp44, pwgtp45, pwgtp46, pwgtp47, pwgtp48, pwgtp49,
pwgtp50, pwgtp51, pwgtp52, pwgtp53, pwgtp54, pwgtp55, pwgtp56, pwgtp57,
pwgtp58, pwgtp59, pwgtp60, pwgtp61, pwgtp62, pwgtp63, pwgtp64, pwgtp65,
pwgtp66, pwgtp67, pwgtp68, pwgtp69, pwgtp70, pwgtp71, pwgtp72, pwgtp73,
pwgtp74, pwgtp75, pwgtp76, pwgtp77, pwgtp78, pwgtp79, pwgtp80 from
household as a inner join person as b on a.serialno = b.serialno with data;
select * from merged limit 5;
invalid tuple received from server, got 138 columns, expected 476, ignoring
2
1
Hi,
I am trying to insert data into monetdb using sqoop, via the monet jdbc
interface. It keeps crashing 20 odd rows into the import, with a monetdb
ROLLBACK. The debug info from Sqoop is poor. Does anyone know if the monetdb
ROLLBACK can be disabled, so that I can see the last row imported.
Has anyone tried Sqoop to Monetdb, are there any debugging tips that you can
give ?
Regards,
Jeremy
sqoop export --connect jdbc:monetdb://cluster-03/ngpm -driver
nl.cwi.monetdb.jdbc.MonetDriver --num-mappers 1 --password monetdb
--username monetdb --table query_start --export-dir
/test/dash_test/QueryStart.Log --fields-terminated-by ','
12/09/24 17:27:49 INFO mapreduce.Job: Task Id :
attempt_1347971665109_0247_m_000000_1, Status : FAILED
Error: java.io.IOException: java.sql.SQLException: EXEC: wrong number of
arguments for prepared statement: 100, expected 102
at
org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.close(AsyncSqlRecordWriter.j
ava:192)
at
org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.close(MapTask.java
:610)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:730)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)
at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:152)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.ja
va:1232)
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:147)
Caused by: java.sql.SQLException: EXEC: wrong number of arguments for
prepared statement: 100, expected 102
at
nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnectio
n.java:2524)
at
nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnectio
n.java:2274)
at
nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:508)
at
nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:349)
at
nl.cwi.monetdb.jdbc.MonetPreparedStatement.execute(MonetPreparedStatement.ja
va:247)
at
org.apache.sqoop.mapreduce.AsyncSqlOutputFormat$AsyncSqlExecThread.run(Async
SqlOutputFormat.java:230)
1
0