Srinimf

Advertisements

  • 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… Read More ⇢

    IMS DB V11-Latest Enhancements

  • 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… Read More ⇢

    Top IMS DB and DB2 Blogs

  • DB2 SQL: How to check Host-variables (2 of 2)

    I have provided sample SQL queries to check host variables in SQL IN clause. Read More ⇢

    DB2 SQL: How to check Host-variables (2 of 2)

  • DB2 – ILLEGAL Symbol

    DB2 Illegal symbol error and resolution Read More ⇢

    DB2 – ILLEGAL Symbol

  • 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. Read More ⇢

    DB2 SQL: How to check Host-variables (1 of 2)

  • DB2-Undefined Unusable Host Variable

    Rules to define DB2 host variables. Read now. Read More ⇢

    DB2-Undefined Unusable Host Variable

  • 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) *… Read More ⇢

  • 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.… Read More ⇢

  • 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 .… Read More ⇢

    COBOL: Nested PERFORM VARYING