Generally, we use a program to generate a single statement; however if you may be able to use sql on the file with the UNNEST command to do this in a single statement. This will mean you will have make sure your file and dicts are SQL/ODBC naming compliant.
There is a fair amount of documentation on the UniData SQL implementation. There isn't a lot of good, complicated examples though. Hth Colin Alfke Calgary, Canada >-----Original Message----- >From: Aherne, John > >Hi all, > I want to do a complicated select statement in UD. >Basically, I have a list of items "AA", "BB", "CC". I want to >do a select along these >lines: > >SELECT FILE_A WITH RECORD_A IN (SELECT FILE_B WITH NO @ID = "AA" "BB" >"CC") > >RECORD_A is MV > > >Is there a way to do this in UD? > >TIA, > John Aherne ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
