Search results

Hi, I want to have a database query run automatically on a Progress database. To do that I created a scheduled task to open a certain Excel sheet which contains a auto_open macro. The auto_open macro runs another macro which runs the query and copies data to a new workbook if a certain...

I want to create a qyery in MS Query using the SQL 92 driver but get a -20003 error. The field I query is called date and that is the problem I suppose. I can query all other fields, but this is a reserved keyword in SQL. I tried to add brackets in several forms, but I don't get the query to...

A customer which runs an interface program to update records in our database is facing the problem that the interface is requesting a lock for a record which has a shraed lock on t. After half an hour the lock is cancelled based on the default lock wait time setting of 30 minutes. In the lock...

I am trying to use the strdbmon command (start database monitor) on the AS400 to get some information on the performance of our database on AS400. First I submit a job (sbmjob) and write down the job numer and job queue. Then I start the database monitor and use the previously created job...