-
SQL max function ideas to use correctly
SQL max function explained using best example Read More ⇢
-
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… Read More ⇢
-
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. Read More ⇢
-
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… Read More ⇢
-
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… Read More ⇢
-
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… Read More ⇢
-
DB2 Tutorial For Software Developers (5 of 5)
The best DB2 tutorial that covers index, synonyms,alias and DCLGEN. Read more. 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.View post to subscribe to site newsletter. Read More ⇢
-
How to Create Tape Dataset in JCL
JCL Tape datasets and its parameters with syntax Read More ⇢
Srinimf 