DECLARE and SET not working on VDB

adi22 Jul 17, 2018 9:17 AM

1. Re: DECLARE and SET not working on VDB

shawkins Jul 17, 2018 9:32 AM (in response to adi22)

You are using SQL Server syntax which is not directly supported. You can use Teiid procedure syntax in a procedure block to do something similar.
Actions
2. Re: DECLARE and SET not working on VDB

adi22 Aug 6, 2018 6:07 AM (in response to shawkins)

Hi Steven,

Please guide us on how to write a Teiid procedure for DECLARE AND SET
Actions
3. Re: DECLARE and SET not working on VDB

shawkins Aug 6, 2018 8:00 AM (in response to adi22)
You can do it all as part of declare:

BEGIN DECLARE TIMESTAMP myTs = timestampadd(sql_tsi_day, -5, now()); ... END

Or in a procedure assignment does not require a keyword:

BEGIN DECLARE TIMESTAMP myTs; myTs = timestampadd(sql_tsi_day, -5, now()); ... END
Actions