It looks like the ODBC driver is timing out our query that executes for more than 30 seconds. How do we set the timeout. It's not in the UI for the ODBC properties and I can't find anything in th...
http://www.experts-exchange.com/Database/Miscellaneous/Q_11669559.html
Zones:
DatabasesDate Answered: 10/26/2000 Rating: 7.8 Views: 0
where can i find an quivalent of TOAD client (oracle) or SQL Navigator for DB2 Database?
the db2 command centeris very primitive and simplistic. i want a software like TOAD client. is there a soft...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20074744.html
Zones:
DatabasesDate Answered: 02/24/2001 Rating: 7.8 Views: 0
How to find out the number of days between 2 dates?
E G current date - date('2001-03-28');
HArsha
http://www.experts-exchange.com/Database/Miscellaneous/Q_20098118.html
Zones:
DatabasesDate Answered: 04/03/2001 Rating: 7.4 Views: 0
I have a script of DDL that creates Tables and Constraints in SQL Server. I want to execute this script in DB2. I have made all the changes compatable with regard to datatypes to DB2. I wanna know ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20103446.html
Zones:
DatabasesDate Answered: 04/13/2001 Rating: 7.6 Views: 0
Hi all :->
From what i know different database will support different sets of sql syntax like for select the first 5 rows -
in sqlserver and ms access
"select top 5 from..."
in oracle
" ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20144355.html
Zones:
DatabasesDate Answered: 07/02/2001 Rating: 8.2 Views: 12
Hi,
Iam facing frequent Locking of some of the Tables in DB2.
My application uses JSP(In WebSphere) and DB2.
my application flows like this..
i'am creating a connection object from jsp, pass...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20230272.html
Zones:
DatabasesDate Answered: 02/12/2002 Rating: 7.8 Views: 0
Hi,
i have two tables. total_time contains total time while busy_time contains the busy time (i.e. time
which has been assigned).tt_id is PK in total_time and FK in busy_time. bt_id is PK in bus...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20295348.html
Zones:
DatabasesDate Answered: 09/21/2002 Rating: 7.6 Views: 4
I have been using MsSQL and and porting to IbmDB2. In my apps I make low-level calls to SQLExecute. With MsSQL and Sybase, I found that I could get fantastic performance improvements by stringing ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20298059.html
Zones:
DatabasesDate Answered: 09/05/2002 Rating: 6.8 Views: 0
Hi, I need some code samples of executing a DB2 stored procedure running on an IBM 3090 Mainframe. Supposedly some of our techs have been able to get the stored procedure to execute and even get s...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20327506.html
Zones:
Visual BasicDate Answered: 03/08/2003 Rating: 9.0 Views: 0
I need do a employee salary year summary report. because employee will change department or leave company, so I need show employee's LAST infortmation in report. but DB2 have not a Last() function,...
http://www.experts-exchange.com/Database/DB2/Q_20347768.html
Zones:
DB2Date Answered: 08/17/2004 Rating: 7.4 Views: 0
