variable substitution without FCC

[Former Member]

hi experts,

can we use variable substitution without using FCC in the CC.

Regards,

Akhil

[santhosh_kumarv]

Hi,

Since you are using flat file at the sender side you need FCC to convert the flat file to the XML structure. With this XML stucture you can either use the variable substution or dynamic udf to name the target file at the receiver side.

If you requirement it to move a flat file to target location naming it dynamically you need to have FCC both at the sender and at the receiver to convert the flat file to XML and vice-versa.

Thanks

SaNv...

P.S: Don't post multiple thread for the same issue.

[Former Member]

thanks Santosh,

Could you pl. help me out what FCC parameters I should maintain for the structure given below:

<Header>

<Itema>a</Itema>

<Itemb>b</Itemb>

<Itemc>c</Itemc>

<Detail>

<DetailA>A</<DetailA>

<DetailB>B</<DetailB>

.

.

.

</Detail>

<Detail>

<DetailA>A</<DetailA>

<DetailB>B</<DetailB>

.

.

.

</Detail>

<Trailer>

<TrailerA>A</TrailerA>

</Trailer>

</Header>

The structure is same in both sender and receiver.

[Former Member]

Hi,

Is it fixed length value or comma separated?

Anyway go through this blog and use the feild separator as require.

Note: you do not have any key field coming in your data, don't worry. Just do the FCC without keyfield.

Regards,

Sarvesh