Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: comp field from Oracle vb.net app

    From a vb.net/Oracle app, I am producing an output file to be sent to a vendor who is requiring the money fields to be signed comp format. How do I convert the field? Thanks for any help!
    Anita

  2. #2
    Join Date
    Jan 2004
    Posts
    492
    What exactly is comp format? Since I do not know vb.net can you explain a little more?
    Oracle OCPI (Certified Practicing Idiot)

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    The only "comp" format I remember is the old COBOL comp(utational) fields.

    This type of format has several variations, therefore you need to ask which one is required, for example:

    COMPUTATIONAL
    or COMP (binary) This is the equivalent of BINARY. The COMPUTATIONAL phrase is synonymous with BINARY.

    COMPUTATIONAL-1
    or COMP-1 (floating-point) Specified for internal floating-point items (single precision). COMP-1 items are 4 bytes long.

    COMPUTATIONAL-2
    or COMP-2 (long floating-point) Specified for internal floating-point items (double precision). COMP-2 items are 8 bytes long.

    COMPUTATIONAL-3
    or COMP-3 (internal decimal) This is the equivalent of PACKED-DECIMAL.

    COMPUTATIONAL-4
    or COMP-4 (binary) This is the equivalent of BINARY.

    COMPUTATIONAL-5
    or COMP-5 (native binary) These data items are represented in storage as binary data.

    On the other hand, you may want to tell the vendor you will be submitting the data in your own format.


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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