DD version 5.0
DB
rcale8i
In my datacapture.cfg file, I have top level item name='columns' which has 7 replicant fileds. DD successfully reads all the files in my data folder and also extracts tuples using wide option.
FILE=[templatedata/group/selectortool_new/data/angola]
TUPLE={columns/0/is_registration=Yes, TeamSite/Templating/DCR/Type=group/selectortool_new, columns/0/region_name=angola, columns/0/link=
www.us.hsbc.com, state=Original, columns/0/region_order=20, columns/0/contact=akhtar, columns/1/link=
www.us.hsbc/marketting.asp, columns/1/region_name=angola, columns/0/preferred_country=No, columns/1/link_description=marketting, columns/0/link_description=personal banking, path=templatedata/group/selectortool_new/data/angola, columns/1=, columns/0=, columns/1/is_registration=Yes, columns/1/contact=jennfer lopez, columns/1/region_order=21, columns/1/preferred_country=No}
TTableSchemaHelper object for [SELECTOR_TOOL_REGIONS_TEMP] found in cache.
SELECT Path, region_order,region_name,link_description,link,preferred_country,contact,is_registration FROM SELECTOR_TOOL_REGIONS_TEMP WHERE Path=?
TTableSchemaHelper object for [SELECTOR_TOOL_REGIONS_TEMP] found in cache.
WHERE clause parameter 1: templatedata/group/selectortool_new/data/angola
Using PreparedStatement for Insert....
TTableSchemaHelper object for [SELECTOR_TOOL_REGIONS_TEMP] found in cache.
TTableSchemaHelper object for [SELECTOR_TOOL_REGIONS_TEMP] found in cache.
PreparedInsert:INSERT_STR:INSERT INTO SELECTOR_TOOL_REGIONS_TEMP (Path,region_order, region_name, link_description, link, preferred_country, contact, is_registration) VALUES (?,?, ?, ?, ?, ?, ?, ?)
Inserting into SELECTOR_TOOL_REGIONS_TEMP:
Parameter Index: 1, Value: templatedata/group/selectortool_new/data/angola, Converting 'templatedata/group/selectortool_new/data/angola' to VARCHAR
Parameter Index: 2, Value: (null)
Parameter Index: 3, Value: (null)
Parameter Index: 4, Value: (null)
Parameter Index: 5, Value: (null)
Parameter Index: 6, Value: (null)
Parameter Index: 7, Value: (null)
Parameter Index: 8, Value: (null)
-- Inserted
UPDATE iwtracker SET UPDATETIME='Mon Apr 29 11:03:57 EDT 2002' WHERE NAME='SELECTOR_TOOL_REGIONS_TEMP'
1 row(s) updated.
Committing database [scops-host2:1521:hsbc2]...
Deployment[dcr-to-db] Table[SELECTOR_TOOL_REGIONS_TEMP]
-----------------------------------
Tuples inserted : 3
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
-----------------------------------
Files with EA's [3]
Started : Mon Apr 29 11:03:54 EDT 2002
Finished: Mon Apr 29 11:03:57 EDT 2002
But the problem is that it only inserts the path value. Is there a special format for replicant field values to use in the <update> section of <destination> tag. I'm using the following format:
<select>
<column name="Path" value-from-field="path" />
</select>
<update type="base">
<column name="region_order" value-from-field="region_order" />
<column name="region_name" value-from-field="region_name" />
<column name="link_description"
value-from-field="link_description" />
<column name="link" value-from-field="link" />
<column name="preferred_country"
value-from-field="preferred_country" />
<column name="contact" value-from-field="contact" />
<column name="is_registration"
value-from-field="is_registration" />
</update>
Any would be highly appreciated!
Thanks
