• PLSQL Procedures – Top Syntax Rules

    PL/SQL is a case-independent language, unless you specifically set up Oracle to be case-sensitive or explicitly define object names within the “” marks. Audio Post You can also align all long-running code blocks vertically, as follows: Data types Data Type Prefix Example Comment Boolean B lb_employee_status Prefix common variables Date D ld_hire_date   Number N gv_bonus_percentage  …

  • DFSORT: How to Use Conditional Include In OUTFIL

    JCL sample how to use OUTFIL in DFSORT.

  • JCL Sort Interview Questions

    Here are top interview questions on JCL sort. JCL Interview Questions on Sort (Slideshare) Keep Reading

  • Oracle-Shared Pool Concept

    Oracle interview question on shared pool: The shared pool is one of the most critical memory components particularly when it comes to how SQL executes. The way you write SQL doesn’t just effect the individual SQL statement itself. The combination of all SQL that executes against the database has a tremendous effect on overall performance and scalability…

  • PLSQL Complex Interview Questions (Part 1)

    PL SQL interview questions in slides.

  • Top COBOL Features That are Not Allowed in CICS

    Many command level COBOL Features not allowed in CICS program. Below are the statements that are not allowed in CICS Operator communication statements Accept Display File I/O statements Open Close Read Rewrite Delete Start Other statements Accept Date/Time Merge COBOL Vs CICS Compatibility Under CICS, all terminal I/O is handled by the terminal control module, whose…

  • Top Unix Commands for Beginners – Part 1

    Top UNIX Commands cat – display or concatenate files cd – change directory chmod – change the permissions on a file or directory compress – compress a file cp – copy a file date – display the current date and time diff – display differences between text files echo – echo arguments to the standard…

  • PLSQL: Early Vs Late Binding Concepts Simplified

    Early binding and late binding in plsql and real differences.

  • UNIX: How to Use Sed and AWK Commands

    Top ideas to use ‘sed’ and ‘awk’ commands in UNIX.

  • PLI: JCL to Compile,Execute

    PLI procedural language compile and run JCL for quick use in your project.

  • How to get Date and Time in CICS

    How DATE and TIME captured during initiation of transaction in CICS. There is always standard way present to capture DATE and TIME in CICS programs. Read more.

  • CICS – Multithreading And Working Storage

    When you code a command-level CICS program in COBOL, you can use the Working-Storage Section just as you do in any other COBOL program: for program variables and switches, as well as for data areas for terminal and file I/O. When CICS loads your program, it allocates storage for its Working-Storage Section and associates that…