DSXchange

There is a routine supplied by IBM to do it. UtilityRunJob.

That is what Parameter Manager is for. So you can copy parameters from one job to all other jobs which need them. Several top posters have posted their routines and jobs to do the same. Parameter Manager is available on www.tools4datastge.com. All the others use at your own risk. Updating the reposi...

I think some of the things you are sharing are accurate. I think some are not. I think PX functionality lags behind Server but from what we hear is ahead of the competition. I do think every release you will see improvements in all products offered by IBM and Ascential. I think the GUI is not slow i...

How about http://www.dsxchange.com/viewtopic.php? ... ttimestamp Do an exact search on JOBSTARTTIMESTAMP. Should show you a lot of code already posted. I would imagine STAGESTARTTIMESTAMP is not much different.

The READONLY field has "NRO" or "RO" in it which stands for Not Read Only or Read Only. It is in the DS_JOBOBJECTS.

If you are using UV stages then use single quotes. If you are using hash files then use a WITH clause with double quotes around values. A WHERE clause is used with UV stages only.

You would need to use Samba or some other tool to mount a UNIX filesystem so you can write to it from Windows.

Are you out of disk space?

I doubt if I would trust an export of this job. I would import it from an old export.

Your question is unclear. If you are asking can you run the same job in one sequence with different params then the answer is yes. A multiple instance job can run at the same time with as many instances as your machine can handle. It is expected that each instance has different parameter values.

Not a good idea. If you get to TCL then CLEAR.FILE RT_LOGnnn. That would be much better.

Try to delete it in Manager.

I am not sure you can do it. I know what to delete but the Director is not notified. You have to logout of the project and then log back in. There is some trick I do not know. The instance ids are stored in RT_STATUS and RT_LOG. The ones in RT_STATUS are the active ones. RT_LOG are historical.

It is difficult to run jobs from more than one project. So that should be part of the criteria in spliting a project into 2 projects. I would also try to keep a project under 1,000 jobs. It seems to run better even under 500. So try to estimate the number of target tables. Then estimate the number o...

Telnet is the best way. Do a search. This has been covered a lot. You can easily do SQL at the TCL prompt. You can also find values in the Designer.