When i try to create a table with a lot of foreign keys i am gettingthis error’elim@“q”"ad:([id:()]\n a:a$();\n b:b$();\n c:c$();\n d:d$();\n e:e$();\nf:f$()..I am not sure what i am doing wrong in the script , here is thecontents ( sorry it is a bit too long)a:([a:()]val:());b:([b:()]val:());c:([c:()]val:());d:([d:()]val:());e:([e:()]val:());f:([f:()]val:());g:([g:()]val:());h:([h:()]val:());i:([i:()]val:());j:([j:()]val:());k:([k:()]val:());l:([l:()]val:());m:([m:()]val:());n:([n:()]val:());o:([o:()]val:());p:([p:()]val:());q:([q:()]val:());r:([r:()]val:());s:([s:()]val:());t:([t:()]val:());u:([u:()]val:());v:([v:()]val:());w:([w:()]val:());x:([x:()]val:());y:([y:()]val:());z:([z:()]val:());a1:([a1:()]val:());b1:([b1:()]val:());c1:([c1:()]val:());d1:([d1:()]val:());e1:([e1:()]val:());f1:([f1:()]val:());g1:([g1:()]val:());h1:([h1:()]val:());i1:([i1:()]val:());j1:([j1:()]val:());k1:([k1:()]val:());l1:([l1:()]val:());m1:([m1:()]val:());n1:([n1:()]val:());o1:([o1:()]val:());p1:([p1:()]val:());q1:([q1:()]val:());r1:([r1:()]val:());s1:([s1:()]val:());t1:([t1:()]val:());u1:([u1:()]val:());v1:([v1:()]val:());w1:([w1:()]val:());x1:([x1:()]val:());y1:([y1:()]val:());z1:([z1:()]val:());a2:([a2:()]val:());b2:([b2:()]val:());c2:([c2:()]val:());d2:([d2:()]val:());e2:([e2:()]val:());f2:([f2:()]val:());g2:([g2:()]val:());h2:([h2:()]val:());i2:([i2:()]val:());j2:([j2:()]val:());k2:([k2:()]val:());l2:([l2:()]val:());m2:([m2:()]val:());n2:([n2:()]val:());o2:([o2:()]val:());p2:([p2:()]val:());q2:([q2:()]val:());r2:([r2:()]val:());s2:([s2:()]val:());t2:([t2:()]val:());u2:([u2:()]val:());v2:([v2:()]val:());w2:([w2:()]val:());x2:([x2:()]val:());y2:([y2:()]val:());z2:([z2:()]val:());a3:([a3:()]val:());b3:([b3:()]val:());c3:([c3:()]val:());d3:([d3:()]val:());e3:([e3:()]val:());f3:([f3:()]val:());g3:([g3:()]val:());h3:([h3:()]val:());i3:([i3:()]val:());j3:([j3:()]val:());k3:([k3:()]val:());l3:([l3:()]val:());m3:([m3:()]val:());n3:([n3:()]val:());o3:([o3:()]val:());p3:([p3:()]val:());q3:([q3:()]val:());r3:([r3:()]val:());s3:([s3:()]val:());t3:([t3:()]val:());u3:([u3:()]val:());v3:([v3:()]val:());w3:([w3:()]val:());x3:([x3:()]val:());y3:([y3:()]val:());z3:([z3:()]val:());bigtable:([id:()] a:a$(); b:b$(); c:c$(); d:d$(); e:e$(); f:f$(); g:g$(); h:h$(); i:i$(); j:j$(); k:k$(); l:l$(); m:m$(); n:n$(); o:o$(); p:p$(); q:q$(); r:r$(); s:s$(); t:t$(); u:u$(); v:v$(); w:w$(); x:x$(); y:y$(); z:z$(); a1:a1$(); b1:b1$(); c1:c1$(); d1:d1$(); e1:e1$(); f1:f1$(); g1:g1$(); h1:h1$(); i1:i1$(); j1:j1$(); k1:k1$(); l1:l1$(); m1:m1$(); n1:n1$(); o1:o1$(); p1:p1$(); q1:q1$(); r1:r1$(); s1:s1$(); t1:t1$(); u1:u1$(); v1:v1$(); w1:w1$(); x1:x1$(); y1:y1$(); z1:z1$(); a2:a2$(); b2:b2$(); c2:c2$(); d2:d2$(); e2:e2$(); f2:f2$(); g2:g2$(); h2:h2$(); i2:i2$(); j2:j2$(); k2:k2$(); l2:l2$(); m2:m2$(); n2:n2$(); o2:o2$(); p2:p2$(); q2:q2$(); r2:r2$(); s2:s2$(); t2:t2$(); u2:u2$(); v2:v2$(); w2:w2$(); x2:x2$(); y2:y2$(); z2:z2$(); a3:a3$(); b3:b3$(); c3:c3$(); d3:d3$(); e3:e3$(); f3:f3$(); g3:g3$(); h3:h3$(); i3:i3$(); j3:j3$(); k3:k3$(); l3:l3$(); m3:m3$(); n3:n3$(); o3:o3$(); p3:p3$(); q3:q3$(); r3:r3$(); s3:s3$(); t3:t3$(); u3:u3$(); v3:v3$(); w3:w3$(); x3:x3$(); y3:y3$(); z3:z3$());
Date: Thu, 20 Aug 2009 08:22:43 +0200Message-ID: <47e19e0e0908192322p14de6fcbxa7427ba41697843b@mail.gmail.com>Subject: Re: [personal kdb+] what is 'elim errorFrom: Charles Skelton To: personal-kdbplus@googlegroups.comthere’s a limit on how many foreign keys you can have(comes from the limit on enums)enums are types 20 thru 76On Thu, Aug 20, 2009 at 7:54 AM, bharani<bharani_vms> wrote:>> When i try to create a table with a lot of foreign keys i am getting> this error>> 'elim> @> “q”> "ad:([id:()]\n a:a$();\n b:b$();\n c:c$();\n d:d$();\n e:e$();\n> f:f$()..>> I am not sure what i am doing wrong in the script , here is the> contents ( sorry it is a bit too long)>> a:([a:()]val:());> b:([b:()]val:());> c:([c:()]val:());> d:([d:()]val:());> e:([e:()]val:());> f:([f:()]val:());> g:([g:()]val:());> h:([h:()]val:());> i:([i:()]val:());> j:([j:()]val:());> k:([k:()]val:());> l:([l:()]val:());> m:([m:()]val:());> n:([n:()]val:());> o:([o:()]val:());> p:([p:()]val:());> q:([q:()]val:());> r:([r:()]val:());> s:([s:()]val:());> t:([t:()]val:());> u:([u:()]val:());> v:([v:()]val:());> w:([w:()]val:());> x:([x:()]val:());> y:([y:()]val:());> z:([z:()]val:());> a1:([a1:()]val:());> b1:([b1:()]val:());> c1:([c1:()]val:());> d1:([d1:()]val:());> e1:([e1:()]val:());> f1:([f1:()]val:());> g1:([g1:()]val:());> h1:([h1:()]val:());> i1:([i1:()]val:());> j1:([j1:()]val:());> k1:([k1:()]val:());> l1:([l1:()]val:());> m1:([m1:()]val:());> n1:([n1:()]val:());> o1:([o1:()]val:());> p1:([p1:()]val:());> q1:([q1:()]val:());> r1:([r1:()]val:());> s1:([s1:()]val:());> t1:([t1:()]val:());> u1:([u1:()]val:());> v1:([v1:()]val:());> w1:([w1:()]val:());> x1:([x1:()]val:());> y1:([y1:()]val:());> z1:([z1:()]val:());> a2:([a2:()]val:());> b2:([b2:()]val:());> c2:([c2:()]val:());> d2:([d2:()]val:());> e2:([e2:()]val:());> f2:([f2:()]val:());> g2:([g2:()]val:());> h2:([h2:()]val:());> i2:([i2:()]val:());> j2:([j2:()]val:());> k2:([k2:()]val:());> l2:([l2:()]val:());> m2:([m2:()]val:());> n2:([n2:()]val:());> o2:([o2:()]val:());> p2:([p2:()]val:());> q2:([q2:()]val:());> r2:([r2:()]val:());> s2:([s2:()]val:());> t2:([t2:()]val:());> u2:([u2:()]val:());> v2:([v2:()]val:());> w2:([w2:()]val:());> x2:([x2:()]val:());> y2:([y2:()]val:());> z2:([z2:()]val:());> a3:([a3:()]val:());> b3:([b3:()]val:());> c3:([c3:()]val:());> d3:([d3:()]val:());> e3:([e3:()]val:());> f3:([f3:()]val:());> g3:([g3:()]val:());> h3:([h3:()]val:());> i3:([i3:()]val:());> j3:([j3:()]val:());> k3:([k3:()]val:());> l3:([l3:()]val:());> m3:([m3:()]val:());> n3:([n3:()]val:());> o3:([o3:()]val:());> p3:([p3:()]val:());> q3:([q3:()]val:());> r3:([r3:()]val:());> s3:([s3:()]val:());> t3:([t3:()]val:());> u3:([u3:()]val:());> v3:([v3:()]val:());> w3:([w3:()]val:());> x3:([x3:()]val:());> y3:([y3:()]val:());> z3:([z3:()]val:());>>> bigtable:([id:()]> ? ? ? ?a:a$();> ? ? ? ?b:b$();> ? ? ? ?c:c$();> ? ? ? ?d:d$();> ? ? ? ?e:e$();> ? ? ? ?f:f$();> ? ? ? ?g:g$();> ? ? ? ?h:h$();> ? ? ? ?i:i$();> ? ? ? ?j:j$();> ? ? ? ?k:k$();> ? ? ? ?l:l$();> ? ? ? ?m:m$();> ? ? ? ?n:n$();> ? ? ? ?o:o$();> ? ? ? ?p:p$();> ? ? ? ?q:q$();> ? ? ? ?r:r$();> ? ? ? ?s:s$();> ? ? ? ?t:t$();> ? ? ? ?u:u$();> ? ? ? ?v:v$();> ? ? ? ?w:w$();> ? ? ? ?x:x$();> ? ? ? ?y:y$();> ? ? ? ?z:z$();> ? ? ? ?a1:a1$();> ? ? ? ?b1:b1$();> ? ? ? ?c1:c1$();> ? ? ? ?d1:d1$();> ? ? ? ?e1:e1$();> ? ? ? ?f1:f1$();> ? ? ? ?g1:g1$();> ? ? ? ?h1:h1$();> ? ? ? ?i1:i1$();> ? ? ? ?j1:j1$();> ? ? ? ?k1:k1$();> ? ? ? ?l1:l1$();> ? ? ? ?m1:m1$();> ? ? ? ?n1:n1$();> ? ? ? ?o1:o1$();> ? ? ? ?p1:p1$();> ? ? ? ?q1:q1$();> ? ? ? ?r1:r1$();> ? ? ? ?s1:s1$();> ? ? ? ?t1:t1$();> ? ? ? ?u1:u1$();> ? ? ? ?v1:v1$();> ? ? ? ?w1:w1$();> ? ? ? ?x1:x1$();> ? ? ? ?y1:y1$();> ? ? ? ?z1:z1$();> ? ? ? ?a2:a2$();> ? ? ? ?b2:b2$();> ? ? ? ?c2:c2$();> ? ? ? ?d2:d2$();> ? ? ? ?e2:e2$();> ? ? ? ?f2:f2$();> ? ? ? ?g2:g2$();> ? ? ? ?h2:h2$();> ? ? ? ?i2:i2$();> ? ? ? ?j2:j2$();> ? ? ? ?k2:k2$();> ? ? ? ?l2:l2$();> ? ? ? ?m2:m2$();> ? ? ? ?n2:n2$();> ? ? ? ?o2:o2$();> ? ? ? ?p2:p2$();> ? ? ? ?q2:q2$();> ? ? ? ?r2:r2$();> ? ? ? ?s2:s2$();> ? ? ? ?t2:t2$();> ? ? ? ?u2:u2$();> ? ? ? ?v2:v2$();> ? ? ? ?w2:w2$();> ? ? ? ?x2:x2$();> ? ? ? ?y2:y2$();> ? ? ? ?z2:z2$();> ? ? ? ?a3:a3$();> ? ? ? ?b3:b3$();> ? ? ? ?c3:c3$();> ? ? ? ?d3:d3$();> ? ? ? ?e3:e3$();> ? ? ? ?f3:f3$();> ? ? ? ?g3:g3$();> ? ? ? ?h3:h3$();> ? ? ? ?i3:i3$();> ? ? ? ?j3:j3$();> ? ? ? ?k3:k3$();> ? ? ? ?l3:l3$();> ? ? ? ?m3:m3$();> ? ? ? ?n3:n3$();> ? ? ? ?o3:o3$();> ? ? ? ?p3:p3$();> ? ? ? ?q3:q3$();> ? ? ? ?r3:r3$();> ? ? ? ?s3:s3$();> ? ? ? ?t3:t3$();> ? ? ? ?u3:u3$();> ? ? ? ?v3:v3$();> ? ? ? ?w3:w3$();> ? ? ? ?x3:x3$();> ? ? ? ?y3:y3$();> ? ? ? ?z3:z3$());>>>>> >></bharani_vms>
Date: Thu, 20 Aug 2009 07:25:55 +0100Message-ID: <1855e77f0908192325q25519c03r43e2c1d35b588bf1@mail.gmail.com>Subject: Re: [personal kdb+] what is 'elim errorFrom: Attila Vrabecz <attila.vrabecz>To: personal-kdbplus@googlegroups.comyou can have only 57 different enums AttilaOn Thu, Aug 20, 2009 at 6:54 AM, bharani<bharani_vms> wrote:>> When i try to create a table with a lot of foreign keys i am getting> this error>> 'elim> @> “q”> "ad:([id:()]\n a:a$();\n b:b$();\n c:c$();\n d:d$();\n e:e$();\n> f:f$()..>> I am not sure what i am doing wrong in the script , here is the> contents ( sorry it is a bit too long)>> a:([a:()]val:());> b:([b:()]val:());> c:([c:()]val:());> d:([d:()]val:());> e:([e:()]val:());> f:([f:()]val:());> g:([g:()]val:());> h:([h:()]val:());> i:([i:()]val:());> j:([j:()]val:());> k:([k:()]val:());> l:([l:()]val:());> m:([m:()]val:());> n:([n:()]val:());> o:([o:()]val:());> p:([p:()]val:());> q:([q:()]val:());> r:([r:()]val:());> s:([s:()]val:());> t:([t:()]val:());> u:([u:()]val:());> v:([v:()]val:());> w:([w:()]val:());> x:([x:()]val:());> y:([y:()]val:());> z:([z:()]val:());> a1:([a1:()]val:());> b1:([b1:()]val:());> c1:([c1:()]val:());> d1:([d1:()]val:());> e1:([e1:()]val:());> f1:([f1:()]val:());> g1:([g1:()]val:());> h1:([h1:()]val:());> i1:([i1:()]val:());> j1:([j1:()]val:());> k1:([k1:()]val:());> l1:([l1:()]val:());> m1:([m1:()]val:());> n1:([n1:()]val:());> o1:([o1:()]val:());> p1:([p1:()]val:());> q1:([q1:()]val:());> r1:([r1:()]val:());> s1:([s1:()]val:());> t1:([t1:()]val:());> u1:([u1:()]val:());> v1:([v1:()]val:());> w1:([w1:()]val:());> x1:([x1:()]val:());> y1:([y1:()]val:());> z1:([z1:()]val:());> a2:([a2:()]val:());> b2:([b2:()]val:());> c2:([c2:()]val:());> d2:([d2:()]val:());> e2:([e2:()]val:());> f2:([f2:()]val:());> g2:([g2:()]val:());> h2:([h2:()]val:());> i2:([i2:()]val:());> j2:([j2:()]val:());> k2:([k2:()]val:());> l2:([l2:()]val:());> m2:([m2:()]val:());> n2:([n2:()]val:());> o2:([o2:()]val:());> p2:([p2:()]val:());> q2:([q2:()]val:());> r2:([r2:()]val:());> s2:([s2:()]val:());> t2:([t2:()]val:());> u2:([u2:()]val:());> v2:([v2:()]val:());> w2:([w2:()]val:());> x2:([x2:()]val:());> y2:([y2:()]val:());> z2:([z2:()]val:());> a3:([a3:()]val:());> b3:([b3:()]val:());> c3:([c3:()]val:());> d3:([d3:()]val:());> e3:([e3:()]val:());> f3:([f3:()]val:());> g3:([g3:()]val:());> h3:([h3:()]val:());> i3:([i3:()]val:());> j3:([j3:()]val:());> k3:([k3:()]val:());> l3:([l3:()]val:());> m3:([m3:()]val:());> n3:([n3:()]val:());> o3:([o3:()]val:());> p3:([p3:()]val:());> q3:([q3:()]val:());> r3:([r3:()]val:());> s3:([s3:()]val:());> t3:([t3:()]val:());> u3:([u3:()]val:());> v3:([v3:()]val:());> w3:([w3:()]val:());> x3:([x3:()]val:());> y3:([y3:()]val:());> z3:([z3:()]val:());>>> bigtable:([id:()]> ? ? ? ?a:a$();> ? ? ? ?b:b$();> ? ? ? ?c:c$();> ? ? ? ?d:d$();> ? ? ? ?e:e$();> ? ? ? ?f:f$();> ? ? ? ?g:g$();> ? ? ? ?h:h$();> ? ? ? ?i:i$();> ? ? ? ?j:j$();> ? ? ? ?k:k$();> ? ? ? ?l:l$();> ? ? ? ?m:m$();> ? ? ? ?n:n$();> ? ? ? ?o:o$();> ? ? ? ?p:p$();> ? ? ? ?q:q$();> ? ? ? ?r:r$();> ? ? ? ?s:s$();> ? ? ? ?t:t$();> ? ? ? ?u:u$();> ? ? ? ?v:v$();> ? ? ? ?w:w$();> ? ? ? ?x:x$();> ? ? ? ?y:y$();> ? ? ? ?z:z$();> ? ? ? ?a1:a1$();> ? ? ? ?b1:b1$();> ? ? ? ?c1:c1$();> ? ? ? ?d1:d1$();> ? ? ? ?e1:e1$();> ? ? ? ?f1:f1$();> ? ? ? ?g1:g1$();> ? ? ? ?h1:h1$();> ? ? ? ?i1:i1$();> ? ? ? ?j1:j1$();> ? ? ? ?k1:k1$();> ? ? ? ?l1:l1$();> ? ? ? ?m1:m1$();> ? ? ? ?n1:n1$();> ? ? ? ?o1:o1$();> ? ? ? ?p1:p1$();> ? ? ? ?q1:q1$();> ? ? ? ?r1:r1$();> ? ? ? ?s1:s1$();> ? ? ? ?t1:t1$();> ? ? ? ?u1:u1$();> ? ? ? ?v1:v1$();> ? ? ? ?w1:w1$();> ? ? ? ?x1:x1$();> ? ? ? ?y1:y1$();> ? ? ? ?z1:z1$();> ? ? ? ?a2:a2$();> ? ? ? ?b2:b2$();> ? ? ? ?c2:c2$();> ? ? ? ?d2:d2$();> ? ? ? ?e2:e2$();> ? ? ? ?f2:f2$();> ? ? ? ?g2:g2$();> ? ? ? ?h2:h2$();> ? ? ? ?i2:i2$();> ? ? ? ?j2:j2$();> ? ? ? ?k2:k2$();> ? ? ? ?l2:l2$();> ? ? ? ?m2:m2$();> ? ? ? ?n2:n2$();> ? ? ? ?o2:o2$();> ? ? ? ?p2:p2$();> ? ? ? ?q2:q2$();> ? ? ? ?r2:r2$();> ? ? ? ?s2:s2$();> ? ? ? ?t2:t2$();> ? ? ? ?u2:u2$();> ? ? ? ?v2:v2$();> ? ? ? ?w2:w2$();> ? ? ? ?x2:x2$();> ? ? ? ?y2:y2$();> ? ? ? ?z2:z2$();> ? ? ? ?a3:a3$();> ? ? ? ?b3:b3$();> ? ? ? ?c3:c3$();> ? ? ? ?d3:d3$();> ? ? ? ?e3:e3$();> ? ? ? ?f3:f3$();> ? ? ? ?g3:g3$();> ? ? ? ?h3:h3$();> ? ? ? ?i3:i3$();> ? ? ? ?j3:j3$();> ? ? ? ?k3:k3$();> ? ? ? ?l3:l3$();> ? ? ? ?m3:m3$();> ? ? ? ?n3:n3$();> ? ? ? ?o3:o3$();> ? ? ? ?p3:p3$();> ? ? ? ?q3:q3$();> ? ? ? ?r3:r3$();> ? ? ? ?s3:s3$();> ? ? ? ?t3:t3$();> ? ? ? ?u3:u3$();> ? ? ? ?v3:v3$();> ? ? ? ?w3:w3$();> ? ? ? ?x3:x3$();> ? ? ? ?y3:y3$();> ? ? ? ?z3:z3$());>>>>> >></bharani_vms></attila.vrabecz>
X-Mailer: Apple Mail (2.936)you’ll find help.q useful for a quick description of errorshttps://code.kx.com/trac/browser/contrib/simon/help/help.q> q)\l help.q> q)helperror\> runtime errors\> error--------example-----explanation\> access attempt to read files above directory, run \> system commands or failed usr/pwd\> assign cos:12 attempt to reuse a reserved word\> cast sym$xxx attempt to enumerate invalid value (xxx > not in sym in example)> conn too many incoming connections (1022 max)> d8 the log had a partial transaction at the > end but q couldn’t truncate the file.> domain !-1 out of domain> elim more than 57 distinct enumerations> glim g# limit, kdb+ currently limited to 99 \> concurrent g#'s> ?On 20.08.2009, at 07:54, bharani wrote:>> When i try to create a table with a lot of foreign keys i am getting> this error>> 'elim> @> “q”> "ad:([id:()]\n a:a$();\n b:b$();\n c:c$();\n d:d$();\n e:e$();\n\> f:f$()..>> I am not sure what i am doing wrong in the script , here is the> contents ( sorry it is a bit too long)>> a:([a:()]val:());> b:([b:()]val:());> c:([c:()]val:());> d:([d:()]val:());> e:([e:()]val:());> f:([f:()]val:());> g:([g:()]val:());> h:([h:()]val:());> i:([i:()]val:());> j:([j:()]val:());> k:([k:()]val:());> l:([l:()]val:());> m:([m:()]val:());> n:([n:()]val:());> o:([o:()]val:());> p:([p:()]val:());> q:([q:()]val:());> r:([r:()]val:());> s:([s:()]val:());> t:([t:()]val:());> u:([u:()]val:());> v:([v:()]val:());> w:([w:()]val:());> x:([x:()]val:());> y:([y:()]val:());> z:([z:()]val:());> a1:([a1:()]val:());> b1:([b1:()]val:());> c1:([c1:()]val:());> d1:([d1:()]val:());> e1:([e1:()]val:());> f1:([f1:()]val:());> g1:([g1:()]val:());> h1:([h1:()]val:());> i1:([i1:()]val:());> j1:([j1:()]val:());> k1:([k1:()]val:());> l1:([l1:()]val:());> m1:([m1:()]val:());> n1:([n1:()]val:());> o1:([o1:()]val:());> p1:([p1:()]val:());> q1:([q1:()]val:());> r1:([r1:()]val:());> s1:([s1:()]val:());> t1:([t1:()]val:());> u1:([u1:()]val:());> v1:([v1:()]val:());> w1:([w1:()]val:());> x1:([x1:()]val:());> y1:([y1:()]val:());> z1:([z1:()]val:());> a2:([a2:()]val:());> b2:([b2:()]val:());> c2:([c2:()]val:());> d2:([d2:()]val:());> e2:([e2:()]val:());> f2:([f2:()]val:());> g2:([g2:()]val:());> h2:([h2:()]val:());> i2:([i2:()]val:());> j2:([j2:()]val:());> k2:([k2:()]val:());> l2:([l2:()]val:());> m2:([m2:()]val:());> n2:([n2:()]val:());> o2:([o2:()]val:());> p2:([p2:()]val:());> q2:([q2:()]val:());> r2:([r2:()]val:());> s2:([s2:()]val:());> t2:([t2:()]val:());> u2:([u2:()]val:());> v2:([v2:()]val:());> w2:([w2:()]val:());> x2:([x2:()]val:());> y2:([y2:()]val:());> z2:([z2:()]val:());> a3:([a3:()]val:());> b3:([b3:()]val:());> c3:([c3:()]val:());> d3:([d3:()]val:());> e3:([e3:()]val:());> f3:([f3:()]val:());> g3:([g3:()]val:());> h3:([h3:()]val:());> i3:([i3:()]val:());> j3:([j3:()]val:());> k3:([k3:()]val:());> l3:([l3:()]val:());> m3:([m3:()]val:());> n3:([n3:()]val:());> o3:([o3:()]val:());> p3:([p3:()]val:());> q3:([q3:()]val:());> r3:([r3:()]val:());> s3:([s3:()]val:());> t3:([t3:()]val:());> u3:([u3:()]val:());> v3:([v3:()]val:());> w3:([w3:()]val:());> x3:([x3:()]val:());> y3:([y3:()]val:());> z3:([z3:()]val:());>>> bigtable:([id:()]> a:a$();\> b:b$();> c:c$();\> d:d$();> e:e$();\> f:f$();> g:g$();\> h:h$();> i:i$();\> j:j$();> k:k$();\> l:l$();> m:m$();\> n:n$();> o:o$();\> p:p$();> q:q$();\> r:r$();> s:s$();\> t:t$();> u:u$();\> v:v$();> w:w$();\> x:x$();> y:y$();\> z:z$();> a1:a1$();\> b1:b1$();> c1:c1$();\> d1:d1$();> e1:e1$();\> f1:f1$();> g1:g1$();\> h1:h1$();> i1:i1$();\> j1:j1$();> k1:k1$();\> l1:l1$();> m1:m1$();\> n1:n1$();> o1:o1$();\> p1:p1$();> q1:q1$();\> r1:r1$();> s1:s1$();\> t1:t1$();> u1:u1$();\> v1:v1$();> w1:w1$();\> x1:x1$();> y1:y1$();\> z1:z1$();> a2:a2$();\> b2:b2$();> c2:c2$();\> d2:d2$();> e2:e2$();\> f2:f2$();> g2:g2$();\> h2:h2$();> i2:i2$();\> j2:j2$();> k2:k2$();\> l2:l2$();> m2:m2$();\> n2:n2$();> o2:o2$();\> p2:p2$();> q2:q2$();\> r2:r2$();> s2:s2$();\> t2:t2$();> u2:u2$();\> v2:v2$();> w2:w2$();\> x2:x2$();> y2:y2$();\> z2:z2$();> a3:a3$();\> b3:b3$();> c3:c3$();\> d3:d3$();> e3:e3$();\> f3:f3$();> g3:g3$();\> h3:h3$();> i3:i3$();\> j3:j3$();> k3:k3$();\> l3:l3$();> m3:m3$();\> n3:n3$();> o3:o3$();\> p3:p3$();> q3:q3$();\> r3:r3$();> s3:s3$();\> t3:t3$();> u3:u3$();\> v3:v3$();> w3:w3$();\> x3:x3$();> y3:y3$();\> z3:z3$());>>>>> >
Thanks - help.q is really helpful :)-BharaniOn Aug 20, 12:25?pm, Simon Garland <simon.garl…> wrote:> you’ll find help.q useful for a quick description of errors>> https://code.kx.com/trac/browser/contrib/simon/help/help.q>>>>>> > q)\l help.q> > q)helperror> > runtime errors> > error--------example-----explanation> > access ? ? ? ? ? ? ? ? ? attempt to read files above directory, run ?> > system commands or failed usr/pwd> > assign ? ? ? cos:12 ? ? ?attempt to reuse a reserved word> > cast ? ? ? ? sym$xxx ? attempt to enumerate invalid value (xxx ?> > not in sym in example)> > conn ? ? ? ? ? ? ? ? ? ? too many incoming connections (1022 max)> > d8 ? ? ? ? ? ? ? ? ? ? ? the log had a partial transaction at the ?> > end but q couldn’t truncate the file.> > domain ? ? ? !-1 ? ? ? ? out of domain> > elim ? ? ? ? ? ? ? ? ? ? more than 57 distinct enumerations> > glim ? ? ? ? ? ? ? ? ? ? g# limit, kdb+ currently limited to 99 ?> > concurrent g#'s> > ?>> On 20.08.2009, at 07:54, bharani wrote:>>>>>> > When i try to create a table with a lot of foreign keys i am getting> > this error>> > 'elim> > @> > “q”> > "ad:([id:()]\n a:a$();\n b:b$();\n c:c$();\n d:d$();\n e:e$();\n> > f:f$()..>> > I am not sure what i am doing wrong in the script , here is the> > contents ( sorry it is a bit too long)>> > a:([a:()]val:());> > b:([b:()]val:());> > c:([c:()]val:());> > d:([d:()]val:());> > e:([e:()]val:());> > f:([f:()]val:());> > g:([g:()]val:());> > h:([h:()]val:());> > i:([i:()]val:());> > j:([j:()]val:());> > k:([k:()]val:());> > l:([l:()]val:());> > m:([m:()]val:());> > n:([n:()]val:());> > o:([o:()]val:());> > p:([p:()]val:());> > q:([q:()]val:());> > r:([r:()]val:());> > s:([s:()]val:());> > t:([t:()]val:());> > u:([u:()]val:());> > v:([v:()]val:());> > w:([w:()]val:());> > x:([x:()]val:());> > y:([y:()]val:());> > z:([z:()]val:());> > a1:([a1:()]val:());> > b1:([b1:()]val:());> > c1:([c1:()]val:());> > d1:([d1:()]val:());> > e1:([e1:()]val:());> > f1:([f1:()]val:());> > g1:([g1:()]val:());> > h1:([h1:()]val:());> > i1:([i1:()]val:());> > j1:([j1:()]val:());> > k1:([k1:()]val:());> > l1:([l1:()]val:());> > m1:([m1:()]val:());> > n1:([n1:()]val:());> > o1:([o1:()]val:());> > p1:([p1:()]val:());> > q1:([q1:()]val:());> > r1:([r1:()]val:());> > s1:([s1:()]val:());> > t1:([t1:()]val:());> > u1:([u1:()]val:());> > v1:([v1:()]val:());> > w1:([w1:()]val:());> > x1:([x1:()]val:());> > y1:([y1:()]val:());> > z1:([z1:()]val:());> > a2:([a2:()]val:());> > b2:([b2:()]val:());> > c2:([c2:()]val:());> > d2:([d2:()]val:());> > e2:([e2:()]val:());> > f2:([f2:()]val:());> > g2:([g2:()]val:());> > h2:([h2:()]val:());> > i2:([i2:()]val:());> > j2:([j2:()]val:());> > k2:([k2:()]val:());> > l2:([l2:()]val:());> > m2:([m2:()]val:());> > n2:([n2:()]val:());> > o2:([o2:()]val:());> > p2:([p2:()]val:());> > q2:([q2:()]val:());> > r2:([r2:()]val:());> > s2:([s2:()]val:());> > t2:([t2:()]val:());> > u2:([u2:()]val:());> > v2:([v2:()]val:());> > w2:([w2:()]val:());> > x2:([x2:()]val:());> > y2:([y2:()]val:());> > z2:([z2:()]val:());> > a3:([a3:()]val:());> > b3:([b3:()]val:());> > c3:([c3:()]val:());> > d3:([d3:()]val:());> > e3:([e3:()]val:());> > f3:([f3:()]val:());> > g3:([g3:()]val:());> > h3:([h3:()]val:());> > i3:([i3:()]val:());> > j3:([j3:()]val:());> > k3:([k3:()]val:());> > l3:([l3:()]val:());> > m3:([m3:()]val:());> > n3:([n3:()]val:());> > o3:([o3:()]val:());> > p3:([p3:()]val:());> > q3:([q3:()]val:());> > r3:([r3:()]val:());> > s3:([s3:()]val:());> > t3:([t3:()]val:());> > u3:([u3:()]val:());> > v3:([v3:()]val:());> > w3:([w3:()]val:());> > x3:([x3:()]val:());> > y3:([y3:()]val:());> > z3:([z3:()]val:());>> > bigtable:([id:()]> > ? ?a:a$();> > ? ?b:b$();> > ? ?c:c$();> > ? ?d:d$();> > ? ?e:e$();> > ? ?f:f$();> > ? ?g:g$();> > ? ?h:h$();> > ? ?i:i$();> > ? ?j:j$();> > ? ?k:k$();> > ? ?l:l$();> > ? ?m:m$();> > ? ?n:n$();> > ? ?o:o$();> > ? ?p:p$();> > ? ?q:q$();> > ? ?r:r$();> > ? ?s:s$();> > ? ?t:t$();> > ? ?u:u$();> > ? ?v:v$();> > ? ?w:w$();> > ? ?x:x$();> > ? ?y:y$();> > ? ?z:z$();> > ? ?a1:a1$();> > ? ?b1:b1$();> > ? ?c1:c1$();> > ? ?d1:d1$();> > ? ?e1:e1$();> > ? ?f1:f1$();> > ? ?g1:g1$();> > ? ?h1:h1$();> > ? ?i1:i1$();> > ? ?j1:j1$();> > ? ?k1:k1$();> > ? ?l1:l1$();> > ? ?m1:m1$();> > ? ?n1:n1$();> > ? ?o1:o1$();> > ? ?p1:p1$();> > ? ?q1:q1$();> > ? ?r1:r1$();> > ? ?s1:s1$();> > ? ?t1:t1$();> > ? ?u1:u1$();> > ? ?v1:v1$();> > ? ?w1:w1$();> > ? ?x1:x1$();> > ? ?y1:y1$();> > ? ?z1:z1$();> > ? ?a2:a2$();> > ? ?b2:b2$();> > ? ?c2:c2$();> > ? ?d2:d2$();> > ? ?e2:e2$();> > ? ?f2:f2$();> > ? ?g2:g2$();> > ? ?h2:h2$();> > ? ?i2:i2$();> > ? ?j2:j2$();> > ? ?k2:k2$();> > ? ?l2:l2$();> > ? ?m2:m2$();> > ? ?n2:n2$();> > ? ?o2:o2$();> > ? ?p2:p2$();> > ? ?q2:q2$();> > ? ?r2:r2$();> > ? ?s2:s2$();> > ? ?t2:t2$();> > ? ?u2:u2$();> > ? ?v2:v2$();> > ? ?w2:w2$();> > ? ?x2:x2$();> > ? ?y2:y2$();> > ? ?z2:z2$();> > ? ?a3:a3$();> > ? ?b3:b3$();> > ? ?c3:c3$();> > ? ?d3:d3$();> > ? ?e3:e3$();> > ? ?f3:f3$();> > ? ?g3:g3$();> > ? ?h3:h3$();> > ? ?i3:i3$();> > ? ?j3:j3$();> > ? ?k3:k3$();> > ? ?l3:l3$();> > ? ?m3:m3$();> > ? ?n3:n3$();> > ? ?o3:o3$();> > ? ?p3:p3$();> > ? ?q3:q3$();> > ? ?r3:r3$();> > ? ?s3:s3$();> > ? ?t3:t3$();> > ? ?u3:u3$();> > ? ?v3:v3$();> > ? ?w3:w3$();> > ? ?x3:x3$();> > ? ?y3:y3$();> > ? ?z3:z3$());</simon.garl…>