#DateForumTypeThreadPost
1226 Dec 2012 @ 01:36 PSTDatabaseReplyteradata error 3523The only reason I think of is, the user id which is calling this SP doesn't have proper rights to the database name you pass in your SP. Please ask your DBA team to provide that.
1126 Dec 2012 @ 01:30 PSTDatabaseReplyTransposed multiple rows into one column and one rowOne thing I forgot to mention above. In my query, field called 'rnk' of MYDB.MYTB is the ranked column by columname values. It happens before the recursive query starts. Like bel...
1026 Dec 2012 @ 01:25 PSTDatabaseReplyTransposed multiple rows into one column and one rowThis is how I resolved my issue, that might help. WITH RECURSIVE base (c_rnk, c_list) AS ( SELECT rnk c_rnk, CAST(TRIM(columnname) AS VARCHAR(5000)) c_list FROM MYDB.MYTB WHERE rnk = 1 ...
920 Dec 2012 @ 08:05 PSTAnalyticsReplyDate and formatAre you running this query using teradata sql assistant ? sometime the answerset of it has default format. If you want to see the output in YY/mm/dd then I would say you should use CAST function in...
820 Dec 2012 @ 07:54 PSTDatabaseReplyMerge SQL Duplicate Key errorCan you make sure that contact_object_id is unique in both stg and pr tables by taking count(*) and count(distinct contact_object_id) ? Because MULTISET and UPI together do not make sense to me.&nb...
720 Dec 2012 @ 01:09 PSTDatabaseReplyMerge SQL Duplicate Key errorLooks like, at least one of the contact_object_id in the source file (stg) is already present in your target table (PR) (may be from previous loads). And as you have defined contact_object_id ...
620 Dec 2012 @ 10:13 PSTDatabaseReplyTransposed multiple rows into one column and one rowYup, found the solution using recursive. Thanks.
519 Dec 2012 @ 08:08 PSTDatabaseReplyteradata error 3523Hi, do you have any views in this bteq ? Did the view defintion got changed by any chance in one month ? Because, views might be pointing to different database tables now and the user doesn't h...
419 Dec 2012 @ 05:25 PSTDatabaseTopicTransposed multiple rows into one column and one rowHi,  I have 2 tables. One table with 1 column and multiple rows (say, 5) and another table is also with 1 column but can have only 1 row. I need to store all the rows of table 1 in the one co...
319 Dec 2012 @ 11:56 PSTDatabaseReplyWhat is dynamic sqlIt worked very well. Thank you.  
219 Dec 2012 @ 07:51 PSTDatabaseReplyWhat is dynamic sqlThat Helped. Thanks. One more question, I need to pass string as parameter and need to use in WHERE clause. For example in a dynamic SQL, 'SELECT * FROM DBC.COLUMNS WHERE TABLENAME =' || ...
117 Dec 2012 @ 09:41 PSTDatabaseReplyWhat is dynamic sqlHi, I am using dynamic SQL to do the update. I face difficulty when I want to filter my query using any string. For example - where attribute1 = 'ABC' - It doesn't allow that and consi...

Pages