Querying SQL inside formula tool

[Pickaxe]

Im trying to add my "SQL query" into the "formula tool" with data type as V_Wstring, and then pass it to the database tool ( dynamic input in db ) with a source link to execute the query.

But my issue is - the sql code becomes "truncated" 

I have tried string,v_string but none of them worked 

I.e. when executed after few words the code ends with three dots ,example: [select isg ...]

IS THERE ANY WAS TO PASS THE ENTIRE QUERY WITHOUT IT GETTING TRUNCATED.

Kindly advice. Stuck on it for days.

[atcodedog05]

Hi @Pickaxe 

If you created the SQL query using formula tool it should be able to accommodate a large length. Even though it might look truncated it will still have the data try running and checking it once.

[atcodedog05]

Hi @Pickaxe 

To view the complete data you can add a browse tool after running the workflow open a browse window by selecting below options.

In the new window double click on your data cell to see the full existing data

Hope this helps : )

[Pickaxe]

Thanks a lot will try it out😊