#DateForumTypeThreadPost
503 May 2008 @ 11:35 PDTUDAReplyUse CASE statement in Fastload scriptYou can't use case statement directly in the fastload script.It is possbile for you to embed INMOD into fastload to do such transfer job.Or you can use NULLIF in the define section. But with this m...
405 Apr 2008 @ 05:36 PDTUDAReplyQuery select..where..in on a partitioned table: partitions are not usedTo eliminate partition, you must put constant constraint on partition column.when you use derived table, it will be treated as PPI and NPPI join without partitioning elimination.Is your purpose to ...
329 Mar 2008 @ 09:45 PDTUDAReplyMacro Variable TYPE, and a quizuse varchar(255), and format the all the variables into one string passed to macro.Do you want to consturct a dynamic query? Store procedure can achieve the goal.
229 Mar 2008 @ 09:39 PDTUDAReplyCase Statement Variable.You can use paramenter in macro,for example:create macro testm(iday char(10)) as(select case when date=:iday then 1 else 0 end;);usage:exec testm('2008-03-29');
124 Mar 2008 @ 08:02 PDTDatabaseReplyHow to insert a string with quotes into a char datatype?e.ginsert into tbl_a values('ab''cd');Two consequent ' stand for one ' in teradata.