• Happy New Year 2012

    Dear Readers Happy and prosperous new year 2012. I am taking 2 months commitment to write posts on mainframe tough questions from Jan 1 2012 to Feb 29 2012.

  • 12 On the Job Skills Make Your Career Fruitful

    Some skills on the job learning, in the long run, those provide a way to be successful in your career.

  • IMS DB V11-Latest Enhancements

    I am writing as part of updating IMS knowledge on latest enhancements…read on.. If you really have a new year resolution to get skills on IMSDB, I am recommending some books. DBRC enhancements DBRC now has the option of running on BPE, which gives DBRC additional functionality. You can override the access security for non-production copies of the RECON data set. Transaction…

  • Top IMS DB and DB2 Blogs

    I am just going through the popular databases IMS DB and DB2. I am recommending to read some popular blogs on these. It improves your knowledge and, if apply it your skills will improve. Top Blogs DB2 Blogs Mainframe-Srini Blogs (has all mainframe technologies information) IMS DB Blogs In my next posts I would like to give solutions for…

  • 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.