Muti sql statements execution issue with DB2 - iSeries

[shinystar999]

Hello,

I  am encountering "[SQL0104] Token ; was not valid. Valid tokens: ). " error  , when  I  execute below statement.

Using ; (semi colon) for  sql statements separation.

Please  let me know , how  to fix  it.

Thanks in advance.

<cfquery name="qInsertTo" datasource="dsn">

    <cfloop from="1" to="25" index="i">

        insert into test1(userId,firstname) values('xx#i#','fname#i#') ;

    </cfloop>

</cfquery>

PS:  I  don't want to keep  cfloop outside  cfquery.