MVSFORUMS.com

[bjain]

Need your Help !!

Folliwng is the problem :

After retriving from SQL query. I will get the count.

For eg. Count is 3.

I will again pass cd : FFL

So Now I will be having count =3 and cd = FFL

with these two things I need a output of :

(%F1 %, %F2 %, %A %F3 %L3)

% IS A DELIMITER , F IS first name, L is last name and A='and'.A comma is placed between templated components(exceptat the end where the %A value is present )

In the above example if the count is 4, then the output will be

(%F1 %, %F2 %, %F3 %, %A %F4 %L4)

can you please guide me how to do it.

Thanks and Regards,

[kolusu]

Buntyjain,

A couple of clarifications. What will be the max value of the sql-count. Let us say if the sql count is 2 digits say 99, then will the output be

[bjain]

Hi Kolusu,

Thanks for your response.

A couple of clarifications. What will be the max value of the sql-count. Let us say if the sql count is 2 digits say 99, then will the output be
Code:

(%F01 %, %F02 %, %F03 %, %F04 %, %F05 %, %F06 %, %F07 %, %F0... %A %F99 %L99)


Max value of the SQL-COUNT will be 25.

Yes the output will be
%F1 %, %F2 %, %F3 %, ................., %A %F25 %L25

Thanks again for your reply.