Re: Returned row count doesn't match lines in output file

--00000000000091e2000596c5871c
Content-Type: multipart/alternative; boundary="00000000000091e1ff0596c5871b"

--00000000000091e1ff0596c5871b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Nov 7, 2019 at 9:58 AM Tchouante, Merlin <[email protected]>
wrote:

> Hello group,
>
>
>
> I=E2=80=99m new to this group so please bear with me.
>
>
>
>
>
> select count (u.user_id)
>
> from users u, course_main cm, course_users cu
>
> where cu.crsmain_pk1 =3D cm.pk1
>
> and cu.users_pk1 =3D u.pk1
>
> and cm.course_id =3D 'Org.dent.Training';
>
>
>
> (4915 rows)
>
>
>
>
>
> I=E2=80=99m executing an .sql file which looks like this:
>
>
>
> \o /home/bbuser/banner/gradeload/sodorgusers.txt
>
> \t on
>
> select
> u.user_id||'|'||u.firstname||'|'||u.lastname||'|'||u.email||'|'||u.studen=
t_id
>
> from users u, course_main cm, course_users cu
>
> where cu.crsmain_pk1 =3D cm.pk1
>
> and cu.users_pk1 =3D u.pk1
>
> and cm.course_id =3D 'Org.dent.Training'
>
> order by u.lastname, u.firstname;
>
> \t off
>
> \o
>
>
>
> When I look at the output file, it has a bunch of blank lines in between
> the records but displays a line count of 4916.  What is causing the blank
> lines?  When I strip away the blank lines from the file, I get 3525 lines=
.
> Why aren=E2=80=99t all 4,915 records writing to the file?
>
>
>
>
>
If you just run a simple select on user_id (none of the pipe concat stuff)
from the file, what results do you get? Also if you run the count statement
from the file, what results do you get? (Just want to make sure you're not
accidentally running against a different server, database or default schema
as the source of the problem..)

Steve

--00000000000091e1ff0596c5871b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Thu, Nov 7, 2019 at 9:58 AM Tchoua=
nte, Merlin &lt;<a href=3D"mailto:[email protected]">mtchouan@umarylan=
d.edu</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:=
1ex">





<div lang=3D"EN-US">
<div class=3D"gmail-m_-5280549166487772848WordSection1">
<p class=3D"MsoNormal">Hello group,<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">I=E2=80=99m new to this group so please bear with me=
.<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">select count (u.user_id)<u></u><u></u></p>
<p class=3D"MsoNormal">from users u, course_main cm, course_users cu<u></u>=
<u></u></p>
<p class=3D"MsoNormal">where cu.crsmain_pk1 =3D cm.pk1<u></u><u></u></p>
<p class=3D"MsoNormal">and cu.users_pk1 =3D u.pk1<u></u><u></u></p>
<p class=3D"MsoNormal">and cm.course_id =3D &#39;Org.dent.Training&#39;;<u>=
</u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">(4915 rows)<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">I=E2=80=99m executing an .sql file which looks like =
this:<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">\o /home/bbuser/banner/gradeload/sodorgusers.txt<u><=
/u><u></u></p>
<p class=3D"MsoNormal">\t on<u></u><u></u></p>
<p class=3D"MsoNormal">select u.user_id||&#39;|&#39;||u.firstname||&#39;|&#=
39;||u.lastname||&#39;|&#39;||u.email||&#39;|&#39;||u.student_id<u></u><u><=
/u></p>
<p class=3D"MsoNormal">from users u, course_main cm, course_users cu<u></u>=
<u></u></p>
<p class=3D"MsoNormal">where cu.crsmain_pk1 =3D cm.pk1<u></u><u></u></p>
<p class=3D"MsoNormal">and cu.users_pk1 =3D u.pk1<u></u><u></u></p>
<p class=3D"MsoNormal">and cm.course_id =3D &#39;Org.dent.Training&#39;<u><=
/u><u></u></p>
<p class=3D"MsoNormal">order by u.lastname, u.firstname;<u></u><u></u></p>
<p class=3D"MsoNormal">\t off<u></u><u></u></p>
<p class=3D"MsoNormal">\o<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">When I look at the output file, it has a bunch of bl=
ank lines in between the records but displays a line count of 4916.=C2=A0 W=
hat is causing the blank lines?=C2=A0 When I strip away the blank lines fro=
m the file, I get 3525 lines.=C2=A0 Why aren=E2=80=99t all
 4,915 records writing to the file?<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">=C2=A0</p></div></div></blockquote><div>If you just =
