DSXchange

What's Iconv and Oconv? Doesn't sound like DSTX function. You can use the ADDDAYS if you know how many days or set up an algorithm to work it out. Similarly you could convert the date to a number using DATETONUMBER, add the number of days and convert it back to a date using NUMBERTODATE. None of the...

Yes but you're using American Date Format.
The example used UK (and probably the rest of the world) date format which is DD/MM/CCYY

Looks like 25 to me.

Define the input field as EDCBIC in the typetree and specify outbot to be binary with empty set to 0

However, if the xml tags are the initiator and terminator you won't get them so you'll only get the data.

oops missed > from the end ot the LF.
Should be
F_String(substitute(PACKAGE(DummyRec:Input01),"<CR><LF>",""))

looks like you've got a CR LF in your input.
you could use
F_String(substitute(PACKAGE(DummyRec:Input01),"<CR><LF",""))

Make sure you don't have a CR LF on your output card group or item.

you could have an output card with an item that occurs S and has no terminator. Put a functional map in the rule like f_string(package(recin)) and in the functional map move the input card to the output card.

It really depends on how you update the database. I have maps that update lots of tables. To be able to get all the right keys at the right time I use a Burst of 1 on the input data (1 file) but other maps that just update 1 table I use a fetch unit of S.

Getting foreign keys can be an interesting exercise. It's not a problem for existing data but when you are creating all new data, you've got to know when this is committed to the database. So if you create a parent row, unless you commit it imediately, you can't get the foreign key for a child row f...

What do you plan to do with the table name in LINEITEM?

What do you plan to do with the table name in LINEITEM?

You can only update one table per output card.

Read the Queue and set the card to delete the message after processing.

Set the trace parameter -T and look in the resulting .dbl file for further information.