Including <new line>

Kannan Perumal

Including <new line>
Hello List members,
One of my application team is sending files from UNIX box to the Mainframe.
They are saying they can't include a <newline> character in the file. Anyone
know what character they need to include to get the newline / line break?
Thanks for your time.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

James Campbell

Re: Including <new line>
(in response to Kannan Perumal)
FTP the file as ASCII, FTP will do the record thing.


James Campbell

On 4 Dec 2008 at 13:12, Kannan Perumal wrote:

>
> Hello List members,
> One ofmy application team is sending files from UNIX box to the Mainframe. They are saying
> they can't include a <newline>character in the file. Anyone know what character they need to
> include to get the newline / line break? Thanks for your time.
>
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Guido Verbraak

Re: Including <new line>
(in response to James Campbell)
Hi

Try James´option first. In the past however I received files that after
using FTP still had the problem you describe. There are two options to fix
the problem with these hidden characters.
The first option is to write a REXX program that fixes the problem.
The second option, the one I used, is using FTP to tranfser the files to
OMVS. Once the file is in a HFS or zFS dataset , you can submit an IDCAMS
job that copies the file from the HFS to a MVS dataset. This option worked
well and solved the problem. The nice thing about this method is that you
do not need to manipulate the original data.


Vriendelijke groet / Best regards
Guido Verbraak

IBM Software Group
Software Services for Information Management.
Location: Johan Huizingalaan 765, 1066 VH Amsterdam
Phone: +31 (0)20 513 8461
Mobile : +31 (0)6 21 11 20 24
Email: [login to unmask email]

IBM Certified Database Administrator -- DB2 Universal Database V8.1 for
zOS
IBM Certified Solution Designer -- DB2 Business Intelligence V8





Kannan Perumal <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
04-12-2008 19:12
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] Including <new line>






Hello List members,
One of my application team is sending files from UNIX box to the
Mainframe. They are saying they can't include a <newline> character in the
file. Anyone know what character they need to include to get the newline /
line break? Thanks for your time.


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
list archives, FAQ, and delivery preferences are at IDUG.ORG under the
Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more. If you have not yet signed up for
Basic Membership in IDUG, available at no cost, click on Member Services


Tenzij hierboven anders aangegeven: / Unless stated otherwise above:
IBM Nederland B.V.
Gevestigd te Amsterdam
Inschrijving Handelsregister Amsterdam Nr. 33054214

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Kannan Perumal

Re: Including <new line>
(in response to Guido Verbraak)
Thank you all for your replies, I appreciate your time. We found out other
options and okay to live with that for now. Thanks

On 12/5/08, Guido Verbraak <[login to unmask email]> wrote:
>
>
> Hi
>
> Try James´option first. In the past however I received files that after
> using FTP still had the problem you describe. There are two options to fix
> the problem with these hidden characters.
> The first option is to write a REXX program that fixes the problem.
> The second option, the one I used, is using FTP to tranfser the files to
> OMVS. Once the file is in a HFS or zFS dataset , you can submit an IDCAMS
> job that copies the file from the HFS to a MVS dataset. This option worked
> well and solved the problem. The nice thing about this method is that you do
> not need to manipulate the original data.
>
>
> Vriendelijke groet / Best regards
> Guido Verbraak
>
> IBM Software Group
> Software Services for Information Management.
> Location: Johan Huizingalaan 765, 1066 VH Amsterdam
> Phone: +31 (0)20 513 8461
> Mobile : +31 (0)6 21 11 20 24
> Email: [login to unmask email]
>
> IBM Certified Database Administrator -- DB2 Universal Database V8.1 for zOS
> IBM Certified Solution Designer -- DB2 Business Intelligence V8
>
>
>
>
> *Kannan Perumal <[login to unmask email]>*
> Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>
> 04-12-2008 19:12 Please respond to
> DB2 Database Discussion list at IDUG <[login to unmask email]>
>
> To
> [login to unmask email] cc
> Subject
> [DB2-L] Including <new line>
>
>
>
>
> Hello List members,
> One of my application team is sending files from UNIX box to the Mainframe.
> They are saying they can't include a <newline> character in the file. Anyone
> know what character they need to include to get the newline / line break?
> Thanks for your time.
>
> ------------------------------
>
> *IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA * < http://idug.org/lsNA >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
> list archives, FAQ, and delivery preferences are at *IDUG.ORG* < http://www.idug.org/lsidug > under the Listserv tab. While at the site, you can also access the IDUG
> Online Learning Center, Tech Library and Code Place, see the latest IDUG *conference
> information* < http://www.idug.org/lsconf > , and much more. *If you have not
> yet signed up for Basic Membership in IDUG, available at no cost, click on
> **Member Services* < http://www.idug.org/lsms >
>
>
> Tenzij hierboven anders aangegeven: / Unless stated otherwise above:
> IBM Nederland B.V.
> Gevestigd te Amsterdam
> Inschrijving Handelsregister Amsterdam Nr. 33054214
>
> ------------------------------
>
> *IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA * < http://idug.org/lsNA >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L
> list archives, FAQ, and delivery preferences are at *IDUG.ORG < http://www.idug.org/lsidug >
> * under the Listserv tab. While at the site, you can also access the IDUG
> Online Learning Center, Tech Library and Code Place, see the latest IDUG *conference
> information < http://www.idug.org/lsconf > *, and much more. *If you have not
> yet signed up for Basic Membership in IDUG, available at no cost, click on Member
> Services < http://www.idug.org/lsms > *
>
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms