Calcs are the under appreciated part of SEQUEL, I believe. Simple things can be added to you view: field conversion: character to numeric or vis-a-versa convert to date or time conditional logic and just about any calculation you can think of.
The system then retrieves the data you’ve asked for in the format you need. It holds the information about the data you need. For SEQUEL it’s the definition we call a SEQUEL View.
#Ibm i access client solutions shortcuts drivers#
The DB2 database on the i is the most reliable and securable but we provide drivers to other systems.
When Excel was released in 1985, it was liked from the beginning. Whether for simple lists or complex pivot tables.
#Ibm i access client solutions shortcuts how to#
I’ll begin with the reasons companies use Excel, a brief overview of the power of SEQUEL, then how to harness the combined strength of SEQUEL and Excel and finally a demo of the 4 ways to integrate SEQUEL and Excel. If you can take a moment to respond and remember to press the submit button after you have answered the questions. HEATH: Before we begin we would like to ask our audience a couple of quick questions.Today we will briefly show how SEQUEL and Excel can be used together to enhance your Business Information needs. Welcome to today’s presentation 4 Ways to merge IBM i data with Microsoft Excel.