Other News

Community

LOCATE function in DB2 LUW

We had discussed the CHARINDEX() function in the previous post. Similar to the INSTR (Oracle) and CHARINDEX (MS SQL Server) functions, DB2 has a LOCATE function to search for a string within another string. It returns the starting position of the search string if it finds it within the string, else

Community

Constraint Naming

(Howard Rogers) I work with a wonderful bunch of developers of whom I think very highly. Unfortunately, none of them seem to remember to name their constraints properly! I therefore have about 160 primary key constraints with names of the ‘SYS_C002553’ type -which is a right pain when trying to inte