DSXchange

Typically one would use an Aggregator to get this kind of count 'in job'. You can count rows or max the rowcount that Ray mentioned, then sent it to your target.

I don't see the correlation between the first question and this one, or with the other post which is why I split this one off. And I'm not sure how 'complex' what you are trying to do is. However, it seems like building those <Data> elements as chunks and then merging them together with the header X...

Really no need to do that for XML, but you could force it by including a record delimiter between each. Use CHAR(13):CHAR(10) for Windows or just a CHAR(10) for UNIX.

Welcome. It most certainly is a pivot, actually a "vertical pivot" of rows to columns. However, you are correct in that the actual Pivot stage only supports the other direction - columns to rows or a horizontal pivot - until the upcoming 8.5 release, at least from what I seem to remember I...

So, seriously... no backups of this? Not even an export of the project? Need to reconsider that policy if that's the case. Open a case with your official support provider and see what they can do. They should have people whom you can give access to your system (either directly or via a 'shared deskt...

It might help if you posted the actual abort message. XMLTYPE is not supported, at least not directly, except perhaps in the new Connector stage as Ernie mentioned. IMHO, you are better off with a PL/SQL procedure for this and there are lots of resources out there for that, for example here. Or you ...

The key question is where are you running this command from? You need to do so from the main project directory for the project you want to initially connect to.

As noted, it's not the database name you use but rather the 'data source name', the name of the entry you made in the ODBC configuration files for this database.

Therefor... signed.

Take a generic but applicable part of your message, say "because of a prior component with the same name" and do an exact search for it here. There are 37 matches for that phrase, see if any of them help you out.

The question is, what if anything works in the odbc.ini file in some kind of dynamic fashion? Can you leverage a $Something there? I don't believe so but have never tried.

No, but you can add a 'sort key' data element and then sort it again after selecting or use a "SSELECT" (sorted select) query in a UV stage but the hashed file would need to be in an account or have a VOC record created for it manually before you could do that.

Are you spelling the sequence's name and owner correctly? Do you have the grants you need on it? First things I'd check.

What "following error"?