Use dddw's in reports or modify report sql to avoid dddw's

Is it more efficient to use dddw's in reports or to modify
the report sql to avoid the use of dddw's. I am not sure how
PB deals with dddw's in reports. Is the result set of the
dddw cached in memory and than used by the report or is the
dddw sql integrated into the reports sql like what occurs
with database views and than sent to the database? I could
not find any info on the net about this.
Any help would be appreciated.
0
JorgeG
3/15/2006 8:03:09 PM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

4 Replies
701 Views

Similar Articles

[PageSpeed] 56

I only recommend using DDDWs for data entry.  If you're running a report 
that needs to show the "description" for a "code" value, then write the SQL 
to perform a JOIN, and include the description in the result set.

-- 
Paul Horan[TeamSybase]
Cynergy Systems
www.cynergysystems.com

<JorgeG> wrote in message news:441872fd.7516.1681692777@sybase.com...
> Is it more efficient to use dddw's in reports or to modify
> the report sql to avoid the use of dddw's. I am not sure how
> PB deals with dddw's in reports. Is the result set of the
> dddw cached in memory and than used by the report or is the
> dddw sql integrated into the reports sql like what occurs
> with database views and than sent to the database? I could
> not find any info on the net about this.
> Any help would be appreciated. 


0
Paul
3/15/2006 8:09:38 PM
Could you explain the logic behind your recommendation? It seems to me that
there are a number of factors, including how many rows in the report, how
many rows in the DDDW, whether one retrieve for the DDDW can be shared to
many columns [I'm thinking of a health care report that had 5 diagnosis
codes, with 1500 or so in the code table], how well the DBMS handles its
internal caching so that the join for each row doesn't always result in I/O
to the code table, maybe even the robustness of the client machine that's
doing the DW rendering.

"Paul Horan[TeamSybase]" <paul.horan@NOSPAM_cynergysystems.com> wrote in
message news:441864b2@forums-2-dub...
> I only recommend using DDDWs for data entry.  If you're running a report
> that needs to show the "description" for a "code" value, then write the
SQL
> to perform a JOIN, and include the description in the result set.
>
> -- 
> Paul Horan[TeamSybase]
> Cynergy Systems
> www.cynergysystems.com
>
> <JorgeG> wrote in message news:441872fd.7516.1681692777@sybase.com...
> > Is it more efficient to use dddw's in reports or to modify
> > the report sql to avoid the use of dddw's. I am not sure how
> > PB deals with dddw's in reports. Is the result set of the
> > dddw cached in memory and than used by the report or is the
> > dddw sql integrated into the reports sql like what occurs
> > with database views and than sent to the database? I could
> > not find any info on the net about this.
> > Any help would be appreciated.
>
>


0
Jerry
3/15/2006 8:57:33 PM
One reasoning that I have for doing as Paul suggested is that it's 
particularly difficult to format the displayed value of a dddw.


Jerry Siegel wrote:
> Could you explain the logic behind your recommendation? It seems to me that
> there are a number of factors, including how many rows in the report, how
> many rows in the DDDW, whether one retrieve for the DDDW can be shared to
> many columns [I'm thinking of a health care report that had 5 diagnosis
> codes, with 1500 or so in the code table], how well the DBMS handles its
> internal caching so that the join for each row doesn't always result in I/O
> to the code table, maybe even the robustness of the client machine that's
> doing the DW rendering.
> 
> "Paul Horan[TeamSybase]" <paul.horan@NOSPAM_cynergysystems.com> wrote in
> message news:441864b2@forums-2-dub...
>> I only recommend using DDDWs for data entry.  If you're running a report
>> that needs to show the "description" for a "code" value, then write the
> SQL
>> to perform a JOIN, and include the description in the result set.
>>
>> -- 
>> Paul Horan[TeamSybase]
>> Cynergy Systems
>> www.cynergysystems.com
>>
>> <JorgeG> wrote in message news:441872fd.7516.1681692777@sybase.com...
>>> Is it more efficient to use dddw's in reports or to modify
>>> the report sql to avoid the use of dddw's. I am not sure how
>>> PB deals with dddw's in reports. Is the result set of the
>>> dddw cached in memory and than used by the report or is the
>>> dddw sql integrated into the reports sql like what occurs
>>> with database views and than sent to the database? I could
>>> not find any info on the net about this.
>>> Any help would be appreciated.
0
Jason
3/15/2006 11:28:27 PM
We're very OCD about having the same format for all DDDW, so this isn't
something I though of. True, though.
"Jason 'Bug' Fenter" <fenterbug_@_hotmail_dot_com> wrote in message
news:4418a31b$1@forums-1-dub...
> One reasoning that I have for doing as Paul suggested is that it's
> particularly difficult to format the displayed value of a dddw.
>
>
> Jerry Siegel wrote:
> > Could you explain the logic behind your recommendation? It seems to me
that
> > there are a number of factors, including how many rows in the report,
how
> > many rows in the DDDW, whether one retrieve for the DDDW can be shared
to
> > many columns [I'm thinking of a health care report that had 5 diagnosis
> > codes, with 1500 or so in the code table], how well the DBMS handles its
> > internal caching so that the join for each row doesn't always result in
I/O
> > to the code table, maybe even the robustness of the client machine
that's
> > doing the DW rendering.
> >
> > "Paul Horan[TeamSybase]" <paul.horan@NOSPAM_cynergysystems.com> wrote in
> > message news:441864b2@forums-2-dub...
> >> I only recommend using DDDWs for data entry.  If you're running a
report
> >> that needs to show the "description" for a "code" value, then write the
> > SQL
> >> to perform a JOIN, and include the description in the result set.
> >>
> >> -- 
> >> Paul Horan[TeamSybase]
> >> Cynergy Systems
> >> www.cynergysystems.com
> >>
> >> <JorgeG> wrote in message news:441872fd.7516.1681692777@sybase.com...
> >>> Is it more efficient to use dddw's in reports or to modify
> >>> the report sql to avoid the use of dddw's. I am not sure how
> >>> PB deals with dddw's in reports. Is the result set of the
> >>> dddw cached in memory and than used by the report or is the
> >>> dddw sql integrated into the reports sql like what occurs
> >>> with database views and than sent to the database? I could
> >>> not find any info on the net about this.
> >>> Any help would be appreciated.


