#DateForumTypeThreadPost
914 Dec 2013 @ 12:43 PSTDatabaseTopicFastLoad lock TypeDoes fastLoad apply Exclusive lock on target table ? If not what type of lock is applied ?
819 Apr 2013 @ 04:21 PDTDatabaseReply3939 there is a mismatch between the number of parameters specified and the number of parameters requiredHere :FOD and :TOD are considered as strings. DBC.SYSEXECSQL doesnot replace :FOD and :TOD with their date values while running the Replace view query.   Now its working fine R...
719 Apr 2013 @ 12:59 PDTDatabaseTopic3939 there is a mismatch between the number of parameters specified and the number of parameters requiredI need last 2 years year and month part as an integer with descending rank in DBC.SYSEXECSQL for example : YEAR_MONTH_ID RELATIVE_MONTH 201304   1 201303  &...
604 Apr 2013 @ 09:20 PDTDatabaseReplyDynamic Column Name  REPLACE PROCEDURE SP_TEMP () CALL DBC.SYSEXECSL( 'REPLACE VIEW TEMP_V AS SELECT ID,ARTICLE, CASE YEAR_MONTH WHEN CAST(CAST(CAST(DATE AS FORMAT 'YYYYMM'...
504 Apr 2013 @ 12:33 PDTDatabaseReplyDynamic Column NameThanks again Dieter   I am done with the VIEW. I had to use a stored procedure which replaces the VIEW. The only drawback is, to get the report I need to first call the stored Procedure and...
404 Apr 2013 @ 05:48 PDTDatabaseReplyDynamic Column NameThanks Dieter   actually I am looking for a view that calculates Revenue for the last 2 years.   so i need coulmns in this fashion Revenue-201304 Revenue-201303 Reve...
304 Apr 2013 @ 12:18 PDTDatabaseReplyDynamic Column NameIn the query mentioned above TD is not supporting Dynamic column. END AS 'REVENUE-'||CAST(CAST(DATE AS FORMAT 'YYYYMM')AS CHAR(6))   Its giving an error saying : SELECT Fai...
203 Apr 2013 @ 09:47 PDTDatabaseTopicDynamic Column NameHow can I create a view with Dynamic column name ? column name is dependent on the current_date   something of this sort   CREATE VIEW TEMP_V SELECT ID,ARTICLE, CASE YEAR_MONTH WH...
128 Dec 2012 @ 08:57 PSTGeneralTopicAlternate to DBC.SYSEXECSQL()  SET VAR_QUER = 'SELECT COUNT(A1.DTTM) INTO VAR_INS FROM ' ||                                 &...