Recent content by Mark2457

  1. M

    Question Search all columns of all tables

    I know how to write the SQL and have ONLY SQL access to the DB (via Linked server), but I'm looking for a way to get a list of all the tables dynamically and search all fields. I can do this with regular SQL DB, but not linked server (that I'm aware of)
  2. M

    Question Search all columns of all tables

    Hi All in MS SQL, I can search all columns for a given value (e.g. %test%). Can I do the same with Progress (using SQL)? Regards mark
  3. M

    Help with QueryPlan

    Thanks
  4. M

    Help with QueryPlan

    Thanks Do I need the "Commit"? Normally only use with explicit transactions is MS SQL
  5. M

    Help with QueryPlan

    I finally got it working on a machine with 32-bit drivers and WinSQL as the client. Puzzled why it doesn't work with a 64-bit drivers and Razor SQL client I need to figure how to run stats on subsets of the DB so we don;t run out of the memory due to the leak Thanks for suggestions
  6. M

    Help with QueryPlan

    Believe me we have told them that! They said that SP is not certified with their product and won;t support us if we install it and something breaks. Problem is they moved to SQL and we're stuck with Progress for the time being because the company we bought had 400 customizations done to the...
  7. M

    Help with QueryPlan

    I tried, but get an error (caused by a memory leak according to Progress KB). Fix is in SP 8 and I can;t apply that (which really sucks)
  8. M

    Help with QueryPlan

    Hi Guys I'm a total noob and using 64 bit ODBC driver to query 10.2B SP06 (can't apply any other SP's as it's a 3rd party vendor product and that's the latest they certify) from SQL client (SSMS, RazorSQL, etc.). Queries are really slow and I'm trying to figure out what the issue sis. Read...
  9. M

    Why does a SQL query take so long to detect invalid col name

    Don't I feel like an idiot now :eek: I'm on server. Was just looking in the OpenEdge programs group in start menu as there seems to be a lot of utils there. What is the command syntax?
  10. M

    Why does a SQL query take so long to detect invalid col name

    So I'm trying to update statistics on the table gams1.pub.ACOptions In Microsoft SQL I'm used to the syntax DBName.SchemaName.TableName this Progress article http://knowledgebase.progress.com/articles/Article/20992 says runt he following: 1. Connect via ODBC or JDBC to the database. 2...
  11. M

    Why does a SQL query take so long to detect invalid col name

    Turns out I'm on 10.B 10.2B Service Pack : 06 Temp. Fix : 00 Build : 1613
  12. M

    Why does a SQL query take so long to detect invalid col name

    I'm using OpenEdge 10.2A with 64 bit ODBC driver and linked server in SQL Server 2008 R2 I run a SQL query that spans 5 tables (probabaly a few thousand rows in each and all inner joins). Query completes in 15 secs (need to improve, but it will do for now). If I mis-spell ONE column name, it...
  13. M

    Total Noob to Progress - Need help with tools

    Hmmm... and the hits just keep on coming :-)
  14. M

    Total Noob to Progress - Need help with tools

    Thanks. Was just looking for our ODBC license and came across a license for MSSQL Data Server, so it seems we have it. How big of a learning curve is 4GL if you know SQL well (just need to write a handful of Stored Procedures to query 5 or 6 related tables in each? Regards Mark
  15. M

    Total Noob to Progress - Need help with tools

    Ultimately, it will be sent to Great Plains (hosted on MS SQL Server). We normally use Scribe Insight: we write stored procedures in SQL server for the source queries.
Top