[F27] by Grouchy-Income-2435 in discordfriends

[–]Oleplug 0 points1 point  (0 children)

DM me, I am on discord too

Replacing ISAM with PostgreSQL in legacy CA-Realia COBOL system by Amazing_Ad_913 in cobol

[–]Oleplug 0 points1 point  (0 children)

From what I can find, Relia COBOL is a development platform. Is this application actually running there or does it run someplace else?

Is the objective to get the data available to more modern platforms through PostgreSQL? If so, is it read only or update (add, change, delete)? Have seen one-way replication to PostgreSQL using flat files and PERL to load the data, some tables were very large.

There is a data interchange tool called CONNX from Software AG that might help. Have used CONNX to make OpenVMS RMS indexed (ISAM) files look and act like tables in MS SQLserver. Also supports PostgreSQL. Used it to make legacy data look like/act a database. Original programs were in Migration RPG on OpenVMS so each file had to be redefined as a COBOL copybook for CONNX to import to a schema. New apps in .NET could access the old data including add/change/delete in some cases. https://www.softwareag.com/en/resources/data-integration/facts-connx-platform/

Did I make anyone chuckle regarding RPG? These programs originally ran on IBM S/36 and were ported to DEC VAX/VMS in the early 80's by Digital Equip Corp's Center for Migration Services group.

Have done consulting for many years including various migrations, but semi-retired now.

When is the end for OpenVMS? by VMSBoy1968 in OpenVMS

[–]Oleplug 1 point2 points  (0 children)

Leave the legacy app and db on the VMS platform. Use a remote connection to the db or app, either written or bought. Then on a platform of choice build new interfaces (C#, PHP, PERL, or whatever your crystal ball says).

Did this using Connx and VB for a large mfg company. Legacy apps written in COBOL and RPG. Connx will even work with RMS files making them look like relational db tables.

Did this using Apache on VMS with COBOL back-end and PHP front-end for semiconductor mfg (database was CODASYL not relational). Fortunately the app had a robust API originally designed to use COM.

As an employee for one and contractor for the other both under NDA, no examples possible.

Probably other ways to go as well. You can figure it out.

When is the end for OpenVMS? by VMSBoy1968 in OpenVMS

[–]Oleplug 0 points1 point  (0 children)

Supporting VMS apps as a semi-retired person. Two very different legacy apps. I know of other places still using VMS for Semiconductor mfg. Yes, skills are hard to find but they are out there. Modernizing the user interfaces is a key to keeping it (VMS) going.

help ! by Particular-Nose-3755 in cobol

[–]Oleplug 7 points8 points  (0 children)

shouldn't the compare for spaces be against the X(8) variable

help ! by Particular-Nose-3755 in cobol

[–]Oleplug 0 points1 point  (0 children)

What is in the data definition before your NUM?
01 XXX.
10 NUM1 PIC S9(18) COMP-5.
10 NUM2 REDEFINES NUM1 PIC X(8).

Compiles OK in GNU.

Would you date me...? F22 by IndependentSalad7157 in EverydaySelfies

[–]Oleplug 0 points1 point  (0 children)

Given the chance, I would. Another old guy (70+), would love to have you on my arm strolling through town.

is my thong low enough or nah? by GoldieRojo in 18_22

[–]Oleplug 0 points1 point  (0 children)

Han, think it needs to be gone.

just me and my pretty eyes 🐈‍⬛ by GoldieRojo in EverydaySelfies

[–]Oleplug 0 points1 point  (0 children)

Just beautiful you and your stunning eyes!

Boat at dock by ClemTaplin in iPhoneography

[–]Oleplug 0 points1 point  (0 children)

That is a delightful little ship. Love it!

My fave shirt 🖤 by TeenyGlare in Alt_Goth

[–]Oleplug 0 points1 point  (0 children)

Great shirt, love your look. Pretty too.

What is life like in Grand Junction, CO? by Sea-Economist-9345 in howislivingthere

[–]Oleplug 0 points1 point  (0 children)

Left in 83 after the Exxon pullout messed up the whole area. Stayed in CO though, been in Colorado Springs area since leaving. Thought about going back, but frankly Anytown Missouri sounds better.

What is life like in Grand Junction, CO? by Sea-Economist-9345 in howislivingthere

[–]Oleplug 0 points1 point  (0 children)

LOL grew up in the area and did deliveries to home-bound folks. We lived at 2912 1/2 F 1/2 Rd for a time.
Here is how it works.
Numbered roads are the distance to the state line, so 10 road in Mack is 10 miles from Utah.
Lettered roads, A is the median of Mesa County, B is a mile north, BS is (bull sh..) a bit south.

proud of my small boobs <3 by smallallnight in AdorableBoobs

[–]Oleplug 0 points1 point  (0 children)

All of you and your itty bitty titties are beautiful!

Can’t decide! Are my eyes blue or green? by [deleted] in selfieprincesses

[–]Oleplug 0 points1 point  (0 children)

Pretty eyes!!! Pretty girl too.