SQL against a hold file ? SQL against a hold file ? jif26 (Programmer) (OP) 29 Oct 03 15:31 Is it possible to use SQL against a HOLD file ?For example :TABLE FILE CARPRINT *ON TABLE HOLD AS HOLD1ENDthenI want to do thisSELECT * FROM HOLD1HOLD1 is not DB2...how can I achieve this, if possible ? RE: SQL against a hold file ? jimster06 (Programmer) 30 Oct 03 08:09 Your first TABLE command in the example you post creates a flat file which is not really recognized by SQL. If you need to select data, why not do it with the first TABLE command. SQL will work great against an RDB file and you can execute it from within FOCUS. How about TABLE FILE CARPRINT THE_FIELDS_I_WANTWHERE ARGUMENT EQ FIELDXON TABLE HOLD AS HOLD1 FORMAT fmtENDSee Chapter 9 in WF5.2 Creating Reports for fmtAnd fmt can be DB2 If you can provide more details as to what your requirements are, you can get a better answer. RE: SQL against a hold file ? zushi (Vendor) 4 Nov 03 03:09 Hellow!YOU CAN SELECT * FROM HOLD, THE FOLLOWING.TABLE FILE CAR PRINT * ON TABLE HOLDENDSQLSELECT * FROM HOLD;ENDGOOD LUCK! RE: SQL against a hold file ? H1004 (MIS) 4 Nov 03 17:15 SET SQLENGINE=SQLMSS -* In this case SQLServer SQL SQLMSS SELECT Field1, Field2 FROM PathToTable; TABLE FILE SQLOUT PRINT * ENDMake sure you put the semicolon after the select statement and that youfully qualify your table names. You can look inthe acx files for the path to the table. Once the data is brought backto the hold file called sqlout, you can then use focus to format the reportany way that you want.