Search results for query: *

Hi, I've problem when using the PUT("FILE" command: no append occurs, meaning that just the last record of data is present, not the whole set of records. Is there an hidden feature allowing this function to create more than one line in the target file ? Thanks a lot

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 !

Yes I do, I assign a dummy value to the variable in the Database Interface Designer, in order to generate the associated type tree. About your last post: this problem doesn't occur as there is no space between '-VAR' and the var name itself (I think I'v read that in the documentation, for Unix...

Thanks Janhes, The query is like the one on the top of this post: select * from table where field = '#LIST#' This is exactly what is displayed in the trace file. Any idea ?

Here is the result: space is not appreciated by Mercator in this context (space = second command line, as specified in the documentation). I must add that FINDLIST exists as value: this is a literal. Any idea ? Thanks a lot mercator mymap.aix -ID1 '-VAR LIST=FINDLIST' Mercator(TM) IBM(TM)...

Thanks Janhes, Sorry for my explanations, but valueok is a literal, containing a true value, which returns data set when being replaced in the SQL statement. It seems the variable, defined in the SQL statement, is not replaced by the value assigned in the command line. Do you have any idea ...

To janhes: Yes, it is specified in the documentation, Database Interface Designer Reference Guide, p 126 (the documentation references an NT example: mercnt MyMap.mmc -ID1 '-VAR parm1=2000-03-11', variable content used by a stored procedure defined in a query, designed in the Database Interface...

This is version 6.7.1. I'm working under Unix (IBM AIX). This is a specific system problem...I try your syntax, without success. Your example seems to be a part of code coming from a RUN command (in a Mercator map). I try to use and assign a variable content at the OS level, using the 'prompt'...

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...