How to genereate a new IRID, IVID, for a given table in Repository

From: Michael Jewell <michael.jewell_at_REMOVETHISuk.thalesgroup.com>
Date: Thu, 6 Feb 2003 09:08:05 -0000
Message-ID: <b1t8m8$a6l$1_at_rdel.co.uk>



This is within the Repository Database for Designer. We are currently attempting to populate the notes field (which apperars on the properties dialog in designer) in the table i$rm_text_lines for every table, view and materialised view in the database.

I have created a insert statement which will populate all the fields, apart from the IRID, IVID, and TXT_REF, all of which are of the same type.

 I am guessing that there is some sort of auto numbering for these fields however I cannot see it. If anyone would know how you can populate these fields it would be a great help. Received on Thu Feb 06 2003 - 10:08:05 CET

Original text of this message