pdm_load is a useful way to data load
The pdm_load command may not like some characters within input data files, such as a tilde or apostophe.
If you are getting error like above
11/05 12:47:31.44 server_hostname dbload 27820 FATAL tokfile.c 537 Invalid character encountered in input
2 ways:
1. pdm_uconv
Examples:
2. Save file using a text tool
pdm_uconv--Convert Local Charset to UTF-8 - CA Service Management - 14.1 - CA Technologies Documentation
pdm_uconv--Conversión de un conjunto de caracteres local a UTF-8 - CA Service Management - 14.1 - Spanish - Spain
pdm_uconv - 将本地字符集转换为 UTF-8 - CA Service Management - 14.1 - Chinese - China
pdm_uconv – Konvertiert den lokalen Zeichensatz in UTF-8 - CA Service Management - 14.1 - German - Germany
pdm_uconv - Conversione di set di caratteri in UTF-8 - CA Service Management - 14.1 - Italian - Italy
pdm_uconv : Conversion du jeu de caractères local à UTF-8 - CA Service Management - 14.1 - French - France
pdm_uconv--ローカルの文字セットから UTF-8 への変換 - CA Service Management - 14.1 - Japanese - Japan
DEREF - pdm_deref - Everthing do you need know
CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg
CA SDM Loading contacts pdm_load
Administration Guide r12.6