Archivo de la categoría: PROGRESS

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… Read More: How to avoid writing the owner (pub) of the table… »

proquiet base -C enable proquiet base -C disable

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… Read More: How to set the PUB qualifier in the Windows registry… »

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 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… Read More: TOP clause progress (Limit sql) »

————————————————————————————————————————————————————————————————————————————– 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… Read More: fathom adminserver java heap problem »

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

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… Read More: How to set up a secondary login broker for SQL-92… »

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… Read More: Quick Guide to setting up Multi Database ODBC / JDBC… »