Tech.Jobs.Biz.Success

Technology blog,Readers across the world. It contains articles on mainframe,cloud,Analytics,mobile.

Already a Member? Log In to Your Account
Technology blog,Readers across the world. It contains articles on mainframe,cloud,Analytics,mobile.
URL: http://srinimf.com
Added: January 26, 2011
Authority: 28.9743
Type: Website
Language: English
  Analytics :: more
   Latest Posts :: more

Truncate and Delete in DB2

Truncate in DB2: It deletes all the rows from a table TRUNCATE TABLE INVENTORY DROP STORAGE IGNORE DELETE TRIGGERS; Delete in DB2: DELETE FROM TABLE TABLE_ONE; It also deletes rows from a table Difference between TRUNCATE and DELETE you can use follo

Browse Tape File in Mainframe

We can use IEBGENER to copy tape file to Sequential file: //STEP01   EXEC PGM=IEBGENER //SYSPRINT DD SYSOUT=A //SYSUT1   DD DSN=J.TAPE.UST.A, //            DISP=SHR //SYSUT2   DD DSN=PQHL.DASD.UST.A, //         DISP=(NEW,CATLG,DELETE

DB2-Identity Column

Defining an identity column on a new table: An identity column provides a way for DB2 to automatically generate a unique numeric value for each row that is added to the table. When creating a table where you know that you need to uniquely identify ea



  Related Blogs
Language: English
Language: English
© 2006-2014 OnToplist.com, All Rights Reserved