Re: View to create a PF?

On 8/23/2013 10:51 AM, Hoteltravelfundotcom wrote:

also it needs to be a dynamic copy of the view records to the pf.

Pinchas,

It won't be and it can't be.

If I understand your underlying problem, it's that you feel Crystal
Reports can only use files defined with DDS. I can tell you for certain
that I use DDL defined VIEWS with Crystal all the time. You are pulling
yourself through a knothole for no good reason.

Don't try to create a VIEW and then update a DDS-PF with it. Just
define the VIEW. Since you are disinclined to fix the CCSID in any one
of the places it would help, create the view using CAST as Rob suggested.

SELECT cast (LMLTPC as char (30) CCSID 37) as LMLTPC... Repeat for
every column.

If that seems like a lot of work, it is. And it is completely
unnecessary. Fix the CCSID in the job, on the table, on the system. Or
set the 'translate 65535' on the ODBC driver.
--buck

On Fri, Aug 23, 2013 at 10:45 AM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

Luis, but that won't be a dds based file.Actaully I was thinking to make
PF first and then load in the records but I will try this idea.