Can be CLID format modified in the Symposium script ?

[johnjose]

SCCS rel5.0.
Is there any scripting trick how to modify CLID number format ( i.e. add 870 at the beginning of CLID ) and then use new CLID format in the SEND REQUEST command ?

Many thanks for help,

jj

 

[PascalHL]

Hi,

so far i do not think so, because Clid is not a writable variable.
With an earlier release of CCS, i was using an Hdx tool to send Sql requests to an external Dbms, and was doing the change in the Sql request, not in the script (you can't there). It would be in MS Access (or in Smart Route, the famous french tool ) something like "SELECT * from xxx where number = "870"&CLID and ..."

Hope it will help
Regards
PG

 

[johnjose]

Hi,


Yes, in SCCS rel.5 Database Integration Wizard there is posibility to write, edit and test SQL statements.
Next statement works fine – inserts 870 at the beginning of every CLID sent to HDX:

SELECT Operator_id FROM DBx WHERE Clid = '870' + CONVERT(varchar(9), ?).

There was just a request from DBadmin guys if we could do it in Symposium.

Many thanks for help PG,


jj

 

[PascalHL]

If i do understand well, you can customise the Sql statemement, but not modify the clid appearing (system variable). It was what i was trying to explain in my answer : concatenete two strings in the request (870 and clid), but not change it in the script.

Sorry if my answer was not understandable.

Good afternoon

PG