To All,
Does anyone have an example of using the ALTOBJ procedure to rename a column? Thanks.





Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Arnab Bhattacharya
[mailto:db2udbdba-ezmlmshield-x59785941.[Email address protected]
Sent: Monday, June 26, 2006 5:20 AM
To: LazyDBA Discussion
Subject: Re: Regarding ALTOBJ procedure






In the command after "sample" just put a space before the bracket starts.

--Arnab



"Jagdish S Rawat
"
<db2udbdba-ezmlms To
hield-x99402519.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

26/06/2006 14:03 Subject
Regarding ALTOBJ procedure










Hi
I want to use the inbuild procedure ALTOBJ
But am facing problem in this any one can help me
I need urgent help



$ db2 "CREATE TABLE sample (name VARCHAR(5), age INTEGER) "
DB20000I The SQL command completed successfully.

$ db2 "CALL SYSPROC.ALTOBJ('APPLY_CONTINUE_ON_ERROR', 'CREATE TABLE sample
(name VARCHAR(5), age varchar(10))',-1, ?)"
SQL0443N Routine "SYSPROC.ALTOBJ" (specific name "ALTOBJ") has returned
an
error SQLSTATE with diagnostic text "SQL0204 Reason code or token:
DB2INST1.sample". SQLSTATE=38553


Thanx in advance


with regards

Jagdish S. Rawat
IBM Certified DB2 DBA
IGSI, DLF Silokhera, Sector 30,
NH-8, Sector 30, Opp. 32nd Milestone,
Gurgoan -122001
Ph.# +91-124-4136722(Direct) +91-124-2832424 Ext. # 6722
Fax# +91-124-2836995
Mob# +919818433596



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page