Rocket® COBOL

I am new to SQL.  Postgresql has a .NET data provider called Npgsql and with it I can do selects, inserts, updates and deletes from my .NET code.  We would also like to use embedded SQL calls if possible.  We have Postgresql installed on a remote computer and access it over the Web.  I found this on the forum: community.microfocus.com/.../8309.aspx, and tried using OpenESQL but if I select DBMAN(ADO) on the SQL tab of my project and then try to connect to my database I get error -19703 Could not make connection; when I select DBMAN(ODBC) I get error -19703 Data source name too long.  COBOL-IT has a COBOL precompiler for Postgresql so maybe that's what we need.#VisualCOBOL

This post is not so much a cry for help but the attempt to start a discussion.I just started to call webservices and the tool to use - according to this forum - was rmnet.So I managed to call HTTPPOST and HTTPGET and was pretty happy.Until I was asked to call a webservice with the method PUT.I tried, failed and asked the support. They sent me a link to a 6 year old post (community.microfocus.com/.../1726138 where the author basically said:PUT and DELETE are not supported, use curl instead.My colleague - the creator of the webservice I have to call - says the only difference between POST and PUT is the word PUT in the call instead of POST.So does anybody know why rmnet does not support PUT ?Can't this dll be changed ? What has to happen that microfocus changes the dll ?I find it so strange (not to say ridiculous) that rmnet supports the creation but not the update and the offered solution means a totally new workflow (to learn a new language, create a file with the call, make a syst

When unit-testing code, when I want to write code for db connect and db disconnect in the current framework, there is no place holder where we can do this a single time for all the test cases for one program.In the unit-testing framework we have entry points which define the program flow, I’ve mentioned the entry points below in the order that it is executed:entry MFU-TC-METADATAentry MFU-TC-PREFIXentry MFU-TC-SETUP-PREFIXentry MFU-TC-TEARDOWNAll these entry points are executed each time a test case is run, so when we write a code for db connect and disconnect in the test program( in any one of the above sections), and I’ve 10 rows in the input CSV file, then the db connect and db disconnect statements will be executed 10 times.This will cause a performance issue down the line when we are running 100s of test cases for a single program. Is there a way we can control the flow or have a section which is executed only once before and after execution of all test cases written?#VisualCOBOL#

I have a UK user who wants to move an RM/Cobol app from a Unix box to Windows 10 PCs. I have been trying to get some info from Microfocus about price and availability for months. I have had contact with 4 different Microfocus employees but can't get an answer from any of them to the following question - "What is the price(UK Pounds) and availability of runcobol for Windows 10 PC 64 bit - 3 user license and  where can I buy if from)?". If anybody can help me I would be extremely grateful. Bob    

We are going to be using the Microfocus Database Connectors with Visual COBOL.  In our SQL data, we are looking to encrypt certain fields using the Transparent Data Encryption. My question is - Does the Database Connectors handle the encrypting/UN-encrypting part when sending the data to/from Visual COBOL program? 

ISSUE:  COBOL record layouts can contain multiple record definitions, and, each one of these records should be represented by its own table.   HOW TO STEPS: In the Catalog Explorer, double-click the File Definitions node.  This action will cause the catalog's file definitions(FD) to be displayed. Expand the relevant file definition, right-click "Record Types", and, select "New Record Type". Enter a name for the record type and click "Add".  The <file-definition-name> tab is displayed, and immediately applies the record type, as indicated by the record type selector displayed at the top of the pane(see image below): In the In Selected column, select each field to belong to the record type.  **Note: Selecting a parent node automatically selects all of its child nodes. If you do not want all of the child nodes, select the parent node for a second time to deselect child nodes.  Click Save to Catalog.  The record type is saved. After adding yo

Trying to read ISAM file via RM/COBOL [In Linux RedHat] and writes in output file. Detail Below : #   Start key is Alternate Record key = Non-Contiguous Split key.  [ Can contain duplicates] #   Read Next. Read Next is resulting in records in below order. [Prime Key is Numeric in file].a. Prime Key 2b. Prime Key 1c. Prime Key 500 and so on.. Output file has records with same Alternate key.Records are not ordered on Prime key.Questions :a. How the records are ordered ? Are the records are ordered on Add/Update Date/Time in file or any other?b. I want record to be ordered on Prime Key. Is  this could be accomplished via changed in some Configuration setting ? c. Is there any other document to refer other than Language/User reference for detail about Alternate Record key?#RM-COBOLAlternateIndexISAM

When debugging in Visual Cobol, if your program displays anything eg.    display "result " some-varthis output ends up in the runw.exe window. How, for all that is holy, do you manage this window? Move it around, decide where it pops up, resize it, anything?If your debuging session is active you just get a busy cursor when you move your pointer to it. If you stop debugging the window goes away. In Net Express you had some control over this window, in Visual Cobol it's just horrible. Case in point, like many others I'm working from home, at the office I have two displays, at home I have one. This is where my runw window ends up, at the edge of the screen, cut off, and I cannot move it. So if anyone has figured out some way to interact with this *thing* - care to share?

Problem: COBOL allows invalid numeric data to be stored in a numeric field.  However, since ODBC does not, invalid numeric data will cause an error to be returned when that data is encountered in a column. Resolution: In order to resolve the issue of invalid numeric data, you can configure Relativity to return NULLs for any encountered invalid numeric data.  This may be accomplished in the new Relativity Designer via the following steps. 1) Select and Connect to the DSN for the table you wish to modify. 2) On the Tools menu, click Options. 3) In the Options pane, click on the Catalog tab. 4) On the Invalid Numerics Return NULL row, click on the down arrow to display the choices. 5) Yes, Except for Record Key Data Items is mostly commonly chosen.  Please see the documentation link below for an explanation of the choices:  https://www.microfocus.com/documentation/relativity/relativity1218/reldbdsn/RM%20Relativity/GUID-6810FD68-103E-450A-9D77-E1