0
Jerry
3/15/2006 11:57:18 PM
Reply:

Similar Artilces:

Using dddw's on html dw's
I've posted this to the powerbuilder.datawindow forum but was not quite sure if that was the correct forum. Here's the problem: I've created an html dw that uses 2 dddw's. It is invoked by the passing of 2 arguments that are passed when then user signs on to the system. These arguments are captured in the DynaScript of the html page via the session variable. Here are the questions: (1) How do I pass the initial arguments - company # and user # - to the primary dddw so that only those records on the table that the dddw is using are available and (2) when the use...

slpinfo reports V1 and V2 DA's, but DA's report both version 2
Any idea why, when I do an SLPINFO /D on an XP machine (with 4.91 SP2"c"), it shows: 10.1.1.1 CNFG V2 10.1.1.2 CNFG V1 But both servers that have the DA's (.1 and .2) say they're using V2 We're at NW 6.5 SP5, BTW. Is the scope set, if any, in NetWare monitor on the .2 box? -- Tony Pedretti In article <6B58h.6544$rF4.5680@prv-forum2.provo.novell.com>, ynotpe@NoSPaMhotmail.com says... > Is the scope set, if any, in NetWare monitor on the .2 box? > > Yes, the scope is set on both servers On 11/20/2006 m_jonis wro...

dddw's on html dw's
I'm having an 'irrating' problem in creating an html dw that contains 2 dddw's. Whats supposed to happen is that when the html dw is invoked, it is passed 2 arguments that are used to specify who the user is - company number and user number. Based upon these arguments, the first dddw is supposed to populate a list of available selections based upon entries in a secondary table - company # and user # are contained in the secondary table that the dddw accesses. Based upon the user's selection from the primary dddw, the second dddw is supposed to be populated with the...

dddw's on html dw's
HELP!! We've run into a MAJOR problem with using dddw's on html dw's that require retrieval arguments. The html dw's use variables that are set based upon the user logon which are the exact same variables that are needed as the retrieval arguments for the dddw's. We haven't been able to find a way to pass these arguments within the html dw to the dddw control either through the use of session variables or linked arguments. If anyone has an example of how this is done or a suggestion on how to accomplish this I'd be forever grateful. TIA Brad ...

dddw's on html dw's
I have an html dw that has a dddw control on it. The purpose of this dddw is to provide the user the ability to select 'vendors' that are relative to the 'vendor item' the user is trying to add to the database. In order for this to work correctly, the dddw must have retrieval arguments set that only pull the vendors that are relative to that user - client # and store #. Both of these fields exist on the vendor table - which populates the dddw - and the vendor item table - which is what the user is updating. My problem is that I cannot seem to establish a link between ...

Using multiple DataSet's together in a RDLC Report
I am using Visual Studio 2008 and building an RDLC Report. This report uses two data sources: DataSet_A and DataSet_B. Both dataset's have a column "userId". I've created a list called List_A in the report that uses's DataSet_A as the DataSet and has Grouping based on DataSet_A.userId. Within List_A i want to print the DistinctCount of records in DataSet_B where DataSet_B.userId = DataSet_A.userId. I want to be able to use the data in DataSet_B to compute totals and averages. I tried setting DataSet_B's "Parent Group" to be =Fields!userId - bu...

