Control Center 6.1 question

Craig Victor

Control Center 6.1 question
> Hello all
> I'm having a problem with Control Center 6.1 and DB2/VM 6.1. When trying
> to add or redefine a column to be not null the procedure fails with an --
> ARI0897E unknown parameter starting at or near position 31. This happens
> for decimal or character columns. I'm using the SQLTABLE panel in CONTROL
> CENTER doing an option 4 then add the column make it (N) for not null then
> make the default value (N) then procedure runs then fails. I checked
> IBMLink and found nothing Anyone run into this?
> Thanks
> Craig Victor
> S & C Electric
> [login to unmask email]



Craig Victor

FW: Control Center 6.1 question
(in response to Craig Victor)
> Just to let you know. There was an old version of the SQLTABLE exec
> sitting on the Reorg serve machine's A disk. Once I renamed it the
> procedure worked.
>
> Craig Victor
> [login to unmask email]
> -----Original Message-----
> From: Victor, Craig
> Sent: Wednesday, December 13, 2000 10:53 AM
> To: '[login to unmask email]'
> Subject: Control Center 6.1 question
>
>
> Hello all
> I'm having a problem with Control Center 6.1 and DB2/VM 6.1. When trying
> to add or redefine a column to be not null the procedure fails with an --
> ARI0897E unknown parameter starting at or near position 31. This happens
> for decimal or character columns. I'm using the SQLTABLE panel in CONTROL
> CENTER doing an option 4 then add the column make it (N) for not null then
> make the default value (N) then procedure runs then fails. I checked
> IBMLink and found nothing Anyone run into this?
> Thanks
> Craig Victor
> S & C Electric
> [login to unmask email]