schema

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
r
Participant
Posts: 13
Joined: Tue May 17, 2005 6:16 am

schema

Post by r »

hi,
i have to extract the schema of all input and output files. is there some way i which i can do it at command line instead of searching for the files in the xml generated
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

Post by bcarlson »

If you have exported the DSX to a file, you can pull the schemas from that. Open the DSX in an editor and search for the word schema. It should look something like this:

-schema record
{record_length=fixed, delim=none, ebcdic, native_endian, binary}
(
FIB_CDC_APPLICATION_ID:string[15];
FIB_CDC_PAGE_NUMBER:int32 {text, default=-99, width=5};

... etc.

)

I am sure there are probably other methods, but that's the first that comes to mind. We export the DSX file to keep in version control along with the rest of our code, so we always have a DSX file available. But not everyone does that.

HTH.
bcarlson
Post Reply