DSXchange

spuli wrote:Is there a need to buy license to use realtime stages especially XML stage?

No, you are good to go.

Yes, that's a good alternative when you don't know how many columns may need to be pivoted or at least don't know the maximum number. And yes, available since 8.5.

Welcome. Normally we'd start by asking things like 'what have you tried?' and 'what issues have you seen?'. Show us that you've at least tried to solve your puzzle before you came here and just posted input and output. In this case though, it's just a one word answer: pivot. More specifically: a hor...

You've got the "double convert" coded incorrectly. What you use for the list of characters are the GOOD ones, the ones to keep which is a finite list. Anything that does not match that list is what ends up being converted.

Agreed.

Looks to be here, copy/paste as a direct link won't work:

http://www-01.ibm.com/support/knowledge ... s/wlm.html

My understanding has always been that it is carried as part of the SQLCA or SQL Communication Area. Not really sure how (or if) one could get access to that in DataStage. Perhaps others do. Last time I recall actually taking advantage of that was way back in my Informix days. ps. Don't really see ho...

ODBC:

https://www.rssbus.com/odbc/ganalytics/

Technically 8.5 was broken and it has been corrected in 9.1. I know that's not the answer you are looking for but DataStage has always (as in from the earliest versions) reported the number of DML operations sent to the database. Meaning if you send one delete DML it logs it as one 'record' going to...

Clarify something for us so we stop making assumptions about exactly what it is you are doing. I understand your source and target are the same table. What I'm wondering is... One "ID" needs to be deleted and there are four records associated with this ID. Does the job send 1 record to the...

I'm curious... I see that this job is new but is this also the first time you've attempted to connect to this DB2 instance? Any DB2 instance? Or do all others work fine and the problem is just with this one job?

Wondering if you've done all the setup / configuration steps needed for DB2 access.

I was assuming you'd be testing your understanding then letting us know if they were indeed correct or not.

First I'd suggest you try the Server version of the Sequential File stage and see how it behaves, what you get. Document that here and then we can see where to go next if you need more help after that.

prasson_ibm wrote:Try to read the file with comma delimited and do not mention double quote in the job in file definition.

So their four columns will read / be parsed as six? Not really sure how that will help.

I'm curious - have you tried to read it yet? If so, what happened? The double-quotes should 'hide' the extra commas and treat them as data. If a Parallel job is having issues, try a Server job as they can handle flat files of that nature better. If for some reason that is not an option, try the Sequ...