DSXchange

Hello again. Again, I am trying to set some standards at my job. Here is the case: I have bunch of parameters for a job. Parameters would be for odbc connections (db connection, user id, password). This job is generic, means that I will be calling this job at command line for different databases. Is...

Hello Gurus, I am trying to come up with Naming Conventions. Any recommendations naming conventions for 1. dsn entries in uvodbc.config and .odbc.ini files 2. Data connections I was thinking about <3 letter ACRONYM of PROJECT>_<Database Server Name>_<DatabaseName> as dsn entries and <3 letter ACRONY...

Yes...It is working...
Thank you so much..

You are right about that file. There is one at project level.
Though, in my case it is a file. I like your suggestion. Easy to maintain and consistent results...

Now, let me try to change the file and see...

Hello again..

I am trying to create ODBC connection and I have the needed entry under .odbc.ini and uvodbc.config files. For some reason I can not see the DSN in my drop down list.
What could be wrong? What did I miss?

I have a job that is suppose to write rejected records into reject files on our UNIX server. During the run, I am getting error: S_Reject_Pto_aten_Clnica,0: Unable to open /xyz/etl/reject/MyProject/Rejec_DIM/PTO_ATEN_CLINICA: Permission denied. Looks like I don't have write permissions in that direc...