Re: Program Described File and SQL

[Mike Wills <mike@xxxxxxxxxxxx>]

At first it didn't seem like this was working, but now it is. Thanks!

Though, I will probably need to do externally described files in the
short-term future.

--
Mike Wills
http://mikewills.me



On Wed, Jun 15, 2011 at 5:48 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:
> Given the noted effect from the interactive SQL reporting, seems
> probable the field(s) have only\all character data [e.g. USEnglish]?  If
> so, then the following might suffice:
>   SELECT CAST(FldName AS VARCHAR(32000) CCSID 37) FROM PgmDsc_PF
>   /* other choices for varchar vs char and size might be preferred */