STRING AND UNSTRING with examples: TALLYING and COUNT options String is used to combine two or more strings/variables in to a single string. Examples: 01 name-in. 05 first-name pic x(10) value 'Mahender ' 05 Last name pic x(10) value 'Reddy ' 05 initial pic x(2) value 'G ' If you display the ‘name-in’ it shows
ESCAPE in DB2 Mainframes: In SQL the percent sign(%) and the under score(_) has special meaning. %’ – represents any set of characters _ – under score represents any single character. Ex: select * from emp where email like 'reddy_%'; This will display all the email ids starting with reddy like reddy123,reddy_34 etc. But here
IBM Debug Tool Commands for mainframes a Quick reference F2 – Line by Line Execution F9 – break point to break point execution F10 – Debug in full screen mode Setting Break Point-> – Place the cursor on the line where the break point
CICS scrolling logic looks very simple in algorithm representation but implementing it practically so many questions arises. This topic is to clear all the queries related to CICS scrolling (page Up / Down) logic with suitable examples. Let me give few basic points before getting into detailed implementation logic. Decide the number of rows(MAX-SCRN-SIZE) to
Below are the few online expeditor useful commands for basic debugging of a program. Expeditor Quick Reference → xpediter keep window size – To increase or decrease the keep window size SET KEEP <n> n can be any number from 3
Modified data Tag (MDT) is the most important feature in CICS programming consisting of MAPS. One who involves in CICS programming needs to know the importance of it for efficient coding. It is stored in 7th bit of a attribute byte of a screen field with either ‘0’(OFF) or ‘1’ (ON) as the values.(Every input
ORDER BY DB2 Order by clause is used to sort the result table values by the sort Key order. Here, sort key can be the column name or column number. Results can be sorted either by Ascending (ASC) or by Descending (DESC) order. ASC is the default order by clause. If you do not specify
DB2 Isolation Levels: How Isolation Levels are useful, what are the different Isolation Level types(CS, RR, RS & UR), how it controls the concurrency, What is Concurrency?, which one is better to use among the four types? What are the advantages and disadvantages ?These are the questions we often encounter. So this topic explains these queries
What is a DB2 Lock? It is a Mechanism provided by DB2 to maintain the access to different database objects. What is Concurrency in DB2? Concurrency is a way which enables more than one application to access the same database object at the same time. Locks and Concurrency control is the most important aspect in
Here is the jQuery code to show the character count when the user enters the text in the text area or any input control, it will show the remaining character count as user enters the text in the field. See the live demo here and view the source if you’d like. jQuery Code add the
