Pages
![]() |
Hello,
I have the following two questions please:
07 Sep 2016
,
|
![]() |
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?
02 Aug 2016
,
|
![]() |
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
14 Jul 2016
| 3 comments
,
|
![]() |
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
06 Jul 2016
| 1 comment
,
|
![]() |
Hello, Table 1
06 Jul 2016
,
|
![]() |
Hallo all,
22 Mar 2016
| 1 comment
,
|
![]() |
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'
17 Feb 2016
| 3 comments
,
|
![]() |
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],
03 Feb 2016
,
|
![]() |
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)
18 Nov 2015
,
|
![]() |
Is there a method, at compile time, to have the stored procedure resolve a volatile table that is not created within the stored procedure?
12 Nov 2015
| 2 comments
,
|
![]() |
Hi,
15 Oct 2015
| 1 comment
,
|
![]() |
Hi , I am using a Stored procedure in teradata , in which multiple updates are written. I want to generate log file for Stored Procedure. so that i can come to know how many rows are getting updated by each update statement. is there any why to implement this.
09 Oct 2015
| 3 comments
,
|
![]() |
Using TD 13.10.
03 Sep 2015
| 1 comment
,
|
![]() |
We have the column defined as below
25 Aug 2015
| 2 comments
,
|
![]() |
Hi,
12 Aug 2015
| 1 comment
,
|
![]() |
Hi,
04 Aug 2015
| 2 comments
,
|
![]() |
Hi,
20 Jul 2015
| 6 comments
,
|
![]() |
Hello,
11 May 2015
| 1 comment
,
|
![]() |
Below is the statement that is a part of a stored procedure.
06 May 2015
,
|
![]() |
I am working on a stored procedure for dropping all sessions for a specific user and I have written a SP to do this. the SP creates but it fails when I run it with an id. I can get the generated SQL out of DBQL and it runs but the SP fails.
27 Apr 2015
| 6 comments
,
|
![]() |
Hi
13 Feb 2015
| 2 comments
,
|
![]() |
Hi
10 Feb 2015
| 7 comments
,
|
![]() |
Good day!
02 Feb 2015
| 1 comment
,
|
![]() |
The following procedure can be called with no errors when the Procedure input parameter is not used in the WHERE clause, but gives the following Syntax error when the input parameter is used:
3706: Syntax error: expected something between a string or a Unicode character literal and the 'AT' keyword.
07 Jan 2015
| 8 comments
,
|
![]() |
Hi,
19 Dec 2014
| 7 comments
,
|
![]() |
Hi Guys,
10 Dec 2014
| 2 comments
,
|
![]() |
Hi,
06 Nov 2014
| 1 comment
,
|
![]() |
|
![]() |
Can someone elaborate on the SQL SECURITY INVOKER option in stored procedures? I need to create a stored procedure and ensure the privilege(i.e. the privilege on the underlying database objects inside the procedure) of the user calling the procedure is always checked and I think the SQL SECURITY INVOKER option achieves that.
06 Oct 2014
| 4 comments
,
|
![]() |
Dear All
02 Oct 2014
| 3 comments
,
|
![]() |
Is it possible to create stored procedures in Aster? Or do anything like a SAS macro? I would like to be able to call a section of code with a simple statement/reference.
30 Sep 2014
| 1 comment
,
|
![]() |
REPLACE Sample_Proc
30 Sep 2014
| 3 comments
,
|
![]() |
Format:HTML Format Version:1.0 StartHTML: 165 EndHTML: 13031 StartFragment: 314 EndFragment: 12999 StartSelection: 314 EndSelection: 314 REPLACE PROCEDURE DBNAME.PROC(
18 Sep 2014
,
|
![]() |
|
![]() |
When i execute the below code in a STORED PROCEDURE i get an syntax error saying "Expects somthing like an EXCEPT keyword UNION keyword or MINUS keyword between a between a String and YYYYMMDD". Please help me fix this syntax error. Thanks.
01 Sep 2014
| 7 comments
,
|
![]() |
Hi,
21 May 2014
| 1 comment
,
|
![]() |
Hi All,
08 May 2014
| 1 comment
,
|
![]() |
Hi Folks,
11 Apr 2014
| 3 comments
,
|
![]() |
Hi Guys,
19 Mar 2014
,
|
![]() |
We have a requirement to mask sensitive information being loaded into the tables. Let's say we had the first three groups in place, the fourth one came in as a new requirement, and so had to make a coding change. We currently have logic similar to this.
Case when diagnosis_description like '%psych%' Then 'sensitive info'
12 Feb 2014
| 1 comment
,
|
![]() |
We are recompiling stored procedures and some are erroing at execution because they use a different default date format. For example: The current default date format is YYYY-MM-DD, and the SP uses a literal defined as '11/02/2012'. The SP compiles ok but errors when executed. I am assuming the default date format was changed when this SP was compiled.
13 Jan 2014
| 2 comments
,
|
![]() |
Hi,
10 Dec 2013
| 3 comments
,
|
![]() |
Dear colleges,
28 Oct 2013
| 2 comments
,
|
![]() |
Hi - I have Created it using SQL Assistant but getting error that ..'the proc. is in Teradta Mode' for some other user who was trying to execute it. After Changing View--> ANSI SQL and when i do a HELP PROCEDURE <<Proc_Name>> ATTRIBUTES, I see 'Transaction Semantics as 'TERADATA'.
09 Oct 2013
| 4 comments
,
|
![]() |
Hi All,
08 Oct 2013
| 3 comments
,
|
![]() |
Hi all
I am using Teradata Express 13.10 & I am trying to write a stored procedure which uses multiple references to dataset defined using a 'common table expression.'
I have a test case below:
18 Sep 2013
| 8 comments
,
|
![]() |
Hi everyone, .logon TD_2700/TPTLoader,
*** Logon successfully completed. *** Teradata Database Release is 14.00.03.03
30 Aug 2013
| 1 comment
,
|
![]() |
Hello,
10 Jun 2013
| 1 comment
,
|
![]() |
Hi, And what is the issue in using if exists in teradata? Thanks in advance.
28 May 2013
| 1 comment
,
|
![]() |
I am new to Teradata and I am trying to convert and Oracle stored procedure. I have been successful at getting the procedure to run but I need to know how to get the correct results from the results set. In our Oracle procedure we run a set of queries to insert data into a table and then sent the results from that table in a ref cursor.
16 May 2013
| 4 comments
,
|