DSXchange

I should have been more clear. I want to create a global variable that can be changed daily and would not have to be passed down as a parameter. Much like an environmental variable. So the question is can an environmental variable be modified from a command line or script or can it only be set thru ...

I'm looking for a way to set several variables once a day and be able to reference those variables from a job without having to call a function or routine. Much like when you use the keyword Current date except in this case it might be CycleDate or CycleDateMinus1 or MonthCycleEnddate. We have used ...

I agree with Ray's comments! In my onion it's best to push off the updates to subsequent jobs but there is also the option of using a DRS stage. This stage is very tricky but will allow you to perform multiple SQL statements from 1 stage... just a thought!

Thanx for verifying that for me! I'll close this thread and again thank you very much!

Larz

Thanx kindly for the tip Ray!

By chance does your DS spell book mention someone besides Manuel?

Larz

Ok, my apologies for opening a new thread on this but I'm not sure if I could reopen my older topic. We exceeded that max number of subdirectories allowed under a unix directory again. After discussing several options last time the conclusion was the best way to resolve is to create a new VERSION re...

We did not even view the hashed file. Only other thing that happened Today is that we rebooted the server. Does it update the timestamp of DATA file ?

Please shed some light on when does the timestamp of the DATA.30 file gets updated when we don't run the job ?

Thanks for the help

I am using CLEAR.FILE as suggested. But I want to know what happens if we delete the DATA and TYPE files ? what are the implications ?

Also, why does it update the LOG FILE even when we are not running the job ?

Thanks a lot for the help...

Thanx again! The last question I have regarding this solution would be can 1 perform this command using wildcard chars and is it advisable to do so. Just to document findings again I ran the following to get the nnnn for each job select * from DS_JOBS where DS_JOBS.NAME = 'DWXIloveMyJob' Guess I'll ...