DSXchange

Un-installing might not be enough. Make sure the files are really gone from the directories and that the registry entries are all removed. Also, is your PC up-to-date with all the service packs?

After executing your dsenv, please check your environment LIBPATH variable and ensure that "$DSHOME/lib" is present.

sekharg_dw, I am a bit surprised at some of your questions. I dislike being too blunt, but it seems that you are trying to get people here to give you programs and tools and that you haven't been able to attend a training class but don't want to try learn yourself. Your rank of 3/5 and 2/5 for Serve...

Friday,

reinstall DataStage on your PC as Ken suggested. You can use the command line options of "dsjob" from Windows; but it would be easier to borrow a colleague's PC

the user that starts the dsjob needs to have the environment set up correctly with paths & variables.

If you execute the dsenv script in the datastage home directory that should do the trick for you.

sekharg_dw,

DataStage subroutines are not only for small and simple work, the are very powerful and versatile. Your idea of a date conversion routine is probably very good for your site.

Tell us what you've done so far and what you are missing and I'm sure you'll get some assistance.

Hmmm... this is odd. I am not sure what the problem was and my only suggestion was to find out more about the error, I'm surprised it solved anything. I would very much like to understand this. What did the output file show as the numbers and result? DataStage will always attempt implicit conversion...

Ice,

in your last comment you asked questions answered in the first post! YES, DataStage server relies on Windows server! The program is called 'at' and needs to be running.

Ice, Doing floating point match is always imprecise, but I don't see how that could be affecting you here. If you change your job to write to a temporary sequential file and put the columns DB2Summation, AS400Summation and DB2Summation-AS400Summation into it, what results to you get for the differen...

nvkuriseti,

you are writing to a DB/2 table in your job and trying to put a NULL value into your data at column number 21. The metadata of DataStage don't enter into the picture.

I think you need to declare and call it as a function.

Craig - I didn't see that comment in the title and wondered if he hit the "return" key too soon and thought I'd see a follow up. This forum is an aid to DataStage, not a substitute for self-help. I won't supply code for such a broad request. As Craig stated, there are a lot of builtin examples avail...

Can you call up the administrator , designer or manager? Or do you have the same problem there? Is the server and the client on the same Windows machine? If both are on the same machine, which process is eating up 100% of the CPU - the director client or some other process?

Sounds like you've done things correctly so far.

How are you calling this from UV/Basic?

Ice, in order to solve the problem you will need to supply more information; right now you have told us that some things don't work sometimes - how can anyone fix a problem with only that statement. You state that your scheduled job didn't run today. I am assuming that you looked into the DataStage ...