From taglibs-user-return-1402-apmail-jakarta-taglibs-user-archive=jakarta.apache.org@jakarta.apache.org Fri Oct 12 14:22:31 2001 Return-Path: Delivered-To: apmail-jakarta-taglibs-user-archive@jakarta.apache.org Received: (qmail 97351 invoked by uid 500); 12 Oct 2001 14:22:30 -0000 Mailing-List: contact taglibs-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk Reply-To: taglibs-user@jakarta.apache.org list-help: list-unsubscribe: list-post: Delivered-To: mailing list taglibs-user@jakarta.apache.org Received: (qmail 97341 invoked from network); 12 Oct 2001 14:22:29 -0000 Subject: Stored procedure data. To: taglibs-user@jakarta.apache.org From: "Vaibhav Bhanot" Date: Fri, 12 Oct 2001 10:22:50 -0400 Message-ID: X-MIMETrack: Serialize by Router on sdbo1005/DBNA/DeuBaInt/DeuBa(Release 5.0.8 |June 18, 2001) at 10/12/2001 10:22:04 AM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Vaibhav, The name of the stored procedure for Consolidated Account Summary is view_asset_acct_summary which is created in INS_D database. This is how you will be calling the stored procedure: exec view_asset_acct_summary @user_id = 'ONLINE_INC', @user_type = 'C', @acct_info = null, @search_type = 'C', -- A = account number, L = account List, null = not known @gcis_no = null, @source_system_cd = null, @bank_no = null, @screen_id = null, @show_excluded_accts = null, @cust_id = null, @input_date = '9/28/01', @ccy_id = 'USD', @grouping_by = 'P', @category_id = null, @category_indicator = null, @report_id = 2, -- 1 =Asset Account Summary - Financials, 2 = Consolidated Account Summary - Report @debug = null go The resultant columns are: product_desc, account_no, account_title, market_value, accrued_income, date_value If you have any questions or comments let me know. Thanks Sridhar Saraf -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.