I don't think there is way to read VSAM files directly. What you can do is IDCAMS Repro them to a sequential file and then load the seq file using FTP.
There are several third party (IBM as well) product you can install that provide SQL access to VSAM files, if you have the funds and volume to go that route.
You will need middleware to make a direct connection. These are two options I found:
- Progress DataDirect for VSAM
- Microsoft BizTalk Host Integration server
Please be aware that you may need codepage translation (also from flat file exports of these systems) from EBCDIC into UTF-8 or ASCII.
Here's a script example of loading COBOL data:
@startpos:endpos represents the start and end positions of a field in a
file with fixed length records. The positions must both be positive integers.
The two numbers must be preceded by "@" and separated by a colon. The
numbering is always made from 1 and up to the number of positions.
If @startpos:endpos is immediately followed by the characters I or U, the
bytes read will be interpreted as a binary signed (I) or unsigned (U)
integer (Intel byte order). The number of positions read must be 1, 2 or 4.
If @startpos:endpos is immediately followed by the character R, the bytes
read will be interpreted as a binary real number (IEEE 32-bit or 64 bit
floating point). The number of positions read must be 4 or 8.
If @startpos:endpos is immediately followed by the character B, the bytes
read will be interpreted as a BCD (Binary Coded Decimal) numbers according
to the COMP-3 standard. Any number of bytes may be specified.
The codepage parameter can be used to specify that the source data is EBCDIC.
LOAD RowNo() as RowId,
@1:3 as alphanumeric, // PIC X(3)
@4:7B /100 as numeric // PIC S9(5)V99 COMP-3
(fix, codepage is 500, record is 7)