System Resources PubChem CID Type

• List of all PubChem Compound ID Types used in PUBCHEM_COMPOUND_ID_TYPE field.

• Fields

• Add New PubChem CID Type
• Remove Rows
• Copy Rows
• Cut Rows
• Paste Rows
• Undo
• Load PubChem CID Type File
• Save PubChem CID Type File
• Save PubChem CID Type
• Close PubChem CID Type
• Refresh PubChem CID Type

• General Comments
• See Also

Fields

• CID Type No is the unique CompoundIdType number defined by PubChem.
• PubChem Component ID Type is the meaning of the CID Type No.

Add New PubChem CID Type

This adds a new row to the PubChem CID Type resource table.

1. Make the PubChem CID Type window active in the Board.
2. On the PubChem CID Type menu click Add New PubChem CID Type.

Note

• The table must be saved before changes in the database occur.

Remove Rows

This removes the selected rows from the PubChem CID Type resource table.

1. Make the PubChem CID Type window active in the Board.
2. Select one or more rows in the table.
3. On the PubChem CID Type menu click Remove Rows.

Note

• The table must be saved before changes in the database occur.

Copy Rows

This copies the data in the selected rows of the PubChem CID Type resource table to local clipboard.

1. Make the PubChem CID Type window active in the Board.
2. Select one or more rows in the table.
3. On the PubChem CID Type menu click Copy Rows.

Note

• The table must be saved before changes in the database occur.

Cut Rows

This removes the selected rows of the PubChem CID Type resource table and copies them to local clipboard.

1. Make the PubChem CID Type window active in the Board.
2. Select one or more rows in the table.
3. On the PubChem CID Type menu click Cut Rows.

Note

• The table must be saved before changes in the database occur.

Paste Rows

This adds the rows in local clipboard to the PubChem CID Type resource table.

1. Make the PubChem CID Type window active in the Board.
2. On the PubChem CID Type menu click Paste Rows.

Note

• The table must be saved before changes in the database occur.

Undo

This cancels the last change to the PubChem CID Type resource table.

1. Make the PubChem CID Type window active in the Board.
2. On the PubChem CID Type menu click Undo.

Note

• The table must be saved before changes in the database occur.

Load PubChem CID Type File

This loads a comma separated value file and adds the data to the PubChem CID Type resource table.

1. Make the PubChem CID Type window active in the Board.
2. On the PubChem CID Type menu click Load PubChem CID Type File.
3. In the folder list, locate and open the folder that contains the file.
4. Click the file, and then click Open.

Note

• The CSV file consists of the header row followed by rows that contain comma separated data.
• To see the exact file format, do a save file for a table with entries.
• The data in the table will be replaced with the data in the file.
• The table must be saved before changes in the database occur.

Save PubChem CID Type File

This saves the PubChem CID Type resource table as a comma separated value file.

1. Make the PubChem CID Type window active in the Board.
2. On the PubChem CID Type menu click Save PubChem CID Type File.
3. If you want to save the file in a different folder, locate and open the folder.
4. In the File Name box, type a name for the file.
5. Click Save.

Note

• The CSV file consists of the header row followed by rows that contain comma separated data.

Save PubChem CID Type

This saves the PubChem CID Type in the database.

1. Make the PubChem CID Type window active in the Board.
2. On the PubChem CID Type menu click Save PubChem CID Type, or click the Save PubChem CID Type button in the button bar.

Note

• This will replace the information for the current PubChem CID Type in the database.

Close PubChem CID Type

This closes the window.

1. Make the PubChem CID Type window active in the Board.
2. On the PubChem CID Type menu click Close PubChem CID Type, or click the X button on the window's Title bar.

Note

• If the content of the View has been modified since the last Save operation, the user will be given an option to proceed and discard the changes, or to cancel the operation.

Refresh PubChem CID Type

This reverts the data for the PubChem CID Type to the version in the database.

1. Make the PubChem CID Type window active in the Board.
2. On the PubChem CID Type menu click Refresh PubChem CID Type.

Note

• This will reload the PubChem CID Type from the database.
• If the content of the View has been modified since the last Save operation, the user will be given an option to proceed and discard the changes, or to cancel the operation.

General Comments

• To open the PubChem CID Type window in the Board, on the Options menu select System Resources then click PubChem CID Type.
• This System Resource is maintained by a Sesame user, usually a Sesame administrator, with a Can Do privilege.
• To give the Can Do privilege for this resource to user JoeSmith, execute the following SQL statement:
  insert into candothis values ('JoeSmith', 'SYS_RSC_PUBCHEMCIDTYPE', 'Sesame', 'SYS');
• To revoke the Can Do privilege for this resource from user JoeSmith, execute the following SQL statement:
  delete from candothis where user_name='JoeSmith' and what='SYS_RSC_PUBCHEMCIDTYPE' and ass_name='Sesame' and ass_type='SYS';

See also

• PubChem SD Fields Description

Copyright © 1999-2009 Zsolt Zolnai, and the University of Wisconsin - Madison