QlikView support VSAM as data source?

[#1]

Hi

I want to know if QlikView support VSAM as data source? And where I find a connection ODBC of VSAM (Cobol) Files whit QlikView, if anyone knows would appreciate your help.

Thanks

[rbecher]

Hi Rob,

you're right. At least the Hxtt JDBC driver can read IBM mainframe line sequential files. Maybe this format can help here?

- Ralf

[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)

;

[#4]

Hi Bas,

Could you give me a clue to translate a BCD data to UTF-8 ?

I have a record like  é¿  with @1:2B  I get a number like 201918133, this data should be a date number.

[rbecher]

Hi Octavio,

can you upload a sample file?

- Ralf

[#6]

Hi Ralf,

This is an example,

DATEDOC

é¿

e!

ê?

¬é¿

Thanks