DSXchange

Hi All, Job which runs successfully in old version is getting aborted in newversion. I am getting a funny error. One of the text column generates junk values in new version. I use IF IsNull(Col) = 1 Then "Open" Else Col. It generates proper values in old version. The same job generates jun...

Thanks it works fine.

Thanks for your early reply. Could you please tell me in detail where should I execute the above queries!

Hi All

I had the same problem, I used @NULL function to hardcode the values as null. It doesn't work when we are populting into Oracle. Try the below
If IsNull(Arg1) = 1 Then '' Else Arg1. It may work out. I had this problem when I was populating into Oracle8i database

Hi All,

Can anyone tell me, how to find the server jobs based on job creation date!

When I tried to open the job it gives error as follows.. "Job is being accessed by another user" I tried to clean up the job resource in datastage director, but I didn't succed to cleanup the resource. It gives error as follows.. ERROR: Cannot find any process numbers for stages in job Pop...

Your project might be corrupted. First thing is to make a UNIX backup of the project directory immediately if you haven't done that already. Try executing the TCL command "COUNT DS_JOBS" from a shell if you know how to do that, or as a command from the DataStage Administrator. If you get ...

Hi All, When I tried to export data stage server jobs in particular category using manager, it gives error as follows.. Error calling subroutine: *DataStage*DSR_SELECT (Action=7); check DataStage is set up correctly in project MISOVS2 (Subroutine failed to complete successfully (30107)) But it allow...

Thank Duke for ur information

Dear All,

I can send a mail with the subject and body, but I amn't aware to send a mail with an attachment through server batch jobs. Could anyone help me please!

I tried to find out, but I don't have the privileges to read many directories.
Anyother way to fix this problem other than the option fixfile?

As I said earlier, I couldn't find the fixfile in bin directory. Seems I can proceed to fix the file as our group members suggested. I will discuss with our Admin tomorrow. Will let you know all, what ever happens.

Thanks for your time.

I tried as you sead, but the result didn't change. When I was executing the command cd $DSHOME or cd $DHOME it takes to the remote directory unless I tried cd $DSHOME/bin I couldn't be able to explore more. If anyone of you can ensure that this command can resolve this issue. I will talk with our un...

Thansk for your response, I tried to execute the command in unix as you said, but it says fixtool not found.

Thanks for your help.
Yes exactly, When I was executing the command, it gives a warning message that file is corrupted so that unable to open DS_JOBOBECTS as you said. I tried to exceute the unix command, but it says fixtool isn't found in your VOC.