Search results

  1. K

    Access table in for loop in nested find

    I'm using a for loop with a nested find for each icsp where icsp.cono = v-cono and icsp.prod = v-prod exclusive-lock: find notes where notes.cono = icsp.cono and notes.primarykey = string(icsp.prod) no-error. if available notes then My...
  2. K

    For each to retrieve data from two tables

    Genius. Thanks.
  3. K

    For each to retrieve data from two tables

    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...
  4. K

    Openedge Procedure editor in Unix

    I wanted to upload an image of the problem I'm having. I've tried ever emulation that has co#132 li#42 with no success. Thanks
  5. K

    Openedge Procedure editor in Unix

    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.
  6. K

    Past version 10, are any versions of openedge multithreaded?

    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.
  7. K

    Anyone experience working with openedge and aix, 8 cpu dual core system?

    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.
  8. K

    Anyone experience working with openedge and aix, 8 cpu dual core system?

    What is the output of "lparstat" and "lssrad -av"? bash-3.2# lssrad -av REF1 SRAD MEM CPU 0 0 15272.00 0-7 1 1 15757.38 8-15 bash-3.2# lparstat System configuration: type=Dedicated mode=Capped smt=On lcpu=16 mem=32000MB %user %sys %wait...
  9. K

    Anyone experience working with openedge and aix, 8 cpu dual core system?

    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...
  10. K

    creating a read only user for progress

    SQL. 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. Thanks.
  11. K

    creating a read only user for progress

    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...
  12. K

    Jasper Reports with OE10.1C

    Did you ever get Jasper to work with openedge?
  13. K

    Getting customer data out of progress and into a CRM

    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. 1. Replicate...
  14. K

    Tracking down heavy disk I/O w/ Progress and SX enterprise

    Everyone, 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...
  15. K

    Tracking down heavy disk I/O w/ Progress and SX enterprise

    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...
  16. K

    Error Starting Protop

    Just an update. I installed Architect ran proTop and it came right up. This program provides the exact information I needed. Thank you for your help. Kevin
  17. K

    Error Starting Protop

    Opps, I must have missed that when I pasted. I ded get a license for just the OpenEdge Architect and OpenEdge Architect Tutorial I'm installing that and I'll see how far I can get. Again thanks you both for your time. Kevin
  18. K

    Error Starting Protop

    Well, These are the licenses they sent me. What do I need to install for the gui? OpenEdge Architect Tutorial OE Application Server OpenEdge Enterprise RDBMS OpenEdge Replication OpenEdge Management...
  19. K

    Error Starting Protop

    Thanks for the advice. Progress wont give an eval for client networking. Just so it's known. :( Kevin
  20. K

    Error Starting Protop

    Well, I think I'm going to see if I can track down 10.2A and stop trying with 9.1 gui per your suggestion. Thank you very much for your response.
Top