DSXchange

jayantthakore wrote:TRY THIS :
DecimalToDecimal(Column name,[2])
This should do it.

hi jayanth,

it is not accepting that expression.You mean 2 is for floor.

Hi

My source column data is coming as decimal(12,3) and i have to insert into target column with data type as decimal (9,2).

I have used decimalto decimal(column,"floor").It was not working.

Is there any other possible solution for this?

Thanks!

Hi,

I have created the expressions manually.
The path i have used is
/AmazonEnvelope/Message/Item/name/Value/text()

Some of the values are not repeating some of them are repeating.
Can you please tell me what would be the problem
Thanks!

Hi, I have a job where my o/p is xml and i/p is dataset. My problem is in dataset the data is correct but in xml for single tag values are repeating. Example: In i/p for a column "name" the data is "not_ready". But for name the o/p i'm getting : <name> <Value>not_ready not_ready<...

Hi,

I have a job which genarates an xml file.

DSet-->Transformer--->xml .

In transformer i'm applying business logic for 260 attributes.

I don't know why it is taking so much time.Is there any other way to decrese compilation time.

please tell some suggestion.

Thanks!

Hi I have to generate an xml file with name_yyddmmDDMMSS.xml . I am presently doing this through the unix script.I have also tried to use name_#dsjobTimestamp#.xml but it will not genarate in the above format. Is there any possibility to specify the timstamp format in the job level itself? thanks in...

Hi

How can we drop null column in a transformer.

i have 250 columns in the job.i have to drop all the column which are null
how can we achieve this

Thanks!

Hi chulett


I want to generate a file with name_YYMMDDddmmss.xml .If i use name_DSJobStartTimestamp.it is genarting in default format but i need in this format name_YYMMDDddmmss.xml

so want should i do.please suggest some solution.

:!: There is no problem with either spaces or colons in UNIX pathnames. And using the DSJobStartTimestamp macro in a sequential filename works fine as I just built a quick test job to verify that fact for myself. It will also 'open in the sequential file stage' (aka View Data) just fine as well wit...

Hi, How can we get the column value as tag in xml? For ex: My 1st column name is COLOUR and its value is 'BLACK','WHITE' etc.., 2nd column name is LENGHT and its values is 1,2,....etc I have to generate xml as <BLACK> <Value> 1 </Value> </BLACK> <WHITE> <Value> 2 </Value> <WHITE> Could anyone sugges...

hi, I'm using db2 udb api stage for selecting columns from a table. The time taken is too high.the job is running for more than half an hour and it is getting delayed because of one table. select ..... from ...with ur is my query. all other tables are retrieving quickly but only two tables are creat...

hi, I have a job where i have to pass max value as parameter. in my script i have included : db2 "export to $LOCAL_DIR/max.ixf OF ixf SELECT MAX(INTF_TASK_I) FROM SPTDR1.INTF_TASK " if [ $? -ne 0 ]; then echo "ERROR fetching the max ids" db2 connect reset exit $FATAL fi JPM_SUR_K...

Hi , I have a situation where i Have to combine all the datasets into single datset and generate one single xml file. I have tried using dummy column on all the datastes and joined(left outer join) but the data is not comming in exact manner. I need to obtain all the data without any modification. I...

You mean XPath not simply path... it was a little confusing at first. And your output while wrong is technically correct - 1 = true, 0 = false. You need to correct your 'DSLink100.PublishFlag' derivation to translate it into words, it would seem. Oh, and nice link name. :wink: hi chulett, I mean to...

Hi I'm facing problems when mentioning path in xml output.I have to generate o/p as : <?xml version="1.0" encoding="UTF-8" standalone="no"?> <gsa-template> <import-items> <add-item item-descriptor="ensemble-product" id="140150"> <set-property name=&q...