Re: View to create a PF?

I'd start out with fixing the CCSID's of your original table first.
Failing that I might change your system value for QCCSID. Failing that
I'd start CASTing values in your view to fix that. Or I might look at
your reporting tool for an option to convert hex.

I could answer your question but not give you what you want. For example,
to create a temporary table you could
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzdgtt.htm
DECLARE GLOBAL TEMPORARY TABLE ...
which is very similar to
CREATE TABLE QTEMP.MYTABLE ...

See also
CREATE TABLE MYTABLE AS (
SELECT * FROM MYVIEW)
WITH DATA

That will create a table from your view. However, if you don't fix the
underlying problem of your CCSID's you'll probably still get crap with
your reporting tool.


Rob Berendt