DSXchange

It wont work. Your job will either fail, or process zero records from file2 if the file is present. Both the streams will fire off simultaneously.

Will the file be empty? You can easily do this with a few lines in a shell script.
psuedocode:
-isolate the column using awk
-grep for the value, if found create the file.

Please go through the manuals or seriously consider going through training.

15 in one. Not a good idea. Keep them seperate. If you really want to get fancy, execute them within a script, create 15 flat files that will contain the result of these stored procs. You can then read these file from within datastage. Now that I have explained that, it doesnt seem very fancy anymore.

Search for it. A lot of posts. One just recently answered.

I jumped ahead of myself.
Change the default timestamp as I advised. Use the TimestampToString() function to change to string and then do

This will give you the day

Set the default for timestamps as %yyyy-%mmm-%dd %hh:%nn:%ss.

Please search for it. This has been covered gazillions of times.

You have two ways. One way is to sort on the keys, do the group change dance using stage variables and flag them. Constraint on the flag for both the target database stream and the reject stream. Second way is to load to a hashed file keyed on the two keys. Before loading it reference the same hashe...

Try this as a workaround. Create a small routine that runs your command. FiletoSearchIn=Arg1 CMD = "grep -i 'Totals' ":FiletoSearchIn:" | wc -l" Call DSExecute("UNIX", cmd, output, rtncd) Ans=output<1> Call this routine in routine activity stage, which will repl...

There are several ways. Tell us this, do you want to restrict all key combo that has duplicates or retain one and send the duplicate row down a reject link? If the latter then how are you identifying it as a reject, is it the sort order coming from the flat file?

Did you try pass it as it is? What is the incoming timestamp format?

There has to be other surrounding error messages. Can we get those as well. Also a little background on your job design, what your trying to accomplish , would be nice.

Yea. You are write. I am able to reproduce the error at my end. And yes the hashes seem to be required. What exactly are you doing with the execute command stage? Are you just cat'ing a file?

Not in stores yet, they are all over the place. Ok well I am more like an internet shopper so they are present online.
A Wii person is more like....I dont know, just a Wii person