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