DSXchange

thanks to all

have that sorted now, as usual it's simple when you know how!

Regards
John Fitz

Hi, I am using an sql server stage to run sql against a table. To data both the code and the db have been on the same machine and so all i need to specify was the DB name, user name and password. Unfortunately, i now need to move to an environment where the db and ds are no different servers. can yo...

thanks, that looks very promising

Any chance you could expand on the idea of the hash file approach, please? Fairly new to all this so not to clued in i'm afraid

Hi, I have spent the last day or so trawling previous posts but cannot find anything to satisfy my requirement. If any one can help I would really appreciate it. I need to extract a large volume of data from a DB and then split the data in appropriately named files. For the purposes of the exercise,...

ray,

that saves me a bit of time anyway, thanks?
any thoughts on an alternative approach?

thanks
john fitz

probably a silly question, but is there any way to identify the variable that is holding the stage counter and just reset that as part of the loop??

thanks again, there is definitely something in idea of a second job restarting the first.

Thanks,

John Fitz

thanks again, there is definitely something in idea of a second job restarting the first.

Thanks,

John Fitz

Craig, Thanks for coming back to me, and the welcome. The idea here is we are running a 24/7 monitoring process. to simplify the model let me describe the jobs as follows: 1. extract job - creating a simple flat file - extract details of change since last extract 2. processing job(s) - file created ...

Hi, I am new to datastage so hopefully this might be a very simple fix. I am looking to create a sequence control loop that will execute a number of jobs continuously. The break of the loop will be controlled from a parameter in an ini file. I can break the loop based on the parameter. My problem is...