INSPECT TALLYING FOR LEADING SPACES The following COBOL program depicts the use of INSPECT TALLYING FOR LEADING SPACES     01 TEST-STRING  PIC X(40) VALUE SPACES.     01 WS-COUNTER   PIC 9(9)  VALUE ZEROES.     01 SEARCH-STRING PIC X(2)  VALUE SPACES.        MOVE ‘ […]
COBOL INSPECT TALLYING FOR LEADING SPACES Read More »
NOIDA 5 Address Tata Consultancy Services (TCS) Can any one please provide the complete address of  NOIDA 5 Address Tata Consultancy Services (TCS) ? “; ; ; ; I heard its near the NOIDA GREATER NOIDA EXPRESS WAY. But if some one can provide me the complete address of TCS then it would really help
NOIDA 5 Address Tata Consultancy Services (TCS) Read More »
 What is a plan? A DB2 plan is an executable module containing the access path logic produced by the DB2 optimizer. It can be consist of One or more DBRM or One or more packages or Combination of DBRM and packages A DB2 program needs a plan associated with it for it to be able
REXX AND THE CORRESPONDING JCL TO CONNECT TO DB2 IN BATCH The following piece of rexx code can be used to connect with the DB2 database. REXX Code for Connecting with DB2   QUERY   = “SELECT EMP_NUM”,                Â
REXX to Connect with DB2 Read More »
UNSTRING DELIMITED BY LITERAL The following COBOL program depicts the use of UNSTRING DELIMITED BY LITERAL     01 WS-DATE    PIC X(10) VALUE ‘2011-01-15’.       05 WS-YYYY PIC 9999 VALUE ZEROES.       05 WS-MM  PIC 99  VALUE ZEROES.       05
UNSTRING DELIMITED BY LITERAL Read More »
How to pass data from COBOL to JCL Is it possible to pass data from COBOL to JCL? This is an interview question I read somewhere “; ; ; ; #2 Passing data from COBOL to JCL Well, COBOL can present/pass data to be used later in the job. . . You would need to clarify what you mean
How to pass data from COBOL to JCL Read More »
SQL CODES CODE         CAUSE +100          No rows fetched.  -102          String constant is too long  -117          The number of values you are trying to INSERT does not match the number of columns.  -180/-181    Bad data in Date/Time/Timestamp  -199           Illegal use
IP address using the mainframe id IP address using the mainframe id Is it possible to know the ip address of the user which is logged on a mainframe id, I have seen that some of the mainframe emulators like QUICK 3270 shows the ip address of the machine which is used to log on to
IP address using the mainframe id Read More »
Compare two files and write matching records to a file and unmatched to another I have two files file 1 and file 2 with huge number of records, I want to compare these two files and write the matching records in these files to file3 and unmatching records to file 4. Can anyone describe the
Compare two files and write matching records to a file and unmatched to another Read More »
