Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 SNMP trap from Mainframe bipinpeter Compuware & Other Tools 6 Wed Apr 26, 2017 3:05 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Opening in Allianz India- T... Rajesh Gopinathan Mainframe Jobs 0 Wed Apr 19, 2017 11:33 am
No new posts Need help in reading and validating a... ABINAYATHULASI COBOL Programming 8 Tue Apr 18, 2017 11:42 am
No new posts FTP from Mainframe to Unix - with CRLF vasanthz All Other Mainframe Topics 7 Thu Mar 23, 2017 5:12 am
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us