Question Re: BODS while loop in Technology Q&A

BODS while loop

Former Member — Wed, 17 Sep 2014 13:14:34 GMT

I am trying to use a while loop to execute a (dataflow to write into a template table)

I have a counter from another template table, say ROW_NO. I have to execute the dataflow in increments of 50 rows until all the ROW_NO are executed.

How can I do that?

Also how can I write to the same template table or append the data without losing the data during the while loop execution?

I am using BODS 14.1.1.210.

Cheers!

Re: BODS while loop

Former Member — Wed, 17 Sep 2014 13:48:53 GMT

Check this

Re: BODS while loop

former_member106536 — Wed, 17 Sep 2014 19:40:02 GMT

using a sql statement in a script, set a global variable to a count of your table.

set another variable = -1 * ( floor( -1 * <var_count> / 50))

(this will be your max count for your while loop iterator) while counter <= max count

create a current iter global variable, assign it a starting value of 0.

you'll need a side table to join to your source table, which has a sequence number and some index to join to source. Counter starts at zero, so you where off counter >= counter * 50 + 1 and var_counter_iter <= (var_counter_iter + 1) * 50

left outer join on sequence table - source table(on index), then where off on sequence table index is not null.

import your temp table as a perm table.

then after the dataflow, inside the while loop ... increment your var_counter_iter. ($var_counter_iter = $var_counter_iter + 1;)

If you followed that...