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 same, but ... Brian -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shane Ricciardi Sent: 20 December 2010 04:01 To: u2-users@listserver.u2ug.org Subject: [U2] uv SQL INSERT INTO error? 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_KEY.name dictionary is defined in the subquery's file like so: @ASSOC_KEY.testAssoc 0001 PH 0002 key col1 col2 Although col1 & col2 are both i-descriptors. Here's an example of the SQL: INSERT INTO myTable (val1,val2,val3) SELECT col1,col2,col3 FROM table_testAssoc WHERE col2 >= '10-23-10'; Thanks! _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
