Catalog Advanced Search

Search by Categories
Search in Packages
Search by Format
Search by Type
Search by Date Range
Products are filtered by different dates, depending on the combination of live and on-demand components that they contain, and on whether any live components are over or not.
Start
End
Search by Keyword
Sort By
  • iSee How You Connect to the IBM i

    Contains 2 Component(s) Recorded On: 09/06/2020

    We have been asked if you can tell how people connect the IBM i.

    We have been asked if you can tell how people connect the IBM i.  There good news is there are some ways.  You can easily determine who is connecting using what interface for any database connection!  You can see what level of ACS is being used, if users are still using the old Windows product, and other connections.  This session will show you how to set up an exit point, and then query that data to see how people are connecting to your 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.

  • IBM iSee Video Blog

    Contains 10 Product(s)

    This recording is free for members and nonmembers. Short demonstrations of tools to help you in your everyday work. Presented by Scott Forstie and Tim Rowe, IBM

    image



    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

  • Spreadsheet Automation on IBM i with SQL & ACS

    Contains 2 Component(s) Recorded On: 08/10/2020

    This recording is free for members and nonmembers. Using some simple building blocks, you can automate the extraction of data and the building of a spreadsheet on your IBM i (yes... your IBM i) with out adding ANY additional software. Its all on your system already!

    Spreadsheets, its something so many of us rely on them every day for reviewing and understanding our business. The question is, how do you create those Spreadsheets ?  Using some simple building blocks, you can automate the extraction of data and the building of a spreadsheet on your IBM i (yes... your IBM i) with out adding ANY additional software. Its all on your system already!   In this session we will show you a progression of using SQL to build a data set (either from Db2, or IBM i Service) using ACS to build a spreadsheet, show how to automate that process so its happens every day at a set time, and lastly email that spreadsheet to a list of users.   This can all be done on your IBM i 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.

  • Manage your IFS with IBM i Services and ACS

    Contains 4 Component(s) Recorded On: 05/20/2020

    This recording is free for members and nonmembers. With IBM i 7.3 TR8 and IBM i 7.4 TR2 there are many new IBM i Services that can really help make the management and understanding of your IFS easier. In this session we will look at some practical examples on how to better manage your Integrated File System (IFS) along with some new features to improve your experience with IBM i Access Client Solutions (ACS).

    With IBM i 7.3 TR8 and IBM i 7.4 TR2 there are many new IBM i Services that can really help make the management and understanding of your IFS easier. In this session we will look at some practical examples on how to better manage your Integrated File System (IFS) along with some new features to improve your experience with IBM i Access Client Solutions (ACS).

    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.

  • PTF Compare

    Contains 2 Component(s) Recorded On: 08/26/2020

    In this session we will be looking at using 3 part naming to build a 'service' that can call to the IBM Service Planning Web Page, and compare to the list of PTFs currently on your partition and show you what missing.​

    How do you PTF ?  How do you determine if your system has the latest PTFs on it ?  There are several options of course! But not to go about things the easy way, lets toss a wrench in the mix... I want to see if my partition is on the latest PTFs, BUT, this partition does not have access to the Internet!  Now what ? Leveraging 3 part naming, you have a magic solution.  In this session we will be looking at using 3 part naming to build a 'service' that can call to the IBM Service Planning Web Page, and compare to the list of PTFs currently on your partition and show you what missing.

    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.

  • 5 SQL Tips Everyone Should Know - Birgitta Hauser and Steve Spieler

    Contains 1 Component(s)

    This recording will also be available to nonmembers for free until September 6, 2020. Join this webinar where Birgitta Hauser, world-renowned database expert, joins the business intelligence experts from HelpSystems to share several tips and tricks that can help when working with SQL

    SQL has become the standard for accessing data located within relational databases, like IBM Db2, Microsoft SQL Server, Oracle Database, or MySQL. In fact, the annual IBM i Marketplace Survey Results show that SQL is the #2 language for new development on IBM i, coming in just behind RPG.

      

    Many organizations use IBM i as a database server and rely on SQL to build new tables and provide faster access to the data. There is so much that you can do with SQL, but the devil is in the details and it can be helpful to have a few tricks up your sleeve.

      

    Join this live webinar where Birgitta Hauser, world-renowned database expert, joins the business intelligence experts from HelpSystems to share several tips and tricks that can help when working with SQL, including:

      

    Searching for % or _ characters in Strings

    Removing (only) leading and trailing characters from a string

    Calculating with SQL

    Editing numeric Values

    Converting numeric Dates/Time Values into SQL Date and Time Data Types and vice versa

    You’ll also discover a tool that can help you move beyond rows and columns to turn data into actionable insight.

     

    Birgitta Hauser

    Database and Software Architect - Fresche Solutions, Inc.

    Birgitta is a database and software architect at Fresche Solutions.

  • Case Study: Using SQL to Overcome Challenges When Consuming XML - Vern Hamberg

    Contains 1 Component(s) Recorded On: 07/30/2020

    This recording will also be available to nonmembers for free until August 30, 2020. In this new world of mobile data collection by our field specialists, we ran head-on into special characters as well as emojis. This case study tells the tale of overcoming the hurdles we were stumbling over to deal with them.

    In this new world of mobile data collection by our field specialists, we ran head-on into special characters as well as emojis. This case study tells the tale of overcoming the hurdles we were stumbling over to deal with them.  Learning objectives:

    1. Learn what issues can be raised when using mobile devices to collect information from the field

    2. Learn how XML support in Db2 for i was used to resolve these issues

    Vern Hamberg

    Senior IT Developer, Ecolab

    Vern has worked on IBM midrange systems for over 25 years, beginning with the System/38 and AS/400. At present he is a senior IT developer for the Pest Elimination division at Ecolab. He is degreed in both music and mathematics, which gives him a distinct approach to the art and science of programming. In his spare time he plays in a community band and sings in a pretty-good a capella choral group. In 2011 he wrote a special report on IBM Rational Open Access: RPG Edition that was published in System iNews in April of that year. More recently he has become more involved in community musical theater as music director, vocal director, and accordionist.

  • Case Study: Filing Tax to the Government - Andy Youens

    Contains 1 Component(s) Recorded On: 07/30/2020

    This recording will also be available to nonmembers for free until August 30, 2020. This customer story showcases how the IBM i and open source technology can be used to develop a modern application to interact direct with UK government systems without a complicated middleware requirement.

    The IBM i has taken great strides forward in recent years, modernizing the platform and allowing it to become a launchpad for a wide array of open source technologies.   

    This customer story showcases how the IBM i and open source technology can be used to develop a modern application to interact direct with UK government systems without a complicated middleware requirement.  

    Hear about the technologies we exploited including development, open source languages and modern application engineering techniques.

    Andy Youens

    IBM i Consultant/Instructor, FormaServe

    Andy is an IBM i Consultant/Instructor at FormaServe, who has over 32 years IT experience working with IBM midrange servers.His specialities are IBM i, RPG, PHP, CL, Zend Server, Zend Frameworks, SQL and DB2.He is also an accomplished instructor and an article writer specialising in programming on the IBM i.Prior to his IT career, Andy is proud to have served 10 years in the Royal

  • How 2020’s Events are Changing How IBM i Organizations Focus their Digital Efforts - Nick Hampson

    Contains 1 Component(s) Recorded On: 07/30/2020

    This recording will also be available to nonmembers for free until August 30, 2020. Please join Fresche’s Nick Hampson for this session where he will highlight how to identify these high value efforts and how to align them with key business objectives. He will also discuss how to lead your organization into a digital era and why so many companies are focused on digital transformation.

    There is no doubt that 2020’s events are changing how IBM i organizations focus their digital efforts. Many of us are under pressure to adapt to urgent business needs. However, it is also important to examine how we can improve resilience by innovating and preparing our IT environments for future business opportunities and threats. Identifying IT initiatives that will drive immediate change and bring value to the organization is where we are seeing the shift in IT budgets. 

    Please join Fresche’s Nick Hampson for this session where he will highlight how to identify these high value efforts and how to align them with key business objectives. He will also discuss how to lead your organization into a digital era and why so many companies are focused on digital transformation.

    You will learn about:

    ·         Responding to challenges when disruption occurs

    ·         Culture and initiatives for digital transformation

    ·         Incremental modernization strategies that maximize time-to-value

    ·         Business benefits derived from modernization and integration

    Nick Hampson

    Director of Design, Fresche Solutions

    Nick has extensive experience in Design, UX, Product Management, innovation and Pre-sales. Focused on bringing the business value of design and UX to IBM i customers and the community at large, Nick is recognized as a UX expert on IBM i. He also describes himself as a geek and a bookworm with interests in design, psychology, neuroscience, physics, engineering and mathematics, and given a little free time, he is also a keen target Archer.

  • Case Study: Keeping Food Supply Chains Moving with IoT and IBM - Shelly Cook, Brenda Boese, & Scott Andrews

    Contains 1 Component(s) Recorded On: 07/30/2020

    This recording will also be available to nonmembers for free until August 30, 2020. The company runs their entire business and trucking operations on IBM i and Power Systems S914. K&J utilizes IoT (Internet of Things) applications on IBM i to monitor and track their truck fleet and ensure cargo stays fresh and safe.

    K&J Trucking was started by Dave Koch in 1979 with the goal of becoming a top refrigerated carrier in the industry.  The company runs their entire business and trucking operations on IBM i and Power Systems S914. K&J utilizes IoT (Internet of Things) applications on IBM i to monitor and track their truck fleet and ensure cargo stays fresh and safe. Each trailer has a device and application from Orbcomm that monitors temperature of the cargo, reducing the costly risk of a shipment of fresh meat or produce going bad and having to be thrown away. If the cargo is getting too warm, the driver will be notified, and a correction can be made. This application is running on IBM i and Power Systems S914, and all trailer data is stored in their Db2 for i database.