I'm using a for loop with a nested find
for each icsp where icsp.cono = v-cono and icsp.prod = v-prod
find notes where notes.cono = icsp.cono and notes.primarykey = string(icsp.prod) no-error.
if available notes then
Let me start by saying I'm entry level efficient in writing ABL.
My co-worker had some scripts that he's started to have me run. We call them QND's (Quick and Dirty's)
Currently I have to launch mpro (the wrapper for us is called sxee) and execute these scripts individually. That is not...
Is there any way to increase the windows size of the Procedure editor for Openedge 10.1B running on AIX Unix?
If I full screen my putty session, the procedure editor only takes up a small area of the screen.
I wanted to find out if Openedge can be run multithreaded? The actual database? We have a AIX system with 8 dual cores. I spoke with IBM and we determined it's not using the system to it's full potential.
We use a program on top of Openedge called SX Enterprise. Runs in windows and is a client. The people that sold it to us say we can't run 64bit Openedge with application.
We're not happy about it, but it is what it is. Trying to squeeze as much performance I can out of the 32bit DB.
What is the output of "lparstat" and "lssrad -av"?
bash-3.2# lssrad -av
REF1 SRAD MEM CPU
0 15272.00 0-7
1 15757.38 8-15
System configuration: type=Dedicated mode=Capped smt=On lcpu=16 mem=32000MB
%user %sys %wait...
We are currently running AIX 7.1. Has 8 power5 cpu's (16 cores) Openedge 10.1b 32bit (can't run 64)
I have a ticket with IBM about this issue, but I'm starting to believe it might be a openedge issue?
What seems to be happening is all the odd number cores aren't being utilized like the even...
I'm basically connecting odbc via the jar files. (openedge.jar)
Where would I apply the -RO flag? In the program I'm using, I might be able to adjust the connection string if that's where that flag is implemented.
I'm working on extracting data from a progress DB. I'm trying to avoid inadvertently writing over data. ( Using a data integration tool and would prefer to not fat finger or cause data to be written over)
I know permissions are set in the sysdbauth table, but which need to be set for read only...
I've been looking for some suggestions on how to implement this.
We have a progress database that has customer data already in it.
We're trying to implement a CRM solution using the data from the customer tables in progress.
Looking over the CRM forums, I think I have 2 choices.
Thanks for the comments.
Let me back up here a second. I might be addressing multiple problems, so I'll start with one.
Our Disk subsystem is a IBM FastT. There are 5 arrays each raid 1. The AIX system sees 5 disks.
Now I would think that if we say hdisk10 which is array1 (4 disks...
Let me first say, I am not a expert progress DBA. I do have some knowledge, but I am looking here for some direction.
Currently we run progress 9.1. Will be upgrading to 10.1 soon, but I'm first having to look at some performance issues.
We run a program called SX enterprise on top of...