Import Remote UV File Definition

jpg1dmg · Post by **jpg1dmg** » Tue Oct 31, 2006 2:04 pm

When trying to import a Universe File definition we are getting the following error messages on some of the files

DSR.MetaGeta(GET.FIELDS): M is not a valid SQL type
DSR.MetaGeta(GET.FIELDS): D is not a valid SQL type

Any ideas what is causing this issue.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Oct 31, 2006 2:17 pm

Welcome aboard! :D

You have some badly constructed dictionary items in your UniVerse (hashed) files. One has a "D" in field #8 of a "D" or "I" type field. Another has "M" in field #8.

It may be that your UniVerse application is using field numbers between 8 and 20 in contravention of advice given in the UniVerse manuals.

Do the table definitions get imported OK despite this warning? If not, you will need, at least temporarily, to clear the contents of field #8 while you are importing the table definition in to DataStage.

Another possibility is to create a separate UniVerse account with "F" pointers pointing at the actual data but at local, clean, dictionaries. This is often an approach used by UniVerse sites to which ODBC or OLEDB access is required from UniObjects and other applications.