• Rankerg (5/3/2016)


    Thanks Again and see my inline response

    frederico_fonseca (5/3/2016)


    going to reply to your 4 comments.

    1 - you do not need to migrate to Microfocus - I was just stating what we did on our project.

    regarding the using client calls this goes to application design.

    . application layer

    . data layer

    the above apply to any language being it Cobol or C#

    In our case we had

    . cobol application -> core IO Module (Cobol) -> IMS DB calls

    and we converted to

    . cobol application -> core IO Module (C#) -> Sql statements using SQL Client

    [highlight="#ffff11"]So you converted CORE IO MODULE to C# and IMS DB calls to SQL Statements in the SQL Server, IF yes, then I did not know that IMS DB calls are segregated / Separate like a Client - Server app.

    Now, the IMS DB calls are written in COBOL or any other language like SQL ? because if I ask the COBOL Developer to separate IMS DB calls and show it to me, can he ?[/highlight]

    2 - Show this to your cobol developers - they will most likely understand it and explain to you what I mean

    3 - Any cobol developer will know what to do and the one that supplied the file has probably done it already, but depending on volumes of data it may be better to do it differently - but this is outside the help I can give here. -[highlight="#ffff11"]How else can we meet ?[/highlight]

    4 - to that I ask "Why not?"

    possible reasons why

    . keep extensive business logic intact

    . avoid making same mistakes on code that have already been fixed on cobol

    . reuse cobol developers that know the application without the need for a full retraining in another language

    Obviously all this is going to be highly dependent on what the application does, how extensive it is in terms of both business logic and volumes of data and how it is processed.

    But for me as an Architect it would require that all possibilities are put on the table and then pros and cons analyzed and all alternatives are given so a decision can be taken on the way to go.

    And my question here was not to suggest in any way that the decision is wrong - was only to confirm that the client has indeed taken this option in consideration - seen many that were not even aware they could do it.

    [highlight="#ffff11"]Yes at an Architect Level, I am contemplating what MIGRATION route to go, as I only have 10 months left

    1. Since not much data 500k records, I wask thinking MS Access

    2. PHP and any DB

    3. OO Java / .NET and any DB[/highlight]

    yes the Cobol developer should know what to show you once you give him all my replies to this thread.

    IMS calls can be segregated or not - it all depends on what the developer of the application did.

    Regarding db to store those 500k record.. DO NOT use MsAccess for data storage - for that volume you can go with Sql Server Express (free) and it will be better than Access.

    With such small volume you may also choose one of the other free database vendors - but I can't advise in any as I haven't used any other recently to know they capabilities.

    As for interface anything will do so not giving any advice here.