Need help modifying a couple of files on CMS in Unix/informix for ODBC

[leeniep]

I am trying to Enable ODBC and JDBC on the CMS server. I have the Avaya document that shows how this is done but I am stuck on the part about modifying a couple of files on the CMS server. This is done at the unix level in CMS. Here is what the document says, can anyone tell me was the exact commands are for editing and saving these files? Help would be greatly appreciated!

3. On the CMS server, add the following two lines to the /opt/informix/etc/sqlhosts file.
Note that in both cases, you must substitute the actual hostname of the CMS server. If
these lines already exist, do not add them again.

cms_net ontlitcp <hostname> 50000

cms_<hostname> ontlitcp <hostname> 50001

The 50000 and the 50001 values are the network port and if you prefer, you can administer
them in the /etc/services and then add the name here instead.


4. Modify the /opt/informix/etc/onconfig.cms file and add the cms_net and
cms_<hostname> entries to the DBSERVERALIASES line separated with commas.
Remember to substitute the output found in step 1 from your system for the example
<hostname> used here.

DBSERVERALIASES oacms_ol,cms_net,cms_<hostname># List of alternate
dbservernames

Leenie P

 

[Stinney]

You would edit the file using VI.

Search the internet for using VI to edit files in unix. It's a tricky so be careful using it.

You also could potentially use WinSCP to take the file off of the server, edit it using wordpad and then putting it back using WinSCP.

- Stinney
"Scire ubi aliquid invenire possis, ea demum maxima pars eruditionis est"

"To know where to find anything is, after all, the greatest part of education"

 

[BIS]

Be careful with the WinSCP option, you may run into CR-LF vs LF issues.
Best option is vi - get someone to help you would be my advice.

 

[phoneguy55]

Just play with vi. No harm in making a copy of the file and messing with the copy.

cp file file.old
vi file.old