DSXchange

Hi Krish, Create three stage variables as suggested by Shane as follows (sort the record first) Stage Variables and derivations (use the same order of stage variable) SVCurrentCount --If SVPreviousName is NULL or SVPreviousName <> DSLink.Name Then 1 Else SVPreviousCount +1 SVPreviousCount --SVCurren...

Hi Raj, Pass the environmental variable as job parameter. It will work Regards Thiru Hi all, I am having a shell script which i would be running from a before/after routine for getting empid like this v_emp_id=`echo "SET HEADING OFF;\n select nvl(max(emp_id), 0)+1 from location ;\n exit\n"...

Hi Raj, Pass the environmental variable as job parameter. It will work Regards Thiru Hi all, I am having a shell script which i would be running from a before/after routine for getting empid like this v_emp_id=`echo "SET HEADING OFF;\n select nvl(max(emp_id), 0)+1 from location ;\n exit\n"...