Hello experts, I am pretty new to DB2. I have a query that returns some result. For each row of the results, I should pass a value from results to external Procedure. Now I want an union of both the results. Here is what I have tried. And I am banging my head to wall since last three days. Can someone please help me with this? It is really really important now.

BEGIN

DECLARE EOF_COND INTEGER DEFAULT 0 ;
DECLARE @ITEM CHAR ( 30 ) ;
DECLARE @BIN CHAR ( 10 ) ;
DECLARE @SIZE CHAR ( 30 ) ;
DECLARE @TIRERACK CHAR ( 10 ) ;
DECLARE @RACKSBIN CHAR ( 10 ) ;
DECLARE @DESC CHAR ( 100 ) ;
DECLARE @DESC1 CHAR ( 100 ) ;
DECLARE @ONHAND CHAR ( 10 ) ;
DECLARE @COMTD CHAR ( 10 ) ;
DECLARE @USEDRACKS CHAR ( 10 ) ;
DECLARE @OPENRACKS CHAR ( 10 ) ;
DECLARE @TEMP CHAR ( 10 ) ;
DECLARE RESULT INTEGER DEFAULT 0 ;

DECLARE CR1 CURSOR WITH RETURN FOR

SELECT T2 . ICITEM , T2 . BABLOC , C . ISSIZE , D . UNITSPER
, E . NBRRCKBINB , F . ICDSC1 , F . ICDSC2 , T2 . TQOH , T2 . TQCM
, CEIL ( INTEGER ( ( T2 . TQOH ) ) / D . UNITSPER )
NBR_USED_RACKS
, E . NBRRCKBINB - ( CEIL ( INTEGER ( ( T2 . TQOH ) ) / D . UNITSPER ) )
NBR_OPEN_RACKS , ( E . NBRRCKBINB * D . UNITSPER ) - T2 . TQOH
FROM (
SELECT A . BACMP , A . BALOC , MIN ( A . BAITEM ) ICITEM
, A . BABLOC , INTEGER ( SUM ( A . BAQOH ) ) TQOH ,
INTEGER ( SUM ( A . BAQCM ) ) TQCM
FROM TESTDATA . VINBINI A WHERE A . BALOC = '13' AND 1 = A . BACMP AND
A . BAQOH - A . BAQCM > 0 GROUP BY A . BACMP , A . BALOC , A . BABLOC HAVING
MIN ( A . BAITEM ) = MAX ( A . BAITEM )
AND SUM ( A . BAQOH - A . BAQCM ) > 0
) AS T2
, TESTDATA . PALITMLOC B , TESTDATA . VINITEMSIZ C , TESTDATA . PALSIZQTY D , TESTDATA . PALBINPF E
, TESTDATA . VINITEM F
WHERE T2 . BACMP = B . TACOMP AND T2 . ICITEM = B . ICITEM
AND T2 . BALOC = B . IALOC AND T2 . ICITEM = F . ICITEM
AND T2 . ICITEM = C . ISITEM
AND B . PALLETID = D . PALLETID
AND C . ISSIZE = D . ISSIZE
AND E . TACOMP = T2 . BACMP
AND E . IALOC = T2 . BALOC
AND E . IMBLOC = T2 . BABLOC
AND E . PALLETID = B . PALLETID
ORDER BY 1 , 2 ;

OPEN CR1 ;
SET EOF_COND = 0 ;
FETCH CR1 INTO @ITEM , @BIN , @SIZE , @TIRERACK , @RACKSBIN , @DESC , @DESC1 , @ONHAND , @COMTD , @USEDRACKS , @OPENRACKS , @TEMP ;

CALL TESTDATA . PARECR24SP ( '01' , '13' , @BIN , RESULT ) ;

RETURN ;

END

Your help is much appreciated. Thanks Happy Coding!

Hello Experts, I have been to most of the links provided by Google for the below question. All I get is difference. For some reason, there is a table has all the columns as Key columns which is kinda weird but I have to deal with this. Let me put this way. My table contains Data with 6 columns and all are Keys. If I want to edit something then I will have to either delete entire row first and Insert it again or do something. So now if we have sequence object, If I edit the row with a extra Item, wont that be a new row? will that also be existing row with same sequence? Please help me in understanding this.

Your help is much appreciated. Thanks Happy Coding!

Yeah I have already been there. But if my panel has button/ Textbox or any other controls I do not understand how to proceed further.

Your help is much appreciated. Thanks Happy Coding!

