SQL against a hold file ?

jif26 · Oct 29, 2003

Is it possible to use SQL against a HOLD file ?
For example :

TABLE FILE CAR
PRINT *
ON TABLE HOLD AS HOLD1
END

then

I want to do this

SELECT * FROM HOLD1

HOLD1 is not DB2...how can I achieve this, if possible ?

jimster06 · Oct 30, 2003

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 CAR
PRINT THE_FIELDS_I_WANT
WHERE ARGUMENT EQ FIELDX
ON TABLE HOLD AS HOLD1 FORMAT fmt
END

See Chapter 9 in WF5.2 Creating Reports for fmt

And fmt can be DB2

If you can provide more details as to what your requirements are, you can get a better answer.

zushi · Nov 3, 2003

Hellow!

YOU CAN SELECT * FROM HOLD, THE FOLLOWING.

TABLE FILE CAR
PRINT *
ON TABLE HOLD
END
SQL
SELECT * FROM HOLD;
END

GOOD LUCK!

H1004 · Nov 4, 2003

SET SQLENGINE=SQLMSS -* In this case SQLServer
SQL SQLMSS
SELECT Field1, Field2 FROM PathToTable;
TABLE FILE SQLOUT
PRINT *
END

Make sure you put the semicolon after the select statement and that you
fully qualify your table names. You can look in
the acx files for the path to the table. Once the data is brought back
to the hold file called sqlout, you can then use focus to format the report
any way that you want.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SQL against a hold file ?

jif26

Programmer

jimster06

Programmer

zushi

Vendor

H1004

MIS

Similar threads

Part and Inventory Search

Sponsor