Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Mukund D Shevkar — — source: Informix-list mailing list archive (1991-1998)
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--
↪ replying to Mukund D Shevkar
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.