DSXchange

kvsudheer wrote:I will certainly move it general forum.

You cannot, however I can - and already did.

Since there's no parallel in this discussion of how to write a certain routine, moving this post to the General forum.

On the subject of all of those "GoTo" statements - make sure you understand that it is all fall thru code after that. For example, once you goto ErrorExit you also fall thru ErrorExit1, GetOut & GetAns before finally returning the last value of "Ans".

Which unfortunately doesn't answer either of my questions. And obviously not "same as in ODBC" since you seem to be generating a field with "aaaaaaaaaa" in it which cannot be converted a date.

We can't without more information from you. Answer my question, please... are there any other kind of errors logged at the same time? If you restart them do they then run OK?

That would be a UNIX issue, ask your SysAdmin to look into it.

What exactly did you tell the Row Generator to generate? What is its purpose?

Fixed your ascii art for you... and I'm curious, how do you plan to convert 'aaaaaaaaaa' to a date?

Did any of the things you tried address the "system-wide limit on the number of mmap'ed shared memory segments"? Hard for me to tell.

Somewhat of an apples and oranges comparison to me as you'll always need a scheduler of some sort but not necessarily Sequence jobs. And, as Paul notes, there really is no "one size fits all" answer here. Keep in mind the fact that Sequence jobs allow something no "external" sche...

Another reason would be that if we make changes at a dsenv level, then we have to get all the different projects owners to agree to an outage so that I can restart Datastage... but if I do it just using project level variables then I can make the changes to one project without having to inconvenien...

FranklinE wrote:If the reality is the latter, I don't see them being motivated to get started.

Point taken.

Most (all?) other ETL tools provide one so it surprises me that there still isn't one for DataStage even given the fact that it will need to be scratch-built.

As noted, you didn't need to do this as the file is perfectly readable as is (or "as was") in DataStage.

Dmitriy wrote:I used it but with no success

Where exactly did you use it?