Search results for query: *

I've taken a look at Volume 5, Chapter 7 and I believe I've come across a syntax problem in the manual. on page 7-51, Example 2:Group Sum The query is coded as such: select city, kind, sales SUM(sales) OVER (ROWS UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM monthly; When I attempt to...

Yes, I verified access rights with the DBA's.

I am trying to create the below SP: create procedure core_proddb_s.table_nme3( in p1 char(50), out p2 char(50) ) begin call DBC.SysExecSql('Select campaign_id from ' || :p1); End; This is the message that is being returned when I attempt to create the proc: SPL1078:E(L3), User is not...

I am trying to parse a table name from a field in a teradata table, pass the table name to a variable and use the variable to populate the table name in a select statement. Is this possible? create procedure core_proddb_s.table_nme2( in p1 int ) begin Declare var1 char(50); select...

Thanks, this solves my issue.

I want to generate a number and populated a table field via sql based upon a starting number. For example my starting number is 102, and I want to assign a number to a number field for each record in my table by incrementing the starting number by 1 for each record.