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