DSXchange

Missed the .odbc.ini


Found it now!

Thanks!

I tried ls -las but it still is no where to be found. I am working with DS 5.2 if that helps.

I found it in branded_odbc...but I don't see any other connection information for the ones I currently have working.

Thanks Ken.

I looked in the engine directory but don't see a listing for it. I know its somewhere because we have ODBC entries in other jobs.

I haven't done this in a while...so I need some help. :lol: In order to call on Oracle servers via the ODBC stage, you have to enter the information in two places: uvodbc.config (located in the projects directory) and odbc.ini...that is my problem. I cannot find odbc.ini, where is its location? The ...

DS support is useless. They have an open ticket (since August) on this issue from a former co-worker...still with the technician! DS gives the usual answer: 1)We'll check on it. 2)Them:Have you thought of upgrading? Me:Will it fix the issue? Them: Maybe? I'm sure someone on here has moved a field la...

I have a simple job that moves it from the source to the destination that works fine (varchar2(4000). I know for a fact that the column does not go over that and that nothing is being concatenated on the end. If I set the field on my job (not the simple one) to VARCHAR2(255) it will error out with t...

Is your metadata imported exactly from the source and target tables, respectively? No manual twiddling going on there? Are you comparing apples to apples, meaning the working instance is the same Oracle version and client? Yes, we load oracle to oracle...source is the same version as the destinatio...

CmpdOdsDataLoader..CInsOrUpdStage: ORA-01461: can bind a LONG value only for insert into a LONG column I keep receiving the following error through datastage. I'm not sure if it is DS problem or an Oracle problem. The source table has a field that is VARCHAR2(4000) and I have set up a destination t...

OK, problem somewhat solved. See this thread:

http://www.tools4datastage.com/forum/to ... C_ID=83776

Answering my own questions again. :) After reading some more, I took out the MissingFiles section and it worked perfectly. quote:homeDir = pODSDSN ErrCode = 0 Call DSExecute("UNIX","/datastage/DataStage/Projects/DRDWSysRes/test_run.ksh",homeDir,ErrCode) Now, I have passed homeDir...

All I have is a one page summary of the DSExecute subroutine. I need some working examples. The one I got off of this site does not work. Call DSExecute("UV","/datastage/DataStage/Projects/DRDWSysRes/test_run.ksh", Output, ErrCode) If ErrCode 0 Then GoTo MissingFiles End MissingF...

Is it ok if I just say Hi Ray from time to time?

[:D][;)]

That can be done in the unix script to pick up the values, but I am not sure how to pass them from the batch. There are two ways to invoke a unix script: ExecSH = which only gives you a place to put the unix script name DSExecute = I am having problems with the syntax. I wrote a DSExecute but it fau...

Couldn't you set up another computer:

Install v5.2
Install backup software

Import backup to v5.2 computer
Export project

Import project to v6.0 computer
Test

Cleanup v5.2 computer