Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

sql with free table in DBF NTX format

7 posts in Xbase++ Last posting was on 2008-09-23 22:11:30.0Z
Simone Degl'Innocenti Posted on 2008-08-27 07:45:55.0Z
From: "Simone Degl'Innocenti" <hot@albalog.it>
Newsgroups: Advantage.Xbase++
Subject: sql with free table in DBF NTX format
Date: Wed, 27 Aug 2008 09:45:55 +0200
Lines: 10
Organization: Albalog s.r.l.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: 213.255.125.48
Message-ID: <48b504cf@solutions.advantagedatabase.com>
X-Trace: 27 Aug 2008 01:39:59 -0700, 213.255.125.48
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.255.125.48
Xref: solutions.advantagedatabase.com Advantage.Xbase++:979
Article PK: 1140822

Hello all

Is it possible to use SQL to create table or alter table (without data
dictionary) in DBF NTX format?

A sample would be greatly appreciated.
Thanks
Simone


Friedhelm Goeder Posted on 2008-08-27 10:41:18.0Z
From: "Friedhelm Goeder" <fgoeder@tobax.de>
Newsgroups: Advantage.Xbase++
References: <48b504cf@solutions.advantagedatabase.com>
Subject: Re: sql with free table in DBF NTX format
Date: Wed, 27 Aug 2008 12:41:18 +0200
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: 81.173.215.210
Message-ID: <48b52dca@solutions.advantagedatabase.com>
X-Trace: 27 Aug 2008 04:34:50 -0700, 81.173.215.210
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!81.173.215.210
Xref: solutions.advantagedatabase.com Advantage.Xbase++:980
Article PK: 1140826

with ADS, you can?t use SQL statements on DBFNTX tables! This is independet
from the type of connections (via datadictionary or not). ADS allows SQL
access only on tables DBFCDX or ADSADT.

Friedhelm


"Simone Degl'Innocenti" <hot@albalog.it> schrieb im Newsbeitrag
news:48b504cf@solutions.advantagedatabase.com...

> Hello all
>
> Is it possible to use SQL to create table or alter table (without data
> dictionary) in DBF NTX format?
>
> A sample would be greatly appreciated.
> Thanks
> Simone
>
>


Simone Degl'Innocenti Posted on 2008-09-02 10:36:57.0Z
From: "Simone Degl'Innocenti" <hot@albalog.it>
Newsgroups: Advantage.Xbase++
References: <48b52dca@solutions.advantagedatabase.com> <1b468bc837e968cad7cb9d24ea87@devzone.advantagedatabase.com>
Subject: Re: sql with free table in DBF NTX format
Date: Tue, 2 Sep 2008 12:36:57 +0200
Lines: 23
Organization: Albalog s.r.l.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 213.255.125.48
Message-ID: <48bd15db@solutions.advantagedatabase.com>
X-Trace: 2 Sep 2008 04:30:51 -0700, 213.255.125.48
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.255.125.48
Xref: solutions.advantagedatabase.com Advantage.Xbase++:982
Article PK: 1140827

with a data dictionary is it possible to create or alter table in dbf
format?
do you have a sample of the syntax?
thanks
Simone

"Jeremy Mullin" <no@email.com> ha scritto nel messaggio
news:1b468bc837e968cad7cb9d24ea87@devzone.advantagedatabase.com...

>> with ADS, you can?t use SQL statements on DBFNTX tables!
>
> Actually, you can if the table is in a data dictionary. You don't get the
> full benefit like you would with a CDX or ADI (because the index is still
> not used in AOFs), but I think they will get used for ORDER BY
> optimization and maybe a few others.
>
> J.D. Mullin
> Advantage R&D
> Sybase iAnywhere
> http://jdmullin.blogspot.com
>
>


