DSXchange

... and off you go to your own topic.

Split from this post if anyone is curious.

Welcome to the Server job questions forum.

I'm assuming they meant to increment/update /select "in one operation" but wanted to see that spelled out before taking it any further.

The "mask" you use with the function describes the incoming string's format, got nothing to do with what you want it to look like - a date is a date.

Correct... only convert it after you know it is valid.

"in an atomic way"?

That would be more of a DBA / sqlnet configuration discussion. For example: http://www.dba-oracle.com/t_ora_12170_t ... imeout.htm

It is related to the ctl file being generated as it specifies CHARACTER for the fields. Perhaps there is a patch available for this?

Meaning, without it being reproducible you'll probably never know.

Meaning, when you run it from the command line does it need to ask a question or prompt the user? That is a common cause of 'hangs' like this as the question can't be answered.

That's about as "automatic" as it gets.

Would need more details. How are you importing? Does the database contain a large number of tables? Have you tried... waiting longer?

moving this to the General forum...

You need to LOGTO an actual project, not UV.