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 Offline
    F Offline
    federico strati
    wrote on last edited by
    #1

    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...

    R N N P F 7 Replies 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...

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

      If you do not know which forum to post a programming question in, just go to Questions and Answers and choose "Ask a question". It will be moved to the correct section with tags, or if required, the community will create new tags. In any case, the chances of getting a programming question answered in the lounge is bleak.

      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.

      D 1 Reply Last reply
      0
      • R Rajesh R Subramanian

        If you do not know which forum to post a programming question in, just go to Questions and Answers and choose "Ask a question". It will be moved to the correct section with tags, or if required, the community will create new tags. In any case, the chances of getting a programming question answered in the lounge is bleak.

        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.

        D Offline
        D Offline
        Dalek Dave
        wrote on last edited by
        #3

        It has been known! Though most answers may not be the ones the OP was looking for :)

        ------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]

        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...

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

          federico.strati wrote:

          how to handle in Oracle the "Packed" fields

          Soft #3 mallet.


          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

          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...

            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 Offline
                        realJSOPR Offline
                        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 Offline
                                  realJSOPR Offline
                                  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 Offline
                                          realJSOPR Offline
                                          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