Re: Query output with Tab delimeted file

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi GG,

I can think of two solutions:

1. In Query/400, defined result fields TAB01 - TABnn as x'09', then sequence
them between each of the selected output fields.

2. Use CPYTOIMPF and specify FLDDLM(x'09').

hth,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: "Giri Gopal" <GiriGopal@bcginK.com>
To: <rpg400-l@midrange.com>
Sent: Monday, March 11, 2002 9:38 AM
Subject: Query output with Tab delimeted file


> Hello:
>
> I am running a query to output a file. I want to put a tab between each
> field. I created a new field, but how do I key in the tab character. Can
> some one help me please. I am able to get comma delimeted file, but we
have
> some fields which have commas as part of the data eg: xyz, inc.  I want to
> create this TAB file so users can open this file once downloaded to a pc
> with Excel.
>
>
> Thanks for your help in advance.
> GG
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com