- Blog
- Blog
- Homepage
- Homepage
-
SQL COUNT(*) Vs COUNT(DISTINCT)
COUNT function in SQL. Explained how to use to avoid NULL values and Duplicate values.
-
How to Say Correctly – If DB2 down will Pre-compilation successful
This is an interview questions if DB2 is down will the pre-compilation successful. Here is correct answer.
-
VSAM RRDS: Fixed Vs. Variable Length Records
The differences between variable and fixed-length records, I have simplified and posted these.
-
COBOL READ NEXT – How to Code Correctly Unlock now
INDEXED files cam be access in 3 ways (Refer previous post). There are key difference on the options especially how they support differenct file options. Below is the complete list file options.
-
3 Top VSAM File Access Modes
VSAM file access modes given in this post to handle VSAM files in COBOL modules.
-
CICS: GETMAIN Vs FREEMAIN to Manage Storage
4 Most searched Technics on how to manage storage using GETMAIN and FREEMAIN commands in CICS. CICS makes working storage available within each command-level program automatically, without any specific request from the application program, and provides other facilities for intermediate storage, both within and among tasks. Design for performance describes storage within individual programs. If…
-
COBOL Figurative Constants How to Understand Correctly
HIGH-VALUE, HIGH-VALUES Represents one or more occurrences of the character that has the highest ordinal position in the collating sequence used. HIGH-VALUE is treated as an alphanumeric literal in a context that requires an alphanumeric character. For alphanumeric data with the EBCDIC collating sequence, the value is X’FF’. For other alphanumeric data, the value depends…
-
3 top Teradata certifications add value to career
The more you need to know about Teradata certifications and the rules behind and eligibility of certification in Teradata.
-
How to Open a Queue in MQseries with MQOPEN
Explained sample MQSeries program with different options of MQOPEN call. A good example to use in your projects.
-
The Real Purpose of DBDGEN Utility in IMS DB
DBDGEN Utility the purpose of this utility for IMS DB programs explained in this article.
-
List of IMS DB Topics for Interviews
The below is the complete list you need to refresh before you take for IMS DB interview: Prepare These Before Your Interview IMS DB Architecture IMS DB DBD declaration. What is PSB and PCB IMS DB DL/I entry. different Calls in IMS DB Tools being used to browse IMS DB database Error handling in IMS…
-
Mastering EXPLAIN PLAN: Improve SQL Performance
Syntax for EXPLAIN PLAN What happens when you issue EXPLAIN PLAN? Explanation for Set Query No SET QUERYNO = integer ==>Associates integer with explainable-sql-statement. The column QUERYNO is given the value integer in every row inserted into the plan table, statement table, or function table by the EXPLAIN statement. If QUERYNO is not specified, DB2…
Srinimf 