DB2

Difference in number of day using DB2 days function DAYS – This returns the number of days starting from date ‘0001-01-01’.  SELECT DAYS(‘2010-10-31’) FROM SYSIBM.SYSDUMMY1 This will query will return 734076. If you wish to calculate difference in number of days between two dates then the following query can be used SELECT DAYS(‘2010-10-31’)-DAYS(‘1990-10-01’) FROM SYSIBM.SYSDUMMY1 This […]

db2 interview questions with answers Recently the job market for mainframe programmers is improving and keeping in mind the DB2 job opportunities, I thought of coming up with a compilation of db2 interview questions with answers. What do you mean by foreign keys? Ans:-  Foreign keys are column or combination of columns in a table that

What is a package? A package is a single, bound DBRM which contains optimized access paths to DB2.  Packages are the ouput of “Bind Package” command which takes DBRM as input. There can be one DBRM per package.  Once the package is formed using the DBRM it can be fed to the “Bind Plan” command

UPDATE DATA IN ONE COLUMN OF A DB2 TABLE USING DATA IN ANOTHER COLUMN  There are instances when you wish to add a new column in a table and initialize it  with data from a column which already exists in the table UPDATE table SET Column1 = Column2 table      – Table in which

UPDATE DATA IN ONE DB2 TABLE USING DATA IN ANOTHER TABLE There are instances when you wish to add a new column in a table and initialize it  with data from a column in another table.  SET (A.COLUMN1) = (SELECT B.COLUMN2 FROM TABLE2 B WHERE B.COLUMN_KEY = A.COLUMN_KEY) TABLE1     – Table in which