How to solve DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502

2015-08-28 18:12:19.047-Fri Aug 28 18:12:19 IST 2015DB2 Connection established -->com.ibm.db2.jcc.t4.b@c26e4a
2015-08-28 18:12:20.030-Execution failed ======> alter table BLP.COUNTER_EXTRACTION_REQUEST alter column SCHEME_ID set not null
2015-08-28 18:12:20.032-Error code for failure ======> DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=SCHEME_ID, DRIVER=3.63.123
2015-08-28 18:12:20.044-Execution failed ======> alter table BLP.COUNTER_EXTRACTION_REQUEST alter column SCHEME_TYPE set not null
2015-08-28 18:12:20.044-Error code for failure ======> DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=SCHEME_TYPE, DRIVER=3.63.123

Related Posts:

  1. getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
  2. Can’t find mysqladmin on Mac OSX 10.6.8
  3. Why do I get SQLCODE=-204, SQLSTATE=42704 with DB2 LUW and WebSphere App Server?
  4. Problem with gif with transparent background
  5. Search for words with telephone numbers from 2-3-4 tree
  6. Java 8 Iterable.forEach() vs foreach loop
  7. How to round a number to n decimal places in Java
  8. Java string to date conversion
  9. Creating a “logical exclusive or” operator in Java
  10. Cannot make a static reference to the non-static method fxn(int) from the type Two [duplicate]
  11. How can I use pointers in Java?
  12. JavaFX – Exception in Application start method?
  13. Is there a stopwatch in Java?
  14. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  15. What is IllegalStateException?
  16. Long vs Integer, long vs int, what to use and when?
  17. Java Using Nodes with LinkedList
  18. When is the @JsonProperty property used and what is it used for?
  19. Why is there no SortedList in Java?
  20. How to convert any Object to String?
  21. How do I copy an object in Java?
  22. Unfortunately MyApp has stopped. How can I solve this?
  23. What is the significance of load factor in HashMap?
  24. Which HTML Parser is the best?
  25. No String-argument constructor/factory method to deserialize from String value (”)
  26. Where can i get BigClip? [closed]
  27. What is the /= operator in Java?
  28. How to override compareTo (Java)
  29. Why do I get an UnsupportedOperationException when trying to remove an element from a List?
  30. java.util.NoSuchElementException: No line found
  31. How to check whether a int is not null or empty?
  32. How to parse JSON in Java
  33. Declaring an unsigned int in Java
  34. Converting Hexadecimal String to Decimal Integer
  35. LocalDate to java.util.Date and vice versa simplest conversion?
  36. package does not exist error!
  37. Required: Variable Found: Value
  38. What does the colon (:) operator do?
  39. Shifting array to the right – homework
  40. How to get rid of Checkstyle message ‘File does not end with a newline.’
  41. Uri not Absolute exception getting while calling Restful Webservice
  42. Very Basic Java
  43. SQLRecoverableException: I/O Exception: Connection reset
  44. What exactly is a Maven Snapshot and why do we need it?
  45. How to check if my string is equal to null?
  46. what is Ljava.lang.String;@
  47. “Could not find Java SE Runtime Environment.” after installing Java
  48. How can I create an utility class?
  49. How can I edit a .jar file?
  50. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  51. JAVA_HOME should point to a JDK not a JRE
  52. This Activity already has an action bar supplied by the window decor?
  53. Convert hex string to int
  54. Orphaned Case Error in Java
  55. Proxy Error 502 : The proxy server received an invalid response from an upstream server
  56. Java double.MAX_VALUE?
  57. how to do a system pause in java for debugging?
  58. Immutable class?
  59. Is spring default scope singleton or not?
  60. Java Reflection – Object is not an instance of declaring class
  61. What does “AL lib: alc_cleanup: 1 device not closed” mean?
  62. How to make a countdown timer in Java
  63. (Java) Tic-Tac-Toe game using 2 dimensional Array
  64. Incompatible types List of List and ArrayList of ArrayList
  65. Dice Rolling java program
  66. int cannot be converted to int []
  67. Joda DateTime to Timestamp conversion
  68. break statement in “if else” – java
  69. What is the difference between JSF, Servlet and JSP?
  70. Get only part of an Array in Java?
  71. How to Get JSON Array Within JSON Object?
  72. What is a class constant?
  73. How to represent a fix number of repeats in regular expression?
  74. How to import a jar in Eclipse
  75. How to use a Do-while loop that continuously prompts a user?
  76. Java equivalent of unsigned long long?
  77. Getting “unixtime” in Java
  78. How do I break out of nested loops in Java?
  79. How do I convert this for loop into a while loop?
  80. Java switch statement: Constant expression required, but it IS constant
  81. Resolving File paths – ‘File not found’ error in Eclipse
  82. Simple Coin Toss using random class in Java. The do while loop doesn’t seem to generate random results
  83. Why I am getting DefaultHttpClient is deprecated?
  84. When should you use multithreading? And would multi threading be beneficial if the different threads execute mutually independent tasks?
  85. How to Convert Int to Unsigned Byte and Back
  86. Suggestions needed: Effective Java to C source code converter
  87. Downloading a file from spring controllers
  88. Preventing a Java class from being instantiated and inherited
  89. Collision Detection between two images in Java
  90. What does .pack() do?
  91. String is immutable. What exactly is the meaning?
  92. How do I autoindent in Netbeans?
  93. What is an attribute in Java?
  94. MessageBodyWriter not found for media type=application/json
  95. Conversion from Long to Double in Java
  96. Failed to find Java VM
  97. Java regex email
  98. Java Iterator on Doubly-linked-list
  99. Why “no projects found to import”?
  100. Java Swing setting JPanel Size

Leave a Comment