#######
tabch.8
#######

.. highlight:: perl


****
NAME
****


\ **tabch**\  - Add, delete or update rows in the database tables.


********
SYNOPSIS
********


\ **tabch**\  [\ **-h**\  | \ **-**\ **-help**\ ]

\ **tabch**\  [\ **-v**\  | \ **-**\ **-version**\ ]

\ **tabch**\  \ *keycolname=keyvalue*\ [,\ *keycolname=keyvalue*\ ,...] \ *tablename.colname=newvalue*\  [\ *tablename.colname=newvalue*\  ...]

\ **tabch**\  \ *keycolname=keyvalue*\ [,\ *keycolname=keyvalue*\ ,...] \ *tablename.colname+=newvalue*\  [\ *tablename.colname+=newvalue*\  ...]

\ **tabch -d**\  \ *keycolname=keyvalue*\ [,\ *keycolname=keyvalue*\ ,...] \ *tablename*\  [\ *tablename*\  ...]


***********
DESCRIPTION
***********


The \ **tabch**\  command adds, deletes or updates the attribute values in the specified table.column for the specified keyvalue.  The difference between \ **tabch**\  and \ **chtab**\  is \ **tabch**\  runs as a plugin under the xcatd daemon. This give the additional security of being authorized by the daemon. Normally, the given value will completely replace the current attribute value.  But if "+=" is used instead of "=", the specified value will be appended to the comma separated list of attributes, if it is not already there.


*******
OPTIONS
*******


\ **-h|-**\ **-help**\           Display usage message.

\ **-v|-**\ **-version**\           Command Version.

\ **-d**\           Delete option.


************
RETURN VALUE
************



0. The command completed successfully.



1. An error has occurred.




********
EXAMPLES
********



1. To add a node=node1 to the nodelist table with groups=all:
 
 
 .. code-block:: perl
 
   tabch  node=node1 nodelist.groups=all
 
 


2. To add a keyword (tftpdir) and value (/tftpboot) to the site table:
 
 
 .. code-block:: perl
 
   tabch  key=tftpdir site.value=/tftpboot
 
 


3. To add node1 to the  nodetype table with os=rhel5:
 
 
 .. code-block:: perl
 
   tabch  node=node1 nodetype.os=rhel5
 
 


4. To change node1 in nodetype table setting os=sles:
 
 
 .. code-block:: perl
 
   tabch  node=node1 nodetype.os=sles
 
 


5. To change node1 by appending otherpkgs to the postbootscripts field in the postscripts table:
 
 
 .. code-block:: perl
 
   tabch node=node1 postscripts.postbootscripts+=otherpkgs
 
 


6. To delete node1 from nodetype table:
 
 
 .. code-block:: perl
 
   tabch -d node=node1 nodetype
 
 



*****
FILES
*****


/opt/xcat/sbin/tabch


********
SEE ALSO
********


tabdump(8)|tabdump.8, tabedit(8)|tabedit.8