Re: Output from a QM query

At 12:51 07/04/2001, Carel Teijgeler wrote:
>All,
>
>I have created a query with Query Manager that concatenates a number of 
>character fields to one field. Each field concatenated field is seperated 
>with a semi-colon. Thus: Fielda CONCAT ':'  CONCAT Fieldb CONCAT ';' 
>CONCAT FieldC .... etc. The last character is a semi-colon and there is no 
>STRIPping.
>
>I run this query over one file and the output is directed to a file. This 
>file is send afterwards to the PC with FTP. So far no problems.
>
>The only problem is: The query adds two extra bytes at the beginning of 
>the records in the file. I assume this indicates the actual length of the 
>field, as query interprets it as a variable length character field.
>
>My question is: How can I output such a query without receiving the binary 
>value in front of each record?

Maybe you could you explicitly cast it as fixed length character:

CHAR(<existing query>, <length>)
Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---