Impact Analysis Powerbuilder & Tables & Stored Procedures

I have 2 datamodels:
One with tables & stored procedures
One with datawindows & nvos
I want to do an impact analysis against a table
and list all the datawindows and stored procedures that call
it.
Is this possible?  Thank you
0
DBGal
7/16/2009 10:37:05 PM
sybase.powerdesigner.general 9408 articles. 1 followers. Follow

2 Replies
592 Views

Similar Articles

[PageSpeed] 12

Worst case is you can create your own relationships using the Extended
Dependency. Those can be created between any objects ( i think ). So
at a minimum you can build them.

Is there some way to do this automatically, I don't know. There's
always VBScript if nothing else.

0
Mark
7/16/2009 10:45:32 PM
To do IA you need to link the objects. Here is how you can do it.

- DataWindows to Tables = Use the Mapping editor either on the table or 
the DW and map the two to each other.

- Tables to SP = This is done at time of reverse engineering for SPs. If 
they are not linked, then just draw an Extended Link from the SP to the 
Table since the SP is dependent on the Table. Or on the property sheet 
of the SP, go to the Extended Dependencies tab and add the corresponding 
tables or SP.

-Side note = As Mark stated you could use extended dependencies for all 
these.

Then Check-In these models into the Repository, and you will then be 
able to see their full impact & lineage.

HTH,
-Matt C.

Matt Creason
Principal System Consultant, PowerDesigner

DBGal wrote:
> I have 2 datamodels:
> One with tables & stored procedures
> One with datawindows & nvos
> I want to do an impact analysis against a table
> and list all the datawindows and stored procedures that call
> it.
> Is this possible?  Thank you
0
Matt
7/25/2009 1:12:37 AM
Reply:

Similar Artilces:

&& In Generated Javascript Becomes &&
I am trying to write client side scripts in c#, asp.net V 1.4. The && operator is generated in the javascript as &amp;amp;, which causes errors.  How can I avoid this? (Code below)  Thanks in advance.   script = "<script language='javascript' type='text/javascript'>\n"; script += "if (Form1." + tbxA.ClientID + ".value == '' && "; script += "Form1." + tbxB.ClientID + ".value == '') {"; script += "Form1." + cbxC.ClientID + ".Checked = false;}"; ...

pb8 & stored procedures & instances
I've just started a new project with PB8 (build 6028) On ASA 7.02 I've got a database with some very easy stored procedures. One of the stored procedures updates a table, it takes one string variable as a parameter. I defined the stored procedure in the "declare instance variable" box of my window: string is_enterprisename, is_abbreviation DECLARE sp_set_enterprise PROCEDURE FOR dba.glo_sp_set_enterpriseinfo @ls_enterprisename = :is_enterprisename, @ls_abbreviation = :is_abbreviation using sqlca; Later in one of the window-functions the...

Convert &amp; to &
I have a Gridview that is populated by the 3 different users from selections made in a prior Form.  This gridview summarizes everything.  I then step through this Gridview and write the data to a history file on SQL. The problem I am having is, one column in this Gridview is a name column which contains the "&" symbol.  When I iterate the Gridview and populate the history file the & becomes &amp;.  I can't seem to figure out how to convert this properly.  Both data fields are nvarchar type.  Please help anyone. This is the code to tak...

&, &&, and backtracking.
------=_Part_20601_33098141.1189046184291 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline How do C<&> and C<&&> differ with respect to backtracking? For instance, "foobar" ~~ / <[a..z]>+ & [ ... ] /; Both sides of the C<&> happen in parallel, so I would guess that they both match "foo" then stop. Please correct me if that's wrong. Were we using the procedural conjunction: "foobar" ~~ / <[a..z]>+ && [ ... ] /; I would gues...

Replacement of & , &amp;
I was trying this java script inside a mozilla extension but the browser shows me error this.replace(/&/g,'&amp;').replace(/</g,'&lt;').replace(/>/g,'&gt;'); XML Parsing Error: not well-formed at replace(/&/g,'&amp;') Any thoughts ? Thanks On Fri, 30 May 2008 10:26:19 -0700 (PDT), sb wrote: > I was trying this java script inside a mozilla extension but the > browser shows me error > this.replace(/&/g,'&amp;').replace(/</g,'&lt;').replace(/>/g,'&gt;'); > ...

& turning to &amp;
I'm doing an operation reformat and trying to use the & in a text box. In the trace it looks ok in the policy, but when it gets to the actual xml value it turns into this: <modify-attr attr-name="EG"> <remove-all-values/> <add-value> <value>&amp;</value> </add-value> </modify-attr> Can I fix this in policy builder or by escaping the character somehow? Or do I need a stylesheet to fix the problem? -- nate_spears ------------------------------------------------------------------------ It isn't a p...

