DSXchange

To work from the command prompt you would build scripted calls to 'dsjob' and the various options it has. Check the Command Line Interface section in either Designer's Guide pdf for the options and their syntax. For all of the DSGet* functions that you would use in a derivation or more likely a cust...

No. A shared container is just a chunk of reusable code / job design and won't faciliate the sharing that you need. Can't you have the first job 'land' the data such that the second job could leverage it without having to redo all the work?

Yoikes! Hopefully this was a cut-and-paste Full Wurlod and not the budding novelist in you coming out.

Four different ways? Can you lay them out for us, Uncle Ray? I've always gone with the basic two that I posted, are we talking variations on that theme? Guessing so, based on your "and whether or not" VOC entry comment.

I gave up I put a request to the DBA to change the procedure to have the procedure parameters as VARCHAR and i sent them the to_timestamp sql to modify that field. So now I will just pass it as a varchar throughout the datastage job THanks for your help. Datastage really has to do something to be a...

A couple of points. If you read the docs, you'll find that TIMESTAMP types are not supported, so you need to play some games. Use a Varchar field in the job and a TO_TIMESTAMP() function in the sql rather than a TO_DATE(). Remind me again, what is your target stage? I don't think you've ever specifi...

So... this is a TIMESTAMP field in Oracle, not a DATE? One last secret?

And post several examples, include morning and afternoon times. I thought your first examples had AM/PM in them...

My help doesn't seem to be helping all that much. :wink: Post some samples again of what your input data looks like, the 'timestamp' information you are trying to convert, maybe I'm missing something there. The code I posted earlier should work fine for the date portion, I'm unclear why it isn't wor...

Umm... what? That sentence doesn't make much sense.

Post your code.

:!: The answer depends entirely on how they were created - pathed or in an account. For the former, then simply delete it from your operating system. Note that Type30 dynamic hashed files will consist of an appropriately named directory holding three files, and a 'dictionary' file at the same level ...

Don't assume. Build a test routine as suggested and make it work properly.

does making a datafield timestamp automatically place it in the format in datastage?

No, that's your job.

Rather than re-invent the wheel, search the forums here for 'ETLStats'.

You need to decide what the procedure needs to be when files don't arrive. I certainly wouldn't have this run forever. I'd suggest putting a limit on how long it will wait and check, make sure it cannot overlap with the next day's processing. That and send out an email when you fail to receive file...

And once the files are found and the set of jobs run, then what? Go back to waiting for the next set or are we done for the day?