View previous topic :: View next topic
|
Author |
Message |
bkvinay7
New User
Joined: 31 May 2007 Posts: 4 Location: banglore
|
|
|
|
I have newly introduced column in a table i want to update all ROws of that table to 3 for that column, column type is smallint. |
|
Back to top |
|
|
RamsIBM
New User
Joined: 08 Jan 2007 Posts: 53 Location: Chennai
|
|
|
|
Update table <table name> set <column name> =3 |
|
Back to top |
|
|
bkvinay7
New User
Joined: 31 May 2007 Posts: 4 Location: banglore
|
|
|
|
I wanna RUn JOB for this so that i can shedule it for any time. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
OK, place your update query in "jcl" and schedule it for whenever it is needed. . . . |
|
Back to top |
|
|
|