DSXchange

I sincerely doubt you need to quote anything. And you really shouldn't be typing this in by hand but rather using the "External Parameter Helper" you can find under the "..." button so you can pick them from the list of valid values. Feel free to edit them afterwards (a little) b...

Use that function in a routine.

Off the top of my head:

prasanna_anbu wrote:Have you resloved this issue? If so please help me on this.

Rather than jump on the end of an old thread, why not start your own post on the subject? Give us the details of your problem.

Did you search for "ParamValue/Limitvalue is not appropriate"? That would tell you that (for whatever reason) the string still had a Field Mark in it. I'll also note that the angle bracket notation certainly is supported in any release, it might just be the "where" of it that has...

That probably came from me, I believe I failed to translate ExecSH properly to DSExecute when we entered the Routine Realm.

Search. I found 53 matches when I did an exact search for "does not fulfill the sort requirements of the downstream operator".

I'll have to defer to someone else on that as I don't know for certain and have no ability to check. I would certainly think you should have a PX version of it...

All stages are supported on all operating systems. The only exception that I'm aware of would be Windows specific ones (say, SQL Server) on a UNIX release.

From what little I've read, a "J2EE Engine" supports ODBC access. You may end up needing to purchase the drivers needed but I would think you could go that route.

I have tried rtn.<$ReturnValue> .But it gives "Expected Expression". I'm curious why in the world you would have tried that? All I meant was for you to replace one set of brackets for another, not completely change the expression. :? What happens when you try rtn.$Returnvalue<1> there? Ma...

What have you tried? Do you have the spreadsheet on the DataStage server in a delimited format like csv or is it still an xls file?

DSGuru2B posted a PX version of the Server Replace() function which should do what you need here. An exact search for PXReplace should turn it up.

From what I recall, it also spells out that the Sequence must be created by a DataStage job rather than manually. Yes?

:!: I'm firmly in agreement with James on this. I'm tired of and not going to be guessing at the answer to "questions" where all that is posted in an alleged example of the input and the desired output. :? Lay our your requirements, people! Spell it out in words. Tell us what you've tried ...