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
 

 

how will we uploading the BLOB column from sybase to DB2 ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
Vijay.S
Warnings : 1

New User


Joined: 09 Jan 2007
Posts: 8
Location: chennai

PostPosted: Thu Mar 25, 2010 11:52 am    Post subject: how will we uploading the BLOB column from sybase to DB2 ?
Reply with quote

Hi Team,

My requirement is need to store the images(which are already available in sybase datbase) to new db2 table.

Noramlly, Images will be stored in BLOB format. we need to load the same into db2 table

Does any have idea about how to migrate the sybase BLOB data in to DB2 table ?

Regards
Vijay.
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Mar 25, 2010 5:16 pm    Post subject:
Reply with quote

http://www.ibmmainframes.com/viewtopic.php?t=36854&highlight=blob
http://www.ibmmainframes.com/viewtopic.php?t=45168&highlight=blob
http://www.ibmmainframes.com/viewtopic.php?t=8569&highlight=blob
Back to top
View user's profile Send private message
Vijay.S
Warnings : 1

New User


Joined: 09 Jan 2007
Posts: 8
Location: chennai

PostPosted: Fri Mar 26, 2010 10:45 am    Post subject: Re:
Reply with quote

Thanks Anuj.

Ex : BLOB of Oracle might not be compatible to BLOB of DB2. we need to format the images before uploading into db2 table ( if migration is from oracle to db2)

Similarly BLOB of Sybase might or might not be comaptible to BLOB of db2. i dont have idea about this.

Do we need to do formatting before the images be uploaded in to DB2 table? and any documetns related to migration from SYBASE to DB2?




Regards,
Vijay
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Fri Mar 26, 2010 2:00 pm    Post subject: Reply to: how will we uploading the BLOB column from sybase
Reply with quote

Quote:
Similarly BLOB of Sybase might or might not be comaptible to BLOB of db2.


a BLOB is a BLOB ==> Binary Large OBject the content is a sequence of bits, and as such it is relevant only to the application dealing with it,
it will be completely irrelevant to the DBMS

thing might be different for a CLOB ( Char large object ), codepages,utf, and so on
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Mar 26, 2010 3:00 pm    Post subject:
Reply with quote

Try these links:

http://publib.boulder.ibm.com/infocenter/iwedhelp/v6r0/index.jsp?topic=/com.ibm.db2e.doc/dbsap_b5.html

http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.112.6626&rep=rep1&type=pdf
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Ccompar BLOB (images of type jpg) on ... nihad DB2 0 Sun Feb 05, 2017 3:13 pm
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 6 Sun Nov 06, 2016 8:11 pm
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am
No new posts Add system date inside of a PS file a... pramitdas DFSORT/ICETOOL 5 Sun Aug 28, 2016 12:06 am


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