Discussion:
VBScript to inform table options
(too old to reply)
unknown
2007-09-19 02:59:47 UTC
Permalink
How can I use VBScript to change/insert tablespace, initial
and next value of a table in a oracle PDM Model?

Regards,
Cícero Galdino.
Marc
2007-09-19 09:11:27 UTC
Permalink
Hi,

You can use the full physical option text "BaseTable.PhysicalOptions" (see
chm help on BaseTable object)
And you can set each option individually using (V12.x) properties
- SetPhysicalOptionValue
- AddPhysicalOption
- DeletePhysicalOption
- SetPhysicalOptionSql
- GetPhysicalOptionSql
- GetPhysicalOptionValues
- HasPhysicalOption
- GetPhysicalOptionValue

Marc


<Cicero Galdino> wrote in message news:***@sybase.com...
How can I use VBScript to change/insert tablespace, initial
and next value of a table in a oracle PDM Model?

Regards,
Cícero Galdino.
unknown
2007-09-19 12:07:23 UTC
Permalink
Hi Marc,
Thank you for your help. But, is it also possible in
version 11?

Cicero.
Post by Marc
Hi,
You can use the full physical option text
"BaseTable.PhysicalOptions" (see chm help on BaseTable
object) And you can set each option individually using
(V12.x) properties
- SetPhysicalOptionValue
- AddPhysicalOption
- DeletePhysicalOption
- SetPhysicalOptionSql
- GetPhysicalOptionSql
- GetPhysicalOptionValues
- HasPhysicalOption
- GetPhysicalOptionValue
Marc
How can I use VBScript to change/insert tablespace,
initial and next value of a table in a oracle PDM Model?
Regards,
Cícero Galdino.
unknown
2007-09-19 10:45:20 UTC
Permalink
In the XDB, in the Profile section, under the Table object
(ORACLE10gR2::Profile\Table), you need to add a new event.
Right-click the Table node.
Select "New", then "Event Handler" from the menu.
Check the "Initialize" box. This code will be executed when you
initially create a table.
Put comments in the General tab (like what you are doing here).
In the Event Handler Script tab, add your code before the %Initialize% -
True line.
In here, you will need to look at the Table object in the VBScript Help.
Click the Help button on the toolbar.
It appears that the tablespace is specified in the Physical Options, so
you will need to work with that string. I don't see a direct object
link anywhere.
Can someone else chime in? I can get you close, but not 100% of the way
there.
--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike[at]datamodel[dot]org (can you figure what to change?)
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement
Post by unknown
How can I use VBScript to change/insert tablespace, initial
and next value of a table in a oracle PDM Model?
Regards,
Cícero Galdino.
Loading...