DSXchange

Gee, thanks Ray.

That RESTART option is only valid for restartable Sequences, i.e. ones with checkpoints enabled. Is that the case here?

Okay, so... basically worthless. Just going to stick with my earlier reply.

Any chance you still have a link to the website? Would be curious to see the discussion. I don't recall there being an "ExecuteSQL" function or routine available out of the box, so guessing it is one they built in-house. And also guessing what it does is call sqlplus (or whatever passes fo...

How did you configure the stage? Anything like what is detailed here?

Interesting... never occurred to me to leverage the filter in that stage on the way out, thought it was all about on the way in. I'm guessing it would be working more better if you weren't doing the 'create multiple output files' thing. You'll probably need to involve support for an answer.

Can you give us an example of what log entries you want versus what log entries you receive and the actual syntax you used? I could almost read into your question that sometimes it works and sometimes it doesn't but guessing that's not the case. And just to be anal, there's only one job log, the one...

That was what I was thinking of and referring to, job number and all. Pardon my aging brain but what other import mechanism is there? I mean what other one would not do the delete/insert?

abyss wrote:chulett: if you think i can get rid of if statement, what's the way to work around it.

Posted that in my first reply.

Is that approach working for you?

Done.

You also never clarified what actually gets logged in your original code, specifically the one with "userstatus" in it. Still curious about that. Since you said it didn't work. Also, clarify something. You keep saying "BASIC Transformer" - that is a very specific stage in a Paral...

abyss wrote:I think the problem is from if statement, control flow always get into the else part. but i don't know how to fix it.

The simplest way? Get rid of it.

Thanks for that.

Unless things have changed, from what I recall when you import a job it completely replaces the original version of the job - i.e. it deletes the original and then imports the new version. Meaning I believe that the "creation date" would be the date of the last import... assuming it was im...