Post reply

Packed

  • November 13, 2007 at 8:48 am

    #119389

    Hi!

    How can I check that in a column there are only data packed?

    Thank you!

  • November 13, 2007 at 8:53 am

    #750731

    What does "data packed" mean?

  • November 13, 2007 at 9:04 am

    #750736

    Are you looking for some way to identify packed data? Mainframe data stored as hex with a subsequent sign of some kind?

    You might need to read some of these threads (don't know much more than the name).

    http://www.systeminetwork.com/isnetforums/showthread.php?t=49104

    http://www.itjungle.com/fhg/fhg011905-story02.html

    Hope they help....

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • November 13, 2007 at 9:16 am

    #750741

    I mean a data type compressed with the sign (+/-)

    In particular, I have a table (T1) in which there is a column (t) defined as text.

    The output of this query

    select CAST (SUBSTRING(t, 655, 2) AS BINARY(2)) from T1

    is, for example, 0X000F (a packed data)

    I'd like to verify quickly if the substring in a binary format is a packed data.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply