DSXchange

Hmm, it looks like you tried for 2 minutes before asking for the answer. The beginning of the line to use is "dsjob -jobstatus " and then there are several command options for the job name, project, login, password and the like. If you use the search facility you will find several posts which detail...

Yes, there are various ways to get the status of a job. It sounds like you might not be comfortable in doing this with DS/Basic code, so the best choice might be for you to get the information from a UNIX command. Please look up the dsjob command, this has many options and some of them will return t...

kduke wrote:CNAME is the TCL command to change a file name.

I'm 100% certain I posted a thank you for your answer this morning but it seems to have gone the way of the dodo! So I'll repeat my thanks, I vaguely recalled that some command like that existed but my search in the VOC didn't locate it.

Thanks!

Ok, I see now. How are you running this job? It looks like it is started from a sequencer RunJobPF. A reset doesn't just happen, it needs to be explicitly triggered and it seems that this is happening in your calling sequencer.

Naveen - look at the log carefully, it is being reset after ABORTING (you can't open a hashed file!). There are four ways to reset a job: 1. From the Director client by issuing a RESET to the job 2. From a sequence that is calling the job and which has the job activity flag set to reset a job if nec...

I think that I might steer away from variable number of arguments even if I do get an answer; since it is most likely not fully documented. I think I will now have one routine with 12 parameters called one time per stage to set up all the environment, then for each of the ~100million daily rows will...

Craig, that's a good approach, I like that idea and hadn't approached it from that angle. But in this it wouldn't work because of the extra performance overhead, this routine gets called ~100 Million times per day so I am trying to tweak performance out of the common call. I found that by adding/rem...

Seeta, the term used in most places in DataStage for this is "transaction size", this equates to the commit frequency. Each Database stage has a way for you to set this value. I think the documentation for whatever stage you are using might be a good place to begin if you can't find the place where ...

I suppose that might be an option - but in my case I'd be calling this function from a transform stage and we can't put DIM statements to allocate an array; a dynamic array might work but would be quite unwieldy in this case. I think if I can't get a variable number of arguments sorted out I'll have...

I recall having programmed my own functions with variable numbers of parameters in the past and am faced with a situation here where being able to do that would save large amounts of run-time; but I can't recall how I did it and haven't found anything on the web about this. Does anyone here know how...

Reddy, the value "2005-12-21." cannot be stored in a numeric field, so there is no answer to the question as you have posed it. The DateToString() function you posted will convert a valid date into a 8 character long fixed representation without any separators, i.e. "20051221" and no decimal point. ...

I'm at a 7.1 installation right now, so I'm not certain if there is a way to do that I can't think of - but it seems that the JobActivity stage will always wait for completion before continuing. I would recommend that you do the following: 1. Create a new server job, go into the Job Control tab and ...

Craig,

yeah, that fool certainly made a big misteak

The buffer size is a function of the database. Find out from you DBA what your configuration's setting are and compute the array size accordingly. I would recommend at least pretending you have a 4Kb buffer. If your row width is 40 characters/bytes then your array size should be no bigger than 100.

Antojj,

fix your DSSendMail call. You are giving it incorrect parameters. Have you read the DSSendMail definition in the BASIC Programmer's Guide? Your first portion of the string should read "From:You@Mail.Com"...