run a simple select on user_id (none of the pipe concat stuff) from the fil=
e, what results do you get? Also if you run the count statement from the fi=
le, what results do you get? (Just want to make sure you&#39;re not acciden=
tally running against a different server, database or default schema as the=
 source of the problem..)</div><div><br></div><div>Steve<br></div><div><br>=
</div></div></div>

--00000000000091e1ff0596c5871b--
--00000000000091e2000596c5871c
Content-Type: image/jpeg; name="image001.jpg"
Content-Disposition: inline; filename="image001.jpg"
Content-Transfer-Encoding: base64
Content-ID: <16e4709d0b74ce8e91>
X-Attachment-Id: 16e4709d0b74ce8e91

/9j/4AAQSkZJRgABAQEAYABgAAD/4REARXhpZgAATU0AKgAAAAgABAE7AAIAAAASAAAISodpAAQA
AAABAAAIXJydAAEAAAAkAAAQ1OocAAcAAAgMAAAAPgAAAAAc6gAAAAgAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFRjaG91YW50ZSwgTWVy
bGluAAAFkAMAAgAAABQAABCqkAQAAgAAABQAABC+kpEAAgAAAAM4MAAAkpIAAgAAAAM4MAAA6hwA
BwAACAwAAAieAAAAABzqAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAMjAxNzowNTowNCAxNjozMjo1NwAyMDE3OjA1OjA0IDE2OjMy
OjU3AAAAVABjAGgAbwB1AGEAbgB0AGUALAAgAE0AZQByAGwAaQBuAAAA/+ELJGh0dHA6Ly9ucy5h
ZG9iZS5jb20veGFwLzEuMC8APD94cGFja2V0IGJlZ2luPSfvu78nIGlkPSdXNU0wTXBDZWhpSHpy
ZVN6TlRjemtjOWQnPz4NCjx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iPjxyZGY6
UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5z
IyI+PHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9InV1aWQ6ZmFmNWJkZDUtYmEzZC0xMWRhLWFk
MzEtZDMzZDc1MTgyZjFiIiB4bWxuczpkYz0iaHR0cDovL3B1cmwub3JnL2RjL2VsZW1lbnRzLzEu
MS8iLz48cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0idXVpZDpmYWY1YmRkNS1iYTNkLTExZGEt
YWQzMS1kMzNkNzUxODJmMWIiIHhtbG5zOnhtcD0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4w
LyI+PHhtcDpDcmVhdGVEYXRlPjIwMTctMDUtMDRUMTY6MzI6NTcuNzk2PC94bXA6Q3JlYXRlRGF0
ZT48L3JkZjpEZXNjcmlwdGlvbj48cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0idXVpZDpmYWY1
YmRkNS1iYTNkLTExZGEtYWQzMS1kMzNkNzUxODJmMWIiIHhtbG5zOmRjPSJodHRwOi8vcHVybC5v
cmcvZGMvZWxlbWVudHMvMS4xLyI+PGRjOmNyZWF0b3I+PHJkZjpTZXEgeG1sbnM6cmRmPSJodHRw
Oi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj48cmRmOmxpPlRjaG91YW50
ZSwgTWVybGluPC9yZGY6bGk+PC9yZGY6U2VxPg0KCQkJPC9kYzpjcmVhdG9yPjwvcmRmOkRlc2Ny
aXB0aW9uPjwvcmRmOlJERj48L3g6eG1wbWV0YT4NCiAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
IAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAog
ICAgICAgICAgICAgICAgICAgICAgICAgICAgPD94cGFja2V0IGVuZD0ndyc/Pv/bAEMAAgEBAgEB
AgICAgICAgIDBQMDAwMDBgQEAwUHBgcHBwYHBwgJCwkICAoIBwcKDQoKCwwMDAwHCQ4PDQwOCwwM
DP/bAEMBAgICAwMDBgMDBgwIBwgMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwM
DAwMDAwMDAwMDAwMDP/AABEIADoAxAMBIgACEQEDEQH/xAAfAAABBQEBAQEBAQAAAAAAAAAAAQID
BAUGBwgJCgv/xAC1EAACAQMDAgQDBQUEBAAAAX0BAgMABBEFEiExQQYTUWEHInEUMoGRoQgjQrHB
FVLR8CQzYnKCCQoWFxgZGiUmJygpKjQ1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2
d3h5eoOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna
4eLj5OXm5+jp6vHy8/T19vf4+fr/xAAfAQADAQEBAQEBAQEBAAAAAAAAAQIDBAUGBwgJCgv/xAC1
EQACAQIEBAMEBwUEBAABAncAAQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS8BVictEKFiQ0
4SXxFxgZGiYnKCkqNTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqCg4SFhoeI
iYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2dri4+Tl5ufo6ery
8/T19vf4+fr/2gAMAwEAAhEDEQA/APz++H3w+1j4r+NtM8N+HbFtS1zWZvs9laLKkbXEmCQoLsqg
nB6kDt1IBn+Jnwn8U/BnXRpvi7w3rnhm+bOyHU7J7Yygd0LABx7oSPevQ/8Agnt8MP8Ahdf7b3ww
8I/294g8L/8ACQa2lr/a+hXQtdS087HYSQSlWCONuMlTwSK/Yj4rf8Elv2gNF8M3em+GfjR4N+MX
h644fwt8VfCkckMygfxXlvukZvQmNdpwdw7fMZ1Xz+jiYVMspUqtG3vRlOUKl7vWD5ZQs1b3ZKOt
9Vc7sPHCSi1XlKMujSurea3+a+4/BYUZr62/bW/YDvvgXqKv4m8A658C9aupBHDHqF7/AGv4K1dz
nC2erpk2krYJEF2SAOssYAr5R13Q77wvrFxp+o2stne2rbJYZBhlPUexBBDBhkMrKQSCK9PLs0ji
lyyhKnUW8JpJr0abjJecZSXR63SxrYdwejUl3W3/AACvRQOlFeoc4UUUUAFFFFABRRRQAUUUUAFF
FFABRRRQAUUUUAFFFFABRRRQAUUUUAeh/sk/H/8A4ZU/aY8F/EgaT/bjeDL/APtFNP8AtH2cXbCN
1VDIFYqNzKSdrcA8ZxX6H+Af2gPit+3t4qj8RfGX9tn4Z/s/+EZm82Hwr4O8Z2drqccRx+7ZYJ8x
ZXOHup5pFYHMQG0D8retfrL8QPgH4JW3/wCCV+i/8IroJ0nxdp0Opa5aGzQxaxcT2ui3M0lwCP3p
eZmZg+QdxBypIoAxPjZ8QPHH7K095qfwk/ba+Fv7Q3gO7Upf+CPiJ4u0/UZdQtiebZkupjFcKVHz
GCW2kYnCo2Tn83/j1478N/EX4s654g8L+EbH4e+H9Ukjng8P2t21xa6W/kxiZYnYA+U0wkdFwAiu
FAwor9WPCPwn8Maj+0V/wU41a48P6Ncah4X8KXUOjzyWiM2lpNpt+ZRDxiPcYY8lQD8oGcdfzL/Y
bv20z9tf4LzLK0Kjx1oKSMG2gxtqNurq3qjKWDA8FSQcjIIB5c1xGkasZEVW6Eng0/NfQ3wS13UN
G/bg+I1x9svLe4/svx39ok81lkymkaow3NnPyuqMM/dZFI5CkaHxI/Zr8MeNfDGj6h8NrGaLxj4N
8K6Fq3i/wnM5uDrFtLplpdTazYBvmeNTK32q25aIfvk/dFxGAfNOaM19I/E74d+GvD/wz/aK1bTf
D2ix3ngz4qaVo2gs0TOlhYzPrhe3ClsMrCxtgS2WwrYI3sTd+M/wn8IeB/Fup/FLS/D+nr8MfFXg
u11vwro8hklt01S/WSxNhuLby1leW+pSncxJXT0DEiXBAPmHNGa+jPi54N8MeFvhH8H57LT/AIe2
994m8JaZqWp2lxbXp1m8uG1e7ge5ifZ9m2PFAiPGZAdu9hGCd9dZ+2n8GfA/wdvtbm1LwTZabpun
/GLUNC0y58Laolwtz4ftMm5sLl1nlihvUDQeSJNlxhpmkBVVIAPkfNGa+xtF+AWg337TvhlRo/gL
xZ8J/FWj+LdS8L6zo1pJax6hFa6RdXUNrdxFxLDeWUsUBdJcy5lO6SaNlJ8y+CWo6Frf7KXxO8QX
3gXwTeav4Fh8ORabcS2czM5ubuSG4kmHnYkaRUGeAFP3Qo4oA8GzRmvoH4TeEPAvx7+E+rapfaTp
vhfVfhTdy+JvEEWnecn/AAk3h6aaJPs0W9nCXMF08FuhON0V8HYsYGLcv4I/Z91L9oSRvEluug+E
bPxNqmp2uj6fbQytbK9lZHULsKCzNFZ20DQh5pGdh5qnD7ZWUA8mzikDgrnIx617p4q+C2h6L+01
8P8A4T6PbR3F/JqWhWWs6tPHLHfSaheeQ11bsgmeJYoGn8rCpu3W7tuO4k+k/Gz4X+Ebz9pWy+Ol
jo9q3wY8RRTeN7nSlO2C2v7e9W2utBO3bjfqLRBVXkWl4kgGFYqAfIatuGRyPajNfVXib4CaFF/w
VE+L1n4g0U6t4D+H/izWtb1XS4LpLH7fZLqDLbWaSsVWMTPPbxZBBCFyOQKp6B+ypH8KPiR+0h4R
v9N8N+ItT+HOgw6h4bvdbvIbSxmSTWtKit73zpZoYPLnsL4uN8gU+chHzBcAHzDnNGa+rtZ+APgr
4hftQ/Ej4J6X4dt/A/ieaaGTwzeahJctDpWrWlmkmo6ZI8jO76dOwuzbzNvkBitG3sksjVw+hWfg
n4j/AAo+OmraN4Xsbex8G+HNEHhy6mVxebv7WsrKW+lG8j7Rcxyyu6cpG0m1AAikgHhNGa+hf2BP
2Y9D/aA1rWl8URoNP1TZ4Q0O4e9jto7HXL+Ob7Leyb2HmQWxhJkRcnNxDkYODU/Z2+DHgXxR8JvH
mk/EiS68CeLE8U6V4b0fxHeMws/DOotBqryW2pxAE/ZJXtRFLKv7y3ZEkw6LKjAHguaM19ZeCf2b
bf4a2E+h+PfAen2vi7w74V8fXmoW98jEtd6dp8N1p85aOTZKilxIjoTHNHIpO9WU15rJ4c8MfF/9
kPxV4yt/Dmn+EvF3w61vSbG4n0ua4Wy8R2epC7VVe3mkkEV3BJaFg0DIjxNJuj3IJCAeL0Ui8KP6
UUALmv2T+IR/4qD/AIJG/wDYAsv/AE26HX42RKryKHYqueTjOPwyM192eA/+CmGneOviH+xTD400
ePwv4f8A2bLhNJv/ABBbTyX1tqFksVjBFO0Sx+ZFKqWmZEG8ktuGBlVlySdmdVLB16tOVWnFtR3t
rbzaWqXm1Y+tvAv/ACWr/gqt/wBizJ/6bdTr8Xba4ks2jmikkhlhKukkbFZI2BBDKRghgQCCCCCB
yOo/Yb9n/wCJfh/4ueNv+Cn3iLwzrGn63oniDwhJe6deWsoeO8g/s3Ux5iHqVBIBOOCQOtfjq3/H
v/wH+lUcp9e/tQaFqkXhX4ha9D420XUfFL6D4a1jxXfP4LttC1DxFaa/bQXaolxFczq1wHkj+0LH
HA1wFmdmlHmLXjmoan8Sk0Dw58d7NZNDtvD+rWnhTSdd0vFrJa3un2MP2dQFOcrbKi7zxJscNuO8
n2/4zftGeG9T07xHpt94y0fxr4J1j4W6BoWl+Hla4lk03xNZaTYWUd1D5kSpaNb3EdyzTrIFlgkk
QGQS7Ri6R8a/AFx4d174KX1/odv4NufBMGn2Hi+N7x4Rr1n5uqw3DRYOIZNQub6z3iESLDdgnCg0
AefeLNV8eP4Dhtdc1nwnDof7Q2pf8Jpc3l0FiBntru9tvtErhB9nEc73y+WgIYM2FYGOovih4J8Z
eGP2cvCWi61478J3HgiKC98Y+GdKiv5d13HPcixuZoFeBCT5tlIPLdg/7uZ0U7yWu/F1vD/j/wDZ
w+DNra+NPC0OpeB/Ceq2esafLJcfaYbh9a1K9hhTbEUkaSK4hAKuVVmbeVCk1h/tLeLdH8YfBj4H
WOk6rZ6hf+GvBNxo+rQR7lawun1vVLxY3LAA/ubuE7lJUEsCQVIAB23i7w98V9Y+JGn/AAqm0PwX
4g8T+AvCscth9j0+Ga5g0q1gbWhHHPtDSMY2dyOZG814wfm21h+Afjt8V/Gd78WviDpMOk6pps8t
p4s8cR3Wk21zpL3L6hGtrdG2kRo1n+1XB2eWFbY9wv8AqzIp9H8d/tK6T4I/a8+I3xI8E+MtN/tL
T/B2ip4Wv4xKgutRt10aOWNVZAeEtbwMrgK6gjLB1DLqfx4+FK3XxS8K+CdQbw34J+JXgvUdVkhv
4ZIo7PXbmWyvbfSQQG3RWTWz20UzAITNM2QrbiAcX4J8aePvCGpeC7+PUvhr8PUubLUJfDWj6nGt
rbPDqsJs7m8ZNkiw/aYV8tZ7x418pEaMrGqsMnwZ8KfiL8PvA3xi8F6h/wAI14L0/SbzS9P8aWvi
JDHPZzLcv9i2OqSFVE2474zsIYMzGMq1Wf2jr7wv+1HqPhnxhpfjDw34bvJPDGkaB4h0XWUuoZNH
udPsobEzweXDItzayxwRyqsJaVGZ0aIYVn7/AMYfta+C/iH/AMLw1q40/SdatdTs/B2k+H9D8TSX
lvN4kttH8u3eeVrOZGjmeG3EjL52AZio8zbkgHm/wz+E/wASPhn4z+MXgFU8O6FqWmeGrqDxlDq8
izRx6Zb3FtPK0UsayK2JFtpFaIkuoUqWUsDwuj+PtU+EOo32gx6tF4i8PsWaewtdVuhpGoNJGnzM
sbRlx8sW9GADmFUkU7AB9BeFvib4Ktfj/wDFrxrp/wAQtHnsfib4A1hNOTxTZGe60zVLt7crpd5C
1s8EvllHVZkRrd4kjJ8skxL8zfE2X7R481CX7X4dvnmZJJJdBs1tNN3sillhiWONFCnghEVMg7Ri
gC/4b+OHiTwx8c7f4kRXkNz4uttZPiBbu6gSZWvjKZvOaNhsb94dwBBGQBggYqnc/FXxFdfCibwK
dUuE8Hz60fELaQhxbC/8kweeAckN5RKdcYx3ANc/RQB6F8V/2oPFnxqm8UT6+2jy3njW9s9Q1y7t
tOjtptRmtUZISxQAKuHYsqhQ7YdgzKrCbUf2rfGOr+ErjR7ubSbm3vPCtr4JuJ5NPT7TcaTazxXF
tA8gwWaKSCHbIcuFhjQkou0+b0UAeleHv2tfG3hzxl4N8RLdaXeeIPAdkNN0jUrzTYZrpLVYnhig
mcr/AKQkUbskZm3tGgRVYKiAYnwy+NusfCXw74n0fSrXQptL8YW0Fnqlrf6cl3HPDDcJcRIpf5kC
zRxvlSGzGuSRweQooA6fx58W9U+IXh7T9JubfRtP03Sr661K1g0ywSzWKe4WBJG+THRLaBVHRVjA
GCWLbPxU/aa8UfGc+KG17+xZJvGmtweI9ZnttOjtpLy/hiniWfKYCkrdXBcKAHaZmILYI8/ooA9N
8M/tg/EDw3p+i2cmrW+tWXh3w5f+EdOt9YtI76O10m+BW5sxvGfLZCyLk5jViqFBgDl/FnxY1bxX
4XttBEemaR4ftLo36aZpdmlrbvdFPL+0SkZkmlCFlVpncxq7qmxXcNzVFAABgUUUUAIRxVjS9Yut
FuGltZmhdhtYAArIPRlPDD2IqCmn7tTKKkuWWx0YXFVsNVVfDzcJx1TTaa+a1Ogt9a0HV5EOraKk
NwhyLmxJQgngnYTgfh+VZOtRWkWqzLYySSWeR5TSDDEYHXgd81VP3qUjkVlTw8YS5ot+l9D3c24o
xGZYaNDFUqXPF39pGnGNR6NWlKNlJa31Td0tQXpS0UVufNBijFFFABRRRQAYoxRRQAYooooAKKKK
ACiiigAooooAKKKKACiiigAooooA/9k=
--00000000000091e2000596c5871c--