question on how to insert to a odbc table in an xlate

[Yamil Velez]

Hi All

    I create a table in my sql database call adt.  The columns are mr, name, account, transactionid which I would like store my msh segment and  the last two columns are createdate and touchdate.  

My question is can I populate the database through an xlate, or do I first need to send my adt to file and then insert from file to my database?

If I can populate my database through an xlate if so can you tell me how this is done.  

Thank you in advance for any help

Yamil

Topic