- Blog
- Blog
- Homepage
- Homepage
-
DB2 SQL: How to check Host-variables (2 of 2)
I have provided sample SQL queries to check host variables in SQL IN clause.
-
DB2 – ILLEGAL Symbol
DB2 Illegal symbol error and resolution
-
DB2 SQL: How to check Host-variables (1 of 2)
In this blog, you can find how to give an Array in WHERE clause of IN list. This way of using saves CPU time. Hence improve performance.
-
DB2-Undefined Unusable Host Variable
Rules to define DB2 host variables. Read now.
-
Cobol-Date Function (2of 2)
In Part-1 I have given Date and Time Format in COBOL how we get. Interestingly, there are different date functions in COBOL. Let us see the conversions as below: WS-DATE is any date example format is 01/01/0001 Convert from Gregorian to Integer formats COMPUTE WS-INTEGER-DATE = FUNCTION INTEGER-OF-DATE (WS-DATE) * Convert from Integer to Gregorian…
-
Cobol- Date Function (1 of 2)
Cobol is simple and powerful language. It is evergreen for 100 yrs now. FUNCTION CURRENT-DATE ===> will retrieve current date & Time in the below format. Usage: MOVE FUNCTION CURRENT-DATE(1:8) TO WS-CURRENT-DATE By using MOVE and Reference modification we can retrieve the part of it as needed. 01 WS-CURRENT-DATE-FIELDS. 05 WS-CURRENT-DATE. 10 WS-CURRENT-YEAR PIC 9(4).…
-
COBOL: Nested PERFORM VARYING
In Cobol, to perform loops you will use PERFORM VARYING. The perform within the perform you can say Nested Perform. You need Perform Varying to get data from two dimensional array. Here are my the best examples for Perform varying. Ex: You can find very intersting things in this book-Buy Today . First inner loop will execute…
-
Easytrieve Key statements (3 of 3)
The best sample Easytrive run jcl for quick reference.
-
Mind Machines on sale
Mind machine is an electronic instrument. It is Walkman like device with pre-loaded music. It has a lot of advantages. It has proven history. It increases concentration It increases memory It reduces stress Its effect is Powerful than you result with Yoga/Meditation It increases your learning ability You grasp more when you study in the early morning.…
-
Easytrieve: Here’s Sample Program
How to use Easytrieve a sample program for your quick reference.
-
DB2: DIGITS and SUBSTR Functions
Built-in functions in DB2 SQL are useful for SQL query tuning. Here is my other post on built-in functions. The DIGITS function is similar to the CHAR function. This function converts a numeric value to a character string value. Below example returns a string, which is unsigned, meaning that it is based on the absolute value of…
-
IT-Software Engineers MUST Read website!
Hey software engineers…are you sure your career path? …read on.. software service is new in india. Many people after completing their degrees join in software jobs. But they are not sure what their career path is. I found a good website “IT CAREER COACH“ that every software/IT engineer must read. You can visit it from my Blog. 🙂 path >> Blogroll>> and…
Srinimf 