Hi everyone,My coworker has been trying to submit a support ticket for a couple of weeks now.  He need help with his credential as well.  He called the support line but had to leave a message.  Is there a better way to get help?

Problem: COBOL allows invalid numeric data to be stored in a numeric field.  However, since ODBC does not, invalid numeric data will cause an error to be returned when that data is encountered in a column. Resolution: In order to resolve the issue of invalid numeric data, you can configure Relativity to return NULLs for any encountered invalid numeric data.  To do so, you can use the Nullable Column Utility. The Nullable Column utility allows you to choose and apply the nullable settings for all numeric and date columns in your Relativity catalog.  To start this utility in the Relativity Designer window, click Nullable Column Utility on the Tools menu.   The following table describes the options available on the pages of the Nullable Column utility: Option Description Welcome The utility opens with the Welcome page, which explains the purpose of the utility. Click Next button to proceed to the next page of options or click Cancel

Trying to connect with https://api.postcode.nl I keep getting this error."exception":"Authorization not found.","exceptionId":"PostcodeNl_Controller_Plugin_HttpBasicAuthentication_NoAuthorizationHeaderFoundException" I am using "HttpGet" with extra headers.       01  EXTRA-HEADERS.          05 filler           PIC X(13) value 'Authorization'.          05 filler           PIC X value x"00".          05 filler           PIC X(05) value 'Basic'.          05 filler           PIC X value x"00".

Trying to connect with api.postcode.nl using Basic Authorization does not work. I keep getting this result:"exception":"Authorization not found.","exceptionId":"PostcodeNl_Controller_Plugin_HttpBasicAuthentication_NoAuthorizationHeaderFoundException"I use "HttpGet" with extra headers.       01  EXTRA-HEADERS.          05 filler                                              PIC X(13) value 'Authorization'.          05 filler                                              PIC X value x"00".          05 filler       &

We are attempting a migration from HP-UX acucobol version 6.2.0.1 to RHEL Acucobol version 10.3.0.We attempt to run the command:dtconnect.pl prod X78B063 jsc.req jsc.rspUsing:CALL "C$SYSTEM" USING SYSTEM-COMMAND GIVING ERR-RETURN.It returns 255. If I invoke the shell in the debugger, the above command works and returns zero. This is an evaluation copy if that matters.Any ideas?Thanks!!!__John

