View Printable Version

E06 - Useful SQL Tips for Db2 and Db2 for z/OS

Session Number: 5266
Track: AppDev and Analytics I
Session Type: Podium Presentation
Primary Presenter: Marcel Scheibe [FIDUCIA & GAD IT AG]
Time: Oct 03, 2017 (02:30 PM - 03:30 PM)

Speaker Bio: * start with Db2 z/Os in 1997 as developer
* change to the DBA group in 2001, mainly Db2 z/OS
* 2008 start with Db2 for LUW
* since 2016 reponsible for Tuning and developing Db2 LUW applications
Audience experience level: Beginner, Intermediate
Presentation Platform: Cross Platform
Presentation Category: Application Development
Audiences this presentation will apply to: Application Developers, Database Administrators
Objective 1: * Multirow-Inserts
* Inserts with subselect
* Insert, Update, Delete from Select

Objective 2: * Merge
Objective 3: * ROWNUMBER() over (e.g. Delete duplicates, ...)

Objective 4: Useful selects
* concat x'0A' concat (new line in Output for Unix)
* SELECT 'Lisbon ''17''' from sysibm.sysdummy1;
* WHERE (name, surname, birthday) IN (select name, surname, birthday from tab …)

Abstract:  Tips and tricks for using SQL

For questions or concerns about your event registration, please contact