Re: join not joining more then 9 lines

From: Andrew Townsend (Andrew.Townsend_at_BISYS.COM)
Date: 10/26/04

  • Next message: Bill Verzal: "FTP a file with text and comp-3 data in it from AIX to MVS (or the other way)" 
    Date:         Tue, 26 Oct 2004 10:46:12 -0400
To: aix-l@Princeton.EDU

    I try to join 2 files but join will only join the first 9 lines. The two
    files I am trying to join are:

    # cat tot-data-BU.041025
         1 Backedup
         2 0.647
         3 0.756
         4 1.576
         5 2.191
         6 2.560
         7 3.300
         8 3.770
         9 4.629
        10 5.024
        11 5.887
        12 6.783
        13 7.386
        14 7.953
        15 8.533

    and

    #cat tot-data-RES.041025
         1 Restored
         2 0.0
         3 0.0
         4 0.0
         5 0.0051
         6 0.0051
         7 0.0051
         8 0.0051
         9 0.0101
        10 0.0101
        11 0.0101
        12 0.0101
        13 0.0101
        14 0.0101
        15 0.0101

    when I do a join tot-data-BU.041025 tot-data-RES.041025
    I get:

    1 Backedup Restored
    2 0.647 0.0
    3 0.756 0.0
    4 1.576 0.0
    5 2.191 0.0051
    6 2.560 0.0051
    7 3.300 0.0051
    8 3.770 0.0051
    9 4.629 0.0101

    Only 9 lines! Is this a limitation of join, or is it something with my
    output?
    The join I am using is:
    #which_fileset join
    /usr/bin/join bos.rte.edit 5.1.0.0

                          cbaker@GOODYEAR.C
                          OM To: aix-l@Princeton.EDU
                          Sent by: IBM AIX cc:
                          Discussion List Subject: Re: join not joining more then 9 lines
                          <aix-l@Princeton.
                          EDU>

                          10/26/2004 09:53
                          AM
                          Please respond to
                          IBM AIX
                          Discussion List

    Where is the "file contents"?

    Christopher M. Baker
    Senior Technical Support Analyst
    DSE/TCO
    Goodyear Tire and Rubber Company

    =================================================
    Contains Confidential and/or Proprietary Information.
    May not be copied or disseminated without the expressed
    written consent of The Goodyear Tire & Rubber Company.
    =================================================

                 Andrew Townsend
                 <Andrew.Townsend@BISYS.COM>
                 Sent by: IBM AIX Discussion List
    To
                 <aix-l@Princeton.EDU>
    aix-l@Princeton.EDU
    cc

                 10/26/04 09:05 AM
    Subject
                                                                   join not
    joining more then 9 lines

                             Please respond to
                          IBM AIX Discussion List
                           <aix-l@Princeton.EDU>

    Good Morning All,

    I am writing a script that is using the join command. when I try to join
    two files with the following contents, I can't seem to get more then 9
    lines of output. Am I doing something wrong?

    Thank you all in advance,

    Drew

    This email is confidential and intended solely for the use of the
    individual or entity to whom it is addressed. If you have received this
    email in error please notify the system manager at mailadmin@bisys.com and
    delete the email immediately.

    This email is confidential and intended solely for the use of the
    individual or entity to whom it is addressed. If you have received this
    email in error please notify the system manager at mailadmin@bisys.com and
    delete the email immediately.

  • Next message: Bill Verzal: "FTP a file with text and comp-3 data in it from AIX to MVS (or the other way)"

    Relevant Pages