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.

SQLXML

7 posts in General Discussion Last posting was on 2004-09-13 16:10:11.0Z
Emad Attia Posted on 2004-09-11 16:47:34.0Z
From: "Emad Attia" <emad@fpacesoftware.com>
Newsgroups: ianywhere.public.general
Subject: SQLXML
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 216.123.208.8
X-Original-NNTP-Posting-Host: 216.123.208.8
Message-ID: <41432c26$1@forums-1-dub>
Date: 11 Sep 2004 09:47:34 -0700
X-Trace: forums-1-dub 1094921254 216.123.208.8 (11 Sep 2004 09:47:34 -0700)
X-Original-Trace: 11 Sep 2004 09:47:34 -0700, 216.123.208.8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3519
Article PK: 7421

Hi There,
I was wondering if ASA (or any Sybase product) supports something like MS
SQLXML or any support for representing a database schema in XML. What we are
looking for is an API that will take an XML representation of the tables and
fields in the DB and translate that into the tables and fields. Also,
filtering capability (using XPATH or any other technique) is a bonus.
Thanks
Emad Attia


Greg Fenton Posted on 2004-09-11 17:35:47.0Z
From: Greg Fenton <greg.fenton_nospam_@ianywhere.com>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQLXML
References: <41432c26$1@forums-1-dub>
In-Reply-To: <41432c26$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <41433773$1@forums-1-dub>
Date: 11 Sep 2004 10:35:47 -0700
X-Trace: forums-1-dub 1094924147 69.193.90.25 (11 Sep 2004 10:35:47 -0700)
X-Original-Trace: 11 Sep 2004 10:35:47 -0700, cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 27
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3520
Article PK: 7422


Emad Attia wrote:
>
> I was wondering if ASA (or any Sybase product) supports something like MS
> SQLXML or any support for representing a database schema in XML.

I have not had much chance to play around with SQL and XML together yet,
but have you read over the XML functionality offered in SQL Anywhere 9.x?

If not see:

ASA SQL User's Guide
Using XML in the Database
What is XML?
- XML and Adaptive Server Anywhere
or

http://tinyurl.com/4o7qn (shortcut to docs on ianywhere.com)

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Emad Attia Posted on 2004-09-11 21:31:48.0Z
From: "Emad Attia" <emad@fpacesoftware.com>
Newsgroups: ianywhere.public.general
References: <41432c26$1@forums-1-dub> <41433773$1@forums-1-dub>
Subject: Re: SQLXML
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 216.123.208.8
X-Original-NNTP-Posting-Host: 216.123.208.8
Message-ID: <41436ec4$1@forums-1-dub>
Date: 11 Sep 2004 14:31:48 -0700
X-Trace: forums-1-dub 1094938308 216.123.208.8 (11 Sep 2004 14:31:48 -0700)
X-Original-Trace: 11 Sep 2004 14:31:48 -0700, 216.123.208.8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3521
Article PK: 7423

Thanks for the quick response Greg,
What we are looking for is a bit different than what's described in the user
guide here. What we require is an abstraction of the database in XML. This
abstraction (like an object abstraction but in XML instead) will be mapped
somehow to the tables and fields in the database. Check SQLXML here
(http://msdn.microsoft.com/library/en-us/dnanchor/html/anch_SQLXML.asp?frame
=true)
Thanks
Emad

"Greg Fenton" <greg.fenton_nospam_@ianywhere.com> wrote in message
news:41433773$1@forums-1-dub...
> Emad Attia wrote:
> >
> > I was wondering if ASA (or any Sybase product) supports something like
MS
> > SQLXML or any support for representing a database schema in XML.
>
> I have not had much chance to play around with SQL and XML together yet,
> but have you read over the XML functionality offered in SQL Anywhere 9.x?
>
> If not see:
>
> ASA SQL User's Guide
> Using XML in the Database
> What is XML?
> - XML and Adaptive Server Anywhere
> or
>
> http://tinyurl.com/4o7qn (shortcut to docs on ianywhere.com)
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/


Jason Hinsperger (iAnywhere) Posted on 2004-09-13 13:28:54.0Z
From: "Jason Hinsperger \(iAnywhere\)" <NOjason_hinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <41432c26$1@forums-1-dub> <41433773$1@forums-1-dub> <41436ec4$1@forums-1-dub>
Subject: Re: SQLXML
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: hinsperg-xp.sybase.com
X-Original-NNTP-Posting-Host: hinsperg-xp.sybase.com
Message-ID: <4145a096$1@forums-1-dub>
Date: 13 Sep 2004 06:28:54 -0700
X-Trace: forums-1-dub 1095082134 10.25.98.197 (13 Sep 2004 06:28:54 -0700)
X-Original-Trace: 13 Sep 2004 06:28:54 -0700, hinsperg-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3526
Article PK: 7424

