XAware Open Source Data Integration - XAware Open Source Data Integration

You are here: Home

Forums

	XAware Community Forums	Forum Flat View

Welcome, Guest
Please Login or Register. Lost Password?

XAware Community Forums

General Forum

Migrating to XAware 5

SQL Insert (1 viewing) (1) Guest

Favoured: 0

TOPIC: SQL Insert

Forum Tools

#3090

axacan2 (User)

XAware user

Posts: 30

SQL Insert 1 Month, 2 Weeks ago Karma: 0

Hello,

I have been working on conversion of 4.3 code to 5.1 and came across the following in one of the SQL bizComponents in 4.3 and am unsure how that can be converted to 5.1

Code:

<xa:request xmlns:xa="http://xaware.com/xas/ns1" xa:oper="insert" xa:table="%jdbc_tblprefix%.T61CITCN" xa:key="CITAPOL">SELECT
  %jdbc_tblprefix%.T61CITCN.COMPANY,
  %jdbc_tblprefix%.T61CITCN.SUBCOY,
  %jdbc_tblprefix%.T61CITCN.CITAPOL,
FROM
  %jdbc_tblprefix%.T61CITCN</xa:request>
<xa:column_map>
        <COMPANY xa:sql_type="5" xa:sql_type_name="SMALLINT" xa:column_class="java.lang.Short">%company%</COMPANY>
        <SUBCOY xa:sql_type="5" xa:sql_type_name="SMALLINT" xa:column_class="java.lang.Short">%subcoy%</SUBCOY>
        <CITAPOL xa:sql_type="1" xa:sql_type_name="CHARacter" xa:column_class="java.lang.String">%citapol%</CITAPOL>
</xa:column_map>

From what I can figure out, xa:key="CITAPOL" is not needed since xa:oper="insert" is also an attribute, is that correct? I am also unsure why SELECT is used at the start of the statement when there is the xa:oper="insert" attribute. Thanks for your help.

Report to moderator Logged