Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

How to run SQL with a variable

JeffStrom
JeffStrom Posts: 2

I am trying to insert a record into our DB2 database and one of the columns contains a CLOB so to pick up the text file it is included as a variable (for example, ${data1-10||C:\workspace\DownloadFiles\EXPORT_DATA\dbvis-9421411203761954562.txt||TextData||noshow vl=file}$) which was exported from DBVisualizer. Currently, SOAtest throws a error as it interprets ${...} in the string as a variable; I would like it to be interpreted as literal text. Is there a way to insert records such as this one using the DBTool in SOAtest?

Best Answer

  • benken_parasoft
    benken_parasoft Posts: 1,089 ✭✭✭
    Answer ✓

    In SOAtest, you can typically use '\' (backslash) to escape the dollar sign.

Answers