Cobol (TXT DB) to MySQL or PostGREE

[Trxplz0]

Hi,

Is there a easly way to convert a Cobol TXT DB to Mysql or Postgree?

The TXT sctructure files have this:

fd AFNSPP
label record is standard.

01 D455-REG-TUP.
05 COD-TUP PIC X(17).
05 F1 PIC X(03).
05 COD-STORE-TUP PIC 9(02).
05 F2 PIC X(03).
05 COD-CLIENT-TUP PIC 9(05) VALUE ZEROS.
05 F3 PIC X(03).
05 VALUE-TUP PIC 9(12)V99 VALUE ZEROS.
05 F4 PIC X(03).
05 DATA-TUP PIC 9(08) VALUE ZEROS.
05 F5 PIC X(03).
05 BANK-TUP PIC 9(03) VALUE ZEROS.
05 F6 PIC X(03).

Thanks i hope you guys can help me!

 

[k5tm]

Not sure what you have in you Fn (presumed filler) variables, but if this file looks somewhat like a CSV file then, for MySQL, LOAD DATA INFILE should do the trick.

Tom Morrison
Hill Country Software

 

[fredericofonseca]

hi Tom, only now noticed your move (might explain lack of reply to my last email). Hope all is well.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886