DSXchange

Is there a way in datastage to read this value since we are calling the SP in the before SQL? Read it? No, you don't have that ability before or after sql. However, it should know if the procedure completed successfully or aborted unless you're saying the procedure is configured to always "suc...

Was curious if the dataset was ever valid (and then was corrupted later) or if it started off life that way. Let us know what you find out about AV on the server. If it is there, it might be as simple as excluding the directories where DataStage components live from being scanned. Another thought - ...

Good to know. Was mostly worried about the new source file comment where each "may have different number" of columns to checksum.

Out of curiosity, do you have the toolset you need to do the "masking"?

Who comes up with systems like this?

"Let's send them a file where the columns can change daily and ask them to 'dynamically' mask a subset of those columns." <snickers>

"Brilliant!"

If you are using the same values that work for dsexport and they do not for dscmdexport, then I would suggest you involve support.

As to your one more question, it always exports everything.

... and that is valid for a "generic" job? As in one using RCP, I assume.

Doesn't really help to simply repeat your original post word for word. :? If you have access to the command line, you can "call" any of those that you wish. I would imagine you would want to script whatever you need done and then call the script rather than trying to do everything at an at...

So it was corrupted somehow, it would seem. Perhaps a support case is in order in case this is something that they are aware of on your platform / version. Otherwise, it is hard to say... did the job creating it finish without error? Did you run out of disk space wherever it is being created? Being ...

Make it... not temporary.

I would imagine what's going on is they're not in fact "in the same session". DataStage makes a separate connection to run the stored procedure, which establishes a new session, and then when the procedure ends and the connection is closed, the session terminates and the table is dropped. ...

Right... rather than jumping straight to your perceived solution, how about letting us know what your actual "issues" are first?

With 'month' being a relative term, it would seem.

Was thinking it was probably a uvconfig issue where one of the parameters needed to be bumped up. Thanks for digging that up! :D

I don't have time for the searching this morning but answers on the subject of how to find gaps in dates / date ranges have been posted here before. Hopefully someone can dig them up, or I can try later. Edited to add: An exact search for "between two dates" returns 64 results, something i...