Check the documentation again and read the chapter called "Using XML in the
Database". It contains sections on importing and exporting relational data
as XML, as well as querying results as XML using SQLXML
ASA supports a lot of the functionality from the SQLXML draft standard, and
thus uses syntax very similar to what MS SQL Server uses (eg. the FOR XML
clause)

--
Jason Hinsperger
Product Manager
iAnywhere Solutions
************************************************************
For the latest downloads technotes, whitepapers, webcasts and other
developer
resources, go to: http://www.ianywhere.com/developer/
************************************************************

"Emad Attia" <emad@fpacesoftware.com> wrote in message
news:41436ec4$1@forums-1-dub...
> Thanks for the quick response Greg,
> What we are looking for is a bit different than what's described in the
user
> guide here. What we require is an abstraction of the database in XML. This
> abstraction (like an object abstraction but in XML instead) will be mapped
> somehow to the tables and fields in the database. Check SQLXML here
>
(http://msdn.microsoft.com/library/en-us/dnanchor/html/anch_SQLXML.asp?frame
> =true)
> Thanks
> Emad
>
> "Greg Fenton" <greg.fenton_nospam_@ianywhere.com> wrote in message
> news:41433773$1@forums-1-dub...
> > Emad Attia wrote:
> > >
> > > I was wondering if ASA (or any Sybase product) supports something like
> MS
> > > SQLXML or any support for representing a database schema in XML.
> >
> > I have not had much chance to play around with SQL and XML together yet,
> > but have you read over the XML functionality offered in SQL Anywhere
9.x?
> >
> > If not see:
> >
> > ASA SQL User's Guide
> > Using XML in the Database
> > What is XML?
> > - XML and Adaptive Server Anywhere
> > or
> >
> > http://tinyurl.com/4o7qn (shortcut to docs on ianywhere.com)
> >
> > Hope this helps,
> > greg.fenton
> > --
> > Greg Fenton
> > Consultant, Solution Services, iAnywhere Solutions
> > --------
> > Visit the iAnywhere Solutions Developer Community
> > Whitepapers, TechDocs, Downloads
> > http://www.ianywhere.com/developer/
>
>


"Matthew Young-Lai \(iAnywhere Solutions\)" <myoungla Posted on 2004-09-13 14:47:01.0Z
From: "Matthew Young-Lai \(iAnywhere Solutions\)" <myoungla@>
Newsgroups: ianywhere.public.general
References: <41432c26$1@forums-1-dub> <41433773$1@forums-1-dub> <41436ec4$1@forums-1-dub>
Subject: Re: SQLXML
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: myoungla-pc.sybase.com
X-Original-NNTP-Posting-Host: myoungla-pc.sybase.com
Message-ID: <4145b2e5$1@forums-1-dub>
Date: 13 Sep 2004 07:47:01 -0700
X-Trace: forums-1-dub 1095086821 10.25.99.172 (13 Sep 2004 07:47:01 -0700)
X-Original-Trace: 13 Sep 2004 07:47:01 -0700, myoungla-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3527
Article PK: 7429

I see this sort of thing as a higher level interface: you provide a mapping
in the form of an annotated xml schema and your xpath queries automatically
get mapped into lower level sql operations that use xml extensions (e.g. FOR
XML). Since the data is really being stored as tables, other operations
like inserts are mapped into plain sql without xml extensions.

The lower level xml extensions are provided in ASA but not the higher level
interface. I believe, however, that the latest version of PowerDesigner has
some related features.

Matthew

"Emad Attia" <emad@fpacesoftware.com> wrote in message
news:41436ec4$1@forums-1-dub...
> Thanks for the quick response Greg,
> What we are looking for is a bit different than what's described in the
> user
> guide here. What we require is an abstraction of the database in XML. This
> abstraction (like an object abstraction but in XML instead) will be mapped
> somehow to the tables and fields in the database. Check SQLXML here
> (http://msdn.microsoft.com/library/en-us/dnanchor/html/anch_SQLXML.asp?frame
> =true)
> Thanks
> Emad
>
> "Greg Fenton" <greg.fenton_nospam_@ianywhere.com> wrote in message
> news:41433773$1@forums-1-dub...
>> Emad Attia wrote:
>> >
>> > I was wondering if ASA (or any Sybase product) supports something like
> MS
>> > SQLXML or any support for representing a database schema in XML.
>>
>> I have not had much chance to play around with SQL and XML together yet,
>> but have you read over the XML functionality offered in SQL Anywhere 9.x?
>>
>> If not see:
>>
>> ASA SQL User's Guide
>> Using XML in the Database
>> What is XML?
>> - XML and Adaptive Server Anywhere
>> or
>>
>> http://tinyurl.com/4o7qn (shortcut to docs on ianywhere.com)
>>
>> Hope this helps,
>> greg.fenton
>> --
>> Greg Fenton
>> Consultant, Solution Services, iAnywhere Solutions
>> --------
>> Visit the iAnywhere Solutions Developer Community
>> Whitepapers, TechDocs, Downloads
>> http://www.ianywhere.com/developer/
>
>


