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! 
 

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

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.

This video will look at new ways to explore user profiles.  Do you know if your profiles on your system have default user profiles ?   Can you tell what user have *ALLOBJ special authority even if they have that elevated authority from group or supplemental profiles ?   With these SQL scripts and techniques you can quick gain insight and gain some control over the user profiles on your system.

Now halfway through the year, COVID-19 has affected everything from buying habits to business operations, and even tax policies. Learn more about what’s changed in the world of sales tax in the first half of 2020 and what to expect for the rest of the year in our upcoming webinars. Our VP of U.S. Tax Policy, Scott Peterson, will shed light on the current state of sales tax obligations, the changes you can expect to see over the next six months, and how it all impacts your business. You’ll learn:

The COVID-19 tax relief efforts that are still available to businesses

How future tax policy may change as states look to recoup revenue lost from the pandemic

The latest on economic nexus laws and marketplace facilitator laws

Answers to your own questions

This isn't your typical case study; this is the reality of open source: One hundred percent of organizations use varying degrees of OSS, yet we still focus on one particular package or layer when it comes to sharing best practices. The reality is, when we get stuck, it's the configuration and operational interrelationships between packages that matter. This session takes open source support data across multiple organizations to examine three different scenarios that represent the most common issues we see today (in fact, 80% of the cases we see are due to configuration and package interrelationship issues). Justin Reock covers e-commerce, mobile PaaS, and high performance computing examples to illustrate top problems and solutions for stack selection, infrastructure implementation, and production troubleshooting. If you use or are planning to use Apache web server, ActiveMQ, CentOS, Docker, Kubernetes, Nginx, OpenSSL, Puppet, or PHP, these stories cover how most organizations use them. Even if you're not using these specific packages, the information presented here also applies to other technologies.

An explanation of RVI’s ability to accept inbound Accounts Payable emails containing attached invoices, automatically index the invoices, and route the invoices through RVI workflow to the appropriate person.  Workflow Analysis features will be discussed.    

All in a GUI environment  

On the IBM I. That is all available today.

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.

When departments are siloed, they miss opportunities to share information and improve efficiencies. The same is true of your software.  

In this session, learn how companies have increased capacity, generated double-digit growth, reduced time-to-customer, and saved significant shipping costs by integrating their ERP, WMS and TMS software on IBM i.   

You’ll also get brief overviews of these three software products that work alone or in combination on IBM i to help you Make, Move, and Ship products:  

Friedman Corporation’s Frontier ERP software: The best ERP for complex, make-to-order or assemble-to-order products, with real-time online ordering for customers and/or dealers, a powerful configurator, CAD integration, and more.   

Logimax WMS software:  Exceptionally robust, reliable and affordable warehouse management software that integrates with your other systems and shopping carts, with tools for kitting, yard management, cross-docking, and more.  

Varsity Logistics’ ShipSoft TMS software: Multi-Carrier shipping software for Parcel and LTL from within your existing IBMI i-based applications. Supports all advanced shipping processes such as optimization, ship at packing, rate shopping, pick-to-label, and more.

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