Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • JCL: How to Use Separator in DFSORT

    Here’s the best example of how you can insert separators in DFSORT. In the above example, inserting ‘*’ 20 times is a separator. Top valid separators: The usage of separators you can find here is OUTREC, IFTHEN, and OVERLAY statement. Wherein the actual values are overlaid with separators. Downloads

  • COBOL PERFORM Varying with UNITIL Logic

    COBOL Perform Varying Until logic useful to search a Table or an Array.

  • DB2: What’s Stored Procedure

    Today’s post What is stored procedure? How many types of stored procedures? What are those? A stored procedure  is a user-written program that can be called by an application with an SQL CALL statement. It is a compiled program that is stored at a DB2 server, and can execute SQL statements. Stored procedures can be called locally…

  • DB2 SQL: How to Write Self-join example

    Self join best example explained on how to use it.

  • 5 Ways to Share Data in CICS Programs

    Below is the list of 5 ways how data sharing happens among CICS transactions: DFHCOMMAREA in RETURN command Common Work Area (CWA) Using CHANNEL command in RETURN Using DISPLAY screen -Data can be stored between pseudo conversational transactions from a 3270 display terminal on the display screen itself Using terminal control table entry area (TCTUA)…

  • How to Re-order fields Using BUILD in DFSORT

    There are two ideas on re-ordering the fields in the output file using DFSORT BUILD option. Option -1 It is you need to write a COBOL sort program. You need to code the fields how you want and write into output file. Click here to know sample COBOL sort program. Option-2 It is you need…

  • Understanding the Logic Behind CICS Record Deletion

    The content discusses the importance of proper planning for coding in CICS programming. It emphasizes the need to understand the sequential order of steps in CICS coding. Additionally, it mentions the CICS logic for record deletion. CICS: Read and Delete a Record First option is READ a record with UPDATE option. The next thing is…

  • How to Use RIDFLD in CICS

    Here are example code on how to use RIDFLD in CICS. This field has importance while READ, WRITE of VSAM files.

  • DFSORT: How to Use FIELDS and BUILD to Delete Fields

    Let us take an example and see, how we can delete fields with FILEDS or BUILD The SORT, SUM and OUTREC statements are as follows Here is an example to use outrec fields in jcl. So, in the OUTREC statement after writing OUTREC give one space and write either FIELDS or BUILD So, in the…

  • 10 DB2 Tricky Interview Questions on Isolation Levels

    Isolation levels in DB2 explained possible interview questions. You can prepare these questions before you attend interviews.

  • 15 Precious Uses of INREC,OUTREC and OUTFIL in JCL DFSORT

    The super best advantages what you can do with DFSORT using sort utility in JCL. Read more.

  • How to Code SORT Logic in COBOL Program

    Sort Logic in COBOL best example Related Posts