All Forums Database
prav33ns 1 post Joined 09/13
07 Jul 2014
Record count increases in PreSQL-Informatica in the absence of Semi Colon(;), Database : Teradata

My PreSQL query in the WorkFlow of Informatica had 2 parts, 1.Insert query 2.Refresh Stats procedure call In the absence of a ';' between these 2 parts gives me record count in Millions but in the presence of the ';' it gives me record count in Thousands.
My Question is , 1. Why is it not throwing the Error for the absence of semi Colon? 2.Why is the increased record count?

gdev 7 posts Joined 04/14
07 Jul 2014

To understand more on this, can you please paste the sample of the query sequence you are running ?

You must sign in to leave a comment.