as indicated before : the nickname is a shadow of a real table
the columns can not be changed, only the datatype mapping
drop nickname-create nickname will reflect changes to base table
ALL doc is in the infocenter
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
I am trying to handle this. I have lots of tables in my database.I am working on a single table.
I embedded this in a procedure. When i am running this I am getting the below error.
can u please let me know what I have to do for this error.
DB2 SQL Error: SQLCODE=-1822, SQLSTATE=560BD, SQLERRMC=07001;SAMPLE;func="SQLExecute" msg=" CLI0100E Wrong number of paramet, DRIVER=4.17.30
Run of routine failed.