IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  String table - rows = columns

    Posted Mon July 12, 2010 07:47 AM

    Hi all,

    Could You, please, tell me how can I fill String table (using LOOP) → each record = column, not row!??
    P.S. or maybe 2 LOOPs…
    Thank You,


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: String table - rows = columns

    Posted Mon July 12, 2010 11:37 AM

    Typically loop is used when you have a document list as inputs,

    so lets say if you have

    doclist

    val1
    val2
    val3

    to pupulate it into string list… loop on doclist and map it to sting table by providing index index[i,j] where i => count=$iteration-1 (as iteration start from 1) and j = 0, this will populate the fields into one column table… similarly you can work on multi coulmn tables as well.

    -nD


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 3.  RE: String table - rows = columns

    Posted Fri April 22, 2011 09:25 AM

    hi,
    initially
    I have 4 string variables, say var1,var2,var3 and var4.
    and i also have a string table.
    now inside a loop, the values of this 4 variable will be change,and
    i want to store this variable row wise into my string table
    say:
    in iteration1:
    var1 var2 var3 var4
    in iteration2:
    var1 var2 var3 var4
    var1 var2 var3 var4
    in iteration3:
    var1 var2 var3 var4
    var1 var2 var3 var4
    var1 var2 var3 var4
    ::::::::::::::::::::::::::::::::

    I used appendToStringList() for this issue
    but then my stringTable multiply column number,
    I dont want to increse column number , my column number must be fixed i.e 4 but i expect it should expand rowwise

    kindly suggest any solution.


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: String table - rows = columns

    Posted Mon April 25, 2011 06:13 AM

    Hi avik,

    Option 1:
    You could have 4 map steps(no of vars) and in each step map the variables(var1,var2…) to the table by assigning column index to each variable starting from 0 - 3. Assign an incremented value to the row index. In this way you would have one row with 4 columns created every iteration.

    Option 2:
    You could write a java service for this. Use IDataCursor methods to traverse thru the variables and assign them to your table which will be in the format of a two dimensional array.

    I’m sure there migth be many other better ways to do this but you could try one of these options, choose and improvise it.

    Hope this helps.

    -Suren


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 5.  RE: String table - rows = columns

    Posted Sat April 30, 2011 08:56 AM

    hi Suren,

    I follow your first option, and its done.
    
    Thnx
    

    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 6.  RE: String table - rows = columns

    Posted Sat July 16, 2011 05:33 PM

    hi Suren,

    I need one help.

    I have create one solution using webMethods Designer.
    in this solution it has UserInterface and Process file

    I also create one CAF -web Application into UserInterface folder
    and one BPM into process folder,which name is say sendEmail.process.

    now I want to call that BPM, inside the CAF -web Application .view file.

    how could i do that, plz send me the steps.

    Thnks


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 7.  RE: String table - rows = columns

    Posted Wed July 20, 2011 06:19 AM