Sorted being truncated while SMTP



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Sorted being truncated while SMTP

Postby jsudha » Sat Jan 26, 2008 1:11 am

Hi,

We had a requirement to change an e-mail notification being sent to indiviual email ids to a Group id.
This change has caused an issue of the last byte in the file being truncated.

We had used a sort to format the email file(80 bytes).We had data formatted till 49 bytes, the remaining 31 bytes was not formated. So sort output file had low-values for it. So when we changed this "Email Recepient ID" the 49th byte was getting truncated in the email we received. This was not happening if we do an SMTP of the same file to an Individual id.

This was so wierd!

When we moved a space after the 49th byte the data was not trucated in the email. Please see below the file being emailed and the output email data:

08021                       18039           22346 ,,,,,,,,,,,,,,,,,,,,,
FFFFF44444444444444444444444FFFFF44444444444FFFFF40000000000000000000000
080210000000000000000000000018039000000000002234600000000000000000000000
-----------------------------------------------------------------------,
08022                       20480           24944,,,,,,,,,,,,,,,,,,,,,,,
FFFFF44444444444444444444444FFFFF44444444444FFFFF00000000000000000000000
080220000000000000000000000020480000000000002494400000000000000000000000
-----------------------------------------------------------------------,
08023                       22179           27773,,,,,,,,,,,,,,,,,,,,,,,
FFFFF44444444444444444444444FFFFF44444444444FFFFF00000000000000000000000
080230000000000000000000000022179000000000002777300000000000000000000000
o/p email –

DATE                   LINE ITEM CNT   ITEM QUANTITY
---------------------- --------------- -------------
08021                       18039           22346
08022                       20480           2494
08023                       22179           2777

Though the issue is solved I am not able to find a reason for this cause. please could let me know on why this can happen?

Sudha
jsudha
 
Posts: 2
Joined: Sat Jan 26, 2008 12:42 am
Has thanked: 0 time
Been thanked: 0 time

Re: Sorted being truncated while SMTP

Postby Frank Yaeger » Sat Jan 26, 2008 2:59 am

I don't think this has anything to do with what SORT is doing. I'm guessing it's some quirk of the mail client having to do with binary zeros. You might have better luck getting an answer to this in a different Forum.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Sorted being truncated while SMTP

Postby jsudha » Sat Jan 26, 2008 3:14 am

Thanks Frank!
jsudha
 
Posts: 2
Joined: Sat Jan 26, 2008 12:42 am
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post