Passing Values to a After-SQL.
Posted: Thu Nov 30, 2006 2:53 am
Hi there,
i am new to this Forum and first want to say "Hello" to every DataStage User...
My Question is:
I have a Transformer Stage who writes Rows into a table (lets call LERBINFO). In another table (lets call LOGINFO) i want to log the information, how many rows where written.
So i have the information @INROWNUM from the Transformer Stage and want to write this information into the table LOGINFO in the After-SQL.
(I assume, that the After-SQL ist called ONCE every run?
But things like: INSERT INTO LOGINFO("LERBINFO", #@INROWNUM#) dosn't work. It only works with Job Parameters.
Any Idea?
Thanks...
Barny
i am new to this Forum and first want to say "Hello" to every DataStage User...
My Question is:
I have a Transformer Stage who writes Rows into a table (lets call LERBINFO). In another table (lets call LOGINFO) i want to log the information, how many rows where written.
So i have the information @INROWNUM from the Transformer Stage and want to write this information into the table LOGINFO in the After-SQL.
(I assume, that the After-SQL ist called ONCE every run?
But things like: INSERT INTO LOGINFO("LERBINFO", #@INROWNUM#) dosn't work. It only works with Job Parameters.
Any Idea?
Thanks...
Barny