Anyone expert in AS400 - DB2 ?
-
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...
Ok ok, as if I said nothing, silly to me thinking anyone skilled on AS400 hanging around here
-
Ok ok, as if I said nothing, silly to me thinking anyone skilled on AS400 hanging around here
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
-
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
a bit rude and whatever, whenever...
-
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
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 -
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, 2001John 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
-
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
-
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
-
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...
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')
-
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
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 -
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...
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
-
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, 2001No 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.
-
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.
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
-
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.
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
