Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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)
;
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.
Hi Octavio,
can you upload a sample file?
- Ralf
Hi Ralf,
This is an example,
DATEDOC |
é¿ |
e! |
ê? |
¬é¿ |
Thanks