Wednesday, February 6, 2008

UNLOAD TABLE in TSV format (bcp compatible)

UNLOAD TABLE in TSV format (bcp compatible)

unload
SELECT device_id,
convert(char(15),ipaddrstr(l3_src_addr)) IP1,
convert(char(15),ipaddrstr(l3_dest_addr)) IP2,
SUM(bytes) B
FROM developer.SFLOW_HOUR_SUMMARY
WHERE /*device_id=101 and */ L3_PROTOCOL=0x0800
GROUP BY device_id,l3_src_addr,l3_dest_addr
ORDER BY device_id,L3_SRC_ADDR,L3_DEST_ADDR
TO 'ipmatrix1.txt' DELIMITED BY '\x09' QUOTES OFF
...
SYBASE ASA 10

No comments: