Automating MF native file conversion to MYSQL
Might be reinventing the wheel here (?).... I'm writing a program to generate code to handle MYSQL calls and return data to existing cobol record layouts i.e. so that COBOL doesn't really know the difference when e.g. a 'write myfile-rec' is simply replaced with a 'perform db-myfile-insert'.
I have a question... Some of my records contain binary fields e.g. PIC 9(5)V99 comp. The db equivalent MYSQL field is defined as decimal(7,2). Visual COBOL says I can't use the PIC 9(5)V99 comp. field as a host variable. Is that right or am I doing something wrong? I've worked around it by using an intermediary host field but obv that makes the process more involved and fiddly.
If anyone's interested, the program I've written (so far, it's a work in progress but basically works) takes in a record layout spec like so:
Linden Rowland - IT Consultant
IT Consultant to Tindle Newspaper Group