Is there any one out there that can help me with this?
I have a query in which I am trying to UNION three tables (all column names match from table to table) and some of the columns are wide character columns. Because this is not allowed, I am stuck on figuring out how to get around it. I have been beating myself over the head on this one and just cannot get it.
I would post the SQL, but it is so esoteric that there is no value in that. It really boils down to the question of how do I represent, in one SQL query, the contents of these three tables, where the results of any given row are always only ever sourced from a single table (I want all rows from all three tables) to create a sinlge view of the three.
The DBMS here is mainframe DB2 7.1, but therules on this should translate from DBMS to DBMS.
--DDTM
I figured it out...
The columns in question were VARCHAR, so I used the function CHAR( column_name , x ) where x = some length.