DSXchange

According to what i learnt recently, is that a semicolon is not needed for a DML (delete) where as its needed for a DLL(TRUNCATE) command. But your observations are making me question my knowledge. I don't believe in that other thread that anyone actually confirmed the DDL v. DML assertation for th...

Interesting... this seems to contravene this post which makes the exact opposite claim.

DSGuru: you'll note that both statements work without the semi-colon while both statements fail with it.

But first suggest you make sure you have exclusive access (which is required or it will not work) to DataStage and then retry the reindex command. Do so by stopping and restating DataStage, then run your command while you're still alone. Far simpler than starting over again.

You need to double-check that you actually have the sdk routines in this 'production' environment. The transform you used is just a gateway to the routine itself and it will happily compile without the routine there, but will blow at runtime. I'm not sure why in the heck you wouldn't have them all a...

As noted - details, please. An example of your syntax used would be good, plus whatever echo'd to the screen.

Did you read the post I linked to? The blue letters there can be clicked on and will explain what you need to do. Short answer is modify your dsenv file. DataStage isn't missing anything because it's not the one that needs that mapping - Oracle does. So nothing to download or install, just a little ...

What we want to know is that ..in the DTD we have the features of the elements like minimum occurence ,maximum occurence,op[tional ,mandatory etc.,How to bring in those into the meta data? You can't as it's not supported. Closest thing would be to use the 'Nullable' attribute for Optional/Mandatory...

If flag1=0 and Field 1=1 then @TRUE else @FALSE If flag1=0 and Field 2=2 then @TRUE else @FALSE If flag1=0 and Field 3=3 then @TRUE else @FALSE If flag1=0 then @TRUE else @FALSE You all do realize that this 'if then else' to simply set something to true or false is completely unnecessary, yes? Deri...

Right, something very much like that - but without the hard-coded timestamps.

You don't any special routine to do this, just one of these: = Yup, the unassuming equal sign. First, however, make sure your timestamps are in a 'comparable' format, like an ISO standard - that will work just fine: YYYY-MM-DD HH24:MI:SS Two timestamps in that format can be compared for equal, great...

It must be an issue if it's not working for you. The 'sort spec' must consist of the column names that you want to sort by, in the order you want them sorted. Each must also specify whether it is an 'ascending' or 'descending' sort. You cannot mix case there so 'Asc' will not work there, it must be ...

Where are you going with all this? You start off by asking: plz help me with the command that displays my job, regarding my metadata and transform components used And you then ignore perfectly good advice that you can get all that by clicking one button in the Designer. Ok, great... now you've got ...

You could always subscribe to their newsletters (they have two) for a no-charge peek into their world.

You find yourself at the top of a cliff. Before you are two paths to your objective at the bottom: A) A long, winding, treacherous path known only to mountain goats and the Hill People who have lived here for centuries. Many have died attempting to take that route. B) A shiny new express elevator. Y...

Again with the hard way, DS.