- Blog
- Blog
- Homepage
- Homepage
-
4 DB2 DATE Formats to Read Right now
DB2 date formats complete list read today and useful for your projects.
-
Top COBOL Error Handling Statements
Handling errors in COBOL and the list of common phrases useful to use in your programs
-
Mainframe: 2 Top Ideas on How to Copy a dataset
Two top methods you can use to copy a dataset in mainframe.
-
SQL max function ideas to use correctly
SQL max function explained using best example
-
SQL AVG Column Function: How to Use it
The SQL AVG function computes the average of the values for the column( or expression) specified as an argument. We should not give AVG function on CHAR arguments. This function operates only on numeric arguments. The following example calculates the average salary of each department: SELECT WORKDEPT, AVG(SALARY) FROM DSN81010.EMP GROUP BY WORKDEPT; The AVG…
-
JCL Ideas: How to Restart a step Using Checkpoint
In this post you will know how to restart a step using checkpoint in JCL. Even Though checkpoint concept is little tricky, you have an option to use it.
-
DB2 Questions on Primary Key, View , Static SQL and Dynamic SQL
What’s the advantage of using a view? By using views, you can set up different presentations of the same data. Each view is derived from the actual table data, but each user will see a subset of the data. The main benefit to using views is that they allow you to control the access your…
-
DB2 Numeric, String, Date, Time Data types
Here is a discussion on DB2 supported data types. Explained each for ready reference. Numeric Data types: SMALLINT: As the name suggests, the smallest numeric data type that DB2 supports. These values use 2 bytes of storage (16 bits) and are interpreted as 2s-complement signed numbers, providing a range between -32768 and 32767. INTEGER: A…
-
DB2 Stored Procedure: How to Call Easy Syntax
What is the role of stored procedure in DB2 Workloads in a client/server environment can be moved from the client to the sever by creating one or more stored procedures. Once a stored procedure has been created and registered with a database (by executing the CREATE PROCEDURE SQL statement), that procedure can be invoked, either…
-
DB2 Tutorial For Software Developers (5 of 5)
The best DB2 tutorial that covers index, synonyms,alias and DCLGEN. Read more.
-
How to Write COBOL Logic for DB2 VARCHAR Field
Real usage of VARCHAR in DB2 is to store variable data. Explained in this post how to use it in COBOL programs.
-
How to Create Tape Dataset in JCL
JCL Tape datasets and its parameters with syntax
Srinimf 