cancel
Showing results for 
Search instead for 
Did you mean: 

How to execute a SQL query which includes temp table ( creates and inserts ) - JDBC Step

SOLVED
Highlighted
Contributor

Re: How to execute a SQL query which includes temp table ( creates and inserts ) - JDBC Step

This is solved, i used

 

def a = context.expand( '${DataSource#a}' )
def b = context.expand( '${DataSource#b}' )

 

sql.eachRow("""Declare @PortfolioOldCode varchar(3) = ${a},
@EndDate Date = ${b},

 

insted of 

 

sql.eachRow("""Declare @PortfolioOldCode varchar(3) = context.expand( '${DataSource#a}' ),
@EndDate Date = context.expand( '${DataSource#b}' )

 

or

 

sql.eachRow("""Declare @PortfolioOldCode varchar(3) = a,
@EndDate Date = b

 

 

-- Thanks for helping in guys 

 

 

 

 

View solution in original post

Highlighted
Occasional Contributor

Re: How to execute a SQL query which includes temp table ( creates and inserts ) - JDBC Step

I do not see the original issue resolved as still CREATE command is not working from JDBC test step. At least for me. I started one more topic to for the same issue: https://community.smartbear.com/t5/SoapUI-Open-Source/CREATE-TABLE-does-not-work-from-JDBC-test-step...

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors