The following query works no problem, (figured it out from dd_populate.ebs). But if I have more than 500 items, I hit the YACC limit and I can not find a way past this Any thoughts?
Alter Type bdd_document
MODIFY bdd_levels (
MAPPING TABLE (
VALUE = '90' DISPLAY = 'Ninth floor',
VALUE = '80' DISPLAY = 'Eighth floor',
VALUE = '70' DISPLAY = 'Seventh floor',
VALUE = '60' DISPLAY = 'Sixth floor',
VALUE = '50' DISPLAY = 'Fifth floor',
VALUE = '40' DISPLAY = 'Fourth floor',
VALUE = '30' DISPLAY = 'Third floor',
VALUE = '20' DISPLAY = 'Second floor',
VALUE = '10' DISPLAY = 'First floor',
VALUE = '00' DISPLAY = 'Ground or Base'
))PUBLISH
I did alter my composer type definition, with 500 plus "value_mappings" and hit the same limit. I guess I can raise this as a Composer (D6.7) defect!!
There is a work around for SELECT statements using UNION or OR but they are not valid for ALTER
http://robineast.wordpress.com/2007/01/23/dealing-with-yacc-stack-overflow
This does seem to be a very old problem, but not dealt with as there is a work around for most use cases
http://tech.dir.groups.yahoo.com/group/documentum-users/message/25855
