Monday, November 30, 2009
Jis ke dil main nahi hai tera dard o gham
Must to listen here
Courtesy: http://www.khanqah.org
Thursday, October 29, 2009
Reply to: UIT Alumni Dinner 2008 has been postponed
My brother Qasim Yeh Kahani hay badi purani keh jab eik raja tha aur eik rani. :D
It was the same point that I made when we were invited for the first time for Alumni. Institute requires Alumni not the other way around.
I am really happy though to hear some stories of UIT for a change though.
Friday, October 24, 2008
UIT Alumni Dinner 2008 has been postponed
[I wrote this post on Wednesday, 22nd October but could not post due to blessing of KESC]
Today, I received email from Mr. Waseem stating that UIT Alumni Dinner 2008 has been postponed till further notice. Well, if someone asks my feeling then there is nothing except sadness.
Timeline:
- I got a call from Mr. Waseem and he informed me about UIT Alumni Gathering. I was so pleased and ensure my cooperation. We discussed about Sponsorship but I stated my point of view clearly that it is not possible for an inactive forum (I remember how I was able to get 0.45 million sponsorship from industry for our event UTECH).
- We got invitation of Alumni Dinner via email. I talked with my seniors, fellows and juniors; everyone was excited.
- Soon, sadly, we got another email with stating that Rs.1,000/- as Alumni Annual charges and somehow a constraint in order to attend this dinner. i.e. Rs.1,000/- for dinner.
- Due to this, people become furious and they reacted oppositely
- A chain of email including views, suggestions and proposals.
- Finally, we got another email for postponed event.
Causes:
- Everyone was excited for gathering, not for dinner. I think the people at UIT didn't earn this point.
- Rs.1,000/- for a year, i.e. around Rs.84/- per month. Obviously, it is not a big deal for any alumnus but everyone considered it as charges for dinner for which they invited (do you ask money from your guest?)
- People floated different suggestion and proposals. Basically, everyone felt wrong execution plan for Annual fee; such announcement after or in dinner could change the entire scene.
- People also showed their concerns that there is no proper plans or management exists for Alumni, therefore we first gather to do so and then ask people for annual charges.
- People also felt that UIT needs this money in order to arrange this Alumni Dinner, like Farewell dinner and this is shameful.
What should to do now?
- UIT Management must realize this fact that an active alumnus is always beneficial for institution not for alumna.
- Periodic get-togethers (I am not asking for dinner!) should be organized. At least three such gathering should be schedule and announce. This is the only way to activate this forum.
- We sit together and agreed on future plans for Alumni (at least for next 6 months). At this stage we can propose the ideas for raising funds.
Thursday, October 09, 2008
Wednesday, October 08, 2008
Concatenation of multiple row string values to one column in DB2
Today I will show you a simple way to link values from multiple rows to a single column on a DB2 SQL DBMS. In my sample table I listed the Formula 1 Championship world champions of the last 10 years. The table contains one entry for each year.
For this example the year value is defined as VARCAHR as well. The schema is VMBASE.
(tSource)
cYear | cChampion |
1997 | Jacques Villeneuve |
1998 | Mika Häkkinen |
1999 | Mika Häkkinen |
2000 | Michael Schumacher |
2001 | Michael Schumacher |
2002 | Michael Schumacher |
2003 | Michael Schumacher |
2004 | Michael Schumacher |
2005 | Fernando Alonso |
2006 | Fernando Alonso |
What I want is to generate the following view:
(tDestination)
cDriver | cWonChamps |
Fernando Alonso | 2005, 2006 |
Jacques Villeneuve | 1997 |
Michael Schumacher | 2000, 2001, 2002, 2003, 2004 |
Mika Häkkinen | 1998, 1999 |
To realise this I created the following function:
CREATE FUNCTION GET_WONYEARS(s_driver VARCHAR(254)) LANGUAGE SQL RETURNS VARCHAR(254) BEGIN ATOMIC DECLARE s_years VARCHAR(254); SET s_years = ''; for1: FOR tmp_row AS ( SELECT tSource.cYear AS cYear FROM tSource WHERE tSource.cChampion = s_driver ORDER BY tSource.cYear ) DO IF s_years = '' THEN SET s_years = tmp_row.cYear; ELSE SET s_years = s_years || ', ' || tmp_row.cYear; END IF; END FOR for1; RETURN s_years; END; |
The call looks like the following:
SELECT DISTINCT
tSource.cChampion AS cDriver,
vmbase.GET_WONYEARS(tSource.cChampion) AS cWonChamps
FROM
tSource
ORDER BY
Courtesy
Friday, September 19, 2008
Alumni Dinner!
Respected Students and Friends,
Assalam O Alaikum
Date of Alumni & Graduated Dinner 2008 has been changed, and now new date of Alumni dinner is October 24, 2008. So it is a very humble request to all of you that please confirm your presence in the event before October 10, 2008 because a lot of arrangement is required for this event in the campus.
The program is as follows;
Event: Dinner
Day: Friday 24th October 2008.
Time : 07:00 P.M.
Venue: Usman Institute of Technology (UIT).
You can register yourself through email at: mwaseem@uit.edu or cell no: 0300 2416835
Regards:
Muhammad Wasim
Convener Office of Alumni Relations
Contact No. 4978274-75; 4976560; 4982476; Ext: 3054; Fax: 4976181
Email: mwaseem@uit.edu
Cell No: 0300 2416835
Thursday, September 04, 2008
Teamwork!
Usually, we consider teamwork as just formal duty to cooperate with colleagues! as I said... its duty not teamwork! :) Personally, I don't have any such bad memories regarding teamwork.. but some very nice memories... especially the time when I was chairman of UITCS and we organized UTECH 2006... I can proudly say that UTECH 2006 team did what this pic said...
Thumbs Up!