#DateForumTypeThreadPost
508 Sep 2016 @ 10:21 PDTDatabaseTopicRules for Multi value compression Can anyone help me on the below questions..   1. Is MVC allowed on primary index ? 2. Having MVC on too many columns will create problem ? 3.Is appliying compression on truncate and load t...
408 Sep 2016 @ 10:14 PDTDatabaseReplyCan we pass object as parameter in a macro ? Thanks Fred.. I was able to achieve through stored procedure.. thanks for your support
329 Aug 2016 @ 02:57 PDTDatabaseReplyCan we pass object as parameter in a macro ? thanks Todd .. after your suggestion i tried with stored procedure .. but still i m a bit confused how to implement it with stored procedure.. can u please guide me ? I m trying it .. but i m gett...
226 Aug 2016 @ 10:49 PDTDatabaseReplyCursors in stored procedures REPLACE PROCEDURE proc () DYNAMIC RESULT SETS 1 BEGIN   DECLARE c CURSOR WITH RETURN ONLY FOR   SELECT * FROM dbc.TablesV;   OPEN c; END; ...
123 Aug 2016 @ 04:20 PDTDatabaseTopicCan we pass object as parameter in a macro ? For eg :  replace macro database1.macro1(databasename char(50),tablename char(50)) as ( Select count(*) from :databasename.:tablename; );   Can someone let me know ho...