Catalog Advanced Search

Search by Categories
Search in Packages
Search by Format
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
  • Git for Open Source and Source Control - Stephanie Rabbani

    Contains 1 Component(s)

    In this session find out how to use Git to contribute to open source projects, and get an introduction on how to use Git to manage source code within your organization.

    In this session find out how to use Git to contribute to open source projects, and get an introduction on how to use Git to manage source code within your organization.


    Learning Objectives:
    1. How to create your own repository
    2. The basics of Git flow
    3. Tips and tricks for using Git on Mac/Windows
    4. How to use Github/Gitlab/Bitbucket to contribute to open source projects

    Stephanie Rabbani

    Consultant, Seiden Group

    Stephanie has 17 years of experience developing web applications on the IBM i.

  • SQLRPGLE the Better File Access - Marina Schwenk

    Contains 1 Component(s)

    We will learn and explore how you can go from record level access to embedded sql and from that how can you streamline your programming process with embedded sql.

    We will learn and explore how you can go from record level access to embedded sql and from that how can you streamline your programming process with embedded sql. How to handle sql exceptions. And finally, how can you leverage SQL to replace your current record level access.

    Learning Objectives:

    • Overview of embedding SQL in your RPG programs. 
    • How to streamline sql procedures with the use of a SQL utility service program.
    • How to modernize your current record level access to use embedded SQL

    Marina Schwenk

    Software Developer, Everbrite

    Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a developer in both RPG and Java and she also is one of two junior IBM i admins at Everbrite. Marina earned her bachelor’s degree in Computer Information Systems Software Development from Bellevue University in June of 2017. She is currently working on her Master’s degree program in Computer Information Systems Software development, with the goal of teaching part time, and empowering the younger generation. Marina is also a member of the Wisconsin Midrange Computer Professional Association, Women in IT committee and has recently started speaking on a couple of topics, ranging from RPG to SQL. She has completed one open source project and is currently working on releasing iUnit an open source RPG unit testing framework written in RPGLE.

  • Intro to SQL - Linda Swan

    Contains 1 Component(s)

    SQL is IBM's relational database language that can be used for data definition, and manipulation -- querying. It is the key to understanding data retrieval in the rapidly evolving client/server environment. SQL is simple to use and is an extremely powerful database and application development tool. This session, will introduce SQL concepts, the use of SQL for query or data retrieval, and the use of SQL for database creation and management.

    SQL is IBM's relational database language that can be used for data definition, and manipulation -- querying. It is the key to understanding data retrieval in the rapidly evolving client/server environment. SQL is simple to use and is an extremely powerful database and application development tool. This session, will introduce SQL concepts, the use of SQL for query or data retrieval, and the use of SQL for database creation and management.

    Linda Swan

    IBM Senior Software Engineer

    Linda Swan is a IBM senior software engineer working in Db2 for i development. For several years Linda has worked on the SQE (SQL) query optimizer doing both add function development work and customer support. For the past nine years Linda has focused primarily on SQL query optimizer field support, exploring both query performance issues, indexing strategy and general query tuning.

  • Automatic Encryption with FIELDPROC - No Application Changes! - Patrick Townsend

    Contains 1 Component(s)

    Join Patrick Townsend as he discusses how organizations of all sizes are implementing FIELDPROC encryption, performance impacts, and how to make sure your FIELDPROC encryption solution will pass a compliance audit.

    Encryption without application or database changes is now possible using FIELDPROC on IBM i V7R1. Join Patrick Townsend as he discusses how organizations of all sizes are implementing FIELDPROC encryption, performance impacts, and how to make sure your FIELDPROC encryption solution will pass a compliance audit. Automatic encryption with FIELDPROC is absolutely the easiest, fastest, and most secure way to encrypt data on the IBM i. Learning Objectives: By the end of this session, attendees will be able to: What FIELDPROC is and what it is not How to easily encrypt and protect sensitive data on your IBM i The importance of encryption key management FIELDPROC limitations you should know What to look for when deciding on a FIELDPROC encryption solution

    Patrick Townsend

    Founder and CEO of Townsend Security

    Patrick Townsend is Founder and CEO of Townsend Security, a leading provider of data encryption, key management and web services solutions for the IBM i, and many other Enterprise operating platforms. Founded in 1989, Mr. Townsend's company specializes in helping customers bring their data security into compliance with PCI DSS, HIPAA/HITECH, GLBA/FFEC, Sarbanes-Oxley, and other State and Federal data security regulations. Patrick has been active in the IBM i community and speaks frequently on the topic of the IBM i and data security.

  • SQL Easy as MAGIC! - Steve Wolk

    Contains 1 Component(s)

    Come join us for a session on SQL that begins with the basics and builds into very useful techniques you can use every day.

    Do you use SQL? Do you use it to its full capabilities? SQL is an amazingly powerful tool, but can seem overwhelming at first. In fact, it can sometimes seem like magic! Come join us for a session on SQL that begins with the basics and builds into very useful techniques you can use every day. Using magic to help explain some key concepts will make this session entertaining as well as educational. Discover how to use SQL not only for data definition and data manipulation, but also as a wonderful ad-hoc query tool. Save time writing reports and get the answers your business needs in seconds. Learn how to easily execute an SQL statement on your PC that will pull data from your IBM i into an Excel spreadsheet! We will cover other practical examples, such as easily processing a job log for the information you need. Learning Objectives: After participating in this session, attendees will have the skills and tools to: Use SQL to perform both simple and sophisticated ad-hoc queries Create and modify database files using SQL Modify your data quickly and easily without writing any RPG code Set up your own PC to pull data from your IBM i to Excel using SQL

    Steven Wolk

    CTO, PC Richard & Son

    Steven Wolk is the CTO for PC Richard & Son, a 110 year old family owned and operated chain of 66 appliance, electronics, and mattress superstores located throughout NY, NJ, CT, and PA. Steve's deep background in retail began on the sales floor while in college, and he's applied those lessons learned to many roles in IT throughout his 33 year career with PC Richard. As CTO, Steve feels fortunate to lead teams of very talented and dedicated people who are collectively responsible for all phases of technology development, acquisition, deployment, and support throughout the company. Always looking to the future, Steve enjoys speaking about the future of retail at conferences and events, along with subjects ranging from leadership and personal success to a wide variety of technical topics. Steve is passionate about applying technology to create business value, along with a world-class customer experience for PC Richard's customers. He's driven to teach and finds it very rewarding to help his teams reach their full potential. Steve and his wife live in Commack, NY, and enjoy traveling as a family with their two daughters who are attending college. If you’d like to strike up a conversation with Steve, mention anything related to Disney or Star Trek, and you’ll have his undivided attention!

  • Managing IBM i PTFs - Larry Bolhuis

    Contains 1 Component(s)

    n this session we will describe PTFs, Cumultative PTFs, and other PTF Groups. We'll discuss how to find out what you have, how to get them, and how to put them in place.

    What are PTFs? Why do I need them? How do I get them? Which ones do I need? Does my technology really need a refresh? In this session we will describe PTFs, Cumultative PTFs, and other PTF Groups. We'll discuss how to find out what you have, how to get them, and how to put them in place. We'll help you determine what PTF strategy is the one for you and your system. Learning Objectives: What PTFs, and PTF Groups are and why you need them. How to get PTFs and load them onto IBM i. The use of Virtual Image Catalogs and Virtual DVD drives to save time and problems in the PTF process. How to determine which PTFs you need for your system.

    Larry Bolhuis

    Chief i-entist - Frankeni Technology Consulting, LLC

    Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction In 1988.After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of working with SNA, SDLC, SNADS, APPC, APPN followed by Token Ring, Ethernet, and TCP/IP taught strong communications troubleshooting skills. In addition to networking on the IBM side Larry learned the infrastructure components of the network including switches routers and firewalls, working chiefly with Cisco equipment.In 15 years as an IBM Business partner Larry worked with IBMs systems from design through implementation and migration. He has worked on the smallest and largest and everything in between. He has been involved in many Beta and other early release programs with IBM. Larry has held more than 30 IBM certifications on the AS/400, iSeries, System i and Power Systems, including IBM Certified Advanced Technical Expert and is a contributing author to many IBM Certification tests.Larry is a frequent and award winning speaker at users groups around North America covering Systems design and management, networking and connectivity, work management, PTF, and Hardware Management Console topics. He has been a long time volunteer and speaker with COMMON and has been awarded Gold, Silver and Bronze medals and also its highest Honor the Distinguished Service Award.">Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction In 1988.After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of working with SNA, SDLC, SNADS, APPC, APPN followed by Token Ring, Ethernet, and TCP/IP taught strong communications troubleshooting skills. In addition to networking on the IBM side Larry learned the infrastructure components of the network including switches routers and firewalls, working chiefly with Cisco equipment.In 15 years as an IBM Business partner Larry worked with IBMs systems from design through implementation and migration. He has worked on the smallest and largest and everything in between. He has been involved in many Beta and other early release programs with IBM. Larry has held more than 30 IBM certifications on the AS/400, iSeries, System i and Power Systems, including IBM Certified Advanced Technical Expert and is a contributing author to many IBM Certification tests.Larry is a frequent and award winning speaker at users groups around North America covering Systems design and management, networking and connectivity, work management, PTF, and Hardware Management Console topics. He has been a long time volunteer and speaker with COMMON and has been awarded Gold, Silver and Bronze medals and also its highest Honor the Distinguished Service Award.">COMMON and has been awarded Gold, Silver and Bronze medals and also its highest Honor the Distinguished Service Award.">Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction In 1988.After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of working with SNA, SDLC, SNADS, APPC, APPN followed by Token Ring, Ethernet, and TCP/IP taught strong communications troubleshooting skills.

  • DB2 for i - Row and Column Access Control - Scott Forstie

    Contains 1 Component(s)

    The session will include a comparison of the most frequently used techniques for limiting access for data and will show how RCAC constructs could be used to deploy a data-centric solution.

    With IBM i 7.2, Row and Column Access Control (otherwise known as RCAC) was added to DB2 for i.  This new capability creates a compelling alternative to traditional techniques for limiting access to data. Attend this session for a technical overview of the new capability.  The session will include a comparison of the most frequently used techniques for limiting access for data and will show how RCAC constructs could be used to deploy a data-centric solution. Working examples and IBM i specific details will be included, making this session a valuable investment.  Arm yourself and your staff with the knowledge needed to improve your data security.

    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.

  • Web Language Shootout - Alan Seiden

    Contains 1 Component(s)

    In this session, we'll compare some of the open source languages commonly used for web-related development and the role of RPG alongside them. Languages include PHP, Python, and Node.js (javascript).

    In this session, we'll compare some of the open source languages commonly used for web-related development and the role of RPG alongside them. Languages include PHP, Python, and Node.js (javascript). The session contains concrete information as well as a lively discussion.


    Learning Objectives:
    1. Learn what makes each of these languages unique
    2. Get an idea of when each language would be best
    3. Learn someething about web and API architecture

    Alan Seiden

    Principal, Seiden Group

    Alan Seiden founded Seiden Group to modernize IBM i applications using open source web technologies such as PHP, Python, Node.js, and DB2 for i and RPG business logic. His team's philosophy is to code while transferring skills to in-house teams.

    Recognized as an IBM Champion, Alan hosts the CIO Summit twice per year. Alan co-developed the popular PHP Toolkit with IBM; was one of the first Zend Framework certified engineers; co-founder of the NYC Zend Framework Meetup; charter member of IBM/COMMON’s PHP Advisory Board; and a consultant for IBM’s manual PHP: Zend Core for i5/OS.

    An award-winning speaker, Alan has been called “the performance guru of PHP on IBM i.”

    In his spare time, Alan plays the trombone and studies and teaches the Feldenkrais Method® of Somatic Education.

  • IBM i Encryption Made Easy - Jeff Uehling

    Contains 1 Component(s)

    You’ll learn how IBM i Field Procedures (FieldProcs), introduced in V7R1, have greatly simplified encryption projects, often eliminating the need for application changes.

    Do you need to encrypt sensitive data on your IBM i, such as confidential employee information, personal credit information or personal health information, but worry about the complexity of implementing encryption? In this session, Jeff Uehling, Security Expert at Syncsort, well-known expert in cryptography and key management, put your encryption fears to rest. You’ll learn how IBM i Field Procedures (FieldProcs), introduced in V7R1, have greatly simplified encryption projects, often eliminating the need for application changes.


    Learning Objectives:
    • How to easily encrypt data without impacting applications using FieldProc
    • Challenges and practical considerations for FieldProc encryption
    • The importance of encryption key management to meet compliance requirements

    Jeff Uehling

    Syncsort Security Expert

    Jeff Uehling has over 30 years of experience working in security technology for the IBM i, and its predecessor systems, and is an expert in the Syncsort’s security offerings. Jeff’s IBM experience includes working in the IBM i OS development group, specifically as lead architect of the security development team, where his responsibilities included architecture, design and development of IBM i security. He has also served as a council member of the IBM security technical community.

  • The Best of ACS - Scott Forstie and Tim Rowe

    Contains 1 Component(s)

    In this session Scott and Tim will use ACS to show best practices in managing and administering the database as well as other aspects of the system.

    IBM i Access Client Solutions (ACS) is the strategic member of the IBM i Access Product Family, and it is a platform independent client that is supported running on multiple Operating Systems like Macintosh, Linux, and Windows. In this session Scott and Tim will use ACS to show best practices in managing and administering the database as well as other aspects of the system. Come to this session to learn about all the great features available in ACS for the database developer and administrator, and how they are in many cases better than what you've been using!
    Learning Objectives:

    1. Discover the latest features in Run SQL Scripts, SQL Performance Center, and more
    2. Revisit the IBM i system access and management strategy
    3. Live Demo !!

    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.