SQL DB2: Concatenate TEXT from multiple records

2017/06/30
By
Concatenation Road in Winter

    Scenario   Here is a recipe on how to concatenate a field from multiple records into one field. There are two pre-conditions for this method to work: First. Your source file needs to have an equivalent of a line number field.  This should be a numeric field indicating the sequence in which to concatenate the records.  This field doesn’t not need to be  consecutive. Second. The difference between lowest and highest line numbers should be a reasonably low number.  In this example the max difference is 11, and it means that at the very maximum we would need to concatenate 11 text fields together.   Step One Generate a driver file with MIN…

Read more »


08-30 SA – Up Rainbow to Carter Dome – down Black Angel to Wild River loop

2017/06/29
By
08-30 09;45 Bears like to visit raspberry bushes

  Always in progress . . .   Next morning started around 7 (I opened my eyes at 07:22).  Around 8:40 AM, I started my hike.  For that day, I planned to complete a circle – climb 4,832 Carter Dome mountain, descend on a Black Angel trail, and complete the circle using Wild River trail.  The last portion of the circle was familiar to me from my May 2014 trip through East Branch trail.  The circle runs about 13 miles, and I was planning to spend the whole day completing it. My breakfast was a mixture of boiling water, Grape Nuts (interesting these is a type of a hot cereal, and…

Read more »

Preparations for July 2017 trip to Appalachian Trail (AT)

2017/06/29
By
Google Maps shows elevation profile for bike rides

Plan On TUE, June 20 I ordered the AT topo map from Carlo Mountain to Pleasure Pond in Maine.  This is a less traveled portion of Appalachian Trail (AT).  From that point, the balance tipped toward going to AT instead of Bog Dam Road (BDR) for my July mini-vacation.  Map expected to arrive June 26-30.  This is very close to my departure date on FRI, June 30. Preparations to my July 2017 trip to rarely visited section of AT between Gorham, NH and Grafton Notch State Park in Maine (route 26).  This is a 31 miles section that is perfect for 3-4 nights trip.  I will return on the bike back…

Read more »

08 Austria and Italy – August 20-21, 2008 – Crossing the Alps

2017/06/28
By
Lunch Break at Downtown Molveno I

Wednesday, August 20 – From Cortina d’Ampezzo to Barbian Next morning on Wednesday, August 20 we were in no hurry to leave. We soaked in the hot tub and took it slow. With great difficulties we found an obscure road toward our new destination – Bolzano.  Apparently local people very rarely venture out that far outside the city limits.  Lira suggested to look for signs not a distant large city, but a sign to local nearby villages in desired direction.  And that trick worked. We started climbing up to the mountains, and this time I handled small ASTRA engine much better.  The whole trick was to switch to manual shift on steep…

Read more »

Block PC Outbound Connections on Router Level (All but RDP)

2017/06/27
By
Router-Open-Ports-for-RDP-3389

This article applies to a scenario, when you already can establish RDP to a machine on your internal network from a remote network.  Now you’ve decided to tighten security screws and close all external access to and from that machine except for RDP on the router level. Inbound connections to a server you can block easily using firewall on the machine itself.  This article deals with a situation, when you need to block access for any process or application running on your server to the external resources.  Other machines on your network still would be able to make external connections through the router. Note: It is good a practice to change…

Read more »

Properly Validate TextArea Length (IE vs. Firefox)

2017/06/26
By
Properly Validate TextArea Length (IE vs. Firefox)

Let’s consider this example, where HTML page has a TEXTAREA and an INBOX.  When user types inside TextArea, Inbox should show the length of TextArea string. <script type="text/javascript"> function TTLength(objTT){ var tt= document.getElementById('TXT1'); tt.value = objTT.value.length; } </script> <textarea onKeyDown="TTLength(this);" onKeyUp="TTLength(this);" rows="10"> This Text Area Contains a string With Newline Characters </textarea>  <input type="text" id="TXT1" value="TT Length"/> Let’s see how this page behaves in IE8 and in Firefox 3.6.11. IE8 Firefox As you can see that IE and FF return two different values for the length of an identical  string in TextArea and that could be a serious problem, if you are trying to validate the string length before updating the…

Read more »

08-29 FR – Off to a wild New Hampshire

2017/06/25
By
08-29 10;46 - First bike load

  Life is always in progress until it is not   This time it was a special trip.  I used all the accumulated information and wisdoms of previous trips on this trip. I woke up really early on Friday morning August 29 2014 (04:39 AM), checked the weather one last time (they promised the coldest night at 51°F – that is very warm for late August. ), asked Google if it is OK to boil water  in an empty can, and at 5:30 I hit the road.  I decided to take a new route this time – not 3 and 93 as usual, but 95 and 16. Police action was in a full swing,…

Read more »

07 August 19, 2008 – Crossing Into Italy – Cortina d’Ampezzo

2017/06/24
By
07 August 19, 2008 – Crossing Into Italy – Cortina d’Ampezzo

Tuesday August 19 – From Pfarrwerfen to Cortina d’Ampezzo   Next day (Tuesday August 19) we would need to play catch up and reach Austria and Italy border.  One large city on the way to Italy was Lienz.  We arrived there around 1PM, had lunch, visited supermarket and away on our way to Italian border. We hardly noticed the border: just a blue sign with ever increasing number of stars – Italia. First point in Italy was town of Toblach.  Without any stops we turned here south to Cortina d’Ampezzo. We knew it is a very expensive resort and the host of 1956 winter Olympics, but we had to go there…

Read more »

Откуда Берутся Идеи?

2017/06/23
By
Origin of an Idea

Пустой лист бумаги.  Перед вами просто ровное поле обязанностей и дел.  И вдруг, откуда ни возьмись – гора-гигант – ИДЕЯ. Естественное расписание спать и есть еще перемежается с работой, детьми и подарками – получить, подарить.  Человек устраивается в этой решетке.  Все удобно и продумано.  Но идеи не вписываются в эти квадратики.  Правда ли, что идеи нарушают, заставляют, меняют?  – Отнють нет. Начало идеи – это тишина наблюдения.  Голова, которая формулирует идеи, обычно не создана для их осуществления.  Поэтому очень часто для успеха надо иметь команду из 3-х человек: человек-идея, человек-план и человек-действие. Человек-идея не боится, не заботится и часто просто не знает о тех трудностях, которые надо преодолеть, чтобы начать идею осуществлять.  Это…

Read more »

Adding Selectable Styles to the WordPress Editor

2017/06/22
By
TinyMCE Advanced - Styles are Listed

How to add Code style and more into Style drop down box inside WordPress editor? If you don’t mind one more plug-in – download and install TinyMCE Advanced Plug-in. According to my tests, this plug-in works on WordPress 3.0.1.  This plug-in allows you to customize your buttons in your WordPress editor and add a number of new features: – Complete control of  your buttons in WordPress editor; – GUI for tables operations; – Insert an image from outside through a  URL; – Fixes IE spell check problem for 64-bit browser; – GUI dialog box to edit CSS element style; – Font drop-down box; – Font size drop-down box; – Font color and…

Read more »

How to Reset Win XP Admin Password

2017/06/21
By

There are two ways to reset forgotten Administrator password. Method one – Reset During Repair Reinstall: Use Win XP installation disk Run Recovery (not Recovery Console) Press Shift+F10 during GIU portion of repair / install Run LUSRMGR.MSC to reset any user password to whatever you want During my tests, this method always ended up in freeze  during a late install stage on “Deleting Temp Files” Method Two – Use LUNIX bootable CD: Download free boot CD software from http://pogostick.net/~pnh/ntpasswd/ It might be called Offline Registry Editor, but this utility main purpose is to reset Administrator passwords to blank. Burn a bootable disk (only 4MB) Boot from this CD. Blank Administrator password…

Read more »