Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Reading blob objects into mainframe

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
tiruvathuruk
Warnings : 1

New User


Joined: 30 Sep 2008
Posts: 6
Location: Pune

PostPosted: Mon Dec 22, 2008 1:05 pm    Post subject: Reading blob objects into mainframe
Reply with quote

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
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Mon Dec 22, 2008 1:12 pm    Post subject:
Reply with quote

What is "mainframe table"?? icon_confused.gif

O.
Back to top
View user's profile Send private message
tiruvathuruk
Warnings : 1

New User


Joined: 30 Sep 2008
Posts: 6
Location: Pune

PostPosted: Mon Dec 22, 2008 1:24 pm    Post subject: Reply to: read blob
Reply with quote

I mean tables in the z/os environment
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Mon Dec 22, 2008 1:26 pm    Post subject:
Reply with quote

Is this a new component of z/os?

O.
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Mon Dec 22, 2008 1:36 pm    Post subject:
Reply with quote

ISPF tables or DB2 tables?

You placed this message in TSO/ISPF forum.
Back to top
View user's profile Send private message
tiruvathuruk
Warnings : 1

New User


Joined: 30 Sep 2008
Posts: 6
Location: Pune

PostPosted: Mon Dec 22, 2008 2:48 pm    Post subject: Reply to: Reading blob objects into mainframe
Reply with quote

I am sorry. i will post the query in DB2 forum
Back to top
View user's profile Send private message
Saroj Tripathy

New User


Joined: 05 Mar 2007
Posts: 23
Location: India

PostPosted: Mon Dec 22, 2008 3:28 pm    Post subject:
Reply with quote

u can handle them in cobol code as BLOB data type. but the contents will be in binary format.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Dec 22, 2008 9:41 pm    Post subject:
Reply with quote

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. . . icon_confused.gif
Back to top
View user's profile Send private message
Saroj Tripathy

New User


Joined: 05 Mar 2007
Posts: 23
Location: India

PostPosted: Wed Dec 24, 2008 4:14 pm    Post subject:
Reply with quote

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 ! icon_eek.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Mainframe scheduling tool ddhar Compuware & Other Tools 2 Wed Sep 27, 2017 12:48 am
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
No new posts Mainframe dataset split purushottam DFSORT/ICETOOL 13 Tue Aug 29, 2017 12:28 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us