OK let me put this again Clear. You must be knowing for Accordion in Web applications work. I want a similar one in windows. I already did try. But If my panel has any other controls other than Label, it doesn't work. Could not figure it out how to achieve this with all the controls in the panel. Here is the code that will act labels click as accordion

Private Sub ButtonClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label2.Click, Label3.Click, Label5.Click
'find out which label was clicked
Dim lbl As Label = CType(sender, Label)
'find the panel containing the label
Dim pnl As Panel = lbl.Parent

For Each p As Panel In TableLayoutPanel1.Controls
  Dim l As Label = CType(p.Controls(0), Label)
  If p.Equals(pnl) Then
    'expand or collapse the panel
    If p.Height = 150 Then
      p.Height = 25
      l.ForeColor = Color.Black
    Else
      p.Height = 150
      l.ForeColor = Color.Black
    End If

  Else
    p.Height = 25
    l.ForeColor = Color.Black
    l.Image = My.Resources.arrow
  End If
Next

End Sub

Your help is much appreciated. Thanks Happy Coding!

Meaning I worked on one such form and I tried to create my own code for accordion. But my form has only label as control. If I add more controls, I do not know how to proceed for accordion. Real time meaning: which has most used the controls in the form like combo box, listbox, button etc

Your help is much appreciated. Thanks Happy Coding!

Oops. I am sorry. I don't want to help me in writing an article. I actually wanted an article/ tutorial to understand accordion in windows forms. I am working on windows forms and I wanted to do something like in Web Accordions. That's the only intension.

Your help is much appreciated. Thanks Happy Coding!

Could someone help in understanding with examples of multiple controls in a Panel which is in an Table layout and should behave like web Accordion? I have gone through the websites and other tutorials but none of those examples have real time scenarios. So it is very hard to find the exact procedure of accordion will act in windows forms with multiple controls like textbox, combo box, checked list box, button etc. I would like to have one such article with real time Examples of Code snippets from SA because this concept has not been explained properly anywhere in google with snippets and examples

Your help is much appreciated. Thanks Happy Coding!

Thank you :)

Your help is much appreciated. Thanks Happy Coding!

Thank you F-ES Sitecore. Is there anyway I can assign session value from same JQuery?

Your help is much appreciated. Thanks Happy Coding!

My both the buttons are not in same.

<form id="TireQuickSearch" method="post" action="DealerTireSearchResults.aspx" onsubmit="return ValidateTireQuickSearch(this);">
<input type="hidden" name="FormAction" value="TireQuickSearch" />
<input type="hidden" name="SortOrder" value="<asp:Literal id='litSortOrderDescription' runat='server' /> />
<label> <input type="text" name="TireQuickSearch" id="PART#" class="tf1" value="<asp:Literal id='litTireQuickSearch' runat='server' /> />
</label>
<input name="SearchButton" type="image" src="images/btn_tireSearchADV-dim.jpg" disabled="disabled" /><br />
</form>

On the below button click I want my above Button click action to happen

<asp:Button ID="btnSubmit" runat="server" Text="Submit" />

Your help is much appreciated. Thanks Happy Coding!

button is in ASP web form. I want that event to happen before user clicks on it.

Your help is much appreciated. Thanks Happy Coding!

ASP web forms. please tell me how to do

Your help is much appreciated. Thanks Happy Coding!

Hello Experts, I have a Textbox and a button below it. In that Textbox, I am passing a session value and I want to make that button click event occur without actually clicking it. Is that possible? If Yes How? Can you please tell me with sample code or tutorial?

Your help is much appreciated. Thanks Happy Coding!

Thanks Richard

Your help is much appreciated. Thanks Happy Coding!

sweet and simple Thank you.

Your help is much appreciated. Thanks Happy Coding!

Hello Experts, I am generating a function that Exports to Excel using Interop.dll in Vb.net. So Do you think that I need to install office for this on Server machine if I deploy the application? Are there any other things that does export to excel and which will not require Office to be installed on the server machine?

Your help is much appreciated. Thanks Happy Coding!

I got this solved. I have two update panels and so it behaves weird ... I arranged them properly in one update panel and works good. Thank you all

Your help is much appreciated. Thanks Happy Coding!

It is

Your help is much appreciated. Thanks Happy Coding!

I have a page with a grid view and it has a link button called Details. When I click on Details it shows the detailed view below panel with all textboxes and dropdowns. I also have a button Export-to-Excel. This button when first loaded will be one. But soon clicked on detailed view it appears twice. wondering where is this coming from. I don't see anything wrong on ASPX page.

Your help is much appreciated. Thanks Happy Coding!

Thank you Rich

Your help is much appreciated. Thanks Happy Coding!