DEV Community

Query Filter
Query Filter

Posted on

trim4

isql -S $SERVER -U $USER -P $PASS -s"¬" -b -w7500 <<EOF
SET NOCOUNT ON
GO
SELECT
INTERNIDENTITY,
INTERNINSTID,
INTERNVERSION,
INTERNTIMESTAMP,
INTERNRECTYPE,
ORDERID,
SYNCNUM,
IDSOURCE,
MEMOID,
MEMOTYPE,
BIDPX,
BIDSIZE,
LASTSALE,
MARKETCENTERID,
MEMOCOMMENTS,
OFFERPX,
OFFERSIZE,
ORDERIDS,
ORDSYNCNUM,
OVERRIDERULESET,
QUOTECONDITIONINDICATOR,
QUOTETIME,
RULE92COMMENT,
SALESTRADERCOMMENTS,
TICKDIRECTION,
TOTALDOLVOL,
TOTALVOLUMETRADED,
TRADERCOMMENTS,
LULDLOWERPXBAND,
LULDUPPERPXBAND,
LULDPXBANDTIMESTAMP
FROM ZMemo
GO
EOF | \
sed 's/ ¬ */¬/g; s/^¬$//g'

Top comments (0)