I found few posts on how to read excel in DS. Everybody told create system DSN and use ODBC stage. How do I create system DSN in UNIX ?
Regards,
Balkrishna Sapre
System DSN for excel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
User/system/file DSNs are only relevant in the Windows environment.
In a UNIX environment you simply create DSNs. You do so by editing the .odbc.ini file in $DSHOME directory. You also edit uvodbc.config file in any project needing to use that DSN, or use a central uvodbc.config file in the $DSHOME directory.
In a UNIX environment you simply create DSNs. You do so by editing the .odbc.ini file in $DSHOME directory. You also edit uvodbc.config file in any project needing to use that DSN, or use a central uvodbc.config file in the $DSHOME directory.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,
All fair and square but do you have an ODBC driver for excell files on unix ???
All fair and square but do you have an ODBC driver for excell files on unix ???
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom