MVSFORUMS.com

[user5]

Hi All,

I am creating a Dynamic sequel in my SP
One of the paramaters that the front end passes to the SP is the User Id string.
The # of user ids can be as high as 2800.
So the front end is passing a string which contains the user ids in quotes and are comma separated. The user id is 8 bytes long.
We are using a VARCHAR field size 31000.(WS-USER-ID-STR)

I have created a dynamic sql in my SP
in another varchar field (WS-DY-SQL size 1000).
This field consists of the SQL until the :
"WHERE USER_ID IN ( "

Then I am trying to STRING the WS-DY-SQL and the WS-USER-ID-STR
and the ' ) ' literal.

The SQL that is created after the string is PREPARED.
I am outputting the DYNAMIC sequel that is created in the SP.

If I pass the max # of user ids as input:
I notice that only the first 1000 bytes of data from the WS-USER-ID-STR are stinged and the ' ) ' literal is also not stringed.

If I pass comma separated user ids that occupy less than 1000 bytes as input:
Then the SQL is properly created and PREPARED successfully.

I also tried to split USER ID STRING into smaller strings of 1000 bytes each. Assuming that I cannot string a field of more than 1000 bytes.
But in that case also, it strings correcty for the same # of user ids.

I ahve checked the length of the VARIABLE into which I string all the fields.



Thanks & Regards,
Meghna

[kolusu]

user5,

cobol defnition for a varchar item consists of 2 fields , 1 contains the length and other contains the actual field.
ex:

[user5]

Thanks you very much Kolusu.
It worked