DataDeploy tables Column size change

TS: 6.1
OD:6.0.2
OS Smiley Frustrated

olaris

The below lines are from my datacapture.cfg. The Entity item is mapped to Column 'Entity' in DD table. It happened to be that the size of the field need to increased more than 255 size (VARCHAR).

< item name="ENTITY" >
< database data-type="VARCHAR(255)" >
...
...

Just wondering if any of could give directions that need to be done in order to update the coumn size with bigger size.

I have several workareas in my brach, what should I need to do inorder to get this propagated across all workarea tables including the stage.

Any input is really appreciated.

Thanks

Find more posts tagged with

Comments

Adam Stoller

TS: 6.1
OD:6.0.2
OSolaris

The below lines are from my datacapture.cfg. The Entity item is mapped to Column 'Entity' in DD table. It happened to be that the size of the field need to increased more than 255 size (VARCHAR).

< item name="ENTITY" >
< database data-type="VARCHAR(255)" >
...
...

Just wondering if any of could give directions that need to be done in order to update the coumn size with bigger size.

I have several workareas in my brach, what should I need to do inorder to get this propagated across all workarea tables including the stage.

Any input is really appreciated.

Thanks

I will never claim to be an expert in DataDeploy - but I believe there are multiple issues involved here:

the columns in the DB through DD or through the DB administrative interface either.

mk_iw

Thanks for your input. It really helped.

I used the following SQL to alter the table, and tested it out. It seems to be working fine.

alter table IWT_188162963B68 change entity ENTITY varchar(2500);

I'm in the process of altering all tables (IWT_*).

Adam Stoller

Thanks for your input. It really helped.

I used the following SQL to alter the table, and tested it out. It seems to be working fine.

alter table IWT_188162963B68 change entity ENTITY varchar(2500);

I'm in the process of altering all tables (IWT_*).

Cool - so you can dynamically change the column definition.
With that then, yes, you just need to make sure everything that references that column of data (for querying, deleting, and especially for inserting) are all updated so that you don't get conflicts of types.
I believe the DCT, dbschema.cfg are the primary places - but the various tables created by DD (both as per the dbschema.cfg and per its own internal management of things) obviously also need to be updated.

Glad it helped.