DSXchange

Depends on your target what 'date format' means. And depending on how trustworthy your data was, you could just use substring to get that into date format or combine that with IConv/OConv if there were any doubts. Check out your online help for the IConv/OConv functions using the 'D' and 'MT' conver...

Not alot to go on, and more of a sql problem than a DataStage one. What database? I've found that your first line of defense for things like this is usually your DBA - have you taken this to them, see what they suggest? There are all kinds of things that could help, but knowing nothing about your en...

Perhaps some prerequisite has not been met, like the latest version of .NET or something else of that ilk? Does the readme give you any information along those lines? Worst case, contact your official Support provider and then let us know what comes of it.

But you have to manually close Explorer, yes? That's going to be your issue, I'd wager. Perhaps there are some command line switches available that would put iexplore.exe into a 'batch' mode?

Yes, that would be wrong. What happens when you run it from the command line?

I'd suggest you ask your DBA that question.

Well, then it sounds like you are out of luck. A check of the Sybase OC pdf documentation confirms the diagnosis - Text is an unsupported datatype. Great, three posts in a row. Actually, the docs I checked were 7.5.x docs and you've marked this as an 8.x job. What does your version of the documenti...

Updates an XML file? Ok, I'll take your word for it. You might want to consider a more... traditional... approach using the XML stages. Does the batch file run to completion from the command line without any user intervention? When something like this 'hangs' it is typically waiting for a user respo...

Welcome aboard. I'm curious... what exactly are you expecting this batch file to do? What is the point of hitting a website from inside your job? I'd be more interesting in hearing the problem you are trying to solve rather than the method you've chosen to solve it, which makes zero sense to me at t...

I'm not sure what the difference between 'server time' and 'system time' would be. All I meant by that was I don't see a difference between the two terms - they are synonymous, identical, can be used interchangeably. And the answer is still "the time on the DataStage server". Doesn't matter where t...

Have you tried uninstalling and reinstalling the client? What operating system, by the way?

Yes, you can use them. Of course they bring performance penalties with them. And, from what I recall, you'd need Server installed on every physical machine the job would run on.

I'm sure there must be something on 'Server Shared Containers' in the docs.

Actually, that's true of the 'OC' stage, a Server stage. Have you tried (or are you using) the Sybase Enterprise stage?

Well, then it sounds like you are out of luck. A check of the Sybase OC pdf documentation confirms the diagnosis - Text is an unsupported datatype. Any idea what the maximum length of the data in your Text field actually is? If it's less than 4K you could try casting it to varchar in your select sql...

'Rebuild' as in 'redesign'. And you certainly don't need to do this for 'all jobs'. Your existing jobs will work just fine as is, you should target those jobs that would benefit the most from the Parallel architecture first. That and take a class or arranging for some kind of mentoring. Parallel job...