MVSFORUMS.com

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Hi,

Could any one pls. give me more clarification on Check pending status. I know one reason when the col. is defined with check contraint and the data in that column does not satisfy the check condition that data will go into check pending status. Also this will occur while loading. Pls. let me know in more detail when this will occur in day to day life and how to resolve it.

2. What is meant by INDEX CARDINALITY?

Regards
Nadh

bauer · Posted: Tue Jul 11, 2006 5:41 am Post subject:

nadh,

run check utility !

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Hi,

Could you pls. give more info.

Regards
nadh

kolusu · Posted: Wed Jul 12, 2006 4:25 am Post subject:

nadh,

Search for check pending in this manual

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH13/CCONTENTS?DT=20020826194002

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

ThanK you Kolusu..

Could you pls. suggest any link which explains INDEX CARDINALITY. I searched in net but not finding good link.

Thanks in advance

cheers!!
Nadh

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Kolusu,

I have one more doubt..In the link you provided its written as after running check utility it will write the error records to exception table. My question is whether we have to create the exception table or utility will create it..How to find the exception table.

Cheers!!!
nadh

kolusu · Posted: Wed Jul 12, 2006 9:13 am Post subject:

coolman · Posted: Thu Jul 13, 2006 3:19 pm Post subject:

Index Cardinality - No of unique values in a column
________
Chrysler Patriot history