DSXchange

Well, that's good news. Can you please mark your topic as Resolved now using the big button at the top of the page? Thanks!

8.now or 8.future?

So... have you been using this ODBC connection for some time now and this issue is only with this particular job or is this newly set up and it is the first time you are attempting to use it?

So... no access to the xsd for this file? That's how one would typically get a full set of XPath expressions generated.

Don't use the Sequential File stage but rather the External Source stage as noted here in Dr Ostic's Sing-Aong Blog.

I've found it as well as noted here but only with the "Pivot" stage, not with the "Pivot Enterprise" stage introduced in 8.1. What version are you running? Seems like a message handler to demote this would be the way to go.

OK. so what exactly is your issue again? As Arnd noted, that 'pivot' or base date has not changed nor is it configurable in any way that I'm aware of.

What I would see are green Info entries like this: Oracle_Enterprise_child,3: Records inserted: 0 Records used for update: 0 Records rejected: 1 Total records: 1. Oracle_Enterprise_child,0: Records inserted: 7 Records used for update: 0 Records rejected: 2 Total records: 9. Followed by the ever popu...

As noted, that "-jobstatus" is a "wait" option as well - both cause the job to wait to finish before returning, what changes is the status returned to the caller. As noted in the documentation.

No, not in a Server job. You're probably going to need to refer this to your support provider to see what your options are there. It seems to be getting confused about your need for a key with no where clause in your query, not to mention the parameter marker is part of the 'from' clause here. And k...

All jobs in the project or individual jobs, those are your two choices. In order to get just "your jobs" or jobs in a category, you'll need to build/have a list of the jobs in question and then iterate through them getting one job at a time and appending them together.

Right... so why not use the Oracle stage to "call" the stored procedure?

Then account_nsp_id should be marked as a Key. And I assume your column order in the stage matches the select order in the query, yes?

Correct, you'd need to write a custom routine to leverage that. Plus convert all those commas to Field Marks or Value Marks or some kind of dang marks first.

asaf_arbely wrote:On the oracle stage there's a check box "use os level authentication" that works

??