Sorry for the late response, but what about the max keyword i.e. LIST file MAX @ID?
It returns the maximum value equivalent to the first value listed in a sort ascending i.e. the justification of the field will affect the order. Regards Kurt Neumann; U2 Certified Solutions Expert -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Boydell, Stuart Sent: 27 May 2011 08:04 AM To: U2 Users List Subject: [U2] [UV] Emulate SQL MAX() function at TCL Just wondering if anyone has a neat trick for picking up the highest ID from a file. Where the file ID is an integer. With UVSQL I would SELECT MAX(@ID) FROM TABLE; - however, the program I need to do this within has the file (table) open and if I try to execute it returns the error 'Non-SQL re-entrant query calls are not allowed.' The best I have so far is: st = 'SELECT FILE @ID BY.DSND @ID' st<-1> = 'LIST ONLY FILE SAMPLE 1' exec st capturing cap maxId = trim(cap<4>) Any other ideas? Cheers, Stuart _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
