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

Confusing SQL Queries With Dates

Query to get latest date: Select item, max(inventorydate) from table where inventorydate is < ‘6/30/2011′ Query to retrieve not more than 6 years from application date: Select item from table where appl_date >= (Currentdate – 6 Year

DB2-Subsystem and Instance

DB2 Subsystem In DB2 S/390, a DB2 subsystem provides a separate DB2 environment similar to a DB2 ULWO instance. Several DB2 S/390 subsystems can be installed in the same machine logical partition (LPAR), and they can only communicate with each other

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



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