Re: csv

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

CPYTOSTMF also has CCSID parameters, as I recall.

At the same time, I've sometimes found it useful to pre-create the 
stream file with the CCSID I want.

HTH
Vern

On 2/23/2013 12:42 AM, Peter Connell wrote:
> Cmd line functions often create stream files that default to CCSID 37 which is rendered unreadable via Notepad which likes a Windows CSSID like 1252 or 819.
> Try explicitly create the *STMF as 1252
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Billy Waters
> Sent: Saturday, 23 February 2013 7:22 p.m.
> To: 'MIDRANGE-L@xxxxxxxxxxxx'
> Subject: csv
>
> Our timekeeping package creates a coma delimited file . I need to export this to SQL server. I have tried CPYTOSTMF with no success.  File is copied, only see garbage when opening with note pad.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
>
> #####################################################################################
>
> This correspondence is for the named person's use only. It may contain confidential
> or legally privileged information, or both. No confidentiality or privilege is waived
> or lost by any mistransmission. If you receive this correspondence in error, please
> immediately delete it from your system and notify the sender. You must not disclose,
> copy or rely on any part of this correspondence if you are not the intended recipient.
> Any views expressed in this message are those of the individual sender, except where
> the sender expressly, and with authority, states them to be the views of Veda.
> If you need assistance, please contact Veda on either :-
> Australia 1300-762-207 or New Zealand +64 9 367 6200