db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: [Derby-573]Optimizer overrides and metadata.properties files
Date Fri, 28 Oct 2005 18:52:03 GMT
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.


Mime
View raw message