- Blog
- Blog
- Homepage
- Homepage
-
IMS DB: DEDB Vs DL/I database Top Differences
DEDB – Often it is called data entry database. These kind of of databases will be used in Banking industry. And credit and Debit card processing projects. The implementation of DEDB is different from DL/I.
-
Differences: DB2 SELECT Vs. Sub-SELECT Vs. Full SELECT
SELECT -The select-statement is the form of a query that can be directly specified in a DECLARE CURSOR statement or FOR statement, prepared and then referenced in a DECLARE CURSOR statement, or directly specified in an SQLJ assignment clause. It can also be issued using SPUFI or the command line processor which causes a result…
-
MQSeries Tutorial for Mainframe Programmers (5 of 5)
On the dynamic queues play crucial role in MQSeries. Read more about dynamic queues.
-
Why ‘SORTWORKdd’ is not Mandatory in DFSORT JCL?
Here I have shown how DFSORT speeds up its sort processing even when you are not supplied the “sortworkdd”. Why SORTWORKdd is not mandatory? Defines a work data set for a sort. Typically, it is not needed because DFSORT can allocate work data sets for a sort dynamically. Why STEPLIB is not needed in SORT…
-
How to ‘Sort’ Input dataset in JCL
Sort card you can write in JCL to select few fields from input dataset and after sorting you can write those records into output file. The JCL is good sort example.
-
10 Top COBOL Compilation Errors With Root Causes
Here is a list of COBOL compilation errors. Also, added root causes so that you can refer to these while fixing your programs.
-
Limitations of COBOL Intrinsic Functions
Rules you need to know on COBOL intrinsic functions.
-
Aggregate functions Vs Scalar functions in DB2
Top differences of Aggregate functions and Scalar functions
-
DB2: CEILING Scalar Function Example
SQL CEIL function explained with best examples
-
DB2 Large object data types- Advantage of LOBs
You can use large object data types to store audio, video, images, and other files that are larger than 32 KB. The VARCHAR, VARGRAPHIC, and VARBINARY data types have a storage limit of 32 KB. However, applications often need to store large text documents or additional data types such as audio, video, drawings, images, and…
-
How to Set Position for File Using COBOL START Statement
The START statement is the best option in COBOL to deal with indexed files. In this post you will learn also best interview questions asked; What is KEY IS How record will START in this file position Exception handling The format of the START statement is given below: START file-name [KEY IS {EQUAL TO GREATER…
-
SQL ‘Aggregate’ Vs ‘DISTINCT’
The power of DB2 aggregate functions well explained with examples and syntax. Especially it covered all the rules related to SQL aggregate functions in a way dummies can understand quickly.
Srinimf 