SQLDBS reorg

[Ven Ilagan]

Hi gurus,

Am trying to use SQLDBS in my program, like so:

CALL SQLDBS 'REORG TABLE 'schema'.'tabname ' INPLACE'
gives me a syntax error, yet when I take off INPLACE, it works fine. Does
this mean that the SQLDBS interface is restrictive and won't allow online
reorgs then?

I can't seem to find any documentation on syntax involving SQLDBS and from
what little I could find inside samples\ directory, there's not much to base
on...

Thanks,
Ven

[Gert van der Kooij]

In article <45***********************@news.optusnet.com.au> ,
vc******@optusnet.com.au says...

Hi gurus,

Am trying to use SQLDBS in my program, like so:

CALL SQLDBS 'REORG TABLE 'schema'.'tabname ' INPLACE'
gives me a syntax error, yet when I take off INPLACE, it works fine. Does
this mean that the SQLDBS interface is restrictive and won't allow online
reorgs then?

I can't seem to find any documentation on syntax involving SQLDBS and from
what little I could find inside samples\ directory, there's not much to base
on...

Thanks,
Ven

This looks like you are using the DB2/Rexx interface. If so, this
interface is 'stabilized' at the DB2 5.2 level and isn't updated after
that. Any functionality added that level isn't supported by the
interface. You can find this statement in the V8 doc at
http://tinyurl.com/y56ukq

[Ven Ilagan]

Thanks for your reply, Gert - though sadly for my case, it doesn't auger
well..... oh well!

Ven

"Gert van der Kooij" <no****@invalid.nlwrote in message
news:MP***********************@news.xs4all.nl...

In article <45***********************@news.optusnet.com.au> ,
vc******@optusnet.com.au says...

>Hi gurus,

Am trying to use SQLDBS in my program, like so:

CALL SQLDBS 'REORG TABLE 'schema'.'tabname ' INPLACE'
gives me a syntax error, yet when I take off INPLACE, it works fine. Does
this mean that the SQLDBS interface is restrictive and won't allow online
reorgs then?

I can't seem to find any documentation on syntax involving SQLDBS and
from
what little I could find inside samples\ directory, there's not much to
base
on...

Thanks,
Ven

This looks like you are using the DB2/Rexx interface. If so, this
interface is 'stabilized' at the DB2 5.2 level and isn't updated after
that. Any functionality added that level isn't supported by the
interface. You can find this statement in the V8 doc at
http://tinyurl.com/y56ukq