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!
Search results for query: *
- Users: CODEMONKEYBRET
- Order by date
-
DB2 Order By limitations
Like this...? db2 => select * from dtest THETIME -------------------------- 2002-10-07-17.47.57.666000 2002-10-07-17.47.59.058000 2002-10-07-17.47.59.479000 2002-10-06-17.56.43.642000 2002-10-05-17.56.51.253001 2002-10-07-15.56.58.744001 6 record(s) selected. db2 => select date(thetime) as...- CODEMONKEYBRET
- Post #3
- Forum: IBM: DB2
-
Index question
I don't think you can do that! I think the only way round this is for you to add a year column to your table and index that (pretty poor really!)- CODEMONKEYBRET
- Post #2
- Forum: IBM: DB2
-
[IBM][JDBC Driver] CLI0615E
the default DB2 UDB port number is 50000... have you set yours differently?- CODEMONKEYBRET
- Post #4
- Forum: IBM: DB2
-
[IBM][JDBC Driver] CLI0615E
the default DB2 UDB port number is 50000... have you set yours differently- CODEMONKEYBRET
- Post #3
- Forum: IBM: DB2
-
How do I run db2cmd in a silent mode?
Assuming Windows?? I've never really got this to work either! The closest I got was to start running the batch files in a db2cmd shell (i.e. Start->Run->"db2cmd") then to run sql files, I use... db2 -td; -v -f <file>.sql ...where... -v will turn off verbose output -td; means...- CODEMONKEYBRET
- Post #2
- Forum: IBM: DB2
-
SQL0518N - Java loosing prepared statements
Hi there! I've been having problems with PreparedStatements in Java connecting to DB2 V7.1 UDB FIXPACK2 on Windows NT Server 2000. Basically, we have a java object that manages database connections and transactions. It prepares statements, uses them and stores them if they need to be used in...- CODEMONKEYBRET
- Thread
- Replies: 0
- Forum: IBM: DB2
