Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Anyone expert in AS400 - DB2 ?

Anyone expert in AS400 - DB2 ?

Scheduled Pinned Locked Moved The Lounge
questionoracletutorial
20 Posts 9 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • F federico strati

    Just as there is no appropriate forum to this... is anyone expert in AS400 - DB2? If so, my question would be the following: what are and how to handle in Oracle the "Packed" fields of DB2/400 ? Thanks in advance for not crying out loudly that this is not the correct forum...

    N Offline
    N Offline
    NormDroid
    wrote on last edited by
    #5

    I tried a popular serach engine, but hey that's just me.

    Software Kinetics - Moving Software

    1 Reply Last reply
    0
    • F federico strati

      Just as there is no appropriate forum to this... is anyone expert in AS400 - DB2? If so, my question would be the following: what are and how to handle in Oracle the "Packed" fields of DB2/400 ? Thanks in advance for not crying out loudly that this is not the correct forum...

      P Offline
      P Offline
      Pete OHanlon
      wrote on last edited by
      #6

      If only somebody could invent a technology where somebody could search for the text from servers and websites all around the world. Perhaps the content could be indexed somehow. Oh, if only somebody would invent this. I, for one, could find a use for it.

      I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

      Forgive your enemies - it messes with their heads

      My blog | My articles | MoXAML PowerToys | Onyx

      N realJSOPR L 3 Replies Last reply
      0
      • P Pete OHanlon

        If only somebody could invent a technology where somebody could search for the text from servers and websites all around the world. Perhaps the content could be indexed somehow. Oh, if only somebody would invent this. I, for one, could find a use for it.

        I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

        Forgive your enemies - it messes with their heads

        My blog | My articles | MoXAML PowerToys | Onyx

        N Offline
        N Offline
        NormDroid
        wrote on last edited by
        #7

        Now that's just silly :)

        Software Kinetics - Moving Software

        1 Reply Last reply
        0
        • F federico strati

          Just as there is no appropriate forum to this... is anyone expert in AS400 - DB2? If so, my question would be the following: what are and how to handle in Oracle the "Packed" fields of DB2/400 ? Thanks in advance for not crying out loudly that this is not the correct forum...

          F Offline
          F Offline
          federico strati
          wrote on last edited by
          #8

          Ok ok, as if I said nothing, silly to me thinking anyone skilled on AS400 hanging around here

          N 1 Reply Last reply
          0
          • F federico strati

            Ok ok, as if I said nothing, silly to me thinking anyone skilled on AS400 hanging around here

            N Offline
            N Offline
            Nagy Vilmos
            wrote on last edited by
            #9

            federico.strati wrote:

            silly to me thinking anyone cares about AS400 hanging around here

            ftfy


            Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre

            F 1 Reply Last reply
            0
            • N Nagy Vilmos

              federico.strati wrote:

              silly to me thinking anyone cares about AS400 hanging around here

              ftfy


              Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre

              F Offline
              F Offline
              federico strati
              wrote on last edited by
              #10

              a bit rude and whatever, whenever...

              1 Reply Last reply
              0
              • P Pete OHanlon

                If only somebody could invent a technology where somebody could search for the text from servers and websites all around the world. Perhaps the content could be indexed somehow. Oh, if only somebody would invent this. I, for one, could find a use for it.

                I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

                Forgive your enemies - it messes with their heads

                My blog | My articles | MoXAML PowerToys | Onyx

                realJSOPR Online
                realJSOPR Online
                realJSOP
                wrote on last edited by
                #11

                Al Gore invented it - it's called "google". Al wanted it to be called "Goregle", but thatnkfully, that name was unanimously rejected by other interested parties.

                .45 ACP - because shooting twice is just silly
                -----
                "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                -----
                "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

                P 1 Reply Last reply
                0
                • realJSOPR realJSOP

                  Al Gore invented it - it's called "google". Al wanted it to be called "Goregle", but thatnkfully, that name was unanimously rejected by other interested parties.

                  .45 ACP - because shooting twice is just silly
                  -----
                  "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                  -----
                  "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

                  P Offline
                  P Offline
                  Pete OHanlon
                  wrote on last edited by
                  #12

                  John Simmons / outlaw programmer wrote:

                  Al Gore invented it

                  Dagnabit. I thought I'd come up with something revolutionary. Wait a second. Didn't Al Gore also invent the internet, the internal combustion engine, the concept of the number zero, nullity and a method for travelling faster than light? Oh, and from the PMRC, didn't Tipper involuntarily admit to being into a bit of bondage?

                  I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

                  Forgive your enemies - it messes with their heads

                  My blog | My articles | MoXAML PowerToys | Onyx

                  realJSOPR 1 Reply Last reply
                  0
                  • P Pete OHanlon

                    If only somebody could invent a technology where somebody could search for the text from servers and websites all around the world. Perhaps the content could be indexed somehow. Oh, if only somebody would invent this. I, for one, could find a use for it.

                    I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

                    Forgive your enemies - it messes with their heads

                    My blog | My articles | MoXAML PowerToys | Onyx

                    L Offline
                    L Offline
                    Lost User
                    wrote on last edited by
                    #13

                    But if this happened then it would only be a matter of time before this company abused their posistion[^], despite there mantra stating the opposite.

                    The Whiteboard - Surely the most remarkable invention ever?

                    P 1 Reply Last reply
                    0
                    • L Lost User

                      But if this happened then it would only be a matter of time before this company abused their posistion[^], despite there mantra stating the opposite.

                      The Whiteboard - Surely the most remarkable invention ever?

                      P Offline
                      P Offline
                      Pete OHanlon
                      wrote on last edited by
                      #14

                      I just knew there had to be a down side.

                      I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

                      Forgive your enemies - it messes with their heads

                      My blog | My articles | MoXAML PowerToys | Onyx

                      1 Reply Last reply
                      0
                      • F federico strati

                        Just as there is no appropriate forum to this... is anyone expert in AS400 - DB2? If so, my question would be the following: what are and how to handle in Oracle the "Packed" fields of DB2/400 ? Thanks in advance for not crying out loudly that this is not the correct forum...

                        L Offline
                        L Offline
                        Lost User
                        wrote on last edited by
                        #15

                        well, from memory the packed fields on the AS/400 use a single hex digit as a decimal integer... So the number 1,234,567,890 is stored in 5 bytes as 0x12 34 56 67 90 How to handle them in Oracle? i think if you access them using SQL it will 'expand' the comp-3 field on select so you should have no issue... Cheers

                        ___________________________________________ .\\axxx (That's an 'M')

                        1 Reply Last reply
                        0
                        • P Pete OHanlon

                          John Simmons / outlaw programmer wrote:

                          Al Gore invented it

                          Dagnabit. I thought I'd come up with something revolutionary. Wait a second. Didn't Al Gore also invent the internet, the internal combustion engine, the concept of the number zero, nullity and a method for travelling faster than light? Oh, and from the PMRC, didn't Tipper involuntarily admit to being into a bit of bondage?

                          I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

                          Forgive your enemies - it messes with their heads

                          My blog | My articles | MoXAML PowerToys | Onyx

                          realJSOPR Online
                          realJSOPR Online
                          realJSOP
                          wrote on last edited by
                          #16

                          Pete O'Hanlon wrote:

                          didn't Tipper involuntarily admit to being into a bit of bondage?

                          Why, yes - yes she is, although she did tell me that she felt the ball gag was a little over the top (at least, that's what I *think* she said), and that the handcuffs were a little too tight the last time we met.

                          .45 ACP - because shooting twice is just silly
                          -----
                          "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                          -----
                          "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

                          R 1 Reply Last reply
                          0
                          • F federico strati

                            Just as there is no appropriate forum to this... is anyone expert in AS400 - DB2? If so, my question would be the following: what are and how to handle in Oracle the "Packed" fields of DB2/400 ? Thanks in advance for not crying out loudly that this is not the correct forum...

                            S Offline
                            S Offline
                            Slacker007
                            wrote on last edited by
                            #17

                            federico.strati wrote:

                            Thanks in advance for not crying out loudly that this is not the correct forum...

                            Don't know why people are 1 voting your question. Maybe because it is in the wrong forum. You know better than this. :-D

                            1 Reply Last reply
                            0
                            • realJSOPR realJSOP

                              Pete O'Hanlon wrote:

                              didn't Tipper involuntarily admit to being into a bit of bondage?

                              Why, yes - yes she is, although she did tell me that she felt the ball gag was a little over the top (at least, that's what I *think* she said), and that the handcuffs were a little too tight the last time we met.

                              .45 ACP - because shooting twice is just silly
                              -----
                              "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                              -----
                              "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

                              R Offline
                              R Offline
                              Rajesh R Subramanian
                              wrote on last edited by
                              #18

                              No complaints about the dog collar and latex mask?!

                              It was ever thus, the Neophiles will always rush out and get 'The Latest Thing' at a high price and with all the inherent faults - Dalek Dave.

                              P realJSOPR 2 Replies Last reply
                              0
                              • R Rajesh R Subramanian

                                No complaints about the dog collar and latex mask?!

                                It was ever thus, the Neophiles will always rush out and get 'The Latest Thing' at a high price and with all the inherent faults - Dalek Dave.

                                P Offline
                                P Offline
                                Pete OHanlon
                                wrote on last edited by
                                #19

                                Is that a question or statement? Your punctuation at the end is ambiguous on this.

                                I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

                                Forgive your enemies - it messes with their heads

                                My blog | My articles | MoXAML PowerToys | Onyx

                                1 Reply Last reply
                                0
                                • R Rajesh R Subramanian

                                  No complaints about the dog collar and latex mask?!

                                  It was ever thus, the Neophiles will always rush out and get 'The Latest Thing' at a high price and with all the inherent faults - Dalek Dave.

                                  realJSOPR Online
                                  realJSOPR Online
                                  realJSOP
                                  wrote on last edited by
                                  #20

                                  Rajesh R Subramanian wrote:

                                  No complaints about the dog collar and latex mask?!

                                  Dog collar - It's bondage, not discipline... Latex mask - she's alergic, so *I* can't even wear one...

                                  .45 ACP - because shooting twice is just silly
                                  -----
                                  "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                                  -----
                                  "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

                                  1 Reply Last reply
                                  0
                                  Reply
                                  • Reply as topic
                                  Log in to reply
                                  • Oldest to Newest
                                  • Newest to Oldest
                                  • Most Votes


                                  • Login

                                  • Don't have an account? Register

                                  • Login or register to search.
                                  • First post
                                    Last post
                                  0
                                  • Categories
                                  • Recent
                                  • Tags
                                  • Popular
                                  • World
                                  • Users
                                  • Groups