IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
  • 1.  low values to be passed

    Posted 01/31/12 07:14 AM

    Originally posted by: Jaango


    Hi,

    I need to pass LOW-VALUES(am not very sure what kind would that be), as default for a copybook field, to the backend team.
    
    15 :abc       PIC X(15).
    

    I use a WTX transform for this, to always pass the default value. From the mainframe team I got this as sample for the field.

    
    X
    '000000000000000000000000000000'
    


    However when I use this rule, it fails because the number of characters is above 15. How can I pass the LOW-VALUES?

    my rule map for the above cobol field

    
    =
    "X'000000000000000000000000000000'"
    


    error meesage

    
    Map:    Output: abc Field:123 Group:outputcbl Size of input item is greater than size of output item.
    

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


  • 2.  Re: low values to be passed

    Posted 02/02/12 06:45 AM

    Originally posted by: SystemAdmin


    If by "low value" you mean the NULL character (hex 00) you need to send <<00>> in a string

    So something like "X'<<00>><<00>>...." should do the trick
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: low values to be passed

    Posted 02/08/12 04:13 AM

    Originally posted by: SystemAdmin


    =FILLRIGHT("<NULL>", "<NULL>", 15)
    or
    =FILLRIGHT("<<00>>", "<<00>>", 15)
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: low values to be passed

    Posted 02/13/12 06:45 AM

    Originally posted by: KK_WTX


    Hi,

    Case-1:
    If the value is a hard-coded/fixed value and the size is more than 15 characters means it won't accept.It will through the below error

    Map: Output: abc Field:123 Group:outputcbl
    Size of input item is greater than size of output item.

    You have to increase the size of the output field.

    Case-2:

    If the value is not fixed than we can use below rules.

    =LEFT(value,15)
    or
    =FILLRIGHT(value, "", 15)
    Thanks.
    KK.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender