DSXchange

So this isn't a one-time occurrence for you?

I'm not aware of any way to 'monitor' this, unfortunately. Perhaps post-cycle timestamped backups are in order?

Would report this to your official support provider, if you haven't already.

Don't be sorry, just don't do it. :wink: Split and linked back for you. Similar != same and you post in the old thread if you are trying to help them, when you need help start a new post. For "library" related issues you need to verify your "shared library" environment variable s...

Sure, don't see why not. You just need a way to determine what "the current month" is and then craft SQL that does the delete for you. Put it in the Open or Before SQL option in that stage, whatever it's called there after you get it working outside of DataStage.

I have close to 40 different layouts to load 40 different tables. This is the reason why i have picked schema files instead of canvassing 40 sequential file stages. Schema files and one RCP enabled job, yes? All fields must always be read from a sequential file, that's their nature. Eric's "dr...

From what I've read if you have installed the client you should have the tutorial files on your client PC as well. Read the Installing and setting up the tutorial appendix in the documentation link posted above.

Can you post a complete example of your source, something without dashes so we can see everything? Also, will your source have multiple records and you need to do this calculation once per row or would there be any kind of aggregation involved? Really don't want to be doing a lot of guessing here an...

What version of DataStage are you running?

Pretty vague requirements, I'm afraid. And "need solution" is not the best choice for a topic's subject. Clarify for us what exactly your source is: database, flat file? If a database, do you have a date dimension that drives your fiscal v. calendar year? I'd also be curious what you've tr...

I am just a beginner who is seeking the solution of the problem. You can :roll: all you like but you must realize that people are trying to help you. The first thing any responsible mentor is going to do is attempt to point out when there are better solutions out there than the path a student is go...

It's not stored as far as I know.

The one mentioned in the first post.

Sort stage is used for sorting the data,if you want to remove duplicate records user "remove dupicate" stage. Or you can sort and remove duplicates while sorting by setting the "Allow Duplicates" option to False in the Sort stage, i.e. a unique sort akin to a sort -u in UNIX. Of...

Another (remote) possibility might be a restore of files in the Project from backup. This hashed file might have been accidentally included.