September e-Bulletin: Application Development - A Closer Look

Lori Ann Galluzzo

September e-Bulletin: Application Development - A Closer Look


[http://img.constantcontact.com/letters/images/1101116784221/IHeartDB2_IDUGB_Header1.png]<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtImwEObkDIbxRB3voJxUJivEzlJHy52ydhGUEDks1QBd8M7Lqsu95EdfH7G8SHhUQc411USX8F4z9KzwGMPmx8ObEODTxUTBJ-7M56W89QX7D_Ykft7NKWT_GluRl_Vkv9UnAMaOFEClYWBSdpPJDewOHVv275owNI1EithjV4_fImjN3dzknOAqNGUTOEmbl0OA9TWjBCacWxtDoNI-tz0DpWl9l_jpH4A=>








[https://imgssl.constantcontact.com/letters/images/1101116784221/IHeartDB2_IDUGB_CornerTL.png]



[https://imgssl.constantcontact.com/letters/images/1101116784221/IHeartDB2_IDUGB_CornerTR.png]


A Letter From the IDUG President

[Joe Borges]Joe Borges, IDUG President

Dear IDUG Membership,


It is hard to believe another month has gone by! With September already here, this means that we are gearing up for two of our main annual events. This is where IDUG excels. There are no better DB2 education and networking opportunities than at IDUG events. IDUG DB2 Tech Conferences are definitely the best bang for your dollar! IDUG events offer the best DB2 technical training in a variety of formats - from full-day classes/workshops to technical deep dives to short presentations on special technical topics and/or new product features - and you not only get DB2 education, but education on many other technologies that are relevant to DB2 ... and you!

Click here to read more<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIm2aZvdBTPr2kADyDY_MoL7v-eJPCurTSx1Vnu1kGkHnUDX32ZvtUJMdwC1h6SMH01lKjezbF01nRGW4LlgZxYjcHJZCgSnrEnwY-M9NTyv4F-jg2v2qIGkochzNPIfn3VuZQsXaOl8cjjTjb_R3KiERtrsKGtYAuixArYLpuNM1FY-iByS3Psm6Q8Rsky__XoVC5PlmhvOJ5lgQoCSpL_g1nXOZhbOdcS4RtRDZ9dZ5w1tDzSFjmF9dMPms8XNuNhXrnshAKF2qA==>.

[https://imgssl.constantcontact.com/letters/images/1101116784221/IHeartDB2_IDUGB_CornerBL.png]



[https://imgssl.constantcontact.com/letters/images/1101116784221/IHeartDB2_IDUGB_CornerBR.png]







Can You Replace an Entire Application Program with a Single OLAP Query?






By Daniel L Luksetich, DanL Database Consulting


You bet you can! If you are using any currently supported version of DB2 for LUW, or are using DB2 10 for z/OS (or DB2 9 for partial support), then you can take advantage of some extremely powerful SQL constructs called OLAP expressions. These expressions, sometimes also referred to as window functions, are typically utilized for report queries and can generate some extremely powerful reports. Let's take a look at some of these expressions to get an example of what they can do.



Read the full article here.<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIlFKDESFodUmrNObQNfIOyhBlOveVcjs7UH2HwrGWxbs0pP6BvEcCjCt6e1rxi56UruF7qnJ8xqsD5rvgcLtgIyTw9s4afQnQVl9S-B-UUsRFVc6mOgF06Vn7BCrXVo5HDPOMrZ1pEvAoO_BLBxrQef0Px3fMTg4lwGZe5_0DM3IGgKXuWdHroJDkvrpWN9T0jspz4NYKZx13U1O7rAOajtqJP0Pmu-qf3hZIEJX1nmNG-1iH1jGDBlrm76LFL2v0pfXCfkI_jHSw==>




IDUG DB2 Tech Conferences




Advance your career and stay up to date with all of the latest developments in DB2 by attending IDUG DB2 Tech Conferences!

Sydney, Australia, 12-14 September, 2012<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtInOIG5Rw5y4zZdLgkam-sB_2jCE20YJm48OcFuCintKgzNwj8EcwjkdoOKoFwjC1d3tgxQoDKnqV8IdtfN1XpBblvKBf083fA9uinLVaqPArcVzoR5XNBQ6vPmrpIGX02bEAhnfMw4KbHMcnsJP7gF6MWQEdbn7v2ZNh_nEAKFskfkhY2TUM_lAez7X_gHS0zxp-gVcItaHKV58HE3Op3cmMlmZRNrZVUzjw3kcD_P-dSn6svl2AEkdYGBE5CmuT4k=>: Offering 40 hours of technical presentations in addition to full day and half day Education Seminars from some of the leading speakers in the DB2 community, this is a can't-miss event! Check out the online agenda<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtInWtDe7T5nAYvshLY5EuVCldCQy8KWV8Et4EetH_KGHd33edE3KwAgdI5A9sfxmv_07ON-0H8XcFVgzk-BJUSfu_pqZxDd3sGrfe7jh936MKsop_5vMg8vgke0b2wkVVIhHgCskquDVUcxpqWZThUwc6hw9NnEx9ARHn0kc9Lz7W818VefntxBP2Jx_vfIZYVMT9XAgZC_2cqF55WCv4mTUAHBaPgLvbMVh2ADUGFfTEXG41hv7IqsG5ir-wIzhOx2h53Ny9evJ8Wr6B22o83hxoVBSzWOX0RE=>, featuring the latest in DB2 and register today<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtInDFpw7V5TzjUF_CEihM45bvgsFIqGFIjLWTAcpR_vCuWM6HWIjTkDXe2Z0sKfGYO7SqWXud-n59WF-Ddy2eFzitV1n5j65hlwwu6YnbN0PsnU4pciha-CbbS6cCH3vCaksrTJd3KMh5fbitt9RvvB82HQ4xcRlNRocHKL8ZjGWAw0KewM_K6qVtGVolWNuHBBOktVXLmHVJdZe_73NdszzYQV6hvPyzkQ3mdPuPphrjwYFXe7mnz5EZ30X5xHlsRcvdlIyPYvLo23U3yqmsnFxCiblnV-meMA=>!

Berlin, Germany, 4-9 November 2012<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIl49GvoP0x50O1_ub0MXGRSS_20CyG3pSwrTjuJ88THZB0YEDH1x2Ko8m_whZ02beZODxzySmk0ip1Wa7-QuDNB_WM9sgVoksR_y7ncpKMvBCKs4yDt1IEn7Js0ylaaoAPbJL0OIx2y4jpSWELbEzUjpI10kQV-aw3Bv3biay2gsdVLn7MV4TFzUTCsbOBQd6vYM94kG-4MwRPAqoKZsjM7hRdcNg8MiB7gc7hXLw7BXude3Dez752QarBADKXL1rs=>: Register<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtImUKac_CPqrv5P5FJx4Vl7reVu0q2hiWivwRKlj4cVIIW7Wz7vviZTAJvp7jNVRbXyyCEuqwemI_fuHwxPsPUyqaVZg493U9DTyRYmMBTVmx2Neo_zccuOS32GND-VNt5Jl9Ta5NJsCk6yBXfmF_IEuKE2SIk3V6y_4RHuWq2foNu4GsDi1RgqWz9klbvCV2CvMwiOVMX4yeNMHPNa3VqusGcQDOkW1xY5H5ouN-lW3ku1ZwOTTl7y40sRjctiU4KU=> to attend the IDUG DB2 Tech Conference in Berlin, Germany. Take advantage of FREE IBM Pre-Certification courses<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIlkHjnnu114_ZU7d8i3VuTEGonrQJWeUCX1YiMi-Us_VAdq6vceCOK2HtZzvwNmQA7DePze2PYJOR1ms6j8F2ORg-JDMkpFW6PAX9SeKCcYAH23mmVDqCA0dDqnKvJilkwqMVlcSvdZt5eUUpp0lmZGIXzVzSkxtxqTRh0NXwTKBw_EwOehmlfHY1hKoJZIvQBrDcuFR3exHMyuG9JecFTGCWbBxj8IRcXL8pJ3zVoLpLMMGM04OcIOpSHayJAEq-4=> and exams<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIlkHjnnu114_ZU7d8i3VuTEGonrQJWeUCX1YiMi-Us_VAdq6vceCOK2HtZzvwNmQA7DePze2PYJOR1ms6j8F2ORg-JDMkpFW6PAX9SeKCcYAH23mmVDqCA0dDqnKvJilkwqMVlcSvdZt5eUUpp0lmZGIXzVzSkxtxqTRh0NXwTKBw_EwOehmlfHY1hKoJZIvQBrDcuFR3exHMyuG9JecFTGCWbBxj8IRcXL8pJ3zVoLpLMMGM04OcIOpSHayJAEq-4=> and a range of complimentary Workshops from IBM on Sunday<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIm7LFNZ1mlayhRtg20QZSiQcJn6lrtsAcZODq7XcBaDlQs_tw9Y8cGiEfCbVU72RsMxL5oKVMXxWcrPz9sYB3PYT7gORFe84rKz-9JHCqBOVLowVZ51AVXoBdJnXytkVZPpvKfv6bhxrsm39J_cja2ZPVHQ2cZj-Ru5Nyjxmnpl6V6jvueG0HS2LjZBMRcOk3u7qZ-X1_9sWTWJkgj9_rH-gRKlMVD2_IraSE0nCUeTyTLy5q-JLM3t> including DB2 10 for z/OS Pre-Certification Workshop, DB2 10 for LUW Pre-Certification Workshop, DB2 10 for z/OS New Functions and Migration Planning Workshop and Data Warehousing with DB2 for z/OS: IBM DB2 Analytics Accelerator Deep Dive Workshop. Learn more<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIl49GvoP0x50O1_ub0MXGRSS_20CyG3pSwrTjuJ88THZB0YEDH1x2Ko8m_whZ02beZODxzySmk0ip1Wa7-QuDNB_WM9sgVoksR_y7ncpKMvBCKs4yDt1IEn7Js0ylaaoAPbJL0OIx2y4jpSWELbEzUjpI10kQV-aw3Bv3biay2gsdVLn7MV4TFzUTCsbOBQd6vYM94kG-4MwRPAqoKZsjM7hRdcNg8MiB7gc7hXLw7BXude3Dez752QarBADKXL1rs=> and register today<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtInSxUmYn30XHWsgoFSaCCtB2eL3A437-W6DrZEqxQZ2WQANDwrabUs8hcpi9DDmLhGiyAl0eJVvOejlYne36yF6qvmjykumR2qzTmFBi60UZmw33rTO0Vb7Xpq0-RBGplITOd72l-dZUXaiyNq5NM21MyuIxO77FO2m7IRkRHN1UEI4-NMG0Fg1kLNkWbXGX-UxVe1x1BibgTBc1KRSLYvLklxyBmTVU9vhnsr8oi8H__AEnLOb0uhoRV0A-Rh3jVk=>.


Orlando, Florida, April 28 - May 3, 2013<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIkrLAnugf-AmLH-x3IQcUsjDOBAhYMq2XvRO07LNa7BUPgeZmWj2EAlr6B6NFWPRsE55fyoRk6SoUJl_oWhP4hFaSJhFkIANj5N8fPLFovrF5yr_LbPGy1GbTvYcFadDJ_Ooe-GRvd643ALPHs6EdOH8jim7zfHgMG6-0nfsmdZE0jcSst2-rN6xokVVPegDY-xPOrrx6uGwLqjhS2xY2313lTd9f1o46rHEvtQkT8w6nVmYglvAvW3b4zvjxWBIBo=>: Share your DB2 expertise and submit a presentation abstract<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIlWk6J5VCnFhyJWG5NR4EO3BI1aiQym5PxjrWjtAKxDYhv4bcBFNB-CVrZeHB0wnwtUflQkDcv_Ee-sel6u6mg5t6yMYFpW8jwfF1dQDrExMBI7nQu9MV7JDIvKzvDkdnL2Eb0h79nTUK0aViYSf3PSwgBb713txanbjdviiH2OA_0KLKMHmx-m4YrncRnje7uNSZOPf3euVhWCdGrCEsbOmJRBxIn-U9FnA1025dkjuxXuJ6LvXykGdCcQ0aqKA6w=> to be a speaker! Find out more<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIlWk6J5VCnFhyJWG5NR4EO3BI1aiQym5PxjrWjtAKxDYhv4bcBFNB-CVrZeHB0wnwtUflQkDcv_Ee-sel6u6mg5t6yMYFpW8jwfF1dQDrExMBI7nQu9MV7JDIvKzvDkdnL2Eb0h79nTUK0aViYSf3PSwgBb713txanbjdviiH2OA_0KLKMHmx-m4YrncRnje7uNSZOPf3euVhWCdGrCEsbOmJRBxIn-U9FnA1025dkjuxXuJ6LvXykGdCcQ0aqKA6w=> and submit your presentation <http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtImBtEC2WvsP1lLvjHrHQ-EtSHlOUxCem98GFLwvPOgiVCSzz9cXBwVWjgPxqVcWl5DJSKAsqVhufVUer50PkIT3ziLLOOS_7nICf4Bdl-6gfjTvJM_nlvVSEmvj9FdLQq9uj4e40CrosQW1k4UIflgMzJaxhAeRS3NhkbVjmg7WknfmwhDtZopsU7PPJPbE_PRAP7ixme28l497vKPhMXp_IGin_VpJm2R0qVqZvtxPs87XWMjq5xnw8Xasdhc68CbamZ4KwxdsdUFyXGvPJsTjPyFe6reuRXk=> by September 21.


DB2 Tech Talk Series





Check out the upcoming webinar available on the IDUG DB2 Tech Channel.


Making the Realtime Operational Data Warehouse a Reality

September 11, 12:30 - 2:00 p.m. EST

In this deep dive Tech Talk, we are covering major new product features in DB2 10 for Linux, UNIX and Windows and the DB2 warehousing product, InfoSphere Warehouse 10. There are performance enhancements that will be covered as well as Continuous Data Ingest. This new multi-threaded ingest capability streams data from files in various data formats or pipes into DB2 tables to quickly populate large databases without locking the target table to minimize impact on concurrent database activity.


Register today<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtInUQz9NJJ0LNDv_to2QT4pDYcW6i5NPkbEL-yhpdACEuSEyadcAjDg7WoYXLOSyf1vAajsnHWoew_S_JGrxHG2T3OeJMv6brYqjahi2JmxcnB3Jx5N-y61oKRmr_qwSdDofhyWKe_2K9D9S0gWw7os7xTAxI4At3FzhqUieHxVZeNRu5mbTLO_wBQZvSLMtDbQEFxzE-hUrugPyl1U4CIKkKhHlnD9sKBEYwR8bs94EjA==>.


September 4, 2012
Issue 9


[FaceBook]<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtImWDGi1-0IBVYtxDjCJVcVaOlWD86W48cCikv1CvQp5qiYwuhFrbSU-Six72AlTxVbd7KhFD3-GRSEX4_fWQvfe2wHPANMf7PlxY5Zf1855_Ocxb8V821Dw> [Twitter] <http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtImepPHZwsGbf-Dg_nB3d76200oyf2DQHXGR2zaPhkPVMMb52Sx3p4MdUTocWPG9pyYSQfGHZdpmz6pqN80xzD4ixgYqc4uihMK8JD20-OHrgQ==> [LinkedIn] <http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtInqJM5lMnHLBT7TZcrIBPjkC22u-Rs3sbFFg9FHZZkWPMtW12ykFrU4ASVMJRPh33G-cltNQ9ogE6Ava6zqiEEHnrOCjdco1tnRRzB4rQT9GMIKnaYHMdu6fBVKLdfDQPvzGXFg_L6S7csF8M54fD5vd39ZTDHJDzx3J0Jf7NpKOU9WLMmTa1-55myDE5o7vYqwdtCWZuMzlw==> [YouTube] <http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtImxA0ogIKB7ods6RdqiREKXjAl9P5I1_K47OEUtwHSTHqCVHM6MV79ynqF8b2XLCoB97SYs7LECWgXWHN8diuM_JA5qPHNCo0zW8At9B3P7iou1LDy4SnG0>


[Join]<http://ui.constantcontact.com/d.jsp?m=1107257096883&p=oi>


[Forward]<http://ui.constantcontact.com/sa/fwtf.jsp?m=1107257096883&ea=lori.galluzzo%40hp.com&a=1110809085430>


Calendar of Events





IDUG DB2 Tech Conference in Sydney, Australia<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtInOIG5Rw5y4zZdLgkam-sB_2jCE20YJm48OcFuCintKgzNwj8EcwjkdoOKoFwjC1d3tgxQoDKnqV8IdtfN1XpBblvKBf083fA9uinLVaqPArcVzoR5XNBQ6vPmrpIGX02bEAhnfMw4KbHMcnsJP7gF6MWQEdbn7v2ZNh_nEAKFskfkhY2TUM_lAez7X_gHS0zxp-gVcItaHKV58HE3Op3cmMlmZRNrZVUzjw3kcD_P-dSn6svl2AEkdYGBE5CmuT4k=>: September 12-14, 2012

IDUG DB2 Tech Conference in Berlin, Germany<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIl49GvoP0x50O1_ub0MXGRSS_20CyG3pSwrTjuJ88THZB0YEDH1x2Ko8m_whZ02beZODxzySmk0ip1Wa7-QuDNB_WM9sgVoksR_y7ncpKMvBCKs4yDt1IEn7Js0ylaaoAPbJL0OIx2y4jpSWELbEzUjpI10kQV-aw3Bv3biay2gsdVLn7MV4TFzUTCsbOBQd6vYM94kG-4MwRPAqoKZsjM7hRdcNg8MiB7gc7hXLw7BXude3Dez752QarBADKXL1rs=>: 4-9 November 2012

IDUG DB2 Tech Conference in Orlando, Florida<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIkrLAnugf-AmLH-x3IQcUsjDOBAhYMq2XvRO07LNa7BUPgeZmWj2EAlr6B6NFWPRsE55fyoRk6SoUJl_oWhP4hFaSJhFkIANj5N8fPLFovrF5yr_LbPGy1GbTvYcFadDJ_Ooe-GRvd643ALPHs6EdOH8jim7zfHgMG6-0nfsmdZE0jcSst2-rN6xokVVPegDY-xPOrrx6uGwLqjhS2xY2313lTd9f1o46rHEvtQkT8w6nVmYglvAvW3b4zvjxWBIBo=>: April 28 - May 3, 2013




[http://ih.constantcontact.com/fs006/1107257096883/img/40.jpg]<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtIlyLXA39C2BgRfCTjCh4EcVE785tgovFNGnu14TXhlVTDSns5xvQRt4eKVcTL9WjOAmZjP6aa2mfoDuaPNMP1Eoq_SYM77zdLbLXOUAJD-V9YNLJbZlxd5BHUZfAwkIRg0N00UBJnrhYTNjet8-foYNWb-xp_3GSR6pb2dR19-3_8BEM9c2UK5diN5bMh9_dmzbntlDlYQvGOyQilCMW-cOb2HvDauR4s-UDRiJpe7AoUOl8N_JH_XZoGY_rnvnFSLlAH9uOgyKKQ6I_zGqevGqXMNjYCLEMoz1LxRfQbNvoHzWp_biMACRLB0byjJpZx_EdxyzXoOfTPXY2ksX4PI67GZ6z2bgUw4=>









[http://img.constantcontact.com/letters/images/1101116784221/IHeartDB2_IDUGB_FooterTop.png]


[http://img.constantcontact.com/letters/images/1101116784221/IHeartDB2_IDUGB_FooterLeft.png]

[http://img.constantcontact.com/letters/images/1101116784221/IHeartDB2_IDUGB_FooterWeb.png]<http://r20.rs6.net/tn.jsp?e=001rhUh9Q-RtImwEObkDIbxRB3voJxUJivEzlJHy52ydhGUEDks1QBd8M7Lqsu95EdfH7G8SHhUQc411USX8F4z9KzwGMPmx8ObEODTxUTBJ-7M56W89QX7D_Ykft7NKWT_GluRl_Vkv9UnAMaOFEClYWBSdpPJDewOHVv275owNI1EithjV4_fImjN3dzknOAqNGUTOEmbl0OA9TWjBCacWxtDoNI-tz0DpWl9l_jpH4A=>

[http://img.constantcontact.com/letters/images/1101116784221/IHeartDB2_IDUGB_FooterEmail.png]<mailto:[login to unmask email]>







Copyright (c) 2012. All Rights Reserved.







Forward this email<http://ui.constantcontact.com/sa/fwtf.jsp?llr=tv5u9ghab&m=1107257096883&ea=lori.galluzzo%40hp.com&a=1110809085430>
[http://img.constantcontact.com/letters/images/SafeUnsubscribe_Footer_Logo_New.png]<http://visitor.constantcontact.com/do?p=un&mse=001caaqJ6MjGFcyLinFO_8zaQuY_O5Lxu9o&t=001uKd-Ik8PFKDvwACjghGr8g%3D%3D&llr=tv5u9ghab>

[http://img.constantcontact.com/letters/images/CC_Footer_Logo_New.png]<http://www.constantcontact.com/index.jsp?cc=IHeartDB_IDUGB>

This email was sent to [login to unmask email] by [login to unmask email]<mailto:[login to unmask email]> |
Update Profile/Email Address<http://visitor.constantcontact.com/do?p=oo&mse=001caaqJ6MjGFcyLinFO_8zaQuY_O5Lxu9o&t=001uKd-Ik8PFKDvwACjghGr8g%3D%3D&llr=tv5u9ghab> | Instant removal with SafeUnsubscribe<http://visitor.constantcontact.com/do?p=un&mse=001caaqJ6MjGFcyLinFO_8zaQuY_O5Lxu9o&t=001uKd-Ik8PFKDvwACjghGr8g%3D%3D&llr=tv5u9ghab>(tm) | Privacy Policy<http://ui.constantcontact.com/roving/CCPrivacyPolicy.jsp>.

Idug | 401 N Michigan Ave | Chicago | IL | 60611