running same .q from cmd line vs. KDB studio

Community Support
1

When I run this script from KDBstudio it works perfectlybc03167@etclnx31u> cat ~/bad.qs) CREATE TABLE Test( securityId varchar(*) primary key, regularCol varchar(*));bc03167@etclnx31u>but when I run it from the cmd line it fails.bc03167@etclnx31u> q ~/bad.qKDB+ 2.5 2008.12.31 Copyright (C) 1993-2008 Kx Systemsl64/ 24()core 23975MB bc03167 etclnx31u 169.193.167.98 NONEXPIREcitigroup.com #42406k){0N!x y}')@“q”");"q))Why?

2

X-Mailer: Apple Mail (2.936)On Oct 18, 2010, at 9:51 PM, ben.cotton@citigroup.com wrote:> bc03167@etclnx31u> cat ~/bad.q> s) CREATE TABLE Test(> securityId varchar(*) primary key,> regularCol varchar(*)> );> bc03167@etclnx31u>>> but when I run it from the cmd line it fails.>> bc03167@etclnx31u> q ~/bad.q> KDB+ 2.5 2008.12.31 Copyright (C) 1993-2008 Kx Systems> l64/ 24()core 23975MB bc03167 etclnx31u 169.193.167.98 NONEXPIRE> citigroup.com #42406>> k){0N!x y}> ')> @> “q”> “);”> q))>> Why?whitespace issues. any continuation lines must start with a space or a tab or they’re treated as separate statements. (you’re much better off learning real q btw, s isn’t good for much.)% cat bad.qs) CREATE TABLE Test( securityId varchar(*) primary key, regularCol varchar(*) );% q bad.qKDB+ 2.7 2010.08.23 Copyright (C) 1993-2010 Kx Systemsm32/ 2()core 2048MB adavies air.local 192.168.1.42 PLAY 2010.11.21q)TestsecurityId| regularCol----------| ----------