VSAM Data Source

[#1]

Hi all,

Do QlikView support VSAM as data source?

[Anonymous]

You will need middleware to make a direct connection. These are two options I found:

- Progress DataDirect for VSAM

http://www.datadirect.com/support-data-sources/mainframe/databases/vsam.html

- Microsoft BizTalk Host Integration server

http://www.microsoft.com/biztalk/en/us/host-integration.aspx

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)

;