Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    12

    Unanswered: Output a Packed Decimal to a text file

    I have an stored procedure/DTS package that creates an output file that I FTP to a mainframe.

    The vendor that is receiving the file expects negative amounts to be in a packed decimal format.

    IE. Negative 95.46 = 0000954O

    I've done a bit of searching to find a function for this, but I must be using the wrong words.

    Any suggestions?
    Howard Nugent
    Sr. Business Application Analyst

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I've actually have had my fill with 3rd party vendors....

    SCRUBS ALL...

    I'm in the wrong business...

    OK, to do what you're asking (And I have NO idea if the ASCII EBCIDIC Conversion will screw it up) you need to pack it your self, and find the cooresponding values and use ASCII...

    Better off telling them to handle display numerics...

    This going to DB2 OS/390?

    If so, all they need is a load card with DECIMAL EXTERNAL clause...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •