DSXchange

Thanks for your suggestions.

I have been able to achieve it by using the stage variables

If the source value is 'fail' or the variable value is 'fail' then the value of the variable would be always fail.

This worked.

Thanks,
Dinesh

Hi Ray, The results using the Not function which i am getting are 0|0|0 0|1|1 where 0 is considered as fail and 1 considered as pass If we sum them up the result is 0|1|1 which is correct. But i would require to get the result of 0|0|0 showing all the fail ones. If i had tried using Not(Not(value)) ...

Hi Ray, While capturing the values i had tried @INROWNUM = 1 OR Field(column,'|',1) = 'Fail' i used the same code and created three variables and i had got the values in 1s and 0s and not as fail or pass. For example: I get for Fail|Pass|Pass as 1|0|0 I had tried to use these and aggregrate them usi...

Hi all, I have a requirement where i would have to do the following 1) For every row i select from the database i would have different combinations of Fail & Pass in one field concatenated as given below. for ex: Fail|Pass|Pass, Fail|Pass|Fail, Fail|Fail|Fail 2) I would have capture these values...

Hi all, I actually will have to calculate the job end time and the job duration with in the server job and load it to the target table. I have tried to achieve it in the following manner. 1) Passed DSJobStartTimeStamp from the sequencer to the server job. 2) Used the GetCurrentDateTime routine in th...

Hi Ray, What i am trying to do here is actually get the difference between the job start time and job end time. None of the jobs which i have would run for more than 24 hrs thus causing an issue which you have mentioned. The approach which i am taking in order to get the time elapsed is by subtracti...

delete

Hi All, I am using Datastage 7.5 and i have to achieve the following in a server job. I have two timestamps for example '2006-09-10 03:10:35' and '2006-09-10 03:15:10'. I would like to get the difference between the two timestamps in the following format. '0000-00-00 00:05:25' Could someone please s...

Ray, this has worked. We happened to replace the file with one from a different project and the job has run fine.

Thanks a lot to you all.

Regards,
Dinesh

Hi all, The following are the results of the command ID "DSTAGE_PLI_E_0089" doesn't hash to primary group 64 ID "DSTAGE_RUN_E_0379" doesn't hash to primary group 64 ID "DSTAGE_JOB_E_2033" doesn't hash to primary group 64 ID "DSTAGE_UDT_E_3018" doesn't hash to ...

Hi all, I had run the command and it said "No such file or Directory".

Any suggestions on how to fix this file.

Thanks,
Dinesh

Hi Ray, thanks for the information. Looks like you have forgotten to mention the command you wanted me to run.

Thanks,
Dinesh

Hi folks, i have a job which reads the job statistics and loads them into a sequential file. The source stage used here is a universe stage. The file into which the details are loaded has been created by me and also the job is run by me so, i guess this should not be a permissions issue as mentione...

Hi folks, i have a job which reads the job statistics and loads them into a sequential file. The source stage used here is a universe stage. The file into which the details are loaded has been created by me and also the job is run by me so, i guess this should not be a permissions issue as mentioned...

Ray, you are right with 64-bit addressing we have the option of using the hash file. I am still curious to know how good the universe table approach is.

Could someone please share their opinion on that.

Thanks,
Dj