DSXchange

Mark j wrote:Thanks for your suggestions. I phrased my question wrong:)

See, Ray. So how was that goose?

Just in case you missed it, Rich - you can actually go back and correct your original post rather than posting a new one with the corrections. Also good to know at times, you can delete your own post provided no-one has replied to it yet and therefore it is still 'last' or most recent. It has come i...

Or never mind the clarification and wait for Ray to roll you up an all-purpose answer.

Mark - you might want to clarify exactly what you it is you need to do before people go off chasing too many wild geese. So... are you saying you have a field with text that can be seperated by any number (or perhaps a fixed number) of question marks or spaces or what? And then you need to turn it i...

A couple of things that will typically cause that error... You are using Custom SQL and there is a trailing semi-colon at the end of the SQL statement. Works in View Data but not when the job runs. You misspelled a parameter name you are using in the SQL and it went through with the pound signs stil...

Are you using it in a Constraint? They won't auto-rename like the Derivation links will.

I really don't believe that DataStage supports out parameters in a Stored Procedure. Perhaps in the future when the much delayed Stored Procedure Stage makes its debut, but not now. Search the forum for 'stored procedure', I seem to recall several prior conversations on this topic... but don't recal...

Yes, but how can you guarantee that all of the places you take a dot out are the only places you put it back in? There's more to it than simply putting one back in each space... unless you 'know' there will never be any other white-space in the string. You'd have to track those positions, I would th...

To expand a little on what Nag said, converting dates to an internal format (Iconv) and then subtracting them will give you the difference in days. You really need to become friends with both Iconv and Oconv as they are staples of date handling in DataStage. A third function that works well with the...

Unless you are running things around the clock, you could simply schedule this at a known 'dead' time - which is the route we went with.

Sure. Check out all of the command line options for the dsjob command in the Server Job Developers Guide. You can also search this site for examples of the specific options once you determine which ones are appropriate for what you are looking to do.

Exactly - that's what CAPITALS does, Oconv and MCT. Someone would need to test things as I believe the "words" it capitalizes must be white-space delimited so something with a 'dot' in it may not get treated as two words.

There is a transform named CAPITALS that should be close to what you need... not sure about the 'dot' part.

Ray has already pretty much covered this, just wanted to throw another log of opinion onto the fire. Warning, this is all "IMHO" stuff coming. I know that XML is all the rage among some circles and I've had people shake their heads and mutter about me being a Luddite for not choosing to use XML at e...

If you always need to add 15 spaces, you can simply concatenate that to the end of the field: MyField:Space(15) If the size of the field is variable, put some logic in the function: MyField:Space(15 - Len(MyField)) You can probably also do it with the FMT function, check the ...