DSXchange

Hi DSguru,

How to acheive this.Give me some idea


Thanks,
sudhakar

Hi,

after the completing the job execution i need to store the howmany records are processed and howmany records are regected into database.

is there any way to capture the information in log files

Thanks,
sudhakar

Hi,

how to find out howmany records were processed and rejected.I want to store this information into database.

Thanks,
sudhakar

Hi ray,

I did not select any options.I just specified the path,where it has to be stored.And i have run the job.I did not find the xml file in specified path.

Thanks,
sudhakar

Hi,

I am creating XML document from a sequential file.In datastage it is showing the job is executed successfully.But,the document is not created.can anybody help me.

Thanks,
sudhakar

Hi kirtikumar/balajisr/ray/chulett/Arndw,

Thank you very much.I got it.The job name should be enclosed with in codes.

Thanks,
sudhakar

Hi kirtikumar / balajisr

I have written as following.But,i am getting result as -1

$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle=DSAttachJob(ABC,DSJ.ERRFATAL)
JobStartTime=DSGetJobInfo(JobHandle,DSJ.JOBSTARTTIMESTAMP)
Ans=JobStartTime
NOTHING=DSDetachJob(JobHandle)

Reply me asap.

Thanks,
sudhakar

Hi Kirtikumar,

Thanks for reply.My job name is ABC.And i have used the following code in routine.But it is giving -1 as result.

$INCLUDE DSINCLUDE JOBCONTROL.H
JobStartTime=DSGetJobInfo(ABC,DSJ.JOBSTARTTIMESTAMP)
Ans=JobStartTime

Let me know what i have to write in jobhandle.

Thanks,
sudhakar

Hi chulett / ray, I did what you people said.It is not showing any errors.But,it is giving the result as -5. And, my reqirement is whenever the job started then the start date and time has to be stored in oracle table.And,when ever the job finished then the finished date and time has to be stored in...

Hi Arnd,

Thanks for your reply,I have used this function as you said.But i am not getting.It is saying DSJobGetInfo is not dimensioned.

Thanks,
sudhakar

Hi,

After completing of my job execution,how to store the job start date and time and end date and time in to oracle.

Thanks,
sudhakar

hi ArndW ,

i want to execute this query in unix
SELECT TIMESTAMP FROM RT_LOGnn WHERE TIMESTAMP >='1900-01-01' AND TIMESTAMP<='2006-01-01'

and i should store this result into one text file in unix.

how to do that?

thanks,
sudhakar

Hi ray.wurlod and ArndW ,

Thanku.I want to store the result in unix file.how can i do that.


thanks,
sudhakar

hi loveojha2 ,

how can i execute this Code in unix

SELECT TIMESTAMP FROM RT_LOGnn WHERE TIMESTAMP >='1900-01-01' AND TIMESTAMP<='2006-01-01'

thanks,sudhakar

Hi,

how to take the back up the log files for n days

thanks,
sudhakar