Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ALTER Table in UDB Stored Procedure Builder

Status
Not open for further replies.
agdata

agdata

Programmer
Jul 5, 2002
2
US
I am trying to use the statement ALTER TABLE tablename ACTIVATE NOT LOGGED INITIALLY and my SP won't build. It seems to think I don't have a semicolon preceding this statement... I do.

Is it possible to use this statement in SPB... if so, does anybody have an example?
 
Status
Not open for further replies.

Similar threads

usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
104
usr1234
usr1234
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
210
fredericofonseca
fredericofonseca
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
171
pratimsingha
pratimsingha
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
193
evr72
evr72
gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
319
gdg1976
gdg1976

Part and Inventory Search

Sponsor

Back
Top