Did you ever need a description of a sqlcode in a programming language like Java? Did you ever wanted to know if an sqlcode is an error or a warning?
You can use SYSPROC.SQLERRM function for that:
VALUES(SYSPROC.SQLERRM('SQL0911N', '', '', 'en_US', 0))
There is a sqlcode: in the description and id this is negative then you have an error, otherwise a warning. I consider sqlcodes that don't have sqlcode: in the description as not important. :)
sobota, 29. september 2007
nedelja, 23. september 2007
sobota, 15. september 2007
Newline
Yesterday one of my coworkers said something that I'm laughing even today over it.
He was trying to open a CSV file with Excel, but he got some strange results. Then he noticed that a description column had newline characters in, so Excel made more lines as it should.
So he said: "Why don't they put newline in one line." :)))
He was trying to open a CSV file with Excel, but he got some strange results. Then he noticed that a description column had newline characters in, so Excel made more lines as it should.
So he said: "Why don't they put newline in one line." :)))
nedelja, 2. september 2007
Easter Egg in Google Earth
Naročite se na:
Objave (Atom)