Re: Migration WEB datablade 2.2 to WEB datablade 3.3 (IUS). HELP.

My solution was to create a table with just one row and do the same select as Thomas gives from it: select current from DUALSystables has a lot of rows and somehow doing a select unique from it strikes me as more expensive, without having tested, than my approach. Seth thomas@koz.com (Thomas Tatum) writes: >>>>>> "Javier" == Javier Riera Serra <javier@bitel.es> writes: > Javier> HI, > Javier> I am working in the migration of the old illustra > Javier> database with web datablade 2.2 to the new informix > Javier> universal server with datablade 3.3: > Javier> Does anyboby knows the correct sentence to do this > Javier> with the new datablade?: >People will tell you to use: >select unique current from systables; >- but I have had recent problems with this in an SPL. I used it like: > select unique current > into tempString > from systables;> >So I recommend an alternative: >select current from systables where tabname = 'systables' >-- >Thomas Tatum >thomas@rtp.koz.com >http://members.tripod.com/~thomastatum/index.html >919-489-5662 x2129 >919-602-6521 -- Seth Grimes Alta Plana Internet & database design & development grimes@altaplana.com http://altaplana.com 301-891-2581 grimes@access.digex.net http://www.access.digex.net/~grimes