REXX Language Support

Shaun Z Lombard

REXX Language Support
Has anyone had any success using the sample DRAW program supplied in the REXX
Language Support manual for DB2 OS/390 V5 ?

Thanks

Shaun




*************************************************************
Opinions contained in this e-mail do not necessarily reflect
the opinions of the Queensland Department of Main Roads, or
of Queensland Transport. If you have received this electronic
mail message in error, please immediately notify the sender
and delete the message from your computer.



Gary V Scarcella

Re: REXX Language Support
(in response to Shaun Z Lombard)
While I haven't used the sample DRAW program (since I already had one), I
have done some testing with the REXX DB2 V5 interface. There are several
problems IBM is working on that will be addressed by APAR PQ31316, so you
should get this applied when it becomes available. There are currently some
problems handling NULLs, floating point numbers and getting 0C7's in
DSNREXX. These problems aside, the DB2 REXX interface has been working fine
for me. It really simplifies accessing DB2 from REXX by just embedding the
SQL, and certainly beats the old way of calling DSNTEP2 and parsing the
output.

Gary Scarcella
Internet address: [login to unmask email]



> ----------
> From: Shaun Z Lombard[SMTP:[login to unmask email]
> Sent: Wednesday, December 15, 1999 1:57 AM
> To: [login to unmask email]
> Subject: REXX Language Support
>
> Has anyone had any success using the sample DRAW program supplied in the
> REXX
> Language Support manual for DB2 OS/390 V5 ?
>
> Thanks
>
> Shaun
>
>
>
>
> *************************************************************
> Opinions contained in this e-mail do not necessarily reflect
> the opinions of the Queensland Department of Main Roads, or
> of Queensland Transport. If you have received this electronic
> mail message in error, please immediately notify the sender
> and delete the message from your computer.
>
>
>
>
>
>



Manas Dasgupta

Re: REXX Language Support
(in response to Gary V Scarcella)
Is REXX DB2 V5 interface a seperately priced item or is it available for
free for V5 customers ?

Thanks,
Manas.

> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
> Scarcella, Gary V
> Sent: Wednesday, December 15, 1999 6:27 AM
> To: [login to unmask email]
> Subject: Re: REXX Language Support
>
>
> While I haven't used the sample DRAW program (since I already had one), I
> have done some testing with the REXX DB2 V5 interface. There are several
> problems IBM is working on that will be addressed by APAR PQ31316, so you
> should get this applied when it becomes available. There are
> currently some
> problems handling NULLs, floating point numbers and getting 0C7's in
> DSNREXX. These problems aside, the DB2 REXX interface has been
> working fine
> for me. It really simplifies accessing DB2 from REXX by just
> embedding the
> SQL, and certainly beats the old way of calling DSNTEP2 and parsing the
> output.
>
> Gary Scarcella
> Internet address: [login to unmask email]
>
>
>
> > ----------
> > From: Shaun Z Lombard[SMTP:[login to unmask email]
> > Sent: Wednesday, December 15, 1999 1:57 AM
> > To: [login to unmask email]
> > Subject: REXX Language Support
> >
> > Has anyone had any success using the sample DRAW program supplied in the
> > REXX
> > Language Support manual for DB2 OS/390 V5 ?
> >
> > Thanks
> >
> > Shaun
> >
> >
> >
> >
> > *************************************************************
> > Opinions contained in this e-mail do not necessarily reflect
> > the opinions of the Queensland Department of Main Roads, or
> > of Queensland Transport. If you have received this electronic
> > mail message in error, please immediately notify the sender
> > and delete the message from your computer.
> >
> >
> >
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
> the list can
> >
> >
>
>
> To change your subscription options or to cancel your
> subscription visit the DB2-L webpage at
http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]



[login to unmask email]

Re: REXX Language Support
(in response to Manas Dasgupta)
Manas,

It's free.

Bill Gallagher





Manas Dasgupta <[login to unmask email]> on 12/15/99 10:20:27 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance)
bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance
Subject: Re: REXX Language Support



Is REXX DB2 V5 interface a seperately priced item or is it available for
free for V5 customers ?

Thanks,
Manas.

> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
> Scarcella, Gary V
> Sent: Wednesday, December 15, 1999 6:27 AM
> To: [login to unmask email]
> Subject: Re: REXX Language Support
>
>
> While I haven't used the sample DRAW program (since I already had one), I
> have done some testing with the REXX DB2 V5 interface. There are several
> problems IBM is working on that will be addressed by APAR PQ31316, so you
> should get this applied when it becomes available. There are
> currently some
> problems handling NULLs, floating point numbers and getting 0C7's in
> DSNREXX. These problems aside, the DB2 REXX interface has been
> working fine
> for me. It really simplifies accessing DB2 from REXX by just
> embedding the
> SQL, and certainly beats the old way of calling DSNTEP2 and parsing the
> output.
>
> Gary Scarcella
> Internet address: [login to unmask email]
>
>
>
> > ----------
> > From: Shaun Z Lombard[SMTP:[login to unmask email]
> > Sent: Wednesday, December 15, 1999 1:57 AM
> > To: [login to unmask email]
> > Subject: REXX Language Support
> >
> > Has anyone had any success using the sample DRAW program supplied in the
> > REXX
> > Language Support manual for DB2 OS/390 V5 ?
> >
> > Thanks
> >
> > Shaun
> >
> >
> >
> >
> > *************************************************************
> > Opinions contained in this e-mail do not necessarily reflect
> > the opinions of the Queensland Department of Main Roads, or
> > of Queensland Transport. If you have received this electronic
> > mail message in error, please immediately notify the sender
> > and delete the message from your computer.
> >
> >
> >
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
> the list can
> >
> >
>
>
> To change your subscription options or to cancel your
> subscription visit the DB2-L webpage at
http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]








John O'Conner

Re: REXX Language Support
(in response to BILL_GALLAGHER@PHL.COM)
We just installed DB2 Rexx Language Support, and we would like to try it
out. Is there documentation available? We must be looking in the wrong
places because we are unable to find any.

Any help would be greatly appreciated.

John O'Conner
[login to unmask email]

