DSXchange

Welcome. Not a big fan of people just posting input and output samples and then sitting back and waiting for a solution. Show us what you've tried, how you think it needs to be tackled and what issues you've had trying to implement those thoughts. However... My first suggestion would be to forget ab...

Those are tabs and should not be your issue. Each EOL will be marked by a $ so make sure they are where they should be and not "in the middle" of any of them. Another check that might help is ":set nu" to show line numbers, make sure any long lines are only associated with a sing...

Or you could just pivot it as this one is as simple as they get so why complicate it?

Maybe this is just me, but to me that is... backwards. My admins are not gonna want some ETL knucklehead like me sending them email alerts about diskspace that we control the usage of. Right now, they come the other way - they monitor the usage and notify the 'owners' when thresholds are hit. I'm cu...

peep wrote:If so Wat is the logic?

Nope, Wat is a temple.

One could write a script to do pretty darn much anything. Space utilization monitoring is typically the domain of the SysAdmins, why not ask them to monitor that for you?

Yah, we skipped that one.

Where / how are you handling the encryption password?

I'm sorry but does that really matter? There are SO many variables to this equation that any number posted here really is meaningless when it comes to what you can do on your system with your particular jobs.

I'd wager that what is being done manually is the file is being opened in a editor, the header and footer are being deleted and the file is then saved. As to how to automate that, I'd look into something like sed which could remove the header & footer and then stream the result to standard out w...

That's all on your select query, assuming your target column is a DATE in the database. If you want it to come out in a particular format, you'd need to control the string conversion that is automatically going on. Oracle? Use "TO_CHAR" and the appropriate format mask. Others would be very...

Out of morbid curiousity, what kind of system includes a "randomly changing database table"? That just seems like... crazy talk.

As to the matching changes to the target table, is that meant to be automated in some fashion or is that a manual step?

Or you could just wait for someone to come along and hand you the answer on a silver platter. I believe in stimulating critical thinking and learning... teach a man to fish and all that rather than just handing him one.

I know, that's right there in your error message. You were meant to look at the question, answer "no" in your mind and then realize that you needed to fix the format you are using in the function call.

No, this is a Teradata specific issue. It's been discussed here before so a search should turn it up or you can go have a chat with your DBA.