59806--------Valid Tyoecatind of Project
268337-------Invalid Typecatind of Project under same family


Tigris

select * from tigris.category where typecatind in (268337)
---------------------------------------------------------------------------------
					PRODRAFT SCHEMA

2)SELECT COUNT(*) FROM PRODRAFT.TYPECATEGORY WHERE TYPECATIND IN (59806,268337)500

3)SELECT COUNT(*) FROM PRODRAFT.TYPECATEGORY WHERE TYPECATIND IN (268337)2-3
---------------------------------------------------------------------------------------------------------------
4)SELECT TYPECATIND, DESCRIPTION, PARENTCATIND, VALID FROM PRODRAFT.TYPECATEGORY WHERE TYPECATIND IN(268337) AND PARENTCATIND IN ( SELECT PARENTCATIND FROM PRODRAFT.TYPECATEGORY WHERE TYPECATIND=59806)
---if you get relut in query no 4 then execute qury number 5

Prodraft
if records from above query, execute delete

5)delete FROM PRODRAFT.TYPECATEGORY WHERE TYPECATIND IN (268337) AND PARENTCATIND IN ( SELECT PARENTCATIND FROM PRODRAFT.TYPECATEGORY WHERE TYPECATIND=59806)
-------------------------------------------------------------------------------------------------------------------
else

6)select * from PRODRAFT.TYPECATEGORY WHERE TYPECATIND IN (268337)
7)UPDATE PRODRAFT.TYPECATEGORY SET TYPECATIND=59806 WHERE TYPECATIND IN (268337)


8)SELECT * FROM PRODRAFT.TYPECATCHILD WHERE TYPECATIND IN (268337) AND PARENTCATIND IN (SELECT PARENTCATIND FROM PRODRAFT.TYPECATCHILD WHERE TYPECATIND=59806)

9)delete FROM PRODRAFT.TYPECATCHILD WHERE TYPECATIND IN (268337) AND PARENTCATIND IN (SELECT PARENTCATIND FROM PRODRAFT.TYPECATCHILD WHERE TYPECATIND=59806)

10)select * from PRODRAFT.TYPECATCHILD WHERE TYPECATIND IN (268337)
UPDATE PRODRAFT.TYPECATCHILD SET TYPECATIND=59806 WHERE TYPECATIND IN (268337)

11)select * from PRODRAFT.CATEGORY WHERE TYPECATIND IN (268337)
UPDATE PRODRAFT.CATEGORY SET TYPECATIND=59806 WHERE TYPECATIND IN (268337)


=======================================================================================================================
						PRODUCT SCHEMA

1)SELECT COUNT(*) FROM PRODUCT.TYPECATEGORY WHERE TYPECATIND IN (59806,268337)


2)SELECT COUNT(*) FROM PRODUCT.TYPECATEGORY WHERE TYPECATIND IN (268337)
------------------------------------------------------------------------------------------------------------
3)SELECT TYPECATIND, DESCRIPTION, PARENTCATIND, VALID FROM PRODUCT.TYPECATEGORY WHERE TYPECATIND IN(268337) AND PARENTCATIND IN ( SELECT PARENTCATIND FROM PRODUCT.TYPECATEGORY WHERE TYPECATIND=59806)

Product
if records from above query, execute delete

4)delete FROM PRODUCT.TYPECATEGORY WHERE TYPECATIND IN (268337) AND PARENTCATIND IN ( SELECT PARENTCATIND FROM PRODUCT.TYPECATEGORY WHERE TYPECATIND=59806)
------------------------------------------------------------------------------------------------------------------
else

5)select * from PRODUCT.TYPECATEGORY WHERE TYPECATIND IN (268337)
6)UPDATE PRODUCT.TYPECATEGORY SET TYPECATIND=59806 WHERE TYPECATIND IN (268337)


7)SELECT * FROM PRODUCT.TYPECATCHILD WHERE TYPECATIND IN (268337) AND PARENTCATIND IN (SELECT PARENTCATIND FROM PRODUCT. TYPECATCHILD WHERE TYPECATIND=59806)

8)delete FROM PRODUCT.TYPECATCHILD WHERE TYPECATIND IN (268337) AND PARENTCATIND IN (SELECT PARENTCATIND FROM PRODUCT. TYPECATCHILD WHERE TYPECATIND=59806)

9)select * from PRODUCT.TYPECATCHILD WHERE TYPECATIND IN (268337)
UPDATE PRODUCT.TYPECATCHILD SET TYPECATIND=59806 WHERE TYPECATIND IN (268337)

10)select * from PRODUCT.CATEGORY WHERE TYPECATIND IN (268337)
UPDATE PRODUCT.CATEGORY SET TYPECATIND=59806 WHERE TYPECATIND IN (268337)










-------------------------------------------------------------------------------------------------------
Special Error:---------for typecatchild-----------query



DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0803N  One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because the
primary key, unique constraint or unique index identified by "1" constrains
table "PRODRAFT.TYPECATchild" from having duplicate rows for those columns.
SQLSTATE=23505