topic QlikView support VSAM as data source? in QlikView

QlikView support VSAM as data source?

Thu, 12 Jan 2012 18:23:10 GMT

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

QlikView support VSAM as data source?

rbecher — Thu, 12 Jan 2012 19:42:49 GMT

Hi,

as far as I know this is the driver with the most features:

http://www.hxtt.com/cobol.html

You can probably use this in combination with our QlikView JDBC Connector:

http://community.qlik.com/docs/DOC-2438

- Ralf

QlikView support VSAM as data source?

rwunderlich — Thu, 12 Jan 2012 20:46:36 GMT

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.

-Rob

http://robwunderlich.com

QlikView support VSAM as data source?

rbecher — Thu, 12 Jan 2012 21:11:42 GMT

You can contact me directly for configurational questions on the JDBC Connector:

ralf.becher@tiq-solutions.de

Re: QlikView support VSAM as data source?

rwunderlich — Fri, 13 Jan 2012 00:42:28 GMT

What platform are your VSAM files on, z/OS or AS/400?

If on z/OS, it looks like you can access VSAM directly using Distributed File Service, SMB-RFS. I don't know if this is available on AS/400.

-Rob

QlikView support VSAM as data source?

Fri, 13 Jan 2012 21:57:43 GMT

The platform are on z/OS

QlikView support VSAM as data source?

Wed, 18 Jan 2012 20:46:20 GMT

Does anyone have done it, importing VSAM files into QlikView?

any other sugestions?

Thanks

QlikView support VSAM as data source?

rbecher — Thu, 19 Jan 2012 06:09:51 GMT

I'm just curious to try this with our JDBC Connector. Can you send me a sample file?

- Ralf

QlikView support VSAM as data source?

rbecher — Tue, 10 Apr 2012 11:51:50 GMT

So, in the meantime I did an example how to read a Cobol file:

http://community.qlik.com/docs/DOC-2904

- Ralf

Re: QlikView support VSAM as data source?

rwunderlich — Tue, 10 Apr 2012 16:40:11 GMT

This is great Ralf. But I'd like to point out that that "COBOL" files are not the same as VSAM.

-Rob

Re: QlikView support VSAM as data source?

rbecher — Tue, 10 Apr 2012 17:43:24 GMT

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

Re: QlikView support VSAM as data source?

Anonymous — Wed, 30 Jan 2013 12:27:16 GMT

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)

;

Re: QlikView support VSAM as data source?

Fri, 15 Aug 2014 04:21:16 GMT

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.

Re: QlikView support VSAM as data source?

rbecher — Sun, 17 Aug 2014 10:56:53 GMT

Hi Octavio,

can you upload a sample file?

- Ralf

Re: QlikView support VSAM as data source?

Mon, 18 Aug 2014 03:05:41 GMT

Hi Ralf,

This is an example,

DATEDOC

é¿

ê?

¬é¿

Thanks