UNLOAD TO "batchfile" DELIMITER "|"
SELECT rfc, ch5_id, name, cwa, forecast_group, point_type,

TRUNC (pnt_lat_user) ,

TRUNC ((pnt_lat_user - TRUNC (pnt_lat_user)) * 60) ,

TRUNC ((pnt_lat_user - TRUNC (pnt_lat_user)) * 3600) -
(TRUNC ((pnt_lat_user - TRUNC (pnt_lat_user)) * 60) * 60) ,

TRUNC (pnt_lng_user * (-1)) ,

TRUNC ((TRUNC (pnt_lng_user) - pnt_lng_user ) * 60) ,

TRUNC ((TRUNC (pnt_lng_user) - pnt_lng_user) * 3600) -
(TRUNC ((TRUNC (pnt_lng_user) - pnt_lng_user) * 60) * 60) ,

description, TRUNC (total_area, 1) , user_attribute 

FROM basintable
