Search results

We have a Progress table with a few fields that are using extent (about 4 extents for each field with different data format). When I use PRO_ELEMENT such as shown below: ..., PRO_ELEMENT("table"."field",1,1), PRO_ELEMENT("table"."field",2,2), PRO_ELEMENT("table"."field",3,3)...

I try to run the DTS package which has th following statement from my SQL2000 server and get the syntax error. select * from PUB."table_name" with (index=index##name) We have Progress 9.1E SP4 on AIX 5.2 machine. The SQL2000 server is on Windows 2003 which has a DataDirect ODBC driver to...

Hi All, I just enabled 64-bit kernel on one of my AIX 5.2 test server to see if I can run my QAD MFGPRO eB 32-bit application or not. I was able to bring the QAD db up and test all the functionality and the system ran flawlessly. I am wondering if anyone has run QAD MFGPRO 32-bit application...

I noticed that after my first dump and load of the database with full index rebuild. The size of some index area is reduced to almost half of its size before d&l even though the data area for that index has never been archived. This is great but I would like to know why the size of the index...

We use binary dump to dump all data on one of our bigest table called 'customer' which is about 13 GB. We got about 7 binary dump files with suffix like .db1, .bd2 etc. My question is how do we load all these bin file back into the table? And should we load the last file first (.bd13) or...

Hi All, I am testing an in-place coversion on the production db from MFGPRO eB SP5 to eb 2.1 SP5 with Progress OE10.1A02. I am following QAD eB2.1 Conversion Guide - Progress Database and run into a strange problem... The conversion fail to update the source schema using the delta schema file...

Hi All, We have a warm-spare db on a different server. I am wondering if I can ship the filled AI extents over and roll forward while the db on this warm-spare server is online. The reason is that warm-spare database is also being used for running report during the day (before the next refresh...

Hi All, I try to pull the data from a Progress array (9.1E) over to a SQL 2000 table using PRO_ELEMENT and I recevied to following error: "...Conversion invalid datatypes on column pair 1 (source column 'pro_element(item_date,1,1)'(DBTYPE_STR), destination column...

Hi All, Do you know that Progress 9.1E has been tested on AIX 5.3 yet? Thanks, Bob.

:confused: Hi All, Is it possible that qaddb can be loaded into multiple test environment? I want to create mutliple test enviroments from the production database and having a start script that user can launch to connect to his/her test database with -ld qaddb. Thanks, Bob.

Hi All, I have a couple of user telnet session that is not log out probably...so they start new ones which in turn leave the old client processes active on the UNIX server. I can only disconnect these stranded sessions manually on the following day using promon, and using previous day as the...

Can Progress installation directory (DLC), all production db (.db files), parameter file (.pf), db start and stop scripts and all database extents installed on the shared drives in HACMP cluster? This is my dilemma. We have two HACMP nodes and all our production dbs including Progress...

Hello All, I am wondering anyone out there has run HACMP without Fathom Cluster? Or with Fathom Cluster installation directory and Progress $DLC on the shared volume file system? Thanks, Bob.

Hi, I am working on DR and need to move all Progress Installation from one machine to another. We are running AIX 5.2. I am wondering if I can backup all Progress DLC directories using AIX native commands (backup/restore) and restore it on a different server...or do I have to re-install the...