Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Boiler plate text for Table and Column comments

6 posts in General Discussion Last posting was on 2013-01-12 19:35:48.0Z
Navin Ladda Posted on 2013-01-02 20:29:49.0Z
Sender: 4f02.50e44b96.1804289383@sybase.com
From: Navin Ladda
Newsgroups: sybase.public.powerdesigner.general
Subject: Boiler plate text for Table and Column comments
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50e498bd.6261.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Jan 2013 12:29:49 -0800
X-Trace: forums-1-dub 1357158589 172.20.134.41 (2 Jan 2013 12:29:49 -0800)
X-Original-Trace: 2 Jan 2013 12:29:49 -0800, 172.20.134.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30977
Article PK: 1158679

Where can I specify some boiler plate text that will show up
for each new Table and Columns created in a Physical Data
Model.

For instance, I want the text of DESCRIPTION: to show up in
each new column I add to a table.


Ondra D. Posted on 2013-01-03 10:03:04.0Z
Sender: 22a9.50e55088.1804289383@sybase.com
From: Ondra D.
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Boiler plate text for Table and Column comments
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50e55757.243e.1681692777@sybase.com>
References: <50e498bd.6261.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 3 Jan 2013 02:03:04 -0800
X-Trace: forums-1-dub 1357207384 172.20.134.41 (3 Jan 2013 02:03:04 -0800)
X-Original-Trace: 3 Jan 2013 02:03:04 -0800, 172.20.134.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30978
Article PK: 1158689

Hi Navin,

I think you`ll have to use the Initialize event handler for
this purpose. You can add it in any Extension in your model
to the Column metaclass.

Regards,
Ondrej

> Where can I specify some boiler plate text that will show
> up for each new Table and Columns created in a Physical
> Data Model.
>
> For instance, I want the text of DESCRIPTION: to show up
> in each new column I add to a table.


Navin Ladda Posted on 2013-01-03 15:27:43.0Z
Sender: 3513.50e5a281.1804289383@sybase.com
From: Navin Ladda
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Boiler plate text for Table and Column comments
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50e5a36f.3545.1681692777@sybase.com>
References: <50e55757.243e.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 3 Jan 2013 07:27:43 -0800
X-Trace: forums-1-dub 1357226863 172.20.134.41 (3 Jan 2013 07:27:43 -0800)
X-Original-Trace: 3 Jan 2013 07:27:43 -0800, 172.20.134.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30979
Article PK: 1158708

Will have to experiment with the Extensions, as I am new to
PD.

In Erwin it is quite simple. On the Domains, it has a
propery of Inherited by, where you can type free form text.
Then any column, which is associated/tagged with that
domain, get's that boiler plate text automatically added to
it's Comment field. This property of the Domain did not come
over into PD when the model was converted, as PD does not
have such a concept.

I was thinking that with the various types of Customizations
in PD, this would be an easy thing, as I find that Extension
concept little difficult to digest. We used it so far just
for capturing what is called as UDPs (User Defined Property)
at the Column level in Erwin.

> Hi Navin,
>
> I think you`ll have to use the Initialize event handler
> for this purpose. You can add it in any Extension in your
> model to the Column metaclass.
>
> Regards,
> Ondrej
>
> > Where can I specify some boiler plate text that will
> > show up for each new Table and Columns created in a
> > Physical Data Model.
> >
> > For instance, I want the text of DESCRIPTION: to show up
> > in each new column I add to a table.


randy.buchholz Posted on 2013-01-04 16:40:14.0Z
Sender: 34ae.50e6f4a2.1804289383@sybase.com
From: Randy.Buchholz
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Boiler plate text for Table and Column comments
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50e705ee.3b06.1681692777@sybase.com>
References: <50e5a36f.3545.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 4 Jan 2013 08:40:14 -0800
X-Trace: forums-1-dub 1357317614 172.20.134.41 (4 Jan 2013 08:40:14 -0800)
X-Original-Trace: 4 Jan 2013 08:40:14 -0800, 172.20.134.41
Lines: 50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30982
Article PK: 1158748

A good way to get into Extensions basics is with
stereotypes. In the editor right click on Profile and Add
Metaclass. Select Table and OK. Right click Table and
New>Stereotype. Give it a name. Hit OK. Now you will see
your sterotype in the stereotype dropdown in the table
details.

Go back to the Extension definition and and right click on
your stereotype. Do New>Custom Symbol. On the bottom right
click "Modify..." Select the "Custom Shape" tab, check the
"Enable custom shape" box. Click "Browse..." and pick a
symbol (you can make your own too) click all of the "OK's"
until you are out. Now when you change your stereotype the
symbol will change. Pretty Cools! Custom Symbols are
pretty much only useful for diagrams, but they really add
clarity. Hopefully that will help get you started with
Extensions.