Jeremy Mullin Posted on 2008-09-05 19:47:49.0Z
Date: Fri, 5 Sep 2008 19:47:49 +0000 (UTC)
Message-ID: <1b468bc83831d8cadd751eba0ddc@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: sql with free table in DBF NTX format
Newsgroups: Advantage.Xbase++
References: <48bd15db@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.114
X-Trace: 5 Sep 2008 13:41:38 -0700, 10.24.38.114
Lines: 19
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.114
Xref: solutions.advantagedatabase.com Advantage.Xbase++:983
Article PK: 1140829


> with a data dictionary is it possible to create or alter table in dbf
> format?
> do you have a sample of the syntax?

Yes. It's no different if the table is a free table or a dictionary-bound
table.

See the CREATE TABLE and ALTER TABLE documentation in the help file.

http://devzone.advantagedatabase.com/dz/webhelp/Advantage9.0/supported_statements/create_table.htm

http://devzone.advantagedatabase.com/dz/webhelp/Advantage9.0/supported_statements/alter_table.htm

J.D. Mullin
Advantage R&D
Sybase iAnywhere
http://jdmullin.blogspot.com


Simone Degl'Innocenti Posted on 2008-09-09 08:10:54.0Z
From: "Simone Degl'Innocenti" <hot@albalog.it>
Newsgroups: Advantage.Xbase++
References: <48bd15db@solutions.advantagedatabase.com> <1b468bc83831d8cadd751eba0ddc@devzone.advantagedatabase.com>
Subject: Re: sql with free table in DBF NTX format
Date: Tue, 9 Sep 2008 10:10:54 +0200
Lines: 39
Organization: Albalog s.r.l.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: 213.255.125.48
Message-ID: <48c62e1d@solutions.advantagedatabase.com>
X-Trace: 9 Sep 2008 02:04:45 -0700, 213.255.125.48
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.255.125.48
Xref: solutions.advantagedatabase.com Advantage.Xbase++:984
Article PK: 1140828

Hello Jeremy

I have ARC 9.0 with a connection to a datadictionary via local server.
the alter table command seems to work also on DBF tables.

If I use the command "CREATE TABLE [sal.dbf] (emp_id numeric(10,3), salary
date, dept char(20))"

it creates a file named "sal.dbf" but the format of the file is ADT, not
DBF.

Is it possible to create a table in DBF format?
thanks
Simone


"Jeremy Mullin" <no@email.com> ha scritto nel messaggio
news:1b468bc83831d8cadd751eba0ddc@devzone.advantagedatabase.com...

>> with a data dictionary is it possible to create or alter table in dbf
>> format?
>> do you have a sample of the syntax?
>
> Yes. It's no different if the table is a free table or a dictionary-bound
> table.
>
> See the CREATE TABLE and ALTER TABLE documentation in the help file.
>
> http://devzone.advantagedatabase.com/dz/webhelp/Advantage9.0/supported_statements/create_table.htm
>
> http://devzone.advantagedatabase.com/dz/webhelp/Advantage9.0/supported_statements/alter_table.htm
>
> J.D. Mullin
> Advantage R&D
> Sybase iAnywhere
> http://jdmullin.blogspot.com
>
>


Jeremy Mullin Posted on 2008-09-23 22:11:30.0Z
Date: Tue, 23 Sep 2008 22:11:30 +0000 (UTC)
Message-ID: <1b468bc8389678caebae2c992c78@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: sql with free table in DBF NTX format
Newsgroups: Advantage.Xbase++
References: <48c62e1d@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.114
X-Trace: 23 Sep 2008 16:05:15 -0700, 10.24.38.114
Lines: 12
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.114
Xref: solutions.advantagedatabase.com Advantage.Xbase++:985
Article PK: 1140830

> Is it possible to create a table in DBF format?

Certainly. ARC uses the table type from the active connection when creating
a table, however. So to create a dbf set the connection property "tabletype"
to cdx or vfp.

J.D. Mullin
Advantage R&D
Sybase iAnywhere
http://jdmullin.blogspot.com