Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView support VSAM as data source?

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

14 Replies
rbecher
MVP
MVP

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

Astrato.io Head of R&D
Anonymous
Not applicable
Author

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)

;


Not applicable
Author

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
MVP
MVP

Hi Octavio,

can you upload a sample file?

- Ralf

Astrato.io Head of R&D
Not applicable
Author

Hi Ralf,

This is an example,

DATEDOC
é¿
e!
ê?
Ž
Thanks