DSXchange

Lyman ...

You're on the right track - the MSXML 4.0+ parser must be installed - this was causing your messages.

And Peytot is correct: whoever is logged on to MetaStage must have read/write/select access to the underlying database.

... tom

Erik ...

You can pose MetaStage questions here and you can also visit:
http://DeveloperNet.Ascential.com (if your company holds a DataStage license) where you will find a "MetaStage" forum.

... tom

James ...

There are bi-directional MetaBrokers available for Impromptu and Impromptu60. The PowerPlay MetaBroker is Import only. The MetaStage CD will have a pdf for each of these detailing the object classes available. Sorry, but can't offer a "tips and tricks".

... tom

8. Using DS Manager, import all COBOL copybooks. How is this going to effect the migration from Prism from DataStage? What will happen in case I don't export the copybooks? For example if I have two tables, one is used as the main data source and the second one for lookups. To design a DataStage jo...

Geppo ...

I don't understand ... would it not be better to stay "within the tool" and use the DS MetaBroker?

Where are you sending this captured meta data?

... tom

gdean ...

Let me do a little research over the weekend ... it's been a while and am a little rusty.

And Ken's right. I'm probably rusty from all the fresh salt air down here. And I've certainly had way too many margaritas and far too much lobster, grouper and hammock time ...

gdean ... I've got about 6 years of Prism experience so let me offer a few thoughts, bearing in mind there is no way to automate this: 1. Sometimes some very bad habits emerge if no one has been watching the store: do a diff between the COBOL code presently running in production and the code you gen...

Peter !!!!! Welcome !!!! For those who are not subscribed to DWLIST (THE data warehousing forum), Peter is one of their heavyweight "Inner Circle" gurus. We are very pleased to have your (future) input. :D

... tom

Hi folks ... I've got a rookie error here, but I can't get past it: when I use KeyMgtGetNextValueConcurrent in a Transform stage it fails. So I go look at it and press Test. I get <<ERROR>>. Huh. So maybe it needs a compile, but the Compile button is grayed out. So I make a copy of it which enables ...

Dfong ... It is my understanding that you can use a custom metabroker to import spreadsheet information into MetaStage. I've not done this, but one of the meta data folks at Ascential suggested it as a working solution. If you don't have MetaArchitect, call Ascential and get an EVAL copy good for 3 ...

dfong ... Been thinking about your post and wanted to offer a thought or two: 1) to put data mapping specifications into MetaStage would mean they would have to exist elsewhere and be imported. If your focus is on your DataStage environment, when you import from DataStage to MetaStage, Job Design so...

James ...

Yes, all of these may be captured.

... tom

Craig ...

AaaHaaaa!!! Thank you. Did not realize that the Transform called the Routine and that the Transform is what I should be using.

... tom

Hi Folks ... In the Designer I open a Transform Stage and rt-clk an integer field called trn_skey, choose Edit Derivation, then rt-clk and choose DS Routine. What I want is KeyMgtGetNextValueConcurrent, but it is not visible. I can see it in the Browser, and I can see it in Manager, but it is not av...

Mike ...

Super! And thanks ... your next-to-last post was the one I needed - didn't realize you could throw DD names into the parameter grid. Really appreciate the help. :D

... tom