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 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… Leer más »
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… Leer más »
————————————————————————————————————————————————————————————————————————————– 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 »
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… Leer más »
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 »
http://knowledgebase.progress.com/articles/Article/18590 Información Article Number 000001100 Environment Progress 9.x OpenEdge 10.x, 11.x All Supported Operating Systems Question/Problem Description How to remove all extents from a storage area. Can I remove an extent that is not empty? How to remove storage areas and data extents. Steps to Reproduce Clarifying Information Error Message Defect/Enhancement Number Cause Resolution… Leer más »