Hello,    I have the following two questions please:  

    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?

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

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

Hello,   I have been struggling with this concept and any help would be highly appreciated. Do we need a stored procedure here?   Table 1                            

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?

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'

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],  

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)

Is there a method, at compile time, to have the stored procedure resolve a volatile table that is not created within the stored procedure?