AS400,iseries,System i,LANSA,CSS,HTML,Scripts: How to update same data into different column?

Message

   How to update same data into different column inthe same table  having different datatype ?

Thanks & Regards,
Anil

Author	Message
Anil Newbie Joined: 10 Apr 2007 Location: Cote D'Ivoire Posts: 32	Topic: How to update same data into different column? Posted: 27 Feb 2010 at 7:08pm
	How to update same data into different column inthe same table having different datatype ? Thanks & Regards, Anil

	IP Logged

DB2GURU Newbie Joined: 23 Feb 2010 Location: Japan Posts: 3	Posted: 27 Feb 2010 at 7:10pm
	Inserting same data into different column inthe same table having different datatype. Here I have used the view of same table to update the coumn with diffent data base. The syantax is for MS SQL server. username varchar(50) Custid intger update table1 set username = CAST(a.custid as varchar(50)) from view1 a where table1.custid = a.custid
	IP Logged

SQL400
AS400,iseries,System i,LANSA,CSS,HTML,Scripts :AS400(Iseries) :SQL400