- Blog
- Blog
- Homepage
- Homepage
-
Here’s Difference Between Describe Vs. Declare Cursor in DB2
The DESCRIBE CURSOR -statement obtains information about the result set that is associated with the cursor. The information, such as column information, is put into a descriptor. DESCRIBE Use DESCRIBE CURSOR for result set cursors from stored procedures. The cursor must be defined with the ALLOCATE CURSOR statement. Example 1: Place information about the result set…
-
6 Ideas – How to use JCL GDG Correctly
Quick ideas and tips how to use GDGs effectively in JCL of mainframe projects. Valuable tutorial on GDGs really helpful for all mainframe developers.
-
How to Use TRLUPD in DFSORT
JCL sort TRLUPD parameter to update totals and counts in report generation using DFSORT
-
Ensure These 4 Steps Before You Run DB2 Load
Below four steps you need to make sure before you start the LOAD process. No sorting of the data rows occurs during LOAD processing. Rows are loaded in the physical sequence in which they are found. Sort your input records in clustering sequence before loading the data. Ensure that no duplicate keys exist for unique indexes.…
-
SQL Query to Remove, get Only Duplicates
SQL Query examples useful to remove duplicates and to get duplicates rows.
-
PACBASE For Mainframe Is Not Rocket Science! Here’s Why
PACBASE fundamentals useful for mainframe developers.
-
15 best VSAM Quiz Questions for Mainframe Developers
VSAM also called virtual storage access method. Try these questions. Readily useful for your projects.
-
How to use EXPLAIN in COBOL program
EXPLAIN special register explained how to use in COBOL program
-
Happy New Year 2016
Srinimf.com in service for 6 years. Most popular site across the world. Srinimf.com wishes happy , prosperous, healthy new year for all its readers across the world. Thank you all for keeping this site most successful and one of the best blog/site.
-
JCL GDG Required and Optional Parameters
Top parameters you need to give while using GDGs in a JCL
-
Mainframe Linux Hercules Emulator Helpful Commands
You can learn Linux through on-line courses. If you know already mainframe this is easy to work on Linux mainframe. Lot of jobs available with combination of these skills. What are the different Linux Operating Systems You can run mainframe Linuxes without fear of the license policy. RHEL and SLES are battle-hardened supported commercial editions. Of course there…
-
COBOL: How to MOVE Comp-3 to Numeric
How to move COBOL comp-3 value into numeric format
Srinimf 