DSXchange

Yea, thats what i thought. If its server, then use my suggestion, if its px, use ArndW's suggestion.

Use ICONV to change them into internal format. For date coming in from oracle, use substring to extract the first 10 characters (Date Part) and apply ICONV to it. Then do your comparison.

Wow. It would have certainly been a kick for their users and some memory to share with us new kids on the block.

I never got a chance to witness those machines
Heard about them from my univ. professors.

I think you need to filter your results then pass it through the aggregator. If you are aggregating before doing the filtering, it will give you one record for each group.

Ok. Now i see. That's pretty straight forward. So basically instead of UNLOCK, i will have myUNLOCK which will perform the UNLOCK command and also take some audit details. Hmm, thanks ArndW.

As Ray advised, add the month names using transformer and then use the pivot stage. Read about its use in the manual guide.

If you want to re-run a job on a checkpointed mechanism, even though it was successful the last time, check the box that says "Do not checkpoint run" inside the job activity.

Hmm, interesting. So that means if an audit routine can look upon the UNLOCK command. It can look upon other commands too, right? Just for educational purposes, how would you do that.

dsjob command has many options for logs. -logdetail, -logsum etc. Use that to get the log into a text file. You can then parse that text file to bring it into a delilmited file with all the information you need.

This error usually occurs due to the fact that your input data is larger than what is expected. For specifics, do an exact search on the error message, as advised earlier.

Check your dsenv file and see if APT_LINKER and its sub-ordinate, APT_COMPILER and its subordinate, variables are set, properly.

The first part is easy, pass it through the aggregator, grouping on Col1 and provide 'First' as the derivation for Col2.
As for your second requirement, i have a followup question:
Do you want 10,200(in your sample data) to be in your reject file as well???

Load your file into a temp table and write a sql query.

Its a range lookup. Search on the keywords "range lookup". Do an exact search.