November 2017

Career Enhancing Technical Intelligence

Issue 26



Using SQL Functions in a DEFINE field in Db2 Web Query for i

In a prior article, I noted that Web Query DEFINE can be used to create a new field in an InfoAssist report. To quickly recap, a field can be created at the row level, with its value set by the expression editor.

Each DEFINE uses the expression editor in some combination of ways. The new field value could be a literal, a value from another field, a calculated value (i.e., price * qty = extended_price), some IF/THEN/ELSE logic within the expression, or some of the many built-in-functions (BIFs) that exist in Web Query. The DEFINE logic is processed for every detail row of the report. (Note: COMPUTE fields operate similarly but apply to summary or aggregated totals in the report, as opposed to detail row data.)

A DEFINE can also be used to create a field that calls an SQL function to return a value when a report is executed. Why would you do this? Perhaps you require a numeric or character manipulation of your data, and no Web Query function exists to perform this task. Because Web Query writes SQL that "communicates with" Db2, the DEFINE allows you to specify the Db2 function you wish to utilize.

Continued at IBM

FREE Report

Take the first step in reaching your GOALS!!!

Learn More Here

FREE Download

iSeries Server - Understanding CCSID

The iSeries and AS/400 servers encode all data stored in database files using a Coded Character Set Identifier (CCSID). This article describes the concepts of CCSID and the OS/400 System Values used to work with it.

Download Here

Microsoft Excel and Word for the iSeries
Learn More Here

SQL Server Reporting Services for Developers

Get the practical and relevant skills needed to build graphic, web-enabled reports using no charge Microsoft tools embedded in your SQL server. There is no software to buy. SQL Server Reporting Services (SSRS), is available with all editions of SQL Server, from Express to Enterprise.

Learn More Here

Word of the Month

Collogue
Verb
[ kuh - lohg ]

to confer secretly

to plot mischief; conspire

Give us your feedback

Click here


To learn more about advertising with us, click here.



Get Started With CICS Performance and Tuning

The first question when starting a tuning project is: What should I look for? With CICS, tuning has changed dramatically over the decades. When I joined IBM in 1978, CICS/Virtual Storage (VS) was a single-platform (mainframe), single-region product that enabled alphanumeric-only, monochrome (green screen), 3270-based applications, processing business functions like order entry/inquiry, customer service, accounting, shipping, etc. I recall re-generating a CICS/DOS system on a small IBM computer, trimming every possible feature to fit the system within available real storage. Tuning was simple back then; the only processing resources to tune were processor utilization, real storage, a few CICS parameters and application code.

VS, a 24-bit addressing scheme that expanded a region to 16 MB (minus OS storage) complicated CICS/VS tuning, because more storage and DASD enhancements meant more real-time data could be processed. Data set layout, channel speed, utilization, disk rotation time and arm movement, and buffering now became vital. Tuning was no longer limited to processor utilization, real storage, some CICS parameters, and user code; I/O became another crucial tuning skill. Relieving one bottleneck only to reveal another became a tuning characteristic.

Continued at IBM

Interesting But Useless Fact:

40% of McDonald's profits come from the sales of Happy Meals.