Creating a dummy dataset using orchadmin

nelab28 · Post by **nelab28** » Mon Oct 10, 2005 2:22 am

Hi,

We are close to moving to production, and realised that the jobs using routines to remove existing dataset uses the "orchadmin rm < file name > fails as there is no file <file name>.. The routine contains DSLogFatal, if the rm is unsuccessful.

so, as alternative,

1) Is there a way to create a dummy dataset using orchadmin

2) Is there a command to specify to remove a file name using orchadmin, only if the file exists ?.

The solution of having a job create the dummy dataset initially, is ruled out as it is only the first time the jobs run this error occurs. Later on it doesn't have a problem on this front.

Thanks in advance..

Cheers.

roy · Post by **roy** » Mon Oct 10, 2005 10:26 am

Hi,
The most easy solution you can implement will probably be to run a manual first time load without removing the files.

If your using specific file name when you issue the orchadmin rm command you might be able to build an empty DataSet and use orchadmin to copy it in a new name of your choice.

IHTH,

ray.wurlod · Post by **ray.wurlod** » Mon Oct 10, 2005 2:33 pm

Explicitly handle the error in a job sequence. If you explicitly handle the error, then the automatic handling does not kick in.

nelab28 · Post by **nelab28** » Mon Oct 10, 2005 9:27 pm

Thanks guys,

We actually went ahead in altering the routine, to test for existance of a file before deleting.

But, now facing a problem in importing the altered routine from dev as the existing routine in Production has been created as a read-only routine.

It prompted me to send another SOS..

Cheers.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 11, 2005 2:51 am

Was it created as a read-only routine by Version Control? If so, you can happily overwrite it with Version Control.

Otherwise, do a search here for READONLY (the name of the column in the repository table DS_ROUTINES that you will need to update in the production environment).