DSXchange

Hi sachin,
How can I check repeating element , as there are many repeating elements in the same file ,At a time I can only select one repeating element in xml input stage,
can u Please elaborate .......
In my file I will have all repeating tags for different patients
Thanks

Hi, I have a requirement where I have to process xml file , and have job designed which works fine , folder stage --> xml input stage --> Seq file stage . Previously I had seperate file for each record , I mean in one file I have just one patient report record , My job works fine , Now I have the xm...

Hi earnie , Thanks a lot, what i did is , I changed one of the xml file as a standard template by replacing all nil expression , just to import meta data , then in the description i added \text() in front of that particular column , thats how i got null in the flat file instead of "true" ....

Hi roy,

Thanks ,
I will go thro' this best practices , it looks really helpful ,
if somebody wants to refer this doc , here is the link :

http://www.duke-consulting.com/DataStage_Tips.htm

Thanks ,

Hi , I am very new to xml , my requirement is source XML and target is oracle table , I am getting separate file for every patient report ,I will be processing 75000 at a time . I created one job : folder-xml input -seq file , I imported meta data from xml file ( I found out from one of the post tha...

[quote="chulett"][quote="knowledge"]I was using automatic mode but have to use manual mode since my database and datastage is residing on diff server[/quote] I use Automatic mode with my database on a different server than DataStage without issue. :?[/quote] Hi Craig , When I cha...

[quote="knowledge"][quote="crouse"]Also, cut and paste here all your values from the OCIBL stage AND the OCI stage. I agree with Ray, because I just tested it here, that you have something typed wrong relative to Service Name or User Name or Password or Table Name or Schema Name....

[quote="crouse"]Also, cut and paste here all your values from the OCIBL stage AND the OCI stage. I agree with Ray, because I just tested it here, that you have something typed wrong relative to Service Name or User Name or Password or Table Name or Schema Name.[/quote] I wish it is true , ...

I m using stage in automatioc mode ,

Thanks Craig , I will talk to my dba ,

Ray I m using Automatic mode , so no need to specify control file property rt ?
Thanks.

Thanks for the replay , I will talk to my DBA, but same table with same parameter I could load by OCI stage but not with bulk loaded , Ray where do I have to check for SQL loader ?(My DBA is new cry: ) Its loads in the same schema as OCI stage load then why only problem with Bulk loader. I m not sur...

[quote="chulett"]Double-check the values you've supplied for Service Name, User Name, Password, Table Name and Schema Name. Something there isn't correct or you wouldn't have received the error that you did.[/quote] Hi Craig , I checked it couple of times by changing parameters and even ta...

Hi , I m using datastage 7.5 server edition, I have a job with simple load logic : oci --transformer--oci which is working fine , for performance tunning I replaced o/p stage with ORAOCIBL (just to check), but I am recieving the following error message ********************************** Ard_Codes_or...

Hi , In the oracle enterprise stage I am using the mode user defined update , but I am writing user defined insert query in this option , does it mater what code we write in it , whether it is update or insert statement , will it cause job to hang and not complete , please suggest, according to IBM ...

hey guru ,

thanks a lot ,

My CC stage problem is solved ,

Hi All,

when I made target column nullable it did not give me any error ,

will this cause any issue in future if the column is not nullable and I changed the metadata manually in the oracle stage to make it nullable ,

pl suggest ,,

Thanks,