Day 21: Informix(2)

環境設定

查詢自己帳號預設的登入 shell 設定

對於 Informix DB 而言，是ksh

• 顯示目前正在執行的 shell 名稱

  echo $0
  

• 終端介面輸入:

  • 環境為 ksh
  • 我常用的(紅框已框):
    
    • 游標移到最後: shift + $
    • click R then 取代游標上的字 by 新的字
    • click A then 在游標後append字
    • click I : insert mode
  • More information:
    • 每個開發者都應該要會用的編輯器–Vim
    • Vim Cheat Sheet
    • Vim Editor Modes Explained

.profile

• (A) .profile file

• (B) Automate startup and shutdown on UNIX

  • environment variable

    • INFORMIXDIR

      the full path name of the directory in which the database server is installed

    • INFORMIXSERVER

      the sysmaster database can be updated (or created, if necessary)

      The sysmaster Database

    • INFORMIXSQLHOSTS

      If you store the information in another location, you must set the INFORMIXSQLHOSTS environment variable.

      The sqlhosts file and the SQLHOSTS registry key

• (A+B) What's in .profile?

  export INFORMIXDIR=/usr/ifx_instance/informix_X
  export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhost_X
  export INFORMIXSERVER=[主機]
  

師承謝門