DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
chaks



Group memberships:
Premium Members

Joined: 22 Nov 2006
Posts: 39
Location: MA
Points: 389

Post Posted: Wed Oct 18, 2017 10:04 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I am trying to FTP a EBCDIC file to Mainfram system and the file looks good when viewed from EBCDIC file viewer but when I FTP the file , the fixed length is distorted
Code:

00501 100   RECPT/WAIT OFFICE SUPP  010221 0000                         
 00501 100A  COPY       OFFICE SUPP  010221 0000                       
  00501 100B  CONF       CONFERENCE   010221 0000                       
   00501 101   POFT       OFFICE       010221 0000                     
    00501 102   POFT       OFFICE       010221 0000                     
     00501 103   POFT       OFFICE       010221 0000                   
      00501 104   CLASSROOM  CLASSROOM    010221 0000                   
       00501 105   CLASSROOM  CLASSROOM    010221 0000                 
        01401 S052  GOSR       OFFICE SUPP  052101 0000                 
         01401 S054  POFT       OFFICE       052101 0000               
          01401 S060  CONF       CONFERENCE   052101 0000               
           01401 S074  POFT       OFFICE       052101 0000             
            01401 S075  POFT       OFFICE       052101 0000             
             01401 S076  POFT       OFFICE       052101 0000           
              01401 S077  POFT       OFFICE       052101 0000           
               01401 S078  POFT       OFFICE       052101 0000         
                01401 S079  POFT       OFFICE       052101 0000         
                 01401 S081  POFT       OFFICE       052101 0000       
                  01401 S082  POFT       OFFICE       052101 0000       
                   01401 S083  POFT       OFFICE       052101 0000     
                    01401 S211  OOFT       OFFICE       053901 0000     
                     01401 S250  POFT       OFFICE       053901 0000   
                      01401 S251  POFT       OFFICE       053901 0000   
                       01401 S252  POFT       OFFICE       053901 0000 
                        01401 S253  POFT       OFFICE       053901 0000


Job design is to Read from Sequential file as a single record of fixed length 80 to FTP enterprise stage , using Binary mode transfer and Byte_order as big-endian

If you have any idea or came across this issue before , can you please guide me
FranklinE



Group memberships:
Premium Members

Joined: 25 Nov 2008
Posts: 621
Location: Malvern, PA
Points: 5878

Post Posted: Wed Oct 18, 2017 10:26 am Reply with quote    Back to top    

Most likely cause is extra control characters (CR or LF) at the end of the 80-byte record. View the mainframe file in hexadecimal mode, and if they are there you'll see them.

Another possible but less likely cause is that the file is cataloged with an lrecl of less than 80 bytes. If you don't know how to view the catalog entry for this file, you'll need one of your mainframe colleagues to help.

_________________
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: http://www.dsxchange.com/viewtopic.php?t=143596
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours