DSXchange

Still think that clues will only come from this side of the glass if you post the proc code - and that from someone that speaks SQL Server. Me, I assumed you meant an Oracle procedure. Interesting, the 'O' in 'TOAD' stood for 'Oracle' but now that it's 'Toad' and they have versions for other databas...

Actually, the Pivot stage goes the other way - columns to rows, a.k.a. a horizontal pivot. You want to go the other way - a vertical pivot or rows to columns - and unless the 8.x version 'goes both ways' (so to speak) then you'll need to handle it yourself. Search the forum for 'vertical pivot' for ...

That's all well and good and, as I noted, something that works just fine for me - dsjob is able to restart it without issue. If you are saying that you can't, that when you use dsjob to try and restart the 'main sequence' it fails, then you need to contact your Support provider and ask them what is ...

Yes, you can use the Activity Variable $ReturnValue with the Execute Command stage name to check what exit status your command returned. There is also $CommandOutput if you need to check/pass whatever the command echoes to 'the screen'.

Of course. I just built a small test Sequence and forced it to Abort. The job status was 'Aborted/Restartable' and I was able to run the job and have it pick up with the aborted step simply by issuing a normal dsjob command. Are you sure yours shows as 'Aborted/Restartable' or does it just say 'Abor...

It is still returning 1 row with all the null values in the columns. If table has 4 rows then it is returning 5 rows with one extra record having all values as null. Can any one has clue? Assuming this "it" is a stored procedure, then no, with no code posted - no clue. That really should not be a D...

Ok, just wanted to make sure you're using a supported version of Sybase. So... have you configured DataStage for Sybase? Meaning, have a Sybase client installed on the DataStage server and the proper environment variables included in your dsenv file?

Umm, yah... more simply.

Your DBA should be able to handle configuring the instance to handle the load, whatever that entails. More details may be in the sqlldr log file.

Could be... verify that with your Support provider. Does it happen with any .dsx file or just this particular one?

What version of Sybase?

Hmm... I don't recall seeing that behaviour. Curious what other people have found, if I get a chance I'll build a little test case and see what happens on my system.

dsjob has got nothing to do with it, a Sequence job is either restartable or not regardless of how it is kicked off. And that's set in the job's properties.

Two things. 1) I don't believe this is something testable from the Manager as there is no user status area to update. You'll need to use it in either a small test job or just go for the real deal and see what happens. 2) You didn't actually include the 'RETURN(Ans)' part in your routine, did you? Th...

Welcome aboard. :D A couple of thoughts. Frustration would best be directed to whomever is your support provider. They get paid the big bucks to solve problems like this, have you opened up a case with them? Unfortunately, that '-99' error is an unknown or 'catch-all' type error and will take some d...