from an fex we have some values which are retrieved from a table (please note
that the count of records will not be the same). by clicking a button we need to
insert the data into the respective table. we need to find a logic in which we
can use the same query passed with different values to insert into the table.

Not sure what kind of table you are rying ot pass these values into, but -write might be the solution you seek to write it out, while the
-read would be the mechanism to read from the source. you can control this by clicking on a button to invoke the -read.

Hope this helps.

Did you try putting the query in a loop using -REPEAT ? If I understand you correctly, we also have apps that re-run the same query again and again with changing values in the WHERE statemenent. The input can be static or dynamic (like getting input from another file).
Here is a high level code sample where the input comes from a Hold file :

-SET &HCNT=0;
-READ HOLDFL1 &INVAR.A10
-*
-REPEAT LBL_LOOP1 WHILE &IORETURN EQ 0;
-SET &HCNT=&HCNT + 1;
-*
SQL DB2
SELECT FLD1,FLD2 FROM DB1.TBL1
WHERE FLDX='&INVAR.EVAL'
;
TABLE
ON TABLE HOLD AS HSQL&HCNT..F
END
-*
-READ HOLDFL1 &INVAR.A10
-LBL_LOOP1
-*
(you will then end up with &HCNT value number of Hold files to concatenate and process further).
-*
Hope that example helps you understand the principle behind the process. Your query could be an INSERT or UPDATE query as applicable.

Sandeep Mamidenna

Here's some logic I've used to read from a table and then loop through the values. I'm not sure either about what type of table you need to insert into, but if you mean insert into a database table, I would look at maybe creating a stored procedure to insert the value with the value as the parm to insert. You can then invoke the stored procedure from WF as you loop through your results from the table. Here's the code:

TABLE FILE table_name
WRITE some_field
WHERE ....
ON TABLE HOLD AS HLDVALS
END

-*This returns the number of records retrieved
-*so you'll know how many times to loop on the read.
-SET &RECCNT = &LINES;

-REPEAT READLOOP &RECCNT TIMES
-READ HLDVALS &NEWVAL.A10.
-*You can use whatever logic you need here, such as
-*call a stored procedure, create define or table
-*logic, etc...I'm using stored procedure here for this example.
SQL SQLMSS SET SERVER reportcaster
SQL SQLMSS EX sp_name '&NEWVAL'
END
-YEARS
-READLOOP



I'm using a sql server stored procedure in my example, the syntax may be different depending on you platform.

I'm not sure if this is what you are looking for, just thought I'd share something I've done in the past.

thanks all for your reply. i am working on to achive this using JSP