DSXchange

hi,

imported the TD from file and did it.

also tried

/defns:TranslationResponse/defns:Document/defns:GenericSAPDocument/defns:sap:Material/defns:sap:LineItem/text()

using
/sap:TranslationResponse/sap:Document/sap:GenericSAPDocument/sap:Material/sap:CharacteristicValue/@name
/sap:TranslationResponse/sap:Document/sap:GenericSAPDocument/sap:Material/sap:CharacteristicValue/@value

but no output is thrown.

hi, I want to know the XPath derivation for the below XML, tried to figure it out for a while, but ...... want to read the name="MK_T_9117_MOD" and value="MMA" part Here is the xml i have <TranslationResponse xmlns="http://w3.ibm.com/xmlns/ibmww/crm/blueharmony/configurator&...

u can search this forum definitely, for more info.

u can use trim if the destination is char/varchar.
plz correct me if i am wrong

hi,

welcome to dsx

these are just viewed as ?? in datastage, but they will retain their original shape as they travel.

hi, i am facing the same problem. but it is chinese, here. In DB2 it is VARCHAR(255) and in my stage NLS setting is Job default (UTF-8). I have also tried changing the NLS setting to IBM-1386_P100_2002, UTF-16, result is same. i tried doubling tripling length, can some one, give his/her valuable ins...

The convert function works on a single character, not a string and won't work for you in this case. You might use this: svKeyPosition INDEX(Xfm_DuplicateCAAPS_IN.Chinese_text,'xxxxxxxxxx') NewString[svKeyPosition,10]=Xfm_DuplicateCAAPS_IN.PORDNUMB great, i am still did not understand what to do wit...

hi, the string is "注意：这张订单取代了我们之前的订单#xxxxxxxxx。 请在发票中注明新的" we have to replace xxxxxxxxx with the coressponding key column. like this 注意：这张订单取代了我们之前的订单#BKL2345001。 请在发票中注明新的| , this key colunm value will change for each row. currently i am using Convert('xxxxxxxxxx', Xfm_DuplicateCAAPS_IN.P...

Thank you will test this.

i am only aware of "if then else " condition, but through that, i guess we cannot drop records.

pl throw some more light on the details. we just have column_name='xxxx' condition.

thanx for replies.

thanxs for reply.

we were just running a perfomance test of builp vs transformer.

so exactly how can we implement a filter condition in buildop.

hi,
i have one fundamental question on buildop.

Can we implement a simple filter condition in buildop.

thnx in advance

Hi All, We are doing some kind off capacity planning for our project. We have a fixed file of size 2436999939 bytes. My job is removing the header and trailer record from the job and creating a dataset with only few necessary columns with two additional columns one varchar(5) with a constant value a...