MS4 & Vision – Vision User Group Conference 2010 – In Full Swing

Improve the way you turn data into information using tools to analyze, communicate, and share results. Learn the basics of this report-writing software including sorts, selection criteria, group creation, summary fields, drill-downs, section formatting, and creating formulas. Instruction also covers the basics of database linking as it relates to PC and ODBC databases.

Audience: Anyone needing to access and report on MS4 application data

MedSeries4 applications contain more than 40,000 fields, each one a little packet of potential information. Understanding and utilizing this huge database of information can be a daunting task without an understanding of the design logic behind 25 years of MedSeries4 application development. Like a genome, MS4 application data is built from a simple-to-complex arrangement of data, each with its own distinguishing characteristics and attributes. Our workshop starts at the highest level and dissects database structures down to their most atomic characteristics and concludes with a hands-on introduction to the Query/400 Reporting tool.

Audience: Anyone with a desire to understand MedSeries4 database structures and reporting tools. This workshop is a prerequisite for upper division Query classes.

Query/400 is an excellent tool that lets you quickly design ad-hoc reports for organizing and reporting information, testing data, or creating a database for external use. The Query – Beginning workshop offers a basic, hands-on overview of IBM’s Query/400 utility. This tool is not specific to any application and emphasizes designing, formatting, and running a basic Query definition. There will also be class time for individual exercises. You must complete this course prior to taking Intermediate or Advanced Query training available at the Vision conference.

Audience: Anyone needing to access and report on MS4 application data

Use more sophisticated techniques to turn up the heat a notch in Query definitions. Building on skills learned in Beginning – Query, the Intermediate – Query workshop continues work with joined files, result fields, and other complex Query functions. There will also be class time for individual exercises.

Audience: Users with a basic knowledge of Query/400 who need to access and report on MS4 application data

Despite rumors of its demise, Query/400 continues to remain one of the most popular applications for informal, ad-hoc reporting needs. This advanced workshop explores new ways of squeezing more functionality from this venerable tool. The three hour, hands-on session adds new techniques for advanced screen formatting, file recursion, output to IFS, matched and unmatched record functions, views (your own logical file), parameters, and more.

Audience: Users with a good knowledge of Query/400, and a working knowledge of SQL and MS4 database structures

SQL Advanced is where you will learn more complex SQL tricks including functions and table joins. Explore the case statements and functions that can make your SQL statements more powerful than most people realize and make the data manipulation/management much easier.

Audience: Advanced SQL users