For completeness, some more info about TEXT table. Length of TEXT field is 10000 bytes. Data is stored in multiple rows if it exceeds that value. Each row has a seq_num that contains the sequence number of that row. Rows should be selected with an order by on seq_num and then 'glued' together to get the whole text.
If you are getting this data from traf code, then it is better to call method CmpSeabaseDDL::getTextFromMD which will return glued data. anoop From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, June 15, 2017 4:58 PM To: user@trafodion.incubator.apache.org Subject: RE: alter table add constraint ? modify constraint? Cool thanks, Eric From: Anoop Sharma [mailto:anoop.sha...@esgyn.com] Sent: Thursday, June 15, 2017 6:57 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: RE: alter table add constraint ? modify constraint? yes, stored in text field of "_MD_".TEXT table with text_type = 1. anoop From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Thursday, June 15, 2017 4:55 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: RE: alter table add constraint ? modify constraint? TEXT table From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, June 15, 2017 4:54 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: RE: alter table add constraint ? modify constraint? Check. BTW, I was trying to find them back in _MD_ schema. Do you happen to know where the constraint text is stored in _MD_ (assuming it is somewhere out there?) Eric From: Anoop Sharma [mailto:anoop.sha...@esgyn.com] Sent: Thursday, June 15, 2017 6:51 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: RE: alter table add constraint ? modify constraint? yes, you need to drop/add constraint. There is no support for modify constraint. constraint add/drop are transactionally protected. What kind of constraints are these? check, unique, RI? anoop From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, June 15, 2017 4:30 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: alter table add constraint ? modify constraint? Hi Trafodioneers, Looking at the doc, I don't see that there is syntax to modify a constraint. Should I assume that the only way to modify a constraint is to drop it first then add it back? Are these drop constraint, add constraint transactionaly protected? Thanks in advance for the help, Eric