DSXchange

In datastage 8.5 we have an option to read sqls from file located at particular location.Do any body have idea on this ,if so could you please post the right approach to do that....

Thanks all

It was not done intentionally ....i didnt check my caps lock on....sometimes it happens ......

CURRENTLY MY DATASTAGE SHOWS EMPTY DSN LIST.SO AM UNABLE TO IMPORT TABLES METADAT.

you are true....if the elements name could be the column names and if there is any repitation element it could be easily to acomplish.

I was able to generate the above format but am ending up using two xml output stages ...is there anyway to do in single xml stage.

I dont have XSD.

Thanks craig for your valuble response.

Thanks Ray.But am new to xml.our requirement is to generate the above xml for each record.could you please through some light on the difference between pretty and functional xml.

Hi all I have below requirement for generating xml output. Below are the columns DEPT and its value 01 likewise class and its value 02 <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> <RECS> <REC> <PROPERTY NAME="DEPT"> <VALUE>01</VALUE> </PROPERTY> <P...