DSXchange

Ok, then please post your additions to the odbc.ini and uvodbic.ini files, perhaps the problem lies there.

Look at the log file of your job and see if the ENVironment variables are actually set correctly during runtime for that job.

One cannot read a COMMON block, and doing it line-by-line doesn't make sense. Did you try to run the routine I posted? What doesn't work, it explains both COMMON block usage and also solves your problem.

I know about the DS_CONNECT, but I wanted to ask you to try the "CONNECT" command. I expect that the "CONNECT" command will fail, but I would like to see the error message that is generated.

Sorry, I assumed you would understand what I meant. Here are the commands to execute

• cd `cat /.dshome`
  . ./dsenv
  dssh
  LOGTO {YourProjectName}
  CONNECT {YourDSNName}
  QUIT
  QUIT

Make a backup (better yet 2 backups) before trying to add the "-fix" option to the fixtool command. It doesn't look promising, though and the fix might truncate your UV_SCHEMA file and the system might be corrupted enough to not work any more and require a complete re-install (worst case, ...

go to TCL in your project, and try to "CONNECT {YourDataSourceName}". What happens?

Other options are to declare the whole load as one transaction, or to use UPSERT functionality.

Amit, Welcome to DSXchange! The answer to your question is "yes, there are people here could do that". But you probably won't get anyone to do this since the documentation explains it sufficiently and the question is very broad. If you read the docs and try to do something and then have pr...

There is also the lookup fileset, which is similar to a dataset.

DataStage hashed files have only 1 key column. Your 3 keys are actually just one dynamic array string in CurrID that contains some separator character; thus the 2 column result returned by your DCOUNT() is correct.

7.5.2r2

From UNIX, look into $DSHOME/../../Version.xml

Ok, here goes. I just wrote the code, but there are probably some syntactical errors as I don't have access to DataStage at the moment, but the general structure is there: EQUATE RoutineName TO "MyRoutine" COMMON/MyProgramCommon/Initialized,KeyArray,ValueArray IF NOT(Initialized) THEN OPEN...

You need to use a COMMON block. What are your input arguments and what value do you return to the calling program?