Yes, I knew what the problem is and that is has to do with duplicate columns not being unique. I figured I could use dynamic sql in order to complete...

How can I explicitly list all of the column names from both tables when I won’t have any knowledge of what the user defined columns are when they are different...

Well the fact of the problem is that it is a schema issue and not a data issue (having to do with columns returned in a view). If you created...

I don’t see the relevance of the data in this situation. My goal is to create a view in which I can select all user defined columns from both tables...

Okay here is a pretty simple example. Keep in mind each client could have different columns within these tables as some of them can be user defined. There are also...

I forgot to post what I used that finally allowed me to update the field. The script is below.

UPDATE idsdemo.FFIITMAP

   SET FFIHGTH = (SELECT FFIHGTH

FROM idsdemo.cubiscan1

WHERE ltrim(rtrim(idsdemo.cubiscan1.FFIITMN)) = ltrim(rtrim(idsdemo.FFIITMAP.FFIITMN)))

Where...

Okay in an attempt to accomplish the same goal I've written a cursor however DB2 seems to have a problem with my variables that are declared. Anyone familiar with DB2...

No, the DB name is idsdemo and table is FFIITMAP the same as SQL is. I tried the suggestion anyways and it produced an error on the [

I think it...

I tried that as well but I got another error: Column qualifier or table A undefined.

I actually run without the table name prefix in the set and it still...

I had noticed I posted the original question under a category that was not consistent with my question so I posted under a category that made more sense, however I...

I gave that a try but it still gives me an error dealing with the FROM causing a problem.

Keyword FROM not expected. Valid tokens: <END-OF-STATEMENT>.