SCCS Retrieve Multiple Values from HDX

[Koerant]

Hi I'm having a problem. My HDX from MSSQL2000 Works 100% but I want to return Muliple values in a Coloum.

At this Stage My default Send and Recieve are as follows

ASSIGN CLID TO SymphonyCLI
ASSIGN "sp_clid_to_agent1" TO SymphonySP

SEND REQUEST SymphonyProviderID
SymphonyServiceName,
SymphonySP,
SymphonyCLI,
GET RESPONSE SymphonyProviderID
SymphonyABAgentID

My Response is 1 value named 'SymphonyABAgentID' but I would like to retrieve mulipule value like the following

ASSIGN CLID TO SymphonyCLI
ASSIGN "sp_clid_to_agent1" TO SymphonySP

SEND REQUEST SymphonyProviderID
SymphonyServiceName,
SymphonySP,
SymphonyCLI,
GET RESPONSE SymphonyProviderID
SymphonyABAgentID
SymphonyABGroupID

Have anybody outhere done somthing like this before, is it posible or not?
Thanks

 

[fhirani]

I think if you did the following, it would work....

SEND REQUEST SymphonyProviderID
SymphonyServiceName,
SymphonySP,
SymphonyCLI,
GET RESPONSE SymphonyProviderID, SymphonyABAgentID, SymphonyABGroupID

Example: Receiving a student record
To receive a student record from the host, follow this procedure.
// comments - variables as data holders:
// ProviderID: 12345
// name: to hold the student’s name
// ID: to hold the student’s ID
// subject: to hold the subject that the student has taken
// score: to hold the student’s score for the above subject
...
SEND REQUEST ProviderID type, name
GET RESPONSE ProviderID name, ID, subject, score
...
WHERE score EQUALS