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

    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