Rocket® COBOL

[Migrated content. Thread originally posted on 12 August 2008]Hello,I'm new to AcuSQL and I have a question about cursors. I'm trying to write a program that takes a query string from the user, declares a cursor for a select statement, and fetches the results returned by the query. I've managed to do this successfully.The problem occurs when I try run a second query, using a different user-supplied string. The results returned by the second query are identical to the first set of results. The third time I try it, I get the error message "Duplicate cursor name".I declare, open, and then close the cursor every time, in addition to preparing the statement, but it seems that the cursor (or the prepared statement) doesn't get completely closed. My question is this: Is it possible to free the cursor in order to reuse it for a different query? Or am I just going about it the wrong way?Here's the code I'm using:          * run que

[Migrated content. Thread originally posted on 24 March 2008]Hi All -We have been using Totem as our IDE for more than 6 years and are being told that Totem is not being supported on Vista. We want to convert our programs to AcuBench. We would appreciate any information and ideas on moving from Totem to AcuBench. Thank you!

[Migrated content. Thread originally posted on 05 May 2008]Not sure if anyone will know the answer, but I need to know what the formula would be to calculate the interest on a loan using 365/365 and 365/360 methods.The Loan amount is 100,000.00Interest Rate is 6%I currently have a program that will calculate the interest based on 12 months in year, but I need to make updates to that program to handle the 365/365 and 365/360 calculations and I can't seem to figure out how to do it.Any help would be greatly appreciated.

[Migrated content. Thread originally posted on 14 May 2008]Hello to everyone, I have a serious problem with interoperability with acucobolGT (7.0.1 and 7.2.0 for Windows) and Java.I have a java class (called from acucobolGt) that merge several (500-600) PDF documents in one (big) PDF (about 21Mb-28Mb).The designated java class perform this steps:1 - extracts (one to one) the name of the PDF documents to merge contained in an array of string2 - read the source document 3 - add the source document to the destination PDF4 - update (write) the destination PDF on the disk5 - repeat the steps (1-4) until the source PDF documents endswhile the class perform this steps the memory usage grow until 92Mb, at this point the class exit abnormally without generate exception or other error. In the beginning I thought that the problem depended for the class that I used but changing the method I noticed the same problem at the same size of memory used (about 92Mb).Someone knows if there is a limit of

[Migrated content. Thread originally posted on 14 May 2008]Hi,I want to use the * sign as a tab. In the configuration file I have added the line "KEYSTROKE EDIT=Next Terminate=9 42.This works fine but when I use it in a grid he always leaves the grid and goes to the first entryfield. I am using thin client in a Unix environment. Has anybody an idea how to solve this.

[Migrated content. Thread originally posted on 22 May 2008]I have raised these issues before and just want to share the fact that PKWARE have a command line version of their windows PKZIP family of products called PKZIPC (version 400). It works perfectly with long file names and solved all our problems.download at http://www.pkware.com/download-softwareKeith

[Migrated content. Thread originally posted on 01 May 2008]Hello,Has anyone here worked with PDF Factory?:confused:

[Migrated content. Thread originally posted on 25 March 2008]Hello everyone, we're considering use a .NET component to build up a new program in an existing application: all data's must reside on Vision files due to being useful for other part of the application but graphical look and feel and operativity forces us to use a .NET component. Now we wonder to choose the right approach:1) build a .NET program that talks to Acu for the data i/o and business logic of data's2) build a Cobol program that includes (more than one) .NET objects and manages them?Main app may be running on Thin environment just for performance purpose not due to remote accessibility.Any suggestion to make the right and easier choice?Thank in Advance, Gio.

[Migrated content. Thread originally posted on 01 April 2008]Hello everyone .. I have some questions that I hope I help solve .... -- Imagine a server with Windows Server 2003 for 32-bit and imagine a second server with Windows Server 2003 for 64-bit ... 1 ?. There acubech and runtime for 64-bit whatever? 2 ?. I have a different runtime acubech and one for the 32-bit OS and one for the 64-bit OS? 3. The runtime for the 32-bit OS run on the 64-bit OS? ... And if you are then that the provision would have less than 64 bits (for example slow)?. 4. If I have a 64-bit runtime for?, Run in 32-bit? I hope help me with these questions that I postThanks to hand ... CIAC

[Migrated content. Thread originally posted on 12 May 2008]Hi Folks,I have been trying to get a program working that will connect to a web service so I can load information to the site. I used the "sockhtml.cbl" program found in the 8.0 installation sample directory as a basis for accomplishing this. The data returned from the web site is as follows:==============================HTTP/1.1 302 FoundDate: Mon, 12 May 2008 18:57:29 GMTServer: Apache/1.3.33 (Unix) PHP/4.3.11X-Powered-By: PHP/4.3.11Location: http://cenappsdev.redirectme.net/?fConnection: closeTransfer-Encoding: chunkedContent-Type: text/html0===============================I understand the 302 found message has to do with some sort of redirection going on but I'm not sure now what to do about it or where to go from here. I have attached the source program which uses C$SOCKET that makes the connection to the web site and a file that contains the information being sent "CENAPPS.WEB". Any informatio

[Migrated content. Thread originally posted on 17 February 2008]Hello everyone. A few months ago has left the version 8 of acucobol and I have a series of questions that would help me pudieseis .. 1 ?. Version 8 of acucubol runs on 64-bit platforms? 2 ?. The runtime version 8 of acucobol is more rapid in the execution of programs that version 7? I hope I podais help ... Greetings Cordiales Peter.

