Search results for query: *

Hi all DB2 experts! I have a question for you regarding db2 performance! We have got a table on which there are 20 milion records. When I query the table with the following script " SELECT DISTINCT COL1,COL2,COL3 FROM MYTABLE WHERE STOREID=12345 " it takes nearly three min. to get...

Ahh! Now, you are asking a very qomprehensive question , which is optimization(maximization the performance). The answer to that problem involves a lot of details from opening the recordset properly to designing and maintaining database etc.Well, I am afraid you have to do some research on it...

Hi Tony11, After I have posted my message here I solved my problem regarding accessing SQL Server remotely. Basically there are three solutions to that: First, follow what fluteplr says( I know you don't have that opportunity.) Secondly, use RDS(Remote Data Services).Please don't ask me how...

This is aload of recordsets for ADO. The best thing to do is to implement paging. By doing so you could limit the number of the recordsets to display. The paging could be done on the front end or on the SQL server( by a stored proc). Have a look at " www.4GuysFromRolla.com " and &quot...

Hi Dear fluteplr. What you are saying is very promising. Thank you very much,indeed. Let me explain my problem a little bit more... I have developed an ASP aplication(back-end is SQL Server)and runs on a rented machine somewhere out there(including SQL Server). It seems that we have to insert...

But how do you do that over the internet? This is a burning issue for me at the moment!

Many thanks,Tarwn! To be honest, I haven't devoloped internet applications with VB although I have done some windows programing with it. My question is : Do I have to create DLL? On the other hand I can read the contents of the file( .sql file) within ASP through FSObject but how can I get it...

But How? Any adea?

I have to insert about 200 records into the database remotely every week. I have a bach file which consists of insert statements. How shall I call this file within the ASP pages so that it should be executed on the server and should insert the data into the relevant tables? Perhaps one solution...

Thank you alfredp77. I'll try .

From the other DBMS(non-Microsoft) onto the SQL Server.This has been done by a file written in completely different language,which runs on OpenInsight and populates the database (via ODBC) on the SQL Server. I know "Jobs". In that case, how can I get it recignosed and scheduled this...

I have a database on SQL Server 7. The database has been created and populated via ODBC with a batch file on the source DBMS(non Microsoft) and has been running on the ASP Pages on the local intranet. So far everything is fine. Now, I need to create an ongoing automoted ( maybe daily or weekly...

Acording to Microsoft and many others the best method is to use OLE DB one

the first part of your guess is right. Sorry,the Second part isn't! Let me explain a little bit more clearly then. My ASP page is 'show_timesheet.asp'. When it is called by the search page.asp it displays the dynamic data on it then I pass the necessary variables and the name of the page(which...

Sorry, not quiet! I have been testing the project. I created the downloadable file after using FSObjet and formated the active data on the fly. Then as a client I print it, there is no problem,no ASP code on the browser. But when I download it as a client again I see the real ASP code sitting...

How Can I download the dynamic content of ASP Page without exposing the ASP code? Before I print the same page on the client side , the code is not exposed.But when I download the same page the browser exposes the code.