IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Reading blob objects into mainframe


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 2358
Location: Israel

PostPosted: Mon Dec 22, 2008 1:12 pm
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
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: 2358
Location: Israel

PostPosted: Mon Dec 22, 2008 1:26 pm
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: 459
Location: Belgium

PostPosted: Mon Dec 22, 2008 1:36 pm
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
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
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

Moderator Emeritus


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

PostPosted: Mon Dec 22, 2008 9:41 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 1
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts 10 byte RBA conversion -non applicati... JCL & VSAM 1
No new posts Storing a BLOB/CLOB in PL/I PL/I & Assembler 4
No new posts Reading dataset in Python - New Line ... All Other Mainframe Topics 22
Search our Forums:

Back to Top