REXX for windows and MS SQL SERVER

Hi,
I am looking for a sample code in REXX for making MS SQL Server database connectivity and programming in windows 2000 server environment.
Thanks,
SMANIUse the Generic ODBC from Source Forge (http://rexxsql.sourceforge.net/). REXX never really caught on for the PC, so it isn't well represented for the current generation of Windows tools.

-PatPsql

Returning XML values

I have an XML field in one of our tables.
A sample of the data is here:
<PackageAddTask xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/
XMLSchema"><Item><PackageItemId>11</
PackageItemId><PackageId>6</PackageId><Path>https://10.126.22.1/
SBGImages</Path><Filename>image1.img</Filename><InstallOrder>0</
InstallOrder></Item></PackageAddTask>
I need to retrieve the PackageID value from this field
This query returns the entire item.
SELECT Detail.query('/PackageAddTask/Item/PackageId')
FROM Task T Where TaskTypeID = 4
This query SHOULD return the value, but instead, return NULL
Select Detail.value('(/PackageAddTask/Item/@.PackageItemId)[1]',
'int')
as Result
FROM Task T Where TaskTypeID = 4
What am I missing here?Brian Bunin,
Try:
Select Detail.value('(/PackageAddTask/Item/PackageItemId)[1]', 'int') as
Result
FROM Task T
Where TaskTypeID = 4
go
AMB
"Brian Bunin" wrote:
> I have an XML field in one of our tables.
> A sample of the data is here:
> <PackageAddTask xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/
> XMLSchema"><Item><PackageItemId>11</
> PackageItemId><PackageId>6</PackageId><Path>https://10.126.22.1/
> SBGImages</Path><Filename>image1.img</Filename><InstallOrder>0</
> InstallOrder></Item></PackageAddTask>
> I need to retrieve the PackageID value from this field
>
> This query returns the entire item.
> SELECT Detail.query('/PackageAddTask/Item/PackageId')
> FROM Task T Where TaskTypeID = 4
>
> This query SHOULD return the value, but instead, return NULL
> Select Detail.value('(/PackageAddTask/Item/@.PackageItemId)[1]',
> 'int')
> as Result
> FROM Task T Where TaskTypeID = 4
>
> What am I missing here?
>

Returning XML values

I have an XML field in one of our tables.
A sample of the data is here:
<PackageAddTask xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/
XMLSchema"><Item><PackageItemId>11</
PackageItemId><PackageId>6</PackageId><Path>https://10.126.22.1/
SBGImages</Path><Filename>image1.img</Filename><InstallOrder>0</
InstallOrder></Item></PackageAddTask>
I need to retrieve the PackageID value from this field
This query returns the entire item.
SELECT Detail.query('/PackageAddTask/Item/PackageId')
FROM Task T Where TaskTypeID = 4
This query SHOULD return the value, but instead, return NULL
Select Detail.value('(/PackageAddTask/Item/@.PackageItemId)[1]',
'int')
as Result
FROM Task T Where TaskTypeID = 4
What am I missing here?Brian Bunin,
Try:
Select Detail.value('(/PackageAddTask/Item/PackageItemId)[1]', 'int') as
Result
FROM Task T
Where TaskTypeID = 4
go
AMB
"Brian Bunin" wrote:

> I have an XML field in one of our tables.
> A sample of the data is here:
> <PackageAddTask xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/
> XMLSchema"><Item><PackageItemId>11</
> PackageItemId><PackageId>6</PackageId><Path>https://10.126.22.1/
> SBGImages</Path><Filename>image1.img</Filename><InstallOrder>0</
> InstallOrder></Item></PackageAddTask>
> I need to retrieve the PackageID value from this field
>
> This query returns the entire item.
> SELECT Detail.query('/PackageAddTask/Item/PackageId')
> FROM Task T Where TaskTypeID = 4
>
> This query SHOULD return the value, but instead, return NULL
> Select Detail.value('(/PackageAddTask/Item/@.PackageItemId)[1]',
> 'int')
> as Result
> FROM Task T Where TaskTypeID = 4
>
> What am I missing here?
>