-
Where to Use Compiler Options in COBOL and CICS Program
Compiler options to compile COBOL module or CICS module you can give before identification division. Then, compiler recognize your compiler options. Read more. Read More ⇢
-
JCL: How to Skip Steps from Proc
To skip a step from proc, I have explained the code you need to add in the JCL. So skipping proc steps this solution highly useful. Read More ⇢
-
32 Complex SQL Interview Questions
Best and complex SQL queries for quick reference to apply in projects and for interviews. Read more. Read More ⇢
-
What is Package in Oracle PLSQL
Here is sample PLSQL package and what it is explained here. Read More ⇢
-
Subquery Vs. Correlated Subquery – Top Differences
Sub Query and Correlated Sub query the real differences and useful for Database or SQL developers Read More ⇢
-
SQL -904 Top Reasons to Get This Error
Resolution for DB2 SQL error -904 and real reason and fix on how to resolve error given in a way easy to understand by beginner to professionals. Read More ⇢
-
Joins and Their Types in DB2 SQL
Joins is a one of the key concept in SQL. In an RDBMS we have tables with one-one, one-many and many-many relationships. So the concept of RDBMS depends on relationship. Why do you need Joins In a Realtime environment, database architect will design relation between various tables. User needs collective data… Read More ⇢
-
How to Create VB File in COBOL
One of the best method to create VB files in COBOL. Really good stuff to and highly useful for all COBOL programmers. Read More ⇢
-
COBOL and SQL – Replace Command
Replace is most common in the production environment. There are many occasions we need to do data manipulation in the application programs. In Cobol: SOURCE-STRING: ‘HARE KRISH NARADA’ INSPECT SOURCE-STRING REPLACING ALL ‘H’ BY ‘#’ Result: ‘#ARE KRIS# NARADA’, similarly you can do for REPLACING BEFORE and REPLACING AFTER. In SQL: SELECT… Read More ⇢
Srinimf 