DSXchange

I've learned to make absolutely no assumptions about what people mean here, there's all levels of experience and you might be surprised at some of the inventive ways people do things.

Specific examples are always best to eliminate any potential confusions.

So, you've hijacked your own thread and completely changed the topic we are discussing? Nice.

I do "'" : jpMyDt : "'"

Don't do that.

Add/Remove Programs, just like any other software.

By 'random issue' do you mean that sometimes an empty file 'loads' and other times the job hangs?

What have you tried? Sounds like you just need a 'Nested Condition' stage to control the downstream actions.

Define 'right'. You turned a parallel bulk load into regular sql inserts, so of course it takes longer now. What problems were you having before you made this change?

Post your job design.

What changes between the time when it works and when it doesn't work? Have you asked your Sybase DBA what this might mean?

That cannot be the complete design. What happened to "HashfilestageName"? And there's no way it would add an "IDENT3" stage with that design. :? Scroll around and make sure there's no "extra" bits off screen somewhere that you don't know about. Worst case, export and re...

'Compiling' and 'Testing' are both a button push, so not much to talk about there. Go to the Manager, find the Routines branch of the repository and option it up. Pick routines at random that seem interesting and double-click on them to 'open' them and see their properties. Everything will be there ...

I've never used this option but confirm something for me. Your "O/S user" that runs the job - are you absolutely certain that you have a matching user of the exact same name with the exact same password in the instance you are trying to connect to? There's no way that I know of to "as...

Perhaps by... posting your job design?

Well, I did ask for 'before and after', meaning working and non-working versions. I'm assuming that was the former, can you post the latter? I for one don't want to guess exactly what you mean by 'comment out'.

I don't use it. In all the years I've done DataStage I've never been anywhere that did (or needed to) use it. Hence, I tend to forget that that option exists. Simple as that.