DSXchange

Talk to your DBA, see what they suggest be done. If you're running into a lock and need a 'dirty read' see if whatever stage you are using has a 'Transaction Isolation' setting of 'Read-only' available.

It's pretty obvious what's going on - you are trying to drop a non-existent constraint 'After SQL'. The question is why?

Ah.... Milla. :D This really should have been resolved by now. There's no way you should have to reboot the UNIX server just to unlock a job. Did you grep for any UNIX processes related to this job? If those are gone, then all that should be left are internal locks that need to be released. Try thes...

rafik2k wrote:As per DBA this is not network issue.

Wrong person. Talk to your Network guru. And there's more to it than just 'ping' - have them check their logs or monitor things for you.

I'd have to see the actual job and have access to the source data to know what was going on. I just know it ain't that.

Are you sure it was deleted? Space issues in the DataStage installation filesystem can corrupt everything and make stuff 'disappear'. Search the forum for DS.TOOLS or DS.REINDEX for discussions on rebuilding the repository indices. Otherwise - Repromote it from Version Control. Reimport using the Ma...

Nope.

But first you need to figure out why it is getting to be 'huge'. Is your job aborting? Keep in mind the fact that aborted jobs don't 'auto-clear' their logs. Otherwise, the other thing that comes to mind are it must be chocked full of warnings. There's no reason a Server job should ever log a warnin...

One way would be to use a Sequence job to run other Sequence jobs. Or a script using several dsjob commands without one of the 'wait' options specified.

I need to write a routine which can call an oracle function. No, you don't - nor would you really want to if you knew all that would be involved. Two fairly easy ways to consider: 1) Write a script to connect to sqlplus and run whatever query you think you need to check for data. Spool the output t...

chulett wrote:Do you have that odd View turned on? I forget what it is called - Server view? It doesn't allow movement from what I recall.

I was thinking of 'HostView' but that doesn't disable job movement - 'Extended job view' does, however. Either that or it's something buggy in the 7.5x2 client.

My ^M peeps? Sure, what the heck.

My suggestion was for use with a Timestamp datatype, not Date. If your generated SQL is using a TO_DATE mask of 'DD-MON-YY' then you must match that with your derivation: Oconv(Iconv(DSLink71.HIRED, "DDMY"),"D-DMY[2,A3,2]") I can't tell if "11/03/07" is November 3...

Do you have that odd View turned on? I forget what it is called - Server view? It doesn't allow movement from what I recall.

No worries - I just found it amusing because 'dismal' was a better word for the week I'd been having, not your data. Interesting... AFAIK that should happen automatically when the metadata doesn't support the actual data it sees. I'm going to have to defer this to more smarter people as the nuances ...