random name for recordset?

[former_member190284]

Hi Experts,

I have been going through this blog:

My doubts are:

1.Here author has given the anonymous name for the recordset structure..how would the PI would actually work in this case..as per my understanding it would look for that recordset which is not there...so it would look for  "IgnoreRecordsetName"  and will always ignore the recordset

2. what if we have a field recorset...?

3. why it's that changing the occurence of trailer  has effect..? why not with header has any effect?

4. how changing the recordset per message and occurence of trailer will change the output??

5. what is the login in making  all the subnodes at same hirerchy level..?

Thanks in advance

[somil_gulati · Accepted solution]

Hi Nunu,

The file structure in the blog mentioned by you follows the below pattern -

header  1..1

hbatch   0...unbounded

body      0...unbounded

tbatch    0...unbounded

trailer     1..1

So inorder to adapter understand this pattern , the recordset structure is mentioned as below -\

header,1,hbatch,*,body,*,tbatch,*,trailer,*

here trailer is kept as * , because this will be coming only in the last recordset and it will not come in any other recordset so it can be 0 also.

For example your file is like this -

01 232424252

02 456563576576

02 456563576576

03 33454154545

04 5451345646464

01 232424252

02 456563576576

03 33454154545

04 5451345646464

01 232424252

02 456563576576

03 33454154545

04 5451345646464

05 3462626665665

Your recordset will be divided like this via content conversion -

01 232424252

02 456563576576

02 456563576576

03 33454154545

04 5451345646464

01 232424252

02 456563576576

03 33454154545

04 5451345646464

01 232424252

02 456563576576

03 33454154545

04 5451345646464

05 3462626665665

So here there will be total of 3 recordset and last one is laso having trailer (which is not coming in any other recordset.

Below are answers for your questions -

You can have a field recordset also , if you will ignore that by using IgnoreRecordSetName it will not be in target xml str.

In recordset per message setting you can set how many recordset you want to set per message , * will send all in one message.

Thanks

[former_member190284 · Accepted solution]

Thanks Somil

That was very helpful...!

can u pls tell whether we can give any dummy name in recordset coloumn(as it's done here)

[azharshaikh · Accepted solution]

Hi Nunu,

Yes you can give Recordset name..depends on your design approach..

Eg : Flat structure is (In single file you are getting multiple Headers)

01 12345010101   >>>> First Header Record

02 1

03 1

04 1

01 7896010202     >>>> Second Header Record

02 2

03 1

04 1

It will get added to your converted FCC Payload like:

You need to match your Source Data Type Structure with xml...(i.e. add "details" node hierarchy)...

Regards,

Azhar