Tags for stored procedure
volatile tables inside the stored procedure
Hello,    I have the following two questions please:  
stored procedure volatile table
How to concatenate rows into a varchar parameter in a Stored Procedure?
    Hi , I would like to concatenate a column data (multi rows) into one string inside a Stored Procedure. I’ve succeeded getting what I want using CTE (with recursive) but I can’t use it in my SP.   Is there a way to use CTE within a Stored Procedure?
with recursive stored procedure parameter
how to make Stored Procedure with dynamic SQL to display the records?
Can anyone please help? Below code can finish running with no error, but how to make it to display the records, just so I know I'm getting what I want. Thanks!   replace PROCEDURE dlcna_cateam.sp_test3  ( IN SRC_DB_NM VARCHAR(30) , IN SRC_TBL_NM VARCHAR(30) ) DYNAMIC RESULT SETS 1 BEGIN
stored procedure dynamic sql; parameters; stored procedures;
Stored procedure
Hello, I have been struggling with this concept and any help would be highly appreciated. Do we need a stored procedure here? here is a small mock up example, however this will be implemented on a large scale. Table 1
stored procedure select specific columns
Stored procedure
Hello,   I have been struggling with this concept and any help would be highly appreciated. Do we need a stored procedure here?   Table 1                            
stored procedure select columns
Java external stored procedure returns ResultSet - how to insert this contents to a (temporary) table
Hallo all, I have created a Java external procedure that returns a dynamic result set. I can successfully call it and it returns the correct data. Now how can I store this returned data to a new (temporary) table?
java stored procedure resultset table
How loop through table columns to determine distinct values
SELECT    vw_TPDDP.System_NME   ,vw_TDAD.Date_YYYY_FMT   ,vw_TDAD.Date_MM_FMT   ,vw_TPDDP.Company_CDE   ,SUM(vw_TPF.AMT) Amt FROM    vw_TDAD    INNER JOIN vw_TPF    ON (vw_TPF.Date_DIM_ID=vw_TDAD.Date_DIM_ID)    INNER JOIN vw_TPDDP    ON (vw_TPF.Profile_DIM_ID=vw_TPDDP.Profile_DIM_ID) WHERE    (  vw_TDAD.Date_YYYY_FMT  =  '2015'
loop stored procedure variable
Help with stored procedure metadat
I want to extract meta data for stored procedure from dbc tables something like this.   select a.name AS [ParameterName],   a.parameter_id AS [ParameterID],   TYPE_NAME(a.user_type_id) AS [ParameterDataType],   a.max_length AS [ParameterMaxBytes],  
stored procedure metadata
Stored Procedure conditional handler for spool out error 2646
I want to implement a continue handler in the stored procedure for query that can spool out. I check in pdcrinfo. SqlState_Codes there is no sqlstate associated to spool out error 2646.    Query is in below form and it gets spooled out if values for  column are skewed. INSERT INTO TAB1(col_value,row_count)
stored procedure conditional handler spoolout sqlstate
Stored Procedure Dependencies
Is there a method, at compile time, to have the stored procedure resolve a volatile table that is not created within the stored procedure?
stored procedure

Pages