Replace 1's and 0's in a gridview column with Yes's and No's
Is it possible to change the display of a column in a gridview to show a Yes for all 1's and a No for 0's that display in a particular column of a gridview bound to a database?  If so, can someone share the way with me?  I am using ASP.NET 2.0 with VB Code Behind.  Thanks One way you can do is thrrough  CASE in your select statement: Select YesNoColumn= CASE yourColumn WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' ELSE '' END FROM YourtableLimno <Columns>     <asp:TemplateField HeaderText="yourHeader" SortExpression="yourDataField"> ...

It's Linux !? No, it's BSD ! No, no, it's...
kFreeBSD http://wiki.debian.org/Debian_GNU/kFreeBSD a Debian distro using the FreeBSD kernel ! ObiWan wrote: > kFreeBSD > > http://wiki.debian.org/Debian_GNU/kFreeBSD > > a Debian distro using the FreeBSD kernel ! Why use a BSD kernel? I hope the reason is more than, just because they can. http://wiki.debian.org/Debian_GNU/kFreeBSD_why It's easy to understand why the would want to use Debian packages. :) -- Jimmy Johnson Registered Linux User #380263 >> kFreeBSD >> >> http://wiki.debian.org/Debian_GNU/kFreeBSD >> ...

Do dddw's work on external source dw's?
I've been trying to put a drop down datawindow on an external datawindow. So far, I can't get it to populate. The dddw's datawindow shows everything fine, and I can define the edit style in the dw OK. But the dddw doesn't populate when I display the datawindow. If I put a default value in the dw column, it displays the data value rather than the display value. Can this work? On Mon, 10 Nov 1997 16:59:09 -0800, Marvin Young <younmhy@dfw.wa.gov> wrote: >I've been trying to put a drop down datawindow on an external >datawindow. So far, I can...

Using PowerBuilder's or Infomaker's Query Painter in my applicatoin
I am at the point in my application where I would like to allow my users to create customized queries, and possibly reports. I have figured out how to use syntaxfromsql to convert sql to the special datawindow code, and this works find for me. But some of my users arn't as gifted in the sql department. So now I wish I had a nice GUI query builder. My question is; Is the query painter, and maybe even the datawindow painter accessable from Powerbuilder script kind of like an activeX? Or an object that I can drop into a window. I think I am to the point that I could recreate th...

accessing a datawindow's control's properties using expresisons
Is it possible to access a column's y coordinate and use it in a datawindow extression? example: if(column.y > 500, a..., b...) If( Long( Describe( 'column.Y' )) > 500, a..., b... ) -- Paul Horan[TeamSybase] VCI Springfield, MA www.vcisolutions.com "Leon Mandel" <lmandel@sao.state.tx.us> wrote in message news:3E308134.8070602@sao.state.tx.us... > Is it possible to access a column's y coordinate and use it in a > datawindow extression? > > example: > > if(column.y > 500, a..., b...) > ...

Help! I cannot access the DataGrid's ItemTemplate's LinkButton's Text Atrribute 's Value!!!!!!!!!!!
I write a datagrid's ItemDataBound method as follows:   private void dgTable_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)  {   if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)   {    if(!isRole("Manager"))    {     LinkButton tmp = (LinkButton)e.Item.FindControl("lbPassed");     if(tmp.Text == "Passed")     {      ((LinkBu...

can't get reports 'Old Chart's and 'New Charts' to work properly
1. If I try and draw a chart it doesn't go beyond June of this year so I'm missing a lot of data in the output. 2. Is there a reason for this - I have been modding bugzilla so that it has an extra status field from earlier this year - would that have had an impact ? 3. Also when I try and do a Old Chart or NewChart I can't see my new 'Status' field to select - this is ok if I do a bar chart though. cheers On Mon, 2011-12-05 at 03:25 -0800, nothtb@ukonline.co.uk wrote: > 1. If I try and draw a chart it doesn't go beyond June of this year so &g...

Hyperlink's, ImageURL's, and OnError's
I created an ASP:Hyperlink and set the ImageURL attribute so the link will be the image.If the image is missing, I would like it to display a 'missing image' pic that I have.  I know you can use the OnError attribute of the <img> tag to run some javascript to change it.Unfortunately I can't find a way to access the Hyperlink's Image that is inside it, so I can add an Attribute so the resulting <img> tag will have an OnError attribute inside of it.Any help?If my Hyperlink is called 'foo'....would I do...  ((Image) foo.Controls[0]).Attributes.Add(&...

Web resources about - Use dddw's in reports or modify report sql to avoid dddw's - sybase.powerbuilder.datawindow

Resources last updated: 1/8/2016 5:02:16 PM