> Will have to experiment with the Extensions, as I am new
> to PD.
>
> In Erwin it is quite simple. On the Domains, it has a
> propery of Inherited by, where you can type free form
> text. Then any column, which is associated/tagged with
> that domain, get's that boiler plate text automatically
> added to it's Comment field. This property of the Domain
> did not come over into PD when the model was converted, as
> PD does not have such a concept.
>
> I was thinking that with the various types of
> Customizations in PD, this would be an easy thing, as I
> find that Extension concept little difficult to digest. We
> used it so far just for capturing what is called as UDPs
> (User Defined Property) at the Column level in Erwin.
>
> > Hi Navin,
> >
> > I think you`ll have to use the Initialize event handler
> > for this purpose. You can add it in any Extension in
> > your model to the Column metaclass.
> >
> > Regards,
> > Ondrej
> >
> > > Where can I specify some boiler plate text that will
> > > show up for each new Table and Columns created in a
> > > Physical Data Model.
> > >
> > > For instance, I want the text of DESCRIPTION: to show
> > > up in each new column I add to a table.


Gabor Gollnhofer Posted on 2013-01-12 19:35:48.0Z
From: "Gabor Gollnhofer" <donot@mail.me>
Newsgroups: sybase.public.powerdesigner.general
References: <50e55757.243e.1681692777@sybase.com> <50e5a36f.3545.1681692777@sybase.com>
Subject: Re: Boiler plate text for Table and Column comments
Lines: 1219
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50f1bb14@forums-1-dub>
Date: 12 Jan 2013 11:35:48 -0800
X-Trace: forums-1-dub 1358019348 172.20.134.152 (12 Jan 2013 11:35:48 -0800)
X-Original-Trace: 12 Jan 2013 11:35:48 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30989
Article PK: 1158959

Hi Navin,

For reusing column properties we used to create template table(s) with
temples colums, the tables set as no generate.
And then "replicate" the needed columns. The replicated column is the exact
copy of the original.

If you want to use Domains you can even in PD.
If you'd like to go with domains here is a very simple script to copy the
domain description to the attached columns.

The script:
for each tab in ActiveModel.Tables
for each col in tab.Columns

if not(col.domain is Nothing) then 'check if the column has domain

if not(col.replica) then 'check if it's not replicated column
because then it cannot be modified
col.Description = col.Domain.Description
end if 'not(col.replica)

end if 'not(col.domain is Nothing)

output col.QualifiedCode & ":" & col.Description
next 'col
next 'tab

Of course, you can use the extended model, in the long term that is a more
flexible solution.

HTH,

Gabor


<Navin Ladda> az al?bbiakat ?rta a k?vetkez? h?r?zenetben:
50e5a36f.3545.1681692777@sybase.com...

> Will have to experiment with the Extensions, as I am new to
> PD.
>
> In Erwin it is quite simple. On the Domains, it has a
> propery of Inherited by, where you can type free form text.
> Then any column, which is associated/tagged with that
> domain, get's that boiler plate text automatically added to
> it's Comment field. This property of the Domain did not come
> over into PD when the model was converted, as PD does not
> have such a concept.
>
> I was thinking that with the various types of Customizations
> in PD, this would be an easy thing, as I find that Extension
> concept little difficult to digest. We used it so far just
> for capturing what is called as UDPs (User Defined Property)
> at the Column level in Erwin.
>
>> Hi Navin,
>>
>> I think you`ll have to use the Initialize event handler
>> for this purpose. You can add it in any Extension in your
>> model to the Column metaclass.
>>
>> Regards,
>> Ondrej
>>
>> > Where can I specify some boiler plate text that will
>> > show up for each new Table and Columns created in a
>> > Physical Data Model.
>> >
>> > For instance, I want the text of DESCRIPTION: to show up
>> > in each new column I add to a table.
>
> __________ ESET Smart Security - V?rusdefin?ci?s adatb?zis: 7887
> (20130112) __________
>
> Az ?zenetet az ESET Smart Security ellen?rizte.
>
> http://www.eset.hu
>
>
>


randy.buchholz Posted on 2013-01-04 16:18:23.0Z
Sender: 34ae.50e6f4a2.1804289383@sybase.com
From: Randy.Buchholz
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Boiler plate text for Table and Column comments
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50e700cf.38df.1681692777@sybase.com>
References: <50e498bd.6261.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 4 Jan 2013 08:18:23 -0800
X-Trace: forums-1-dub 1357316303 172.20.134.41 (4 Jan 2013 08:18:23 -0800)
X-Original-Trace: 4 Jan 2013 08:18:23 -0800, 172.20.134.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30981
Article PK: 1158746

Take a look at generation templates and GTL (the template
language) doc's are pretty weak there, but it's worth
digging around. Go to Database>Edit Current DBMS. !!Make
sure you back up the existing definition first!! (It's in
the ProgramFiles.../ResourceFiles/DBMS folder). For simple
hand written stuff you can enter it as comments in the
Scripts tab, but that is at table level. Extensions are
pretty powerful and you should learn to use them, but GTL
does the generation so that's prob the best place to
investigate.

> Where can I specify some boiler plate text that will show
> up for each new Table and Columns created in a Physical
> Data Model.
>
> For instance, I want the text of DESCRIPTION: to show up
> in each new column I add to a table.