DSXchange

Hi I am not able to fix in datastage stored proc stage or in the code (Prepared by DBA). I have made only workaround such as I have put one constraint in the transformer for 3 key columns.(If key columns <> 0 processing the records.) But if anyone has resolution for it...i will be more happier. thanks

Your first explanation solved the problem. I have placed data element as XML. That was creating the problem...it resolved.


thanks
kamal

One more information: If I split the job into 2 (one job is having XML file creation and another job where I put message into MQ) there is no problem in datastage. The error is recurring only when I have XML output stage and MQ in single job. For any further information on the issue, please revert b...

Hi I am creating an XML using XML out put stage, then I trying to put the message into MQ. I am getting following error. MQ_PutOrders: [IIS-CONN-WSMQ-000003] Argument uszDataElementName has invalid value XML (CC_WSMQUtil::buildWSMQDataElement(), file CC_WSMQUtil.cpp, line 1,289) Extract of XML is so...

Hi chulett, You are right. I forgot to mention...datastage extracts data from SQL server through stored procedure stage. When I execute the same stored proc in toad, it is returning no records but in datastage, it is extracting 1 record with null values for all the columns. Let me have a talk with D...

Adding to this...

If execute the same select query in toad it is returning 0 records.

Hello

I have no data in tables.

It is still returning 1 row with all the null values in the columns.

If table has 4 rows then it is returning 5 rows with one extra record having all values as null.

Can any one has clue?

Hi I have 1 line items XMLs. I need to put these 3 elements into the Orders element Ex: job: dataset1--------XML1----------| lookup --------XMLoutputstage dataset2 -------XML2----------| XML2 will give 3 line items XML1 will give XML: <Order><a><b></Order) XML2 will give XML: <Line_Item> for Lookup ...

Hi

I have a stored procedure which returns 2 cursors. My stored procedure has been written in MS SQL dabase. Can datastage handle this stored procedure... I mean whether datastage supports multiple cursors as output paramter of a stored procedure ?


Please reverk back.

Thanks
kamal

Thanks for ur reply guys, it works fine.

thanks for ur reply, but my requirement is like i should not pass a record on the first time I see each particular combination, if combination repeats i should reject that combination entirely, whichever combination comes only one time i shud select that.

Hi, I have a requirement as follows. there are 3 columns User,role, and code sample records U1,R1,D U1,R1,U U2,R1,D U2,R2,U and i need to select only U2,R1,D U2,R2,U meaning i should not select if same user/role combination has 2 codes, in the above ex U1/R1 combination has two codes D and U and so ...

Hi, Ya Maveric my target is a database, you meant to swithoff the RCP in the datastage administrator right. I have found one solution for this problem,that is after dividing the decimal by 100 convert the value to Float as suggested by gopal(Thanks :) ) and futher we can use a transformer stage to u...

[quote="ag_ram"]Hi,

I changed the target to float at the intermediate step it's working fine,but my target is still decimal(5,3),so at the target it's getting rounded off.

Hi, I have the value of input column as 99.99 whose metadata type is Decimal(5,3),this is further divided by 100 in the transformer stage and the output is coming as 1.0, the datatype in output is same as Decimal(5,3).But I require the value to be 0.999 and not as 1.0 without rounding off.Is there a...