VSAM Data Source

Wed, 20 Jul 2011 06:15:20 GMT

Hi all,

Do QlikView support VSAM as data source?

Re: VSAM Data Source

Anonymous — Wed, 30 Jan 2013 12:26:38 GMT

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.

[preuba]:

LOAD RowNo() as RowId,

@1:3 as alphanumeric, // PIC X(3)

@4:7B /100 as numeric // PIC S9(5)V99 COMP-3

FROM [prueba.txt]

(fix, codepage is 500, record is 7)

;