DSXchange

All, Mystery solved. Although I'm more than a little embarrassed by making this post, we all must face up to our little screw-ups! I had copied a number of jobs to redesign a process and for some reason the row limit in Director was set to 1 for all the jobs. My apologies for wasting your time. Chee...

I have used the folder stage successfully several times in the past, but yesterday it all started going wrong. Instead of writing all the filenames (wildcard = *.txt) to a sequential file, it only picks up the first filename. I have tried several odler jobs that use the folder stage as well as setti...

I am trying to use before/after routines to set the UserStatus depending on the JobStatus of a job (am using UserStatus as requested by our support people so they can check jobs within our scheduling software). From reading the manuals I get the impression that I could set the UserStaus at the start...

Hi all, Using V6 on W2K. I want to use an Oracle table as a lookup to validate some data against, but it keeps asking for a table name. When I set this up using the ORAOCI9 stage, there is no where to enter a table name. Does this mean that the table name is set in the driver and that a new driver n...

Hi all, Has anyone worked in an environment where DataStage jobs are instigated via the AppWorx scheduling software? If so, could you please provide some information on how these two applications sit together and how error handling occurs? Or point me in the direction of any information available on...

Thanks guys. I am using version 6 and have gone through end defined the function in DS* as per Rays response to the topic you provided the link for and get the same for each definition. I wouldn't worry about it too much as I can get around it with a bit of extra code. I just thought if this was the...

In the DataStage Designer online help, search for 'timestamp'. From the list returned, double click on Date and Time Functions. This provides a list of available functions withtin DataStage (at least that's the way I read it); this function is listed here. I was trying to use it in a routine I was w...

DS Version 6 Windows 2000

I am trying to make use of this funtion (which I found in the DS online help and returns the difference between two timestamps in seconds) in a routine, but it is not recognised. Can anyone help?

Hi Guys, Sorry it's taken me a while to get around to trying out your suggestions (been a bit busy), but here are the results: Have had a number of people go over the spelling and order of the parameters and everything seems to be OK; ErrCode and BADHAndles as above; Have run the job by itself manua...

Thanks very much Amos

DS Version 6, Windows 2000 I have been importing an ODBC table definitions via the DS Manager functionality. I seem to get different column formats then what our Oracle developers say is there (e.g. I retrieve decimal formats for fields they say are numeric and timestamp for fileds they say are date...

Thanks Ray, Have checked the parameter and it returns 3 so I will take it from your last post that it is setup OK. I did however stumble across something of concern: the displays imediately prior to setting up the parameters and running the job display all the information fine, but when I checked th...

Thanks Roy and Michael, Roy, I have run the job to display the BADHANDLE and it returned -1. Again, have no idea what this means. Michael, the value for svFailPercentage is calculated prior to running these jobs and is not set via parameter or constant anywhere. The value for the working job is 0 an...

Roy, Thanks for the tip. Have tested the ErrCode for each parameter and the pFailPercentage has a code of -4. Do you know what this means or point me to where I can find out? The only thing that worries me is, as I said before, I write all the paramneters to the log and they all appear to be populat...

DataStage version6 - windows 2000 I have written a DSBasic job to validate a file and then follow the following if logic (basic logic not taken verbatim from code): If failed run hFailReport Else run hMerge If 100% success run hCleanReport Else run hOKReport I have tested this code where hCleanRepor...