Originally posted by: Diamond.Li

Hello, 

 

I'm trying to set the following HEX value in WTX. Can someone please show me how, including the field type, etc?

  00 00 0c 07 ac 64 00 21 cc cf 4d 70 08 00 45 00

 

Greatly appreciate for your help!

 

Diamond

#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: Diamond.Li

I know it takes time to get answer. But this is a blocker in our project. Can someone please kindly help?  Thanks!

#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: paul.brett

Field type, should just be normal text.  You rule might be something like:

="<<00>><<00>><<0c>><<07>><<ac>><<64>><<00>><<21>><<cc>><<cf>><<4d>><<70>><<08>><<00>><<45>><<00>>"

Thank-you.

Paul.

Follow me on Twitter

#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Diamond.Li

thanks Paul! any place i can find this tip, like infocenter? i tried search from infocenter, failed miserably!

#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: Diamond.Li

Hi Paul, 

I tried this morning and it doesn't work. Message in the popup windows is: "$" expected. 

Please refer to the attachment. 

Truly appreciate for your help since this is a blocker now. 

Have a nice weekend!

 

Diamond

 

 

 

#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: RichMcFate

Diamond,

 

It looks like you're trying to put a mapping rule into a component rule.  Component rules exist to help determine whether a data object is valid.   You need to create a map, add your target structure as an output card, and put your mapping rule into the map.

 

Rich McFate

#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: Diamond.Li

Yes, you are right. Sorry for my mistake - Way too busy !

#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: Diamond.Li

Hi Rich 

This is very interesting. 

The value I'm using is: 

="<<00>><<00>><<0c>><<07>><<ac>><<64>><<00>><<21>><<cc>><<cf>><<4d>><<70>><<08>><<00>><<45>><<00>><<00>><<00>><<19>><<78>><<40>><<00>><<80>><<06>><<00>><<00>><<0a>><<64>><<19>><<ba>><<0a>><<eb>><<01>><<da>><<fa>><<bf>><<c0>><<31>><<66>><<69>><<cb>><<93>><<1a>><<4f>><<8a>><<a3>><<50>><<18>><<01>><<00>><<30>><<e9>><<00>><<00>><<0a>><<f9>><<45>><<44>><<4c>><<35>><<30>><<33>><<30>><<30>><<34>><<20>>"

 

I'm pretty sure that length is 66 bytes. 

The field type is "text" and interpret as "character". 

I got compilation error and nothing came out after I run the map: 

M200    WARNING:
    Map: MortgagesReq_XSD_TO_REC   Output: header Field:WTX_OUTPUT
    Size of input item is greater than size of output item.

 

So changed length into 200 and pad with <sp>. The entire output became 57 bytes and completely messed up(Please refer to the screenshot). 

 

That would be great if you can try in WTX using my test data!

 

Please offer help before my boss killed me!

 

Thanks, 

Diamond

 

 

 

 

 

#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: RichMcFate

I copied your rule into a WTX map, ran in the Design Studio and got exactly what we would expect.  (See picture).

 

What version of WTX/ITX are you using?

Are you running it in the Design Studio?   If not, how are you viewing the result file?

 

BTW, your compile warning is probably because the compiler is looking at the length of the rule string.  I suspect it's not smart enough to understand that the result of "<<CA>>" is of length 1.  Even if it's able to ignore the << and >>, it still probably thinks CA is two characters long.  In any event, that won't affect the map when it runs.  If you got no output it was for a different reason.

 

#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: Diamond.Li

Hi Rich, 

I truly appreciate for your help. The version I'm using is: 

       IBM Websphere Transformation Extender Design Studio

       Version: 8.4.1.3 
       Build id: 14 

I copied the screenshot for the way I run map. Is it possible because my runtime is "Datapower"? I tried to change it to "WTX", but got error "one or more inputs are invalid". How could this happen since everything is same except runtime. 

I have zipped my entire project. 

 

Have a nice weekend!

Diamond

 

#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: paul.brett

Two issues here.  When running locally, there's a schema validation that fails.  Switch the input the DocumentVerificatio->Xerces = Well Formed and the input will parse.

Secondly your output field is defined as IBM-437.  If you're going to use the <<XX>> notation and input the bytes directly, I suggest you use NATIVE for this field.

Another way of doing the output:

=HEXTEXTTOSTREAM("00000c07ac640021cccf4d7008004500000019784000800600000a6419ba0aeb01dafabfc0316669cb931a4f8aa35018010030e900000af945444c35303330303420")

....which will require no Typetree changes.

Thank-you.

Paul.

Follow me on Twitter

#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange