View previous topic :: View next topic
|
Author |
Message |
tiruvathuruk Warnings : 1 New User
Joined: 30 Sep 2008 Posts: 6 Location: Pune
|
|
|
|
Hi,
My front end team is loading .txt, .csv, .xml file into a mainframe table as blob objects. Is there there any was to read the contents of these blob objects? |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
What is "mainframe table"??
O. |
|
Back to top |
|
|
tiruvathuruk Warnings : 1 New User
Joined: 30 Sep 2008 Posts: 6 Location: Pune
|
|
|
|
I mean tables in the z/os environment |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
Is this a new component of z/os?
O. |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
ISPF tables or DB2 tables?
You placed this message in TSO/ISPF forum. |
|
Back to top |
|
|
tiruvathuruk Warnings : 1 New User
Joined: 30 Sep 2008 Posts: 6 Location: Pune
|
|
|
|
I am sorry. i will post the query in DB2 forum |
|
Back to top |
|
|
Saroj Tripathy
New User
Joined: 05 Mar 2007 Posts: 23 Location: India
|
|
|
|
u can handle them in cobol code as BLOB data type. but the contents will be in binary format. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
My front end team is loading .txt, .csv, .xml file into a mainframe table as blob objects. |
Why?
There is probably something i completely misunderstand, but storing them as blobs will make easily used text data much more difficult to use. . . |
|
Back to top |
|
|
Saroj Tripathy
New User
Joined: 05 Mar 2007 Posts: 23 Location: India
|
|
|
|
even though we store them as BLOB in db2 but if an open system application gets it out then it can read it as per format. i.e if the blob is actually a pdf then the pdf formatting doesn't change. a pdf viewer app in open system can open it as a pdf document ! |
|
Back to top |
|
|
|