[Migrated content. Thread originally posted on 09 May 2008]Hi,I am using acusql 7.20 and i want to execute a stored procedure in my cobol program. When i do this the open cursor gives the next error "Attempt to execute nonexistent, unprepared or invalid statement spcurs"I can't find what i'm doing wrong. Maybe somebody else can?I use the next small program to test IDENTIFICATION DIVISION. PROGRAM-ID. magweg. ENVIRONMENT DIVISION. CONFIGURATION SECTION. SPECIAL-NAMES. COPY "SPECIAL.ENV". INPUT-OUTPUT SECTION. FILE-CONTROL. DATA DIVISION. FILE SECTION. WORKING-STORAGE SECTION. COPY "STANDARD.WS". COPY "STANDSUB.WS". 01 num-rows-read PIC 9(09). EXEC SQL BEGIN DECLARE SECTION END-EXEC. 01 num-rows pic 9(09). 01 ret-code pic 9(09). 01 A24-NAAM PIC X(0030). 01 A24-VOORLETTERS PIC X(0005)

[Migrated content. Thread originally posted on 04 March 2008]Hello,The SQL Server gurus say to avoid cursors. Is there any way to pass data from SQL Server to an Acucobol program WITHOUT using a cursor? The examples in the AcuSQL manual all use cursors.Thanks

[Migrated content. Thread originally posted on 09 May 2008]I do not know quite where to start with this - but I would like to be able to call the compress/decompress (zip/unzip) abilities within MS Windows. Does anyone do this already or knows how to go about it?Keith

[Migrated content. Thread originally posted on 13 May 2008]Does anyone have any experience are advice in developing a program to generate cXML files for Ariba ?

[Migrated content. Thread originally posted on 02 May 2008]Hello, againAre there any sample programs (similar to the email samples) that send documents to Microsoft fax?Thanks

[Migrated content. Thread originally posted on 30 December 2007]There has been some requests for the definition file of the Acrobat reader, it is attached to this email.

[Migrated content. Thread originally posted on 21 January 2008]Acucobol Programmer requiredBransom Retail Systems Ltd.We are currently looking to recruit an experienced Acucobol A/P to work within our busy small team of programmers, assisting with the ongoing development of a retail accounts management system for use by the jewellery trade. The successful applicant for this permanent full-time position will be based at our main office in Hemel Hempstead, Hertfordshire, UK. Please read the attached MS Word document for a full description of the work involved. If you are interested in applying for this position, please send a copy of your CV to robf@bransom.co.uk

[Migrated content. Thread originally posted on 06 February 2008]Hi, AllI have a program that displays Excel spreadsheet names in a grid.When I right-click the name I do a "C$System" call that opens the spreadsheet in Excel. When I close Excel and return to the program, the menu has been "disabled". I can click on all the options, but nothing happens.Clicking on another control outside the grid will reactivate the menu. Does anyone have an Idea about what might be causing this?Thanks!!:)

[Migrated content. Thread originally posted on 21 December 2007]Hello everyone, first of all Merry Christmas and best wishes to all!Has anyone an xfd or fd and select of AcuAccess file?TIA, Giovanni

[Migrated content. Thread originally posted on 14 February 2008]hi, in many circumstances i need to have more than one instance of the same program in a runtime unit. I know you can deal with this issue using some multi-thread technique, but the mechanism of "send/receive" is too slow compared to the "call using".So I suggest something like:77 hnw-my-subprogram-1 handle of program.77 hnw-my-subprogram-2 handle of program.then:call "c$factory" using "myprog" giving hnw-my-subprogram-1.call "c$factory" using "myprog" giving hnw-my-subprogram-2.obtaining two different instances of "myprog", and calling each one by their respective handlescall hnw-my-subprogram-1 using par1, par2, par3call hnw-my-subprogram-2 using par1, par2, par3...now assume that "myprog" exposes different entry points:program-id. myprog.procedure div.entry "entry_1" using...entry "entry_2" using...you call the en

[Migrated content. Thread originally posted on 16 February 2008]I would like to use the I$IO routines as part of a generalized DECLARATIVES procedure, specifically for handling locking. What I'd like is for the declarative procedure to get control when a locked record is read, then handle waiting for the lock to be released. The wait would be done by re-trying the read some number of times, with a delay between each attempt. The problem is the read in the declarative procedure. Use of the I$IO routines occurred to me, but I don't know how to get the handle that I need, since the program uses standard OPEN/CLOSE/READ statements. Is there a way to convert the OS handle that I can get by passing the open file to a subroutine to the POINTER/handle that the I$IO routines expect?

[Migrated content. Thread originally posted on 06 February 2008]I'm curious to know if anyone is using Registration Free COM succesfully(on XP/2003/Vista only) with the runtime executable? msdn.microsoft.com/.../

[Migrated content. Thread originally posted on 07 November 2007]Can anyone give a detailed explanation of what these status messages mean? We are calling an Acucobol app from a .NET app using wrunnet.dll. Sometimes when it calls the program it will generate a CS_CONT message. Many times after this status is returned the interface hangs and we have to do an IISRESET on the server to get things going again.Other times we will get CS_RECURSIVE which seems to mean that the resource is busy but it will politely wait and retry the operation. The CS_RECURSIVE status never hangs the interface.Any ideas about this would be welcome. For 6 months we have had the vendor pointing fingers at the Acucobol side of the interface.

[Migrated content. Thread originally posted on 28 November 2007]We are noticing that Acubench seems inconsistent in its use of line terminators in PSF files (and resulting CBL files, etc.).It seems that some lines are terminated with CR LF and some just with LF.This wouldn't be so bad, except that it seems that regenerating a form results in different terminators than it had before.The resulting mishmash of line terminators is giving our version control system (subversion) fits. Or, more correctly, it's giving us fits.Anyone else experiencing similar issues? Anyone have any suggestions?