I realize this isn't directly a Progress question, but does anyone know a good place to get help on deciphering the QAD database?
QAD's ER and data dictionary files are very incomplete and at least sometimes wrong.
I post about these problems on community.qad.com in their BI, Reporting &...
Well, it seems that when I run mpro /mypath/mydb, mpro ignores that database and does not setup a connection to that database. So then I tried
mpro /mypath/mydb -S myportnumber
and I got the error message
The server or the system has no more resources. Please contact Progress Technical Support...
Environment is character mode Linux on a machine with QAD installed. I use putty on a Windows 7 PC to ssh into the Linux machine. I suspect this is part of my challenges.
I have tried to use MPRO to do some ABL commands that clearly won't work running on SQLENV.
I can't seem to copy and paste...
I am reviewing some QAD tables and it appears that Progress lets you define a unique index that has a nullable column.
Is that correct?
This is in an OpenEdge 10.2 database.
(for QAD users, one example table is vph_hist having the nullable columns vph_ref and vph_pvo_id as part of the unique...
I ran dbtool and it appears to do nothing. As soon as I give an answer to the prompt about verbose level, I IMMEDIATELY get back to the linux prompt as if the tool has run and done everything in a nanosecond.
It is actually doing nothing as I the ODBC error messages continue.
I also noted that...
Both of these failed:
select top 10 * from mylinkedserver.mydatabase.sysprogress.systables
select top 10 * from mylinkedserver.mydatabase.pub._file
error message for 1st one:
Msg 7356, Level 16, State 1, Line 3
The OLE DB provider "MSDASQL" for linked server "mylinkedserver" supplied...
The simple ODBC test connection works. The simple linked server test connection works. I can get a list of tables using that linked server. Outside of SQL Server, I can write a powershell script that does a select * from sometable.
I cannot get a Select * from [whateverlinkedtable] to work...
I am brand new to Progress/OpenEdge, QAD (and my new employer). Using QAD/Progress is just part of my duties as their DBA.
So I am looking for something with a little bit easier to use tool to explore the data in QAD than the character mode SQLEXP. What are 1 or a few options? (which might...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.