SQL Server Varbinary data type in DB2

Question

I have a problem with migrating from SQL Server to IBM DB2 with the following code snippet:

CREATE TABLE  fgt_qrtz_job_details (
        sched_name     varchar(200)  not null, 
        job_name       varchar(200)  not null, 
        job_group      varchar(200)  not null, 
        description    varchar(1020) null, 
        job_class_name varchar(1020) not null,
        is_durable  CHAR(1) not null,
        is_nonconcurrent    CHAR(1) not null,
        is_update_data  CHAR(1) not null,
        requests_recovery   CHAR(1) not null,
        job_data varbinary(max) null);

The reason is the varbinary datatype, I can't find any appropriate type for DB2, maybe you have any suggestions? Thanks in advance.

pic.dhe.ibm.com/infocenter/dzichelp/v2r2/…

Raphaël Althaus
– Raphaël Althaus

2013-07-02 14:36:25 +00:00
Commented Jul 2, 2013 at 14:36 — Raphaël Althaus
– Raphaël Althaus, Commented Jul 2, 2013 at 14:36
Try using BLOB if its a lot of data

Dev N00B
– Dev N00B

2013-07-02 14:45:47 +00:00
Commented Jul 2, 2013 at 14:45 — Dev N00B
– Dev N00B, Commented Jul 2, 2013 at 14:45

jmarkmurphy · Accepted Answer · 2013-07-02 16:06:49Z

1

Well there is a surprise. Usually DB2 for LUW has features that DB2 for i is missing. Here is a case of the opposite, so you will have to use a BLOB.

answered Jul 2, 2013 at 16:06

jmarkmurphy

11.6k37 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server Varbinary data type in DB2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related