Mamta Satoor wrote:
> Hi,
>
[ ]
> If anyone has ideas about a better way of resolving this, please let me
> know.
The properties file format allows newlines to be inserted into property
values using \n. Can't you use that instead of ~ and not have any
special processing?
SELECT CAST ('' AS VARCHAR(128)) AS TABLE_CAT, \
S.SCHEMANAME AS TABLE_SCHEM, T.TABLENAME AS TABLE_NAME, \
COLS.COLUMNNAME AS COLUMN_NAME, \
CONGLOMS.DESCRIPTOR.getKeyColumnPosition(COLS.COLUMNNUMBER ) AS
KEY_SEQ, \
CONS.CONSTRAINTNAME AS PK_NAME \
FROM PROPERTIES joinOrder=FIXED \n \
SYS.SYSTABLES T PROPERTIES index='SYSTABLES_INDEX1' \n , \
etc. etc.
Dan.
