|
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? TIA, With regards, Carel Teijgeler
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.