Hi All,Hope you are well.When importing Visual COBOL Remote Projects (from Linux Platform), is there a way to filter (remote directories and/or files extensions) when the remote initial directory contains a lot of files?Thanks in advance.Franck.

Problem Although the installed version of Internet Explorer is higher than version 9, the MFSupportInfo utility reports it as 9.11.9600.19596 Solution MFSupportInfo is no longer maintained in the Net Express product, so this information can be ignored. The utility is actually reading the information from a registry key that Microsoft no longer updates, and this is because Internet Explorer is no longer supported by Microsoft.

Using a netexpress screen, we have a listbox that users may click entries from by clicking an X next to them.  However, the list display  is very long and always returns to the top of the list once they have clicked the entry, rather than staying where that  last selection was made.

We are evaluating a possibility of migrating customer database from ORACLE to POSTGRESQLCustomer is using Visual Cobol - PROCobol  (Not only (also  java, .NET) -  but we have around 100000 lines of COBOL).Is it practicable (reasonable) to migrate it from Oracle ProCOBOL to OpenESQL POSTGRES? Has anyone tried it, also with other databases?Any hints?

Need help\\documentation on how to add a program to services.This would automatically start when the server gets rebooted. Need the command line or how to submit it to services via task manager? Can a cobol program handle this or????

Dear Sirs,Where do I get the documentation for the Cobol NetExpress 3.1 :Base class libraryGUI class libraryOLE class libraryOLE Automation class library.Tanks,Rogerio Barbosa 

with openEsql assistant it is possible to convert SQL Pictures clauses in Cobol Syntax.SQL_Name nchar(40) not null --> SQL-Name     pic x(40).Is the reverse way also possible?Who know from a tool that haven this functionality?for one data record, this can be done manually, but by more than 100 file-records, this may be helpfullThanks 

Hello VC Forum,in my current project we have to generate JSON from from a COBOL structure which looks like01 jsonStructure. 05 array1Count pic 9. 05 array2Count pic 9. 05 array1 occurs 1 to 5 depending on array1Count. 05 array2 occurs 1 to 5 depending on array2count. 10 subarrayCount pic 9. 10 subarray occurs 1 to 5 depending on subarrayCount.Unfortunately VC compiler produce on the part "subarray" an error:without ODOSLIDE directive: COBCH0144S OCCURS DEPENDING subsidiary to OCCURS only allowed with ODOSLIDEwith ODOSLIDE directive: COBCH0245S DEPENDING ON item subarrayCount missing or illegal.It is maybe possible, to use fix occurs structures, but then we get problems with the called service because of empty elements generated by JSON GENERATE.Does someone have the same problem? Is there any possibility to use dynamic occurs structures with JSON GENERATE or to avoid the generation of empty elements by fix occurs?ThanksAndreas#J

I have a COBOL program for internal use that sends emails to multiple addresses.Does COBOL have a method to check the addresses one by one and return a status? If not, will this method work in COBOL?https://www.interserver.net/tips/kb/check-email-address-really-exists-without-sending-email/ 

After a clean compile of the MF sample program AIRCODE.CBL, I got this statement from the 'OUTPUT';------ Build started ------C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\Community\\MSBuild\\Micro Focus\\Visual COBOL\\v1.0\\MicroFocus.COBOL.CurrentVersion.targets(364,9): error : MSBMF002 - An internal error occurred. Exception text follows:C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\Community\\MSBuild\\Micro Focus\\Visual COBOL\\v1.0\\MicroFocus.COBOL.CurrentVersion.targets(364,9): error : The path is not of a legal form.========== Build failed ==========Time Elapsed: 0.06 seconds I do not know what the 'legal form' means nor how to correct it. 

Hi,my (maybe 25 years old) Copy starts with01 L-VD-Daten sign leading separate.02 MOVE-LVDDATEN.03 Gesamt.05 VNR PIC S9(8)....Trying to compile it in Visual Cobol 5 CobolCopyBook-Project/COBOL-JVM-Poject I am getting 'COBCH0217S Preceding item at this level has zero length' .Is there maybe any directive to avoid this ?Sincerely,Herbert