&amp; instead of &
I have gridview with the following code on row commandDim row As GridViewRow = gvBusinessLines.Rows(e.CommandArgument)txtBusinessLine.Text = CStr(row.Cells(1).Text) ''''''''''''''''''''''''''''''''''''''''''''''' When I have this text in gridview for example:"test & test2", when clicking on the button of the gridview, textbox is containing test &amp; test2How to avoide this other than re...

& where shown as &amp;
hai,     At runtime i will add values from textbox to datagrid using datatables.what my problem was , when i add as he & she in textbox it show as he &amps; she in the grid.how to solve this. Thanks in advance   cool.mugil:    At runtime i will add values from textbox to datagrid using datatables.what my problem was , when i add as he & she in textbox it show as he &amps; she in the grid.how to solve this.  Make sure you are not HTML encoding the input values.  Hai,    How to do stop html enc...

If & =&amp; in xml then { or }= what?
Hi frnds, some problem when using xml & is not compatible in xml file so we replace & with &amp;    like that i want to know what the characters which are not compatible with xml syntax for example when i m using { or } in xml file then its shwoing error msg. if anyone knows the soln then plz reply me. Thanks in advance.Regards,Hasan Mohiuddin Farooqihasan_farooqi@yahoo.co.in Hi Dear,Please find the Table. It contains the all special character list... quot " U+0022 (34) HTML 2.0 HTMLspecial ISOnum quotation mark (= APL quote) amp &am...

Kfarbair.com
Name: LeceHoigree Email: 101atmanga-kenseidotcom Product: eBay Companion Summary: Kfarbair.com - &#1489;&#1497;&#1514; &#1502;&#1500;&#1493;&#1503; &#1499;&#1508;&#1512;&#1497; & &#1495;&#1491;&#1512;&#1497;&#1501; &#1502;&#1512;&#1493;&#1493;&#1495;&#1497;&#1501; & &#1499;&#1508;&#1512; &#1489;&#1506;&#1497;&#1512; Comments: <a href=http://www.kfarbair.com><img>http://www.kfarbair.com/_images/_photos/photo_big8.jpg</img></a> ...

&amp;
C:\Program Files\ASP.NET Starter Kits\ASP.NET Portal (VBSDK)\PortalVBSDK\admin\Cardholders.aspx(174) : error BC30451: Name 'amp' is not declared.            __output.Write(Global.GetApplicationPath(Request) &amp; "/ASPNETPortal.css")                                                   ...

&&
Hi all=2C I have some arrays and like to trigger some events depending on which = array or combination of arrays contains data=2E What I tried was = something like=3A snippet if(=40dates =26=26 !=40themes =26=26 !=40cities) =7B =23do something with the data in =40dates =7D elsif(!=40dates =26=26 =40themes =26=26 !=40cities) =7B =23do somthing with =40themes =7D =2E=2E=2E Alas! I doesn=27t work=2E Using =22and=22 instead of =22=26=26=22 doesn=27= t help either=2E Or do I have to use =22=26=22 instead=2E Although it doesn=27t work eithe= r=2E = instead = ...

and, or, &&, ||
Hello! I remember someone mentioning that there may be a precedence problem with "unexpected results" during a mathematical conditional test, using the keywords "and" and "or"...instead of the symbols (&& and ||). Is this true? Can anyone give me an example? Thanks much! cl __________________________________________________ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com On Tue, 25 Sep 2001, Christine Lenda wrote: > I remember someone mentioning that there may b...

@#%&*!@+%$&@
Name: Rick Kimmel Email: rick_kimmelatbellsouthdotnet Product: Firefox Summary: @#%&*!@+%$&@ Comments: Since I downloaded the latest Firefox version, every time I open it I'm assailed with a prompt telling me I need some kind of goddamned Registry Defender and it pisses me off! I already have registry software and it was free, thank you and I don't need yours. I'm looking around to find a new browser since Mozilla seems to have gone to Hell! Browser Details: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 (.NET CL...

Web resources about - Impact Analysis Powerbuilder & Tables & Stored Procedures - sybase.powerdesigner.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
... Win32 or newer style .Net development After several years of work, Sybase is ready to deliver on the final step in its plan to move PowerBuilder ...

Jim O'Neil (@jimoneil) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Open Directory - Computers: Programming: Languages
about dmoz - dmoz blog - report abuse/spam - help the entire directory only in Programming/Languages Description Top : Computers : Programming ...

The HP Booth Staff (Goons) Owe Me an Apology
... when you might need to use it. For instance, when I was in the WinRunner world there were plugins for driving terminal emulators and powerbuilder ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Sybase.com. Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
... 我的异常网 » 热门搜索 sdpnet2 移动【A111】其它用户原因鉴权失败,是什么意思啊 http:// 192.168.1.102:22578 本网站服务器位于美国,受美国法律保护 MiniUI js 破解 http://192.168.1.103:8080/ powerbuilder ...

Mobile app security: Always keep the back door locked
The best way to keep mobile apps safe is to secure the services they connect to.

10 Tech Skills That Will Instantly Net You A $100,000+ Salary
... that let's developers run Java applications. Java is highly popular language for writing web apps and custom enterprise apps. No. 8: PowerBuilder ...

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Resources last updated: 11/30/2015 6:43:18 PM