Schema support - help needed

kjanes · Post by **kjanes** » Thu Sep 26, 2002 7:32 am

What type of Schemas are you trying to bring in? Database schemas/Table Definitions? For certain data modeling tools like PowerDesigner, you need to save the model as a PowerDesigner/XML format (which is an option when you save). Then, whe you import the schema to DataStage, DataStage uses the PowerDesigner Metabroker in coordination with the Microsoft XML Parser to bring in the schemas.

Does this sound like what you are trying?

-Kevin Janes

Kevin Janes

kjanes · Post by **kjanes** » Thu Sep 26, 2002 9:19 am

In DataStage Manager, under the menu item Import and then Table Definitions, there is a selection for XML Table Definitions that brings up a dialog that allows you to select schema types biz, xdr, and xsd for import.

-Kevin

kjanes · Post by **kjanes** » Fri Sep 27, 2002 8:54 am

We have been applying transforms (XSLT) to MetaStage output and came across the same message. To correct it, we changed the style sheet to the following:

OLD


NEW
- <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

If this is not applicable to you then I would suggest checking
http://www.w3.org.

-Kevin

sansan · Post by **sansan** » Mon Jun 23, 2003 5:49 am

Hi Shiva,

I'm also facing the same problem now like" W3CXML Schema'(XSDL)not supported".How can you import the schema?

Thanks a lot

ariear · Post by **ariear** » Mon Jun 23, 2003 4:00 pm

Guys !
What XML pack are you using it seems to me that it's the old one (from the CD). There is a new xml pack 2.0.1 (with a new importer) and the doc states support for XSD. give it a try

sansan · Post by **sansan** » Tue Jun 24, 2003 3:27 am

Thanks a lot,ariear.I'm currently using XML Meta Data Plug-in and version is 6.0.15. I'm not sure which version of XML pack I'm using. How can i check it? As I'm a new user of datastage.

Two more things I'd like to know that are:
1) I can create the XML doc from squential file stage by exporting as the XML doc in datastage manager.But is there any methods can i use to create XML doc in datastage designer without using datastage manager?
2) Can I create XML schema in datastage (i.e. schema is not imported from datastage manager)as I need to transfer some data that are from DB2 to XML schema for B2B usages? If it's possible, how can i do it?

I'm really need help to proceed my project.Thanks you very much.

ariear · Post by **ariear** » Tue Jun 24, 2003 8:11 am

Hi,
First ask your Ascential rep. for the XML 2.0.1 pack (I think it's free)
Second the Manager export is for DataStage Objects only (for Backup/restore and such) - You need to write a datastage Job that'll do this conversion between Ascii file and XML doc.
Last I believe you to have to take a course or some mentoring for a fast start

ray.wurlod · Post by **ray.wurlod** » Tue Jun 24, 2003 4:23 pm

Where are you in the world, sansan?
You can seek the fast start training through your DataStage provider, or directly through Ascential (check www.ascentialsoftware.com).

HToroyan · Post by **HToroyan** » Thu Aug 07, 2003 6:33 am

For XML schema, use XMLMDImporter.exe from C:Program FilesAscentialDataStage directory. It works.

Hagop Toroyan
Sr. Data Warehouse Consultant
CGI, Toronto, Canada