DSXchange

lstsaur wrote:I am using JDBC in my Java stage. JDBC enables you to handle difficult tasks such as Ref Cursor or BLOB easily.

Hi lstaur, do you have any examples or sites / references that helped you get started w/ the JAVA Stage? Seems like you have to write java class for it right?

Hi there, is anyone using JDBC to connect to data sources within a datastage job? I would be interested in seeing how its done/ your experiences with it.

thanks in advance.

You want service on the weekend sign up with your support provider for priority service, and learn just how much "urgent" costs. This is an all-volunteer site whose members post when they can, and usually only if they have something to contribute. Things like your "bump" are off...

You want service on the weekend sign up with your support provider for priority service, and learn just how much "urgent" costs. This is an all-volunteer site whose members post when they can, and usually only if they have something to contribute. Things like your "bump" are off...

I'm going to disagree with your "longer" comment unless you specifically mean in a recovery situation where it may take longer because you have to load "everything" again and you could be waiting for the rollback to complete. True, but I'll take that over any kind of a "man...

If at all possible, I prefer an "all or nothing" style of load where commits are only done once at the end. That means a restart is simply a restart and something that can be handled at the job contro ... It seems like an all or nothing be style would take longer especially if you are han...

There is no "automatic" functionality if you are talking about restarts at the job level, i.e. inside a job. Sequence jobs can automate restarts between jobs but I suspect that's not wha ... Yes, I saw that job sequences can create checkpoints to restart jobs, but at a more aggregated lev...

Hello,

I was wondering if anyone could point me in the right direction to get information on DataStage functionality to automatically restart jobs/ set checkpoints for recovery if a job fails midstream.

Your thoughts would be appreciated.

TIA.

bump, anyone?

Hi gurus! I was wondering if you all would provide a recommendation on the most efficient way to connect to DB2 on z/OS? I see some native options within the database palette but they seem to just be for DB2 UDB. Can these be used for DB2 on z/OS as well? Any thoughts on the most efficient way would...

Found it: XPATH was the correct issue, I had no idea, that resided in the "DESCRIPTION" column of the XML Output Stage (Input > Columns > Description) That had to be mapped correctly for it to work, the best thing to do would be to use a table definition instead of quickly putting columns ...

This typically means your XPath Expressions are not correct. How were they generated - from an xsd or manually? Can you post some samples of what you are trying to generate and the XPath Expressions you are using? Hi there, this is my input Sequential File: 0001, Company, Lee, Chen, Lee@gmail.com I...

Hi all, I'm trying to figure out what I am missing. When I run my job, everything looks fine and green, but no XML file is generated out of my XML Output Stage. I have checked the box to Write out the XML output but no file is ever created. I have also referenced the IBM example, and still did not g...

Thanks Craig for the welcome and response! If anyone else has a different approach, I am all open ears :) Welcome. :D There's no way to do that kind of 'refusal' that I've ever seen but perhaps someone else has. As far as I know, you'll need to create another version of the job minus the web compone...

Hello there, pretty new to the Datastage product, and new to the forum. I have a quick question: Can Datastage jobs that are enabled to be a web service be REUSED to run for batch file dumps? I.E., you create a datastage job to add a new user via a webservice, that would work for quick hits from web...