Author: rareddy Date: 2010-08-17 12:09:54 -0400 (Tue, 17 Aug 2010) New Revision: 2469 Modified: trunk/build/kits/jboss-container/teiid-examples/dynamicvdb-portfolio/README.txt Log: preventing a cross join int he example Modified: trunk/build/kits/jboss-container/teiid-examples/dynamicvdb-portfolio/README.txt =================================================================== --- trunk/build/kits/jboss-container/teiid-examples/dynamicvdb-portfolio/README.txt 2010-08-17 15:50:45 UTC (rev 2468) +++ trunk/build/kits/jboss-container/teiid-examples/dynamicvdb-portfolio/README.txt 2010-08-17 16:09:54 UTC (rev 2469) @@ -17,7 +17,7 @@ Use the simple client example run script, or another client, to execute a query, e.g. -$./run.sh localhost 31000 dynamicportfolio "select * from product, (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock where product.symbol=stock.symbol" +$./run.sh localhost 31000 dynamicportfolio "select stock.* from product, (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock where product.symbol=stock.symbol" This example will execute the query against both Derby and the text files. The files returned from the getTextFiles procedure are passed to the TEXTTABLE table