[Advantage:Gen] Cursor Labelling convention

Nick CIANCI

[Advantage:Gen] Cursor Labelling convention
A question for the COOL:Gen / DB2 experts

How does COOL:Gen generate it's Cursor labels? Ie: from a READ EACH we'll
get something like :
DECLARE CUR_1842941469_1 CURSOR FOR SELECT

But if we add extra COOL:Gen code or simply re:Gen the action block; will
the same Cursor label appear for the SQL?

Regards
Nick C

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Peter Suhner

Re: [Advantage:Gen] Cursor Labelling convention
(in response to Nick CIANCI)
Nick,

it's been a couple of years since I worked as a Gen techie, but I can't
imagine these basics to have changed:

AllFusion Gen's label naming system is derived from the respective object id
(when the object is created on the workstation or in the encyclopedia). The
tool ensures that unique object id's are generated even without connection
to the encyclopedia. This is achieved through an algorithm that reserves id
ranges for the Model, it's Subsets and the many many single objects created
within (based on the Model Id).

As the object id is unique, the label will be regenerated identically each time.

But please keep in mind: If you copy an object, (e.g. an ActionBlock or the
whole Model), new objects are created and assigned different object ids. As
a result, you will have different labels in the generated code of the copied
objects.

At many sites, version control and staging from development to test to
production is based on copying models and then regenerating the code. Which
means: different labels in identically named ActionBlocks.

Regards,
Peter

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html