Hello. I have a rather large MV association that contains around 40 or so I-
type dicts that all call subroutines. Since this is essentially a "subtable" to
uv/SQL, selecting any field from the subtable causes all the fields to be
processed, although only the requested field is returned. As you c
This worked! Thanks Ray!
> mindless.com> writes:
>
>
>
> It does wherever the column reference is or may be ambiguous (or wherever the
query parser assumes it may be ambiguous!).
>
> Try this.
> SELECT A.field1, B.field2, EVAL B."'TESTING'" AS field3 FROM table1 A, table2
B WHERE A.KeyField =
Anyone ever see this error? It's happening with a SQL statement that pulls data
from a table and a "subtable", which is just an association. Something like
this:
SELECT field1,B.field2,EVAL 'TESTING' AS field3 FROM table1,table1_wtvr B WHERE
table1.KeyField = B.KeyField;
Thanks.
__
>Allen Egerton pobox.com> writes:
>
> If it doesn't exist as a file system object, it's still got to exist in
> VOC as an F or Q pointer. Read the VOC rec, grab <2> and <3> to make
> decisions??
>
Not with a UV/SQL SELECT. @FILENAME can be loaded with an alias that doesn't
exist in the VOC at
> Allen Egerton pobox.com> writes:
>
> There's no direct way that I know.
>
> If you're lucky, @FILENAME will help you, if not, you might try parsing
> out @SENTENCE or @PARASENTENCE.
>
Hey Allen. I can't use @FILENAME in any way because if an alias is used in the
statement that's what @FILEN
Anyone know if there's a way to tell what i-descriptor has called a subroutine
without passing the dictionary name as a parameter? Thanks.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
>Brian Leach brianleach.co.uk> writes:
>
> Hi Shane
>
> Not sure exactly what the problem is, but what happens if you rewrite this
> as:
>
> INSERT INTO myTable (val1, val2, val2) SELECT col1, col2, col3 FROM UNNEST
> table ON testAssoc WHERE col2 >= '10-23-10';
>
> I know it *should* be the
Hi. I'm trying to INSERT INTO a table using results from a subquery that happens
to reference multivalued columns that belong to an association. I keep getting
the following error:
"UniVerse/SQL: No 'stored' columns were found defining association"
Does anyone know what the problem is? The @ASSOC
>Boydell, Stuart spotless.com.au> writes:
>
> Hmm, I just tried the 2 different selects ... order by f1,f2 ... and order by
@id,f1,f2 on one of my files with
> 27000 items/ 15 exploded rows and there was no appreciable difference
between the 2. The select took
> only about a 2 second delay to
John Jenkins btinternet.com> writes:
>
> What's the volume here? Adding the ORDER BY clause will cause the data to be
> pre-processed before the result set starts to get returned.
> Also, if you ignore how long it takes to *start* returning the result set,
> how do the two compare in returning
Hi. I have a table that contains an association of multi-valued columns. I'm
issuing a SELECT against the table and referencing the columns. If I don't ORDER
BY on any of the columns, the query returns data quickly (either executing from
within a uv basic program and capturing output or via uniObje
11 matches
Mail list logo
