DSXchange

What did you try and what error did you get?

Double-check the values you've supplied for Service Name, User Name, Password, Table Name and Schema Name. Something there isn't correct or you wouldn't have received the error that you did.

Actually, it can have quite a dramatic effect on job performance which is why it's important to keep them purged down as much as possible.

Yes.

That would be a Sybase error, something you could take back to your DBA to explain what it means.

First suggestion would be to post your question in the proper forum, which this is not. There is an 'Enterprise' / PX forum you'll find that this should have gone into.

Thanks.

I have done the reindexing on my Dev env. And you'd be surprise to hear that after the reindexing, not a single job was visible in the project. Scary, eh? Been there, done that. As noted, that's what happens when you don't have exclusive ( and we do mean exclusive ) access to the project in question.

Still curious what's so horrible about the 'Truncate then insert' action most stages support? Unless you are using ODBC, from what I recall it doesn't have that as a selectable 'update action', sticking you with the transactional delete of 'Clear' as your only option there.

None that *I* am aware of, but that doesn't mean much as we don't use SQL Server.

Best to put that question to your official Support provider I would think, see what insight (or patch) they might have.

Welcome! :D

There have been a number of discussions on this issue here that a search should turn up. I tried a 'search for All terms' search for 'license check' and got a goodly number of hits, including this classic one.

Hope that helps.

The Folder stage is great for bringing in multiple XML files or anything else where you need the entire contents of the file in a single record. When you need to process multiple 'normal' files, then you need to either concatenate them all together, do something similar in the Filter option of the S...

That example was Windows specific. Try using plain old 'sh' instead.

Yup, we've all been seeing the same thing today when people request a reply via email. There's another thread in the FAQ Discussion forum (why there I have no idea) on this same issue. Explains the plethora of multiple posts today.

They'll get it fixed.

In other words, yes. You'll need to enable the Contains Terminators option for those columns. Slide the Columns tab over the the right to see that particular option.

If you didn't have any data fields with newlines in them, then a "wc -l" for your file would return "1".

Do you own the 'SOA Edition' of DataStage? This would be required to deploy ETL jobs as services, unless that's bundled with 8 now.