Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: KLVIS11
- Order by date
-
db2xml.update
Hello Hase, I think this documentation of the SQLCODE should give you a hint: -407 AN UPDATE, INSERT, OR SET VALUE IS NULL, BUT THE OBJECT COLUMN column-name CANNOT CONTAIN NULL VALUES... -
Debugging stored procedures on mainframe
One tool for debugging DB2 stored procedures on the mainframe is XPEDITER which is a product of COMPUWARE. Stephan -
Initcap function
Sorry, but T.Blom's answer will not work: the result of his function probably will be: "George burns" which is not wished. Stephan -
All I want is 1 record and FAST (an existence check)
Hi gnealsr, another way to get more and fast information is: SELECT count(*) FROM table WHERE column1 = value AND column2 = value Then you'll get the number of rows that will be result of your select conditions anyway. If there is no row found the result will be 0. :-) Stephan
