Archivo de la categoría: PROGRESS
How to avoid writing the owner (pub) of the table (schema) before referencing the table name in the SQL commands
Option #1Use the following statement in the same SQL session prior to running any SQL statements: set schema ‘pub’ Where ‘owner’ is the owner name, e.g. ‘PUB’. It will be valid until the end of the session or until it is changed. Option #2If using an ODBC DSN, set the default schema to the owner in the… Leer más »
proquiet
proquiet base -C enable proquiet base -C disable
How to set the PUB qualifier in the Windows registry to avoid prefixing it in existing reports?
Environment Product: Progress Version: 9.1x Product: OpenEdge Version: 10.x OS: Windows Other: Crystal Reports Question/Problem Description How to avoid setting the pub qualifier before each table name in a Crystal Report ? How to set the pub qualifier in Windows registry? How to use existing SQL-89 Crystal Reports with SQL-92 ? How to set the… Leer más »
AquaData Studio
How to connect progress jdbc:datadirect:openedge://192.168.1.1:13000;databaseName=dbname[-mdbq:listadb];defaultSchema=pub com.ddtek.jdbc.openedge.OpenEdgeDriver C:\Progress11\OpenEdge\java\openedge.jar Fix width progress sql dbtool dbname
TOP clause progress (Limit sql)
TOP clause Limits the rows returned by an OpenEdge SQL query at the statement level and is supported in subqueries. Syntax TOP n[ column_name [, column_name ] …..| * ] Parameters n Indicates the number of records per table. [ column_name [, column_name ] …..| * ] Indicates the columns within a table. When the… Leer más »
fathom adminserver java heap problem
————————————————————————————————————————————————————————————————————————————– The reason why the adminserver starts when disabling fathom, is because this machine has so many CPU’s There’s a bug in the 3rd Party Orient database, which means that we need to upgrade it to get the fix. I now understand why they may have added the parameter: -XX:+UseParallelGC -XX:ParallelGCThreads=4 However their heap size… Leer más »
Progress Explorer AdminServer slow
Before restarting the AdminServer, in order to rule out an issue with a java Ipv6 not releasing ports properly so it ends up with being owned by kernel: Edit DLC/properties/AdminServerPlugins.properties under the [PluginPolicy.Progress.AdminServer] section and add the following to the end of the current jvmargs line: -Djava.net.preferIPv4Stack=true -Djava.net.preferIPv6Addresses=false
How to set up a secondary login broker for SQL-92 connections for Progress 9.1D and above
For Progress 9.1D and later, the method for using the secondary login broker for SQL connections has changed. Databases that have both Progress ABL and SQL clients simultaneously connected should use a secondary login broker to avoid the following limitations caused by the use of a single login broker: The need to establish the maximum… Leer más »
Quick Guide to setting up Multi Database ODBC / JDBC connectivity progress
http://knowledgebase.progress.com/articles/Article/P119452 For the purposes of this solution examples will be made referring to database1, database2 and database3 which are all copies of the sports2000 database. All databases must be started with separate TCP/IP ports. The primary database (database1) should not be included within the database1.oesql.properties file mentioned below. In the directory where database1 resides create… Leer más »