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
 
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: 10327
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 column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts Ccompar BLOB (images of type jpg) on ... nihad DB2 0 Sun Feb 05, 2017 3:13 pm

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