Wednesday, 1 June 2011

SET FMTONLY OFF

SET FMTONLY OFF

If it is ON, will not return any data only the column names.

For example:
The following command will not return any row/data.


SET FMTONLY ON
select * from T_repstatus

Following will return the rows with column names:


SET FMTONLY OFF
select * from T_repstatus



No comments:

Post a Comment