DSNREXX and ALTER

Database Research

DSNREXX and ALTER
Hi All,

Is it possible to issue the ALTER TABLESPACE statement
from the DB2 for OS/390 DSNREXX interface?

If so could someone provide an example of the EXECSQL
statements needed ?

Thanks

_____________________________________________________________________________
http://au.yahoo.com/shopping/giftguide/christmas/jumppage.html - Yahoo! Gift Guides
- Looking for inspiration?



James Campbell

Re: DSNREXX and ALTER
(in response to Database Research)
Well, I've never done an alter, but have you tried

ADDRESS DSNREXX "EXECSQL ALTER TABLESPACE ..."

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]

-----Original Message-----
From: DB2 DBA [mailto:[login to unmask email]
Sent: Friday, December 15, 2000 10:33 AM
To: [login to unmask email]
Subject: [DB2-L] DSNREXX and ALTER


Hi All,

Is it possible to issue the ALTER TABLESPACE statement
from the DB2 for OS/390 DSNREXX interface?

If so could someone provide an example of the EXECSQL
statements needed ?

Thanks

____________________________________________________________________________
_
http://au.yahoo.com/shopping/giftguide/christmas/jumppage.html - Yahoo! Gift
Guides
- Looking for inspiration?







**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************



Database Research

Re: DSNREXX and ALTER
(in response to James Campbell)
Thanks James,

I tried that without any luck. I got -518 , so I tried
to prepare it and got -504, so I tried to declare it
and got -518.

Any ideas.

Thanks

******************************************************


Well, I've never done an alter, but have you tried

ADDRESS DSNREXX "EXECSQL ALTER TABLESPACE ..."

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]

-----Original Message-----
From: DB2 DBA [mailto:[login to unmask email]
Sent: Friday, December 15, 2000 10:33 AM
To: [login to unmask email]
Subject: [DB2-L] DSNREXX and ALTER


Hi All,

Is it possible to issue the ALTER TABLESPACE statement
from the DB2 for OS/390 DSNREXX interface?

If so could someone provide an example of the EXECSQL
statements needed ?

Thanks



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





_____________________________________________________________________________
http://au.yahoo.com/shopping/giftguide/christmas/jumppage.html - Yahoo! Gift Guides
- Looking for inspiration?



James Campbell

Re: DSNREXX and ALTER
(in response to Database Research)
Well, I just tried what I suggested and it worked for me. Could you post
your actual code.

BTW, which version of DB2, and any PTFs.

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]

-----Original Message-----
From: DB2 DBA [mailto:[login to unmask email]
Sent: Friday, December 15, 2000 12:13 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DSNREXX and ALTER


Thanks James,

I tried that without any luck. I got -518 , so I tried
to prepare it and got -504, so I tried to declare it
and got -518.

Any ideas.

Thanks

******************************************************


Well, I've never done an alter, but have you tried

ADDRESS DSNREXX "EXECSQL ALTER TABLESPACE ..."

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]

-----Original Message-----
From: DB2 DBA [mailto:[login to unmask email]
Sent: Friday, December 15, 2000 10:33 AM
To: [login to unmask email]
Subject: [DB2-L] DSNREXX and ALTER


Hi All,

Is it possible to issue the ALTER TABLESPACE statement
from the DB2 for OS/390 DSNREXX interface?

If so could someone provide an example of the EXECSQL
statements needed ?

Thanks



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





____________________________________________________________________________
_
http://au.yahoo.com/shopping/giftguide/christmas/jumppage.html - Yahoo! Gift
Guides
- Looking for inspiration?







**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************



Database Research

Re: DSNREXX and ALTER
(in response to James Campbell)
James,

Problem solved. You are right it does work, I had a
commit statement that was causing the -518.

Thanks again.

-----Original Message-----
From: James Campbell
[mailto:[login to unmask email]
Sent: Friday, 15 December 2000 13:31
To: [login to unmask email]
Subject: Re: DSNREXX and ALTER


Well, I just tried what I suggested and it worked for
me. Could you post
your actual code.

BTW, which version of DB2, and any PTFs.

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]

-----Original Message-----
From: DB2 DBA [mailto:[login to unmask email]
Sent: Friday, December 15, 2000 12:13 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DSNREXX and ALTER


Thanks James,

I tried that without any luck. I got -518 , so I tried
to prepare it and got -504, so I tried to declare it
and got -518.

Any ideas.

Thanks

******************************************************


Well, I've never done an alter, but have you tried

ADDRESS DSNREXX "EXECSQL ALTER TABLESPACE ..."

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]

-----Original Message-----
From: DB2 DBA [mailto:[login to unmask email]
Sent: Friday, December 15, 2000 10:33 AM
To: [login to unmask email]
Subject: [DB2-L] DSNREXX and ALTER


Hi All,

Is it possible to issue the ALTER TABLESPACE statement
from the DB2 for OS/390 DSNREXX interface?

If so could someone provide an example of the EXECSQL
statements needed ?

Thanks



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





____________________________________________________________________________
_
http://au.yahoo.com/shopping/giftguide/christmas/jumppage.html
- Yahoo! Gift
Guides
- Looking for inspiration?


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



**********************************************************************
This email and any files transmitted with it are
confidential and
intended solely for the use of the individual or
entity to whom they
are addressed. If you have received this email in
error please notify
the system manager.

This footnote also confirms that this email message
has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************


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



_____________________________________________________________________________
http://au.yahoo.com/shopping/giftguide/christmas/jumppage.html - Yahoo! Gift Guides
- Looking for inspiration?