Drop Primary Key on DB2 Table How to drop an existing primary Key on a table? You will need to use the ALTER command to delete the primary key from the table. The following is an example of such query. ALTER TABLE Table_Name DROP PRIMARY KEY; Where Table_Name is the name of table on which […]
Drop Primary Key on DB2 Table Read More »
WIN32 Sality Virus remover. Recenlty my machine got infected with WIN32 sality virus. I had avast antivirus installed on my machine and I guess I had disabled it and was using internet, my mistake. This virus crept into my machine and did so much that I can’t even imagine. It slowed down my machine. Apart
WIN32 Sality Virus remover Read More »
Selecting various groups in SDSF Various groups of the Spool listing are displayed. For eg Sysout, sysprint, JESMSGLG, JESJCL etc The details of any of the group out of the group listing displayed using “?” or if the command is issued at the Job level details of all the groups are displayed in one listing
Selecting various groups in SDSF Read More »
The following COBOL program illustrates how to receive data from JCL in a COBOL program        05 PARM-LENGTH          PIC S9(4) COMP.            PROCEDURE DIVISION USING INPUT-PARM.     * COBOL PROGRAM TO USE DATA
COBOL TO RECEIVE DATA FROM JCL Read More »
COMMONLY USED ISREDIT MACRO COMMANDS S.No ISREDIT Commands Syntax 1 ADDRESS ISREDIT “(CCOUNT) = CHANGE_COUNTS”                      2 ADDRESS ISREDIT “(CURL,CURC) = CURSOR”                          3 ADDRESS ISREDIT “(DSN) = DATASET”                               4 ADDRESS ISREDIT “(LCURS) = LINENUM .ZCSR                        5 ADDRESS ISREDIT “(LLINE) = LINENUM .ZL”                         6 ADDRESS ISREDIT “(MEMB) = MEMBER”                               7 ADDRESS ISREDIT “CHANGE P’
Topic / Topic starter Replies Last post Normal topic Order By Clause in DB2 by Anonymous » Sun, 06/19/2011 – 13:56 1 by Anonymous Thu, 05/30/2013 – 02:05 Normal topic Examples of Inner Join, Left Outer Join, Right outer join by Anonymous » Thu, 06/30/2011 – 06:47 3 by DikDude Tue, 05/28/2013 – 20:26 Normal
Autocomplete feature on mainframe Sometimes we feel if we have an autotype feature on mainframe, we would have saved us a lot of keystrokes. We do have this feature and we can enable by following these simple steps ; ; ; ; Step3: enter KEYS command Step4: Set any PF key to AUTOTYPE and exit.
Autocomplete feature on mainframe Read More »
Transferring Data from Spool to a Dataset Many a times we need the data sitting in spool to be transferred to a dataset. We might be researching on that data or the client might be looking for that data. To take care of such requests we can make use of any of the two approaches
Transferring Data from Spool to a Dataset Read More »
Synonyms are used to give some meaningful (alternate) names to the existing tables. These can refer tables which are local to the system, these can not access the remote tables. If a table is dropped then all the associated synonyms are dropped automatically. How to Create Synonym on a DB2 Table? CREATE SYNONYM synonym_name FOR
Synonym of DB2 Table Read More »
