Record Room modification and Court Room Related Queries

Modify Record Room feature has been depricated now in confonet version later 4.0.

You can use 'Dealing Assistant--->Case Details to modify complainant/respondent related details while if you want to modify court room related details, please use..."Court Room--->Court Room Modification'


Now EA case problem...

              EA case is always filed against a CC disposed case. So select any disposed case and then it will take complainant/Respondent name from that case and then file the case. Later you can modify or add more complainant/respondent through Dealing Assistant.

For any query: Kindly send a mail to confonet-info@nic.in with screen shot and call at 01124305336

Script execution error (At Davangere,karnataka)

If you are not able to run the script using db2 -t -f script.txt then you can run by other way...

Just open script.txt file and copy first SQL Command without semi-column and run as given below...

First go to db2 mode by typeing  db2 and enter...

db2==>

Now if you are getting prompt like given above then paste that SQL command here...
---------------------------------------------------------------------------------------
Example::

db2==> update casefiling set exportflag='N'

(Now you have to run each command one by one...)

If you still have problem then mail to confonet-info@nic.in

Interview Questions: IBM, Nucleous Software for JAVA

Please go for latest interview question in java:::: http://knowledgeserve.blogspot.com

Update case Sequence Number Problem

Update case Sequence Number

If suppose you are getting Case Number like CC/1/2011    or  CC/11/1 and you want to start sequence number from 21, means you want to file a case CC/21/2011(New case Format)  or CC/11/21 (old case format)...

Then Go to Administrator--->Update Case Sequence Number and then choose Consumer Case(CC) and then enter sequence number 20(a integer value not whole case number like CC...) and then submit.

Now the Case will be generated from CC/21/2011.......when you click 'Filing-->Scrutiny & Case Filing'

******Always go for manual from link no 6  http://confonet.nic.in/tsp/tspmanuals.htm

Constraints information in the database catalog in DB2

Table 1. Constraints information in the database catalog

Catalog view	View column	Description	Query example
SYSCAT.CHECKS		Contains a row for each table check constraint	db2 select constname, tabname, text from syscat.checks
SYSCAT.COLCHECKS		Contains a row for each column that is referenced by a table check constraint	db2 select constname, tabname, colname, usage from syscat.colchecks
SYSCAT.COLUMNS	NULLS	Indicates whether a column is nullable (Y) or not nullable (N)	db2 select tabname, colname, nulls from syscat.columns where tabschema = 'DELSVT' and nulls = 'N'
SYSCAT.CONSTDEP		Contains a row for each dependency of a constraint on some other object	db2 select constname, tabname, btype, bname from syscat.constdep
SYSCAT.INDEXES		Contains a row for each index.	db2 select tabname, uniquerule, made_unique, system_required from syscat.indexes where tabschema = 'DELSVT'
SYSCAT.KEYCOLUSE		Contains a row for each column that participates in a key defined by a unique, primary key, or foreign key constraint	db2 select constname, tabname, colname, colseq from syscat.keycoluse
SYSCAT.REFERENCES		Contains a row for each referential constraint	db2 select constname, tabname, refkeyname, reftabname, colcount, deleterule, updaterule from syscat.references
SYSCAT.TABCONST		Contains a row for each unique (U), primary key (P), foreign key (F), or table check (K) constraint	db2 select constname, tabname, type from syscat.tabconst
SYSCAT.TABLES	PARENTS	Number of parent tables of this table (the number of referential constraints in which this table is a dependent)	db2 "select tabname, parents from syscat.tables where parents > 0"
SYSCAT.TABLES	CHILDREN	Number of dependent tables of this table (the number of referential constraints in which this table is a parent)	db2 "select tabname, children from syscat.tables where children > 0"
SYSCAT.TABLES	SELFREFS	Number of self-referencing referential constraints for this table (the number of referential constraints in which this table is both a parent and a dependent)	db2 "select tabname, selfrefs from syscat.tables where selfrefs > 0"
SYSCAT.TABLES	KEYUNIQUE	Number of unique constraints (other than primary key) defined on this table	db2 "select tabname, keyunique from syscat.tables where keyunique > 0"
SYSCAT.TABLES	CHECKCOUNT	Number of check constraints defined on this table	db2 "select tabname, checkcount from syscat.tables where checkcount > 0"

How to see Primary key in a table in DB2

---------See primary key with column name in a table in db2---------------

db2  "select constname,tabname,colname from syscat.keycoluse where tabname='TABLENAME' "

It will give you.....

Example:::  

db2inst1@confonet:~> db2 "select constname,tabname,colname from syscat.keycoluse where tabname='COMPLAINANT_RESPONDENT'"

--------------Output--------------------------------

CONSTNAME                                                                                                                        TABNAME                                                                                                                          COLNAME                                                                                                             
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SQL100416165400090                                                                                                               COMPLAINANT_RESPONDENT                                                                                                           CRSEQ                                                                                                               
SQL100416165400090                                                                                                               COMPLAINANT_RESPONDENT                                                                                                           CR_TYPE                                                                                                             
SQL100416165400090                                                                                                               COMPLAINANT_RESPONDENT                                                                                                           FANO                                                                                                                

  3 record(s) selected.
==========================================================

Here COMPLAINANT_RESPONDENT table have a composite primary key on three column (FANO,CRSEQ,CR_TYPE)

Running Script in DB2

First copy the script (Using WINSCP from client remotely..see screen shot) on server under any directory and then login on server as db2inst1 user through putty remotely from client machine...(You can also do this by accessing server directly)

First give 'ls' command to see whether the script is in current directory or not where you have copied the script on server..

Now connect with your database ... db2 connect to DATABASENAME

And then give command...        db2     -t      -f     script4.txt

Now enter...

----------------------------------------------------------------------------------------

If this is not working then you have to run each SQL command with out semicolumn (end of each SQL statement in script.txt file)....like this...


db2  "update casetypedocs set mndtstatus='N' where casetypeid=1 "

And then enter..this has to be done for all SQL statements...

If this is also not working then do..
(see below screen)
Type db2 and enter
command  update casetypedocs set mndtstatus='N' where casetypeid=1