DSXchange

Looks like I may have been attempting to over-complicate it... I misread it to include a number of business days since x, hence my question regarding a date dimension. As long as "the business date" equates to the current system date then you should be able to do this fairly easily.

I want to sort the data by multiple columns (after one by one) can I use sort stage or can I use the order by clause in the sql query itself? Yes. :wink: Either one can be used but for the latter you may still need to add a Sort stage set to "don't sort already sorted" or whatever it says...

So basically you are looking for SQL to derive the two "last day of the month" values? Do you have access to a date dimension, anything that tracks "business days" in your organization?

Suggest you do more than simply post input and output samples. How about spelling out your requirement in words? Telling us what you've tried and what issues you faced?

I see a simple dual count exercise that stage variables can solve.

Are you sure you replied to the correct post? Wondering if it should be here: viewtopic.php?t=149931

What database?

dudam emailed and said wrote:the Source and Trgt as datatype is Date

First off, reply here not via private email. Those I normally ignore.

So bottom line there is no conversion needed. As noted, a date is a date and has no format.

Discussed in this technote. Note you can also use the Server Sequential File stage in a Server Shared Container in your Parallel job.

Chuck Smith has already built that for you with his "DataStage tools" offerings. Check out the 'Search' or 'List' code... if it doesn't already do what you need, modify it so it does.

Several ways to approach this. Read the file's record as one long string and check the first two bytes for either "00" or "01" to determine header v. detail... or if there's only one header record per file you could use record #1 v. all other records. Store the substring'd header...

prasson_ibm wrote:I saw they are running datastage on unix platform,thats why i suggested.

Why don't we start by suggesting DataStage solutions and only fall back to the O/S heavy stuff if there's no other choice or the "in job" solution is... unwieldy.

Ray - They're deleting based on date, about half of the records each time according to the stats posted earlier. As noted, continue to work with your DBA on what the commit interval should be and possible see about adding more transaction log space. Also as noted, that Array Size is the number of re...

It says "APT_IMPORT..." which could imply it only works in the Sequential File stage rather than a Transformer. And I see your TechNote notes the same thing.

SPuneet wrote:Can you elaborate more how do i make use of USERSTATUS. I ahven't used it

You could always search here... topics on it go back 13 years. Plenty of elaboration out there.

If other people can still see everything and only you on your PC cannot, then that would imply your repository is intact but that your client installation is suspect. In your shoes, I'd first try a reinstall. You can probably try simply reinstalling over the current client (is there a 'repair' optio...