Rocket® COBOL

[Migrated content. Thread originally posted on 26 August 2005]Hi All.Has anyone experienced deadlocks using acu4GL to MS SQL 2000?I have communicated with Martin Nabbs, and have accumulated the available related acu documentation on the subject.What I would appreciate, is to be able to discuss the subject with someone else with the same or similar problem, who may or may not have succeeded in over coming it, with the intention of determining the most effective solution.RegardsRichard

[Migrated content. Thread originally posted on 13 October 2005]Hello everyone, I'm testing the use of ZLIB protocol for AGS_SOCKET_COMPRESS and I noticed a strange behaviour in aAcuConnect/ThinClient system: if I use C$Copy to transfer a file from a client to server if AGS_SOCKET_COMPRESS is setted to ZLIB in tha cblconfi runtime file, sometimes the destination file is created but at 0 byte and it's really empty.The strange thing is that the thing sometimes happens and sometimes no: with debugger open 1st time works well and 2nd fails, without the debuggere activated 1st and 2nd time works and 3rd fails. The server is a Linux Mandrake distr. with glibc 2.2 libraries.Has someone experienced a similar behaviour?TIA Giovanni.

[Migrated content. Thread originally posted on 28 October 2005]Hello everyone, I'm experiencing preformance problems with C$COPY used to transfer file from client to server via thin client (ver.7.0) environment. Transferring 40/50 Mb files evn using ZLIB or noneAGS_SOCKET_COMPRESS option on a Linux server at the 2nd C$COPY launched runtime starts to struggle to deliver bytes to destination file (after an initial exploit of 3/4 Mb after 3/4 seconds) it starts transferring 2/3 Kb every 3/4 seconds and so it goes till the end. Moreover: Acuthin.exe process memory usage passes from 5/6 Mb before starting C$COPY, to 12/19 and even 35 Mb (on an XP Pro client) and it doesn't scale down after C$COPY termination.One more thing:the whole process seems to be faster tranferring from server to client than from client to server.Has anyone experienced similar problems?Has anyone idea of what it can depends on? (we've already tried to switch off anti-virus softwares but with no valuable di

[Migrated content. Thread originally posted on 30 September 2005]We have a called "entry point" program that opens a file, reads a file sequentially, closes the file and exits. When the program that called the "entry point" subsequently attempts to open the file an extended status code of 94,00 is returned. I can find no reference to a 94,00 in the code table.This is a LINUX sever, thin client, XP workstation environment. The runtime is set to use the '74' file status codes. Does anyone have a clue.Vins Nash

[Migrated content. Thread originally posted on 18 July 2005]I have two screens docked by having them share the same window handle. The display is subsectioned into separate windows because we have a huge entry program that we would like to have developed by different programmers at the same time. I tried to use the mouse to determine via it's position which screen should be active and am having problems getting a good value back when in THIN client.I initialize the program by displaying screen "B" first and then displaying screen "A" using the same handle as screen "B". Screen "A" is then the active screen. I place a hidden field at the end of each screen and use a "before" procedure to cause the other screen to be active to take care of tabbing. When I attempt to use the mouse to sense the mouse position, I find that under windows the mouse works fine and gives the line position based on the entire window (so I can assume if say

[Migrated content. Thread originally posted on 17 August 2005]Greetings,i try to bring my vision-data into an MSSQL - Server.Works pretty good so far, but:All fields with only SPACE were transformed into . (and therefore our MsAccess databases have problems with the data)I already tried the config entry: 4GL_ILLEGAL_DATA CONVERTED.But it has no effect. AcuSupport told me, that this entry has a bug and does not work correctly (what i can proof!).The support guy has reached his knowlege-limit and all of his suggestion aren't working.Has anyone here an idea? The tables were created with "allow NULL" in some fields .. some other fields do not have these flag .. i can not find the rule behind this. Maybe someone here who knows how to control this flag?I would be glad about any suggestion. Thanks.p.s. i dont use sql syntax .. simply xfd's and the DEFAULT_HOST SQL entry.

[Migrated content. Thread originally posted on 25 October 2005]I have a Grid and in ?Column?s Settings? property, I have defined a column with Data Type ?99?. I want to cause entry termination after the user entries the 2nd digit (return to navigate mode without pressing enter). In other words, I want to make this grid column act like an entry field with ?AUTO? property set to ?TRUE?.Does anybody knows if I can do this?Thanks

[Migrated content. Thread originally posted on 27 October 2005]Trying to use these configuration values:KBD_DATA_RANGE_LOW 32KBD_DATA_RANGE_HIGH 126to prevent entry of characters outside the ordinary numeric 0 - 9, alpha a-z/A-Z, and special characters. We've found that users can use the alt key and number pad to enter extended ascii values we want to avoid.Is the configuration variable syntax correct? It does not appear to work for us. Environment is XP workstations, Thin Client, Linux.Vins Nash

[Migrated content. Thread originally posted on 19 September 2005]Hello,Is anyone having trouble passing SQL Server Varchar fields into working-storage in Acucobol 6.2?My WS area is set up as follows: 01 A-Test-Data. 05 A-Field1. 06 A-Field1-Length PIC s9(4) comp-5. 06 A-Field1-Name PIC X(50). 05 A-Field2. 06 A-Field2-Length PIC s9(4) comp-5. 06 A-Field2-Name PIC X(50).My SQL Code looks like this: EXEC SQL DECLARE COBCUR1 CURSOR FOR SELECT Field1 , Field2 FROM TBL_Test WITH (NOLOCK) FOR READ ONLY END-EXEC EXEC SQL OPEN COBCUR1 END-EXEC EXEC SQL FETCH COBCUR1 INTO :A-Test-Data END-EXECwhere Field1 and Field2 are varchar(50) fields in tbl_Test.When I execute this code, the data from Field1 is lost and the data from Field2 is put into A-Field1-Name. If anyone has had

[Migrated content. Thread originally posted on 27 June 2005]Welcome to the enhancements forum. This is so that we (Acucorp) can get some ideas of the enhancements that our customers want to see in our extend product suite.

[Migrated content. Thread originally posted on 13 June 2005]Management here would like some US companies that have successfully transitioned to ACU-COBOL on an HP3000, or off of an HP3000 to something else... Closer to Ohio is better-we'd like to speak to you...Thanx!Todd MattesonSuperior Dental CareDayton OH937-438-0283 (office)

[Migrated content. Thread originally posted on 29 April 2005]We are developing under the defaults for Acu-Bench. When running a small portion of the older code, the file status for a good read on a sequential file returns spaces instead of 00's. The documentation insists the status returned is 00's. The format of the 2-byte status is defined as X(02). Is there something else we need to do?

[Migrated content. Thread originally posted on 10 May 2005]Hi!I'm looking for someone that has created a MSI package of the AcuThin client installation. Usually the installation is done thru a zip-file, but I have a customer with a 1000 seats so you can understand I would like to use a MSI package instead.Please help me if you or anyone you know have created a MSI package of the acuthin klient.With kind regards from Sweden,Carl-Hugo

[Migrated content. Thread originally posted on 05 July 2005]The ability to write functions that are activated in a manner similar to intrinsic functions. I believe this may part of the new COBOL standard, and that Acucorp will be implementing new standard features a little bit at a time, so I vote for user-defined functions to be one of the features done sooner rather than later.

[Migrated content. Thread originally posted on 21 March 2005]Folks,I need to know if any of you have anything more to offer regarding the comments I've enclosed here regarding SCO Unix & Multiprocessors.What I asked them was when our application is running on SCO Unix would there be any real benefit from the server having dual processors.The server will be running our application via AcuConnect etc and reasonable hit via AcuODBC.Comments from SCO"Hi ShaunI don?t have all the answers but I hope this helps.You?ll need an SMP license for the extra CPU, but I?m not sure about the additional package.Once installed all applications that spawn multiple processes should be able to take advantage of the extra CPU as the O/S will balance the load across the two CPU?s. In unix land this would mean that almost any application would see some sort of benefit, but it?s hard to say without knowledge of the application.It would be fairly safe to say that a database serving ODBC queries wo

[Migrated content. Thread originally posted on 18 April 2005]We would like our developers to always use screen generator's generated code but we realize that there will be times when the generated code has to be manually modified. We are worried thatnewer programmers could potentially lose the changes. Setting the options to not generate would not work since 99% of the screen code would be used.We would like to have a way to intercept the generated code prior to the compile and replace the generated code with the changes - kind of like a precompiler step. Is there any good way to do this?

[Migrated content. Thread originally posted on 28 June 2005]Just as users became 'bored' with the character-based 'green screens', so they are also becoming quite scathing of the 'grey' screens that are forced by not being able to use different colours on buttons.Also, our application runs on industrial workstations and coloured push buttons would greatly help with user input errors (and speed) and well as helping with safety issues.Please note, this would have to be achieved without ActiveX.

[Migrated content. Thread originally posted on 15 June 2005]I apologize if this isn't the right place but I couldn't find an SQL/ODBC forum. We are using Acucobol 6.1 ODBC for this through Excel We are trying to do a select from two tables using ODBC. We have two tables (Files, Student Info and Award Info). The relationship between the two files is not a one key field but is actually three fields (First name, Last Name, student ID). We want to select * from the student info table where student_info.flag1 = Y and student_info.flag2 = Y and there isn't a match in the Award info. We tried to build the key by using the AS option:rtrim(student_info.STU_LAST_NM) rtrim(student_info.STU_FIRST_NM) rtrim(student_info.STU_ID) as student_keyand create the key for the award the same way:rtrim(award_info.STU_LAST_NM) rtrim(award_info.STU_FIRST_NM) rtrim(award_info.STU_ID) as award_keyThe statement would look like:SELECT * from student_info rtrim(student_info.STU_LAST_NM) rtrim

[Migrated content. Thread originally posted on 26 April 2005]Is it possible to use the SQL command TRUNCATE TABLE tableX in Acusql? When I compile my program I get the error message: "parse error at truncate"Thanks

[Migrated content. Thread originally posted on 04 February 2005]Hi,What other External Sorts can be used on a Microsoft Windows Platform?We have tried using the Microsoft Sort, but is doesn't seem to handle variable length records very well.

[Migrated content. Thread originally posted on 17 February 2005]I'm just wondering if my code is a good way to handle threads.The routines are working great, but I know one has to be carefull with threads.PROGRAM-1 fills a grid with data after it has been sorted. The user can click another heading of the grid wich calls the sort-routine again on other data.It's my intention to give the user a message when the sort is taking too long (> 3 Secs). If it's a good way of programming threads, maybe some other users can use the source as well.Kind regards ;-)PROGRAM-1 does the sort and fills the grid.       FILL-GRID.          PERFORM FILL00 THRU FILL99.       FILL00.          PERFORM THREAD "TIMING" HANDLE IN TIMING-HANDLE.       * DO THE SORT AND FILL THE GRID       * END OF SORT AND FILLING GRID.       FILL88.  &

[Migrated content. Thread originally posted on 27 January 2005]Eureka ... it works with the folowing codeCREATE APPLICATION OF EXCEL HANDLE IN olExcel.MODIFY olExcel @Visible = 1.MODIFY olExcel Workbooks::@_Open(BY NAME FILENAME "filename",BY NAME Format xlCSV,BY NAME Delimiter ";",)GIVING olWrkBk.Txs anyway .. I will post this code in forumSee you later at one of the courses in the Netherlands.

[Migrated content. Thread originally posted on 14 March 2005]I want to write data in XML format using AcuXML. The data I want to write is an order with orderheader and orderlines. The order has to appear in one XML file so i made a file description that looks like:FD ORDER.01 ORDER-RECORD.03 CUSTOMER-NUMBER.03 ORDER-NUMBER.03 ORDER-LINE OCCURS 1 TO 99 TIMES DEPENDING ONNO-OF-ORDERLINES.05 ITEM-ID.05 DESCRIPTION.05 QUANTITY.In the XFD the OCCURS is set to 99. In my XML file the group ORDER-LINE occurs 99 times althoug NO-OF-ORDERLINES is 2 for example. I want the group ORDER-LINE to occur 2 times in my XML files. How can this be done?Can anyone help me with this problem?

[Migrated content. Thread originally posted on 01 December 2004]There are a few issues I'd like to address involving Acucorp's help/doc files:1.) In the past, up to version 6.0, a windows help file(.hlp) was provided, which allowed other text editors(like multi-edit) to use context help. Similiar to VB, this meant I could have my cursor on a cobol verb, press control-F1 and see the acucobol help index listings related to that cobol verb. Very useful. Starting with version 6.1 the .hlp is no longer provided, or at least it wasn't there when I installed 6.1 a while ago. Has anyone else seen it?2.) I figured i'd take a look at how Acubench calls context help, assuming it uses the html doc files. But, it doesn't seem to do this. Am I missing something? Is my Acubench misconfigured?:confused:

[Migrated content. Thread originally posted on 13 December 2004]We have a list box with many entries. We allow users to delete items from the box using the Item-To-Delete command. We do this by allowing the user to select a line and answer yes to a message box.Our issue is after the Item-To-Delete command is used the items in the list after the deleted line are not re-numberd. So if the user selects a line item past where they deleted, it will not give the correct result. How do I go about re-sequencing the lines after the delete?Thanks