Emad Attia Posted on 2004-09-13 16:10:11.0Z
From: "Emad Attia" <emad@fpacesoftware.com>
Newsgroups: ianywhere.public.general
References: <41432c26$1@forums-1-dub> <41433773$1@forums-1-dub> <41436ec4$1@forums-1-dub> <4145b2e5$1@forums-1-dub>
Subject: Re: SQLXML
Lines: 80
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 216.123.208.8
X-Original-NNTP-Posting-Host: 216.123.208.8
Message-ID: <4145c663$1@forums-1-dub>
Date: 13 Sep 2004 09:10:11 -0700
X-Trace: forums-1-dub 1095091811 216.123.208.8 (13 Sep 2004 09:10:11 -0700)
X-Original-Trace: 13 Sep 2004 09:10:11 -0700, 216.123.208.8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3532
Article PK: 7431

Yes.. .that is exactly what we are looking for. I am looking into
PowerDesigner 11 now.
Thanks
Emad

"Matthew Young-Lai (iAnywhere Solutions)" <myoungla@> wrote in message
news:4145b2e5$1@forums-1-dub...
> I see this sort of thing as a higher level interface: you provide a
mapping
> in the form of an annotated xml schema and your xpath queries
automatically
> get mapped into lower level sql operations that use xml extensions (e.g.
FOR
> XML). Since the data is really being stored as tables, other operations
> like inserts are mapped into plain sql without xml extensions.
>
> The lower level xml extensions are provided in ASA but not the higher
level
> interface. I believe, however, that the latest version of PowerDesigner
has
> some related features.
>
> Matthew
>
>
> "Emad Attia" <emad@fpacesoftware.com> wrote in message
> news:41436ec4$1@forums-1-dub...
> > Thanks for the quick response Greg,
> > What we are looking for is a bit different than what's described in the
> > user
> > guide here. What we require is an abstraction of the database in XML.
This
> > abstraction (like an object abstraction but in XML instead) will be
mapped
> > somehow to the tables and fields in the database. Check SQLXML here
> >
(http://msdn.microsoft.com/library/en-us/dnanchor/html/anch_SQLXML.asp?frame
> > =true)
> > Thanks
> > Emad
> >
> > "Greg Fenton" <greg.fenton_nospam_@ianywhere.com> wrote in message
> > news:41433773$1@forums-1-dub...
> >> Emad Attia wrote:
> >> >
> >> > I was wondering if ASA (or any Sybase product) supports something
like
> > MS
> >> > SQLXML or any support for representing a database schema in XML.
> >>
> >> I have not had much chance to play around with SQL and XML together
yet,
> >> but have you read over the XML functionality offered in SQL Anywhere
9.x?
> >>
> >> If not see:
> >>
> >> ASA SQL User's Guide
> >> Using XML in the Database
> >> What is XML?
> >> - XML and Adaptive Server Anywhere
> >> or
> >>
> >> http://tinyurl.com/4o7qn (shortcut to docs on ianywhere.com)
> >>
> >> Hope this helps,
> >> greg.fenton
> >> --
> >> Greg Fenton
> >> Consultant, Solution Services, iAnywhere Solutions
> >> --------
> >> Visit the iAnywhere Solutions Developer Community
> >> Whitepapers, TechDocs, Downloads
> >> http://www.ianywhere.com/developer/
> >
> >
>
>


David Fishburn Posted on 2004-09-13 15:23:27.0Z
Newsgroups: ianywhere.public.general
Subject: Re: SQLXML
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <41432c26$1@forums-1-dub> <41433773$1@forums-1-dub> <41436ec4$1@forums-1-dub> <4145b2e5$1@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns956371D61C0DFfishburnsybasecom@10.22.241.106>
User-Agent: Xnews/06.08.25
X-Original-NNTP-Posting-Host: fishburn-t30.sybase.com
X-Original-Trace: 13 Sep 2004 08:30:41 -0700, fishburn-t30.sybase.com
Lines: 31
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Sep 2004 08:11:31 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Sep 2004 08:23:27 -0700
X-Trace: forums-1-dub 1095089007 10.22.108.75 (13 Sep 2004 08:23:27 -0700)
X-Original-Trace: 13 Sep 2004 08:23:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3530
Article PK: 7432

"Matthew Young-Lai \(iAnywhere Solutions\)" <myoungla@> wrote in
news:4145b2e5$1@forums-1-dub:

MY-L> The lower level xml extensions are provided in ASA but not the higher
MY-L> level interface. I believe, however, that the latest version of
MY-L> PowerDesigner has some related features.

Yes, PowerDesigner 11 is almost completed it's final beta and has added
a significant amount of XML integration that would address this.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList