Problem when assigning variable content used by a query

[yard250]

Hello,

I've a probleme when assigning a variable content to a query designed trough Database Interface Designer, used by a simple map as input, the whole set running on a IBM RS system.

My query, defined in the Database Interface Designer, is:

select * from table where field = '#TEST#'

This is the input of a simple map.
I build my map with as target an IBM RS 6000.
I deploy my map on the server and launch it with:

mercator mymap.aix -ID1 -VARTEST=valueok

'valueok' is a value returning records.

But calling mymap with this syntax returns nothing !
When I hard-code in the query the value 'valueok', I've a result.

What's wrong with this syntax ?

Thanks a lot,

Kind regards

 

[BocaBurger]

It would help



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[yard250]

Thanks Bocaburger,

But what is the exact syntax to use ?

mymap.aix -ID1 -VAR ...?

(as my variable is called TEST and the content is VALUE)

My SQL is always:

select * from table where field = '#TEST#'

Thanks a lot !

 

[janhes]

So the syntax should be
mercator mymap.aix -ID1 '-VAR TEST=VALUE'

If this doesn't work, send a report to Ascential support.