//QUALIFY *;
ODBC CONNECT32 TO Accord (XUserId isxxxxxxxxxxX, XPassword is xxxxxxxxxxxxxx);
RFPKLOGD:
SQL SELECT
assignment,
"bond-status",
depot,
dept,
"e-code",
"loc-status",
"locn-post",
"min-stock",
"move-no",
"o-line",
"o-ordinn",
"o-ordqty",
"o-ordwt",
"o-sentinn",
"o-sentqty",
"o-weight",
"order",
"p-code",
"pk-date",
"pk-hour",
"pk-ind",
"pk-minute",
"pk-second",
"pk-stock",
"pk-stock-in",
"pk-time",
"replen-date",
"replen-move",
"replen-priority",
"replen-time",
"reserve-stock",
"shift-date",
"shift-id",
summarised
FROM PUB.rfpklogd;
STORE RFPKLOGD INTO \\APPSERVER1\QLIKVIEW\QLIKVIEWDATAFILES\QVDS\rfpklogd.qvd;
When i load the above script i get an ODBC read failed error, but i know the connection to Database is ok.
