Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Windows DB2 v8 - v9 Personal Edition Migration Security Issues
Hello, Our developers use Db2 v8.1 Personal Edition we want to migrate these boxes to V9.1 Personal Edition. I am stuck on Security problems. In v8.1 we Created 2 local groups DB2USERS and DB2ADMNS; 2 local Users: DB2ADMIN, DEVUSER. Then we added the developer's Domain/LOGIN ID to both... -
LIKE without wildcard versus = operator
For example with s as ( select 'no trailing spaces' as istrailing, 'somename' as name from sysibm.sysdummy1 UNION ALL select 'has trailing spaces' as istrailing, 'somename ' as name from sysibm.sysdummy1 ) select * from s where s.name like 'somename' ISTRAILING NAME no trailing spaces... -
LIKE without wildcard versus = operator
If you have trailing spaces i.e. 'somename ' (notice the spaces, although the performance are going to be identical between the two queries. select * from S where s.name='somename'; Will ignore the trailing spaces and return all matching rows. select * from S where s.name like... -
How do you change the date format from YYYYMMDD to MM/DD/YYYY
Format MM/DD/YYYY is USA format. To change the format, you can bind the collection of db2 utility packages to use a different date format. The formats supported are: DEF Use a date and time format associated with the territory code. EUR Use the IBM standard for Europe date and time format. ISO... -
FOR FETCH ONLY WITH UR under nested select
Thanks, I had to put WITH UR outside the full select. It worked. UPDATE TEST_STAFF S2 SET DEPT = (SELECT DEPT from PRODUCTION_STAFF WHERE JOB = S2.JOB ORDER BY SALARY FETCH FIRST 1 ROWS ONLY ) WITH UR ; -
FOR FETCH ONLY WITH UR under nested select
First of all, I am new to DB2 (3 weeks). I want to update a TEST table with PRODUCTION table in a nested select with read only with uncommitted read. and i got following error: Please let me know if it is possible to do what I was trying to achieve. Thanks in advance!
