IBM iSee Video Blog
-
Register
- Member - Free!
- Non-member - Free!
Short demonstrations of tools, techniques and examples (including working SQL examples!!) to help you solve real problems that are part of your everyday work. Presented by Scott Forstie and Tim Rowe, IBM
Advanced Search This List
-
Contains 1 Component(s)
A while ago now we showed you how to send text messages from your IBM i. It seemed to work ok…. Well we have now learned of a even better new option!!! Did you know you can send a text message using an Email service? This iSee dives in to sending text messages using this fun new option.
A while ago now we showed you how to send text messages from your IBM i. It seemed to work ok…. Well we have now learned of a even better new option!!! Did you know you can send a text message using an Email service? This iSee dives in to sending text messages using this fun new option.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
-
Contains 1 Component(s)
We have had the ability to send emails from the IBM i for a long time now. A few months ago we delivered a new SQL Service out in SYSTOOLS to really simplify the process. Once delivered, we started getting card and letters about all the ways we could make it better, Ha! Good news… it is! This iSee takes a closer look at this powerful service and shows how easy it is to even attach spreadsheets ( or other documents) to an email. Our last trick… we even automate the process! Nothing better than a daily email from your favorite IBM i.
We have had the ability to send emails from the IBM i for a long time now. A few months ago we delivered a new SQL Service out in SYSTOOLS to really simplify the process. Once delivered, we started getting card and letters about all the ways we could make it better, Ha! Good news… it is! This iSee takes a closer look at this powerful service and shows how easy it is to even attach spreadsheets ( or other documents) to an email. Our last trick… we even automate the process! Nothing better than a daily email from your favorite IBM i.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
-
Contains 1 Component(s)
We recently introduced SELF in an iSee vid. In this episode, we show how EVERY developer could be using SELF as a normal part of their development process. Built within VS Code4i is an integrated feature to enable and use SELF!
We recently introduced SELF in an iSee vid. In this episode, we show how EVERY developer could be using SELF as a normal part of their development process. Built within VS Code4i is an integrated feature to enable and use SELF!
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
-
Contains 1 Component(s)
Environment variables are a popular method to control the behaviors of jobs on your system. Environment variables are defined at the System and Job level. In this iSee we leverage the incredible INCLUDE (SQL) statement to create scalar functions that break the rules on what's possible within SQL.
Environment variables are a popular method to control the behaviors of jobs on your system. Environment variables are defined at the System and Job level. In this iSee we leverage the incredible INCLUDE (SQL) statement to create scalar functions that break the rules on what's possible within SQL.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
-
Contains 1 Component(s)
Printer files, we all have them on our system, but what do we really know about them? Yesterday, CL was your only option available in trying to peel the onion of printer files. With this iSee we show how some SQL magic can bring printer files to light. Easily see your printer files, the IBM shipped printer files, as well as details galore.
Printer files, we all have them on our system, but what do we really know about them? Yesterday, CL was your only option available in trying to peel the onion of printer files. With this iSee we show how some SQL magic can bring printer files to light. Easily see your printer files, the IBM shipped printer files, as well as details galore.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
-
Contains 1 Component(s)
SQL Error Logging Facility better known as SELF. This is one of the best kept secrets on the IBM i. The SELF support provides a lightweight, production safe way to see what is happening on your IBM i in regard to the SQL being run. Do you have warning messages that are being ignored, or worse yet, errors that are happening but ignored. While these may seem ok as they are ignored, these issues in your SQL have the potential to cause you harm. SELF provides a flight recorded that registers these sort of issues giving you the data you need to see what is happening and better yet, pinpoint where you need to fix things. In this iSee we demo how to turn on , the latest new features and give you the SQL such that you can start using it today.
SQL Error Logging Facility better known as SELF. This is one of the best kept secrets on the IBM i. The SELF support provides a lightweight, production safe way to see what is happening on your IBM i in regard to the SQL being run. Do you have warning messages that are being ignored, or worse yet, errors that are happening but ignored. While these may seem ok as they are ignored, these issues in your SQL have the potential to cause you harm. SELF provides a flight recorded that registers these sort of issues giving you the data you need to see what is happening and better yet, pinpoint where you need to fix things. In this iSee we demo how to turn on , the latest new features and give you the SQL such that you can start using it today.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
-
Contains 1 Component(s)
System values on the IBM i are core system properties that control behaviors of many aspects of your IBM i. Things like Security, National Language, SQL runtime, Dates and Times, Auditing, and so much more. This iSee will dive into the latest updates to the System_Value_Info SQL Service. This service has been enhanced to show values that make sense to humans! I know.. what a weird concept. What the shipped default values were. We will give you some nifty SQL that shows you the values that are different than the shipped values, as well as how to easily compare the system values between 2 different systems.
System values on the IBM i are core system properties that control behaviors of many aspects of your IBM i. Things like Security, National Language, SQL runtime, Dates and Times, Auditing, and so much more. This iSee will dive into the latest updates to the System_Value_Info SQL Service. This service has been enhanced to show values that make sense to humans! I know.. what a weird concept. What the shipped default values were. We will give you some nifty SQL that shows you the values that are different than the shipped values, as well as how to easily compare the system values between 2 different systems.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
-
Contains 1 Component(s)
Dead Jobs! Seems a bit dark. In this iSee we are going to shine some light into the darkness. When a Job on your system ends, there are all sorts of nuggets of information about the life of the job, things like CPU usage, temp storage, how long did a job run, how long did it wait before running and such. Using some time tested SQL magic, we are going to do a postmortem on the jobs on the system to learn a great deal! Should be a fun!
Dead Jobs! Seems a bit dark. In this iSee we are going to shine some light into the darkness. When a Job on your system ends, there are all sorts of nuggets of information about the life of the job, things like CPU usage, temp storage, how long did a job run, how long did it wait before running and such. Using some time tested SQL magic, we are going to do a postmortem on the jobs on the system to learn a great deal! Should be a fun!
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
-
Contains 1 Component(s)
In the previous iSee we learned the basics on how to use and install VsCode for your IBM i development needs. In this session we will venture down a path near and deer ( wonderful creature that likes to run out in front of your cars) to Scott, creating SQL for IBM i. This includes accessing databases, as well as getting the most out of your IBM i Services leveraging SQL. We will show you the power of this Db2 support that the Code for i team has been working on. Buckle up!
In the previous iSee we learned the basics on how to use and install VsCode for your IBM i development needs. In this session we will venture down a path near and deer ( wonderful creature that likes to run out in front of your cars) to Scott, creating SQL for IBM i. This includes accessing databases, as well as getting the most out of your IBM i Services leveraging SQL. We will show you the power of this Db2 support that the Code for i team has been working on. Buckle up!
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
-
Contains 1 Component(s)
IBM i is very ‘securable’ capable of locking all sorts of stuff down, including user profile passwords. The question was asked, ‘How can I be sure that all the IBM i users are using 15 character ‘secure’ passwords? ‘ In response to that.. and to help both see how to set that up AND force all your users to comply, Scott and Tim take to the SQL air waves. We have included the SQL so you too can start to insure your users are compliant.
IBM i is very ‘securable’ capable of locking all sorts of stuff down, including user profile passwords. The question was asked, ‘How can I be sure that all the IBM i users are using 15 character ‘secure’ passwords? ‘ In response to that.. and to help both see how to set that up AND force all your users to comply, Scott and Tim take to the SQL air waves. We have included the SQL so you too can start to insure your users are compliant.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
$i++ ?>
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
$i++ ?>
-
Contains 1 Component(s)
A while ago now we showed you how to send text messages from your IBM i. It seemed to work ok…. Well we have now learned of a even better new option!!! Did you know you can send a text message using an Email service? This iSee dives in to sending text messages using this fun new option.
A while ago now we showed you how to send text messages from your IBM i. It seemed to work ok…. Well we have now learned of a even better new option!!! Did you know you can send a text message using an Email service? This iSee dives in to sending text messages using this fun new option.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
-
Contains 1 Component(s)
We have had the ability to send emails from the IBM i for a long time now. A few months ago we delivered a new SQL Service out in SYSTOOLS to really simplify the process. Once delivered, we started getting card and letters about all the ways we could make it better, Ha! Good news… it is! This iSee takes a closer look at this powerful service and shows how easy it is to even attach spreadsheets ( or other documents) to an email. Our last trick… we even automate the process! Nothing better than a daily email from your favorite IBM i.
We have had the ability to send emails from the IBM i for a long time now. A few months ago we delivered a new SQL Service out in SYSTOOLS to really simplify the process. Once delivered, we started getting card and letters about all the ways we could make it better, Ha! Good news… it is! This iSee takes a closer look at this powerful service and shows how easy it is to even attach spreadsheets ( or other documents) to an email. Our last trick… we even automate the process! Nothing better than a daily email from your favorite IBM i.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
-
Contains 1 Component(s)
We recently introduced SELF in an iSee vid. In this episode, we show how EVERY developer could be using SELF as a normal part of their development process. Built within VS Code4i is an integrated feature to enable and use SELF!
We recently introduced SELF in an iSee vid. In this episode, we show how EVERY developer could be using SELF as a normal part of their development process. Built within VS Code4i is an integrated feature to enable and use SELF!
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
-
Contains 1 Component(s)
Environment variables are a popular method to control the behaviors of jobs on your system. Environment variables are defined at the System and Job level. In this iSee we leverage the incredible INCLUDE (SQL) statement to create scalar functions that break the rules on what's possible within SQL.
Environment variables are a popular method to control the behaviors of jobs on your system. Environment variables are defined at the System and Job level. In this iSee we leverage the incredible INCLUDE (SQL) statement to create scalar functions that break the rules on what's possible within SQL.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
-
Contains 1 Component(s)
Printer files, we all have them on our system, but what do we really know about them? Yesterday, CL was your only option available in trying to peel the onion of printer files. With this iSee we show how some SQL magic can bring printer files to light. Easily see your printer files, the IBM shipped printer files, as well as details galore.
Printer files, we all have them on our system, but what do we really know about them? Yesterday, CL was your only option available in trying to peel the onion of printer files. With this iSee we show how some SQL magic can bring printer files to light. Easily see your printer files, the IBM shipped printer files, as well as details galore.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
-
Contains 1 Component(s)
SQL Error Logging Facility better known as SELF. This is one of the best kept secrets on the IBM i. The SELF support provides a lightweight, production safe way to see what is happening on your IBM i in regard to the SQL being run. Do you have warning messages that are being ignored, or worse yet, errors that are happening but ignored. While these may seem ok as they are ignored, these issues in your SQL have the potential to cause you harm. SELF provides a flight recorded that registers these sort of issues giving you the data you need to see what is happening and better yet, pinpoint where you need to fix things. In this iSee we demo how to turn on , the latest new features and give you the SQL such that you can start using it today.
SQL Error Logging Facility better known as SELF. This is one of the best kept secrets on the IBM i. The SELF support provides a lightweight, production safe way to see what is happening on your IBM i in regard to the SQL being run. Do you have warning messages that are being ignored, or worse yet, errors that are happening but ignored. While these may seem ok as they are ignored, these issues in your SQL have the potential to cause you harm. SELF provides a flight recorded that registers these sort of issues giving you the data you need to see what is happening and better yet, pinpoint where you need to fix things. In this iSee we demo how to turn on , the latest new features and give you the SQL such that you can start using it today.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
-
Contains 1 Component(s)
System values on the IBM i are core system properties that control behaviors of many aspects of your IBM i. Things like Security, National Language, SQL runtime, Dates and Times, Auditing, and so much more. This iSee will dive into the latest updates to the System_Value_Info SQL Service. This service has been enhanced to show values that make sense to humans! I know.. what a weird concept. What the shipped default values were. We will give you some nifty SQL that shows you the values that are different than the shipped values, as well as how to easily compare the system values between 2 different systems.
System values on the IBM i are core system properties that control behaviors of many aspects of your IBM i. Things like Security, National Language, SQL runtime, Dates and Times, Auditing, and so much more. This iSee will dive into the latest updates to the System_Value_Info SQL Service. This service has been enhanced to show values that make sense to humans! I know.. what a weird concept. What the shipped default values were. We will give you some nifty SQL that shows you the values that are different than the shipped values, as well as how to easily compare the system values between 2 different systems.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
-
Contains 1 Component(s)
Dead Jobs! Seems a bit dark. In this iSee we are going to shine some light into the darkness. When a Job on your system ends, there are all sorts of nuggets of information about the life of the job, things like CPU usage, temp storage, how long did a job run, how long did it wait before running and such. Using some time tested SQL magic, we are going to do a postmortem on the jobs on the system to learn a great deal! Should be a fun!
Dead Jobs! Seems a bit dark. In this iSee we are going to shine some light into the darkness. When a Job on your system ends, there are all sorts of nuggets of information about the life of the job, things like CPU usage, temp storage, how long did a job run, how long did it wait before running and such. Using some time tested SQL magic, we are going to do a postmortem on the jobs on the system to learn a great deal! Should be a fun!
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
-
Contains 1 Component(s)
In the previous iSee we learned the basics on how to use and install VsCode for your IBM i development needs. In this session we will venture down a path near and deer ( wonderful creature that likes to run out in front of your cars) to Scott, creating SQL for IBM i. This includes accessing databases, as well as getting the most out of your IBM i Services leveraging SQL. We will show you the power of this Db2 support that the Code for i team has been working on. Buckle up!
In the previous iSee we learned the basics on how to use and install VsCode for your IBM i development needs. In this session we will venture down a path near and deer ( wonderful creature that likes to run out in front of your cars) to Scott, creating SQL for IBM i. This includes accessing databases, as well as getting the most out of your IBM i Services leveraging SQL. We will show you the power of this Db2 support that the Code for i team has been working on. Buckle up!
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
-
Contains 1 Component(s)
IBM i is very ‘securable’ capable of locking all sorts of stuff down, including user profile passwords. The question was asked, ‘How can I be sure that all the IBM i users are using 15 character ‘secure’ passwords? ‘ In response to that.. and to help both see how to set that up AND force all your users to comply, Scott and Tim take to the SQL air waves. We have included the SQL so you too can start to insure your users are compliant.
IBM i is very ‘securable’ capable of locking all sorts of stuff down, including user profile passwords. The question was asked, ‘How can I be sure that all the IBM i users are using 15 character ‘secure’ passwords? ‘ In response to that.. and to help both see how to set that up AND force all your users to comply, Scott and Tim take to the SQL air waves. We have included the SQL so you too can start to insure your users are compliant.
Tim Rowe
Business Architect Application Development & Systems Management for IBM i
Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.
Scott Forstie
Db2 for i Business Architect
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.