Operator

Mainframe JOB to run CLIST or REXX In case you have figured out a repetitive task that you have to do on various members of various pds’s, Here’s a job that can do it for you. The following job can be used to run a CLIST/Rexx or a macro in batch. Isn’t that cool? //BATCHCLI   […]

 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”,                                

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

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

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

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

How to create a DB2 Table? The following query can be used to create a DB2 table An example is shown below Emp_Number CHAR(10) NOT NULL WITH DEFAULT, Emp_Salary DECIMAL(10,0) NOT NULL WITH DEFAULT, Emp_Sec_code SMALLINT NOT NULL WITH DEFAULT ; ; ; ;

IP Address for CryptoTerm Hi, I have downloaded CryptoTerm emulator from this site.But I don’t know how to use it.It’s asking for IP address while trying to open it. Can you please let me know which IP address need to mention there? “; ; ; ;