COMMON POWERUp 2021

If your company is doing .NET programming alongside IBM i development, it is important to be conversant about accessing Db2 for i from any Microsoft or 3rd party OO language that uses the .NET Framework. This session will hit all of the main steps required for using this data provider (a part of ACS) in a vb.net web forms style project. We will use Visual Studio Community Edition 2019 as the IDE. This session seeks to show that it is no big deal to get current Db2 for i data into many Microsoft programming environments with little, if any, advance reformatting or data extract steps._x000D_ _x000D_ The detailed example will show how to dynamically churn out a nicely formatted list inquiry on a standard browser web page, using the least amount of specifications. A second virtually identical example is mobile-friendly. The mobile-friendly version is accomplished via use of the responsive master page provided within the base web forms project template. _x000D_ _x000D_ Complete code of the vb.net version will be offered to POWERUp 2021 attendees on day of presentation or via email request. _x000D_ _x000D_ The examples do not require elevated authorities, respect native authorities and allows setup of a *LIBL. The SQL syntax is limited only by your version of Db2 for i._x000D_

Learning Objectives:
1. Be conversant with Microsoft developers at your company regarding this efficient way to access Db2 for i in real time (and without data staging prerequisites such as work files or extracts). _x000D_ 2. See an example of the standard file access technique used in OO programming, where there is no open data path, so files are opened and closed as a part of each data access or data update process._x000D_ 3. Gain an introduction to a working web page and get a taste of the challenges involved in web programming without having to spend a lot of time learning_x000D_ 4. For developers, be able to create and run your own dynamically formatted web page inquiry to prototype and run dynamic SQL statements on physical files, logical files and views with joins etc._x000D_