-
How to Use DB2 LOCATE Built-in Function
Checkout here my earlier post on built-in functions. LOCATE is a Scalar function. Here is my ideas how to use correctly. Below is the Syntax for LOCATE function SELECT LOCATE(‘String to be searched’, Source string’, Start position)FROM SYSIBM.SYSDUMMY1; Key points in LOCATE function The LOCATE function returns the starting position… Read More ⇢
-
DB2 Tutorial For Software Developers (3 of 5)
DB2 tutorial is good for both DB2 and mainframe developers is it is quick to read and given in the form of questions and answers. Read my part-2 post on DB2 tutorial. Data Definition Language(DDL) CREATE: –This statement is used to create objects Syntax : For Creating a Table CREATE… Read More ⇢
-
Top Data warehousing Interview Questions (Part 1 of 2)
Data warehousing interview questions useful to read before you give an interview or training. Read More ⇢
-
SQL Built-in Functions to write better query
All the built-in functions you cannot use in SQL queries. Some functions help you achieve greater performance in SQL queries. Follow these suggestions to get an idea about alternative SQL built-in functions. Read More ⇢
-
CICS ATI, START Real time Macros for new programmers
Command macros to be used in CICS for ATI and START functions Read More ⇢
-
Easytrieve Guide for Mainframe Programmers (5 of 20)
Read my Post-1, Post-2, Post-3, Post-4 on Easytrieve. HEADING Report headings can be supplied in the field definition of a data item. When NOT coded with the data item, the actual field name is used as a heading. The heading can be specified by simply using the HEADING parameter of the field… Read More ⇢
-
DB2 Tutorial For Software Developers (2 of 5)
DB2 tutorial to learn quickly useful for mainframe developers. Read More ⇢
-
Top IMS DB Status codes Asked in Many Interviews
The most popular and mostly asked IMS DB or IMS DC status codes in interviews. Read More ⇢
-
Advanced CICS for Senior Software Developers(1 of 5)
Learn CICS advanced tutorial for senior developers part 1 Read More ⇢
Srinimf 
You must be logged in to post a comment.