DSXchange

You need to learn how to post more better. That is not how one quotes another post.

Please don't start a new topic on the exact same subject you already have a perfectly good post for.

viewtopic.php?t=129846

1. That's fine, just copy them but make sure you get all of the files (including the hidden files) and the "D_" dictionary files as well.

2. Search here for the SETFILE command.

What 'read only elements', precisely? Typically, they are the items you don't need to backup as they install with the product in every project. In other words, this may be a non-issue.

Excellent. Please mark the post as Resolved using the button at the top of the page.

8.0.1? Probably a bug. Best to contact your official support provider and ask them if indeed it is and for the patch. Or upgrade to 8.1.

It won't be that simple, I'm afraid. You could test that process out by exporting one job as a control, then manually changing the stage to Teradata and exporting it again, comparing the two exports. You'd need to quantify the exact differences between the two and see if you could come up with some ...

Welcome.

No can do. The file not found will abort the job looking for it, period. You'd need to do something before that to check for the file and rather than run the job, log a warning and skip running the job. A Sequence job could do that 'check and branch around' for you fairly easily.

I honestly don't know but if you've got the syntax right it wouldn't have spaces around the equal sign. Try "-param param_set=valuesfilename" instead.

Here's the thing... maybe I'm being a little dense today but I still have absolutely no idea what exactly it is you are trying to accomplish. I was hoping someone else would jump in here and show some insight, solve your problem, but that doesn't look like it's going to happen. So... it seems like y...

As noted, from the command line shell - meaning 'dssh', that or the Administrator, assuming an interactive session.

Is there a 'conversion function' for that in Teradata?

You do realize, do you not, that you just repeated yourself without explaining anything or answering any of the questions asked, yes?

So, you need to run this query 39 times, once for each Y/M combination going back that far, right? Sounds like you may already have a looping Sequence in place and just need a delimited list for use in the Start Loop stage? Or do you actually need something else?