DSXchange

Then you should change the values of the environment variables in the job parameters tab to $PROJDEF, that will resolve your issue.

Could you please post exact error message that you are getting

Did you define the value of the evnvironment variable as $PROJDEF or hard coded the values?

Never mind, got the answer. It just rebuilds the current project.

Thanks.

If we rebuild indices from DS.Tools, does it rebuild indices in the selcted project or all the projects on that server.

Thanks,
Diamondabhi.

I have compiled jobs and tried to run them using the following command:
dsjob -run -jobstatus MANAGEMENT jobname

I am getting the following error message:
Error running job

Status code = -14 DSJE_TIMEOUT


Thanks.

Gurus,
I am trying to run the jobs and none of jobs are running. It doesnt show any log and also I tried running using dsjob even then the job is not starting. It doesn't show any error. These jobs were running fine until last week. Please help me fix the issue. We even bounced the box.

Thanks,
Sai.

Then load the column into a stage variable and trim the special character and then load into the table.

so you wnat the length to be 8?

For:
1) use to_char in the sql
2) U can use iconv and oconv

Thanks,
Sai.

The first thing would be using parameters, if you are using version control then making the production jobs read only. And as kris said post more specific questions.

I think you can Use Timestamp as a JobParameter and use that parameter while naming the file.

I from what I understand , you can use substring and check for 'd' in the constarint and insert the rows. If this is not u what you were expecting to do then please post more info.

As dsguru said u can use hashed file stage. Please post what you want to do exactly?

For update existing or insert new rows , you need the array size to be set to 1.