fragmentation
I'm going to load a database and I want some tables to be store in some particular dbspace. What should I write before the semi column ? I remenber something about In dbspacename. Can somebody tell me the right sintax. Create table ........ { } ; Ed
Create table <table_name> ( ) in <dbspace_name> <lock mode row> ; Need to download the SQL manuals from IBM . . . . they have all required syntax for Informix SQL. > -----Original Message----- > From: Gonzalez, E.... [mailto:e.gonzal@radium.ncsc.mil] > Sent: Thursday, February 06, 2003 1:50 PM > To: ids@iiug.org > Subject: fragmentation[276] > > > > I'm going to load a database and I want some tables to be > store in some > particular dbspace. What should I write before the semi column ? I > remenber something about In dbspacename. Can somebody tell > me the right > sintax. > > > Create table ........ > { > > > > } ; > > > Ed > "CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel Retail. This email message and all attachments may contain legally privileged and confidential information intended solely for the use of the addressee. If you are not the intended recipient, you should immediately stop reading this message and delete it from the system. Any unauthorized reading, distribution, copying, or other use of this message or its attachments is strictly prohibited. All personal messages express solely the sender's views and not those of WHSmith USA Travel Retail. This message may not be copied or distributed without this disclaimer."
The guys in tech docs spend years writing f***ing manuals. I'm sure they'd be pleased to hear they're doing it for nothing. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche >From: "Gonzalez, E...." <e.gonzal@radium.ncsc.mil> >To: ids@iiug.org >Subject: fragmentation [276] Date: Thu, 6 Feb 2003 13:49:47 -0500 (EST) > > I'm going to load a database and I want some tables to be store in some >particular dbspace. What should I write before the semi column ? I >remenber something about In dbspacename. Can somebody tell me the right >sintax. > > > Create table ........ > { > > > > } ; > > >Ed _________________________________________________________________ It's fast, it's easy and it's free. Get MSN Messenger today! http://messenger.msn.co.uk