table memory resident
This is a multi-part message in MIME format. ------=_NextPart_000_0019_01BF511F.B6DBD700 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi list Help wanted , what is the syntax for making table memory resident. I've worked on 7.x = then 8.x and now 9.x so bit confused which version it's supported. TIA Mukund ------=_NextPart_000_0019_01BF511F.B6DBD700 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#c0dcc0> <DIV><FONT color=3D#000000 size=3D2>Hi list</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>Help wanted ,</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2>what is the syntax for making table = memory=20 resident. I've worked on 7.x then 8.x and now 9.x so bit confused which = version=20 it's supported.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>TIA</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2>Mukund</FONT></DIV></BODY></HTML> ------=_NextPart_000_0019_01BF511F.B6DBD700--
Mukund D Shevkar wrote: > > Hi list > Help wanted , > what is the syntax for making table memory resident. I've worked on 7.x = > then 8.x and now 9.x so bit confused which version it's supported. Please do not post HTML. Memory resident tables are a 7.30 feature and so is also supported in IDS.2000 (IDS V9.20). The syntax is: SET <TABLE|INDEX> <table or index name> [(dbspace list)] TO RESIDENT; This is in the Guide to SQL Syntax which is available online at the Informix WEB Site under <Documentation>. You can also download the file for local reference. Art S. Kagel