-----Original Message-----
From: Scarcella, Gary V [mailto:[login to unmask email]
Sent: Wednesday, December 15, 1999 3:27 AM
To: [login to unmask email]
Subject: Re: REXX Language Support


While I haven't used the sample DRAW program (since I already had one), I
have done some testing with the REXX DB2 V5 interface. There are several
problems IBM is working on that will be addressed by APAR PQ31316, so you
should get this applied when it becomes available. There are currently some
problems handling NULLs, floating point numbers and getting 0C7's in
DSNREXX. These problems aside, the DB2 REXX interface has been working fine
for me. It really simplifies accessing DB2 from REXX by just embedding the
SQL, and certainly beats the old way of calling DSNTEP2 and parsing the
output.

Gary Scarcella
Internet address: [login to unmask email]



> ----------
> From: Shaun Z Lombard[SMTP:[login to unmask email]
> Sent: Wednesday, December 15, 1999 1:57 AM
> To: [login to unmask email]
> Subject: REXX Language Support
>
> Has anyone had any success using the sample DRAW program supplied in the
> REXX
> Language Support manual for DB2 OS/390 V5 ?
>
> Thanks
>
> Shaun
>
>
>
>
> *************************************************************
> Opinions contained in this e-mail do not necessarily reflect
> the opinions of the Queensland Department of Main Roads, or
> of Queensland Transport. If you have received this electronic
> mail message in error, please immediately notify the sender
> and delete the message from your computer.
>
>
>
>
>
>








Roger Miller

Re: REXX Language Support
(in response to Manas Dasgupta)
There is a pdf you can download - see under news on the DB2 for OS/390
home page www.ibm.com/software/db2os390

Roger Miller


"O'Conner, John" <[login to unmask email]>@RYCI.COM> on 12/16/99
08:35:03 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Re: REXX Language Support



We just installed DB2 Rexx Language Support, and we would like to try it
out. Is there documentation available? We must be looking in the wrong
places because we are unable to find any.

Any help would be greatly appreciated.

John O'Conner
[login to unmask email]

-----Original Message-----
From: Scarcella, Gary V [mailto:[login to unmask email]
Sent: Wednesday, December 15, 1999 3:27 AM
To: [login to unmask email]
Subject: Re: REXX Language Support


While I haven't used the sample DRAW program (since I already had one), I
have done some testing with the REXX DB2 V5 interface. There are several
problems IBM is working on that will be addressed by APAR PQ31316, so you
should get this applied when it becomes available. There are currently
some
problems handling NULLs, floating point numbers and getting 0C7's in
DSNREXX. These problems aside, the DB2 REXX interface has been working
fine
for me. It really simplifies accessing DB2 from REXX by just embedding the
SQL, and certainly beats the old way of calling DSNTEP2 and parsing the
output.

Gary Scarcella
Internet address: [login to unmask email]



> ----------
> From: Shaun Z Lombard[SMTP:[login to unmask email]
> Sent: Wednesday, December 15, 1999 1:57 AM
> To: [login to unmask email]
> Subject: REXX Language Support
>
> Has anyone had any success using the sample DRAW program supplied in the
> REXX
> Language Support manual for DB2 OS/390 V5 ?
>
> Thanks
>
> Shaun
>
>
>
>
> *************************************************************
> Opinions contained in this e-mail do not necessarily reflect
> the opinions of the Queensland Department of Main Roads, or
> of Queensland Transport. If you have received this electronic
> mail message in error, please immediately notify the sender
> and delete the message from your computer.
>
>
>
> the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can
>
>



the










Manas Dasgupta

Re: REXX Language Support
(in response to John O'Conner)
Try ftp://ftp.software.ibm.com/software/os390/db2server/books/REXXV5.PDF

Manas.

> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
> O'Conner, John
> Sent: Thursday, December 16, 1999 11:35 AM
> To: [login to unmask email]
> Subject: Re: REXX Language Support
>
>
> We just installed DB2 Rexx Language Support, and we would like to try it
> out. Is there documentation available? We must be looking in the wrong
> places because we are unable to find any.
>
> Any help would be greatly appreciated.
>
> John O'Conner
> [login to unmask email]
>
> -----Original Message-----
> From: Scarcella, Gary V [mailto:[login to unmask email]
> Sent: Wednesday, December 15, 1999 3:27 AM
> To: [login to unmask email]
> Subject: Re: REXX Language Support
>
>
> While I haven't used the sample DRAW program (since I already had one), I
> have done some testing with the REXX DB2 V5 interface. There are several
> problems IBM is working on that will be addressed by APAR PQ31316, so you
> should get this applied when it becomes available. There are
> currently some
> problems handling NULLs, floating point numbers and getting 0C7's in
> DSNREXX. These problems aside, the DB2 REXX interface has been
> working fine
> for me. It really simplifies accessing DB2 from REXX by just
> embedding the
> SQL, and certainly beats the old way of calling DSNTEP2 and parsing the
> output.
>
> Gary Scarcella
> Internet address: [login to unmask email]
>
>
>
> > ----------
> > From: Shaun Z Lombard[SMTP:[login to unmask email]
> > Sent: Wednesday, December 15, 1999 1:57 AM
> > To: [login to unmask email]
> > Subject: REXX Language Support
> >
> > Has anyone had any success using the sample DRAW program supplied in the
> > REXX
> > Language Support manual for DB2 OS/390 V5 ?
> >
> > Thanks
> >
> > Shaun
> >
> >
> >
> >
> > *************************************************************
> > Opinions contained in this e-mail do not necessarily reflect
> > the opinions of the Queensland Department of Main Roads, or
> > of Queensland Transport. If you have received this electronic
> > mail message in error, please immediately notify the sender
> > and delete the message from your computer.
> >
> >
> >
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
> the list can
> >
> >
>
>
> To change your subscription options or to cancel your
> subscription visit the
>
>
>
>
> To change your subscription options or to cancel your
> subscription visit the DB2-L webpage at
http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]



David Seibert

Re: REXX Language Support
(in response to Roger Miller)
>Is there documentation available?

Look in ftp://ftp.software.ibm.com/software/os390/db2server/books/
for REXXV5.PDF

David Seibert
Compuware Corporation File-AID product planner
[login to unmask email]



Shaun Z Lombard

Re: REXX Language Support
(in response to David Seibert)
Thanks for the reply Gary. We will be watching that APAR closely.
I have written other programs using the interface which worked fine, but for
some reason I keep getting a -188 on the DESCRIBE TABLE statement in the DRAW
program. Any ideas.

Thanks

Shaun




"Scarcella, Gary V" <[login to unmask email]> on 15/12/99 21:26:32

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Shaun Z Lombard/CorpServ/qdot/au)
Subject: Re: REXX Language Support




While I haven't used the sample DRAW program (since I already had one), I
have done some testing with the REXX DB2 V5 interface. There are several
problems IBM is working on that will be addressed by APAR PQ31316, so you
should get this applied when it becomes available. There are currently some
problems handling NULLs, floating point numbers and getting 0C7's in
DSNREXX. These problems aside, the DB2 REXX interface has been working fine
for me. It really simplifies accessing DB2 from REXX by just embedding the
SQL, and certainly beats the old way of calling DSNTEP2 and parsing the
output.

Gary Scarcella
Internet address: [login to unmask email]



> ----------
> From: Shaun Z Lombard[SMTP:[login to unmask email]
> Sent: Wednesday, December 15, 1999 1:57 AM
> To: [login to unmask email]
> Subject: REXX Language Support
>
> Has anyone had any success using the sample DRAW program supplied in the
> REXX
> Language Support manual for DB2 OS/390 V5 ?
>
> Thanks
>
> Shaun
>
>
>
>
> *************************************************************
> Opinions contained in this e-mail do not necessarily reflect
> the opinions of the Queensland Department of Main Roads, or
> of Queensland Transport. If you have received this electronic
> mail message in error, please immediately notify the sender
> and delete the message from your computer.
>
>
>
>
>
>








Gary V Scarcella

Re: REXX Language Support
(in response to Shaun Z Lombard)
The problems I was having were resulting in SQLCODE = -104 and -105 (which
are supposed to be resolved with the APAR).

One possible reason for the -188, might be that some string is not enclosed
in single quotes when it gets to DB2.
To get a REXX variable set to 'ABC' you need to set variable = "'"ABC"'"
(that's <double quote><single quote><double quote>ABC<double quote><single
quote><double quote>)

Gary Scarcella
Internet address: [login to unmask email]


> ----------
> From: Shaun Z Lombard[SMTP:[login to unmask email]
> Reply To: DB2 Data Base Discussion List
> Sent: Thursday, December 16, 1999 7:49 PM
> To: [login to unmask email]
> Subject: Re: REXX Language Support
>
> Thanks for the reply Gary. We will be watching that APAR closely.
> I have written other programs using the interface which worked fine, but
> for
> some reason I keep getting a -188 on the DESCRIBE TABLE statement in the
> DRAW
> program. Any ideas.
>
> Thanks
>
> Shaun
>
>
>
>
> "Scarcella, Gary V" <[login to unmask email]> on 15/12/99 21:26:32
>
> Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
> To: [login to unmask email]
> cc: (bcc: Shaun Z Lombard/CorpServ/qdot/au)
> Subject: Re: REXX Language Support
>
>
>
>
> While I haven't used the sample DRAW program (since I already had one), I
> have done some testing with the REXX DB2 V5 interface. There are several
> problems IBM is working on that will be addressed by APAR PQ31316, so you
> should get this applied when it becomes available. There are currently
> some
> problems handling NULLs, floating point numbers and getting 0C7's in
> DSNREXX. These problems aside, the DB2 REXX interface has been working
> fine
> for me. It really simplifies accessing DB2 from REXX by just embedding
> the
> SQL, and certainly beats the old way of calling DSNTEP2 and parsing the
> output.
>
> Gary Scarcella
> Internet address: [login to unmask email]
>
>
>
> > ----------
> > From: Shaun Z Lombard[SMTP:[login to unmask email]
> > Sent: Wednesday, December 15, 1999 1:57 AM
> > To: [login to unmask email]
> > Subject: REXX Language Support
> >
> > Has anyone had any success using the sample DRAW program supplied in the
> > REXX
> > Language Support manual for DB2 OS/390 V5 ?
> >
> > Thanks
> >
> > Shaun
> >
> >
> >
> >
> > *************************************************************
> > Opinions contained in this e-mail do not necessarily reflect
> > the opinions of the Queensland Department of Main Roads, or
> > of Queensland Transport. If you have received this electronic
> > mail message in error, please immediately notify the sender
> > and delete the message from your computer.
> >
> >
> >
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
> can
> >
> >
>
>
>
> the
>
>
>
>
>
>
>
>