In the past few releases and TRs IBM has introduced a number of SQL views and table functions that allow anyone to do things to spool files that they would have had to use APIs or complex programming. Become the superstar at your company with the knowledge on how to do all of this with just a few SQL statements.
Date & Time
Wednesday November 6th, 2024 9:45am EST
End Date & Time
Wednesday November 6th, 2024 10:45am EST
Venue
Pier 7 & 8
Speakers
Simon Hutchinson
Session Format
Standard 60 Minute Session
Learning Objectives
Learning Objectives:
1. How to find the biggest/oldest spool files on your systems.
2. How to delete old spool files.
3. How to extract data from a spool file into spreadsheet format
4. How to build views over spool files, even when they are not there
5. How to copy one spool file to PDF
6. How to copy many spool files to PDF
1. How to find the biggest/oldest spool files on your systems.
2. How to delete old spool files.
3. How to extract data from a spool file into spreadsheet format
4. How to build views over spool files, even when they are not there
5. How to copy one spool file to PDF
6. How to copy many spool files to PDF
Audience
Anyone who wants to know how they can manage spool files, & get data from them by using SQL.
Session Level
Intermediate
Evaluation Link
https://docs.google.com/forms/d/e/1FAIpQLScZUqaHcpJfO1HYO4XDagewGyp12uhBOCbFHeU3zFMSGu8Egg/viewform?usp=pp_url&entry.86355973=Tricks with spool files using SQL&entry.1165051396=Simon Hutchinson
Conference NAViGATE Toronto
Session Comments