Passing DSQUERY as parameter when opening exclusive urouter connection in SYBASE
Author: firstname.lastname@example.org (lalitpct)
We are opening an exclusive connection by below command and then on server asn we have hardcoded the servername (server1 in below example) for database connection (SYBASE) , at present we have 14 different servers (server1 to server14 ) . Exclusive connection ------------------------- open "|%%ID|%%$PINFO$|%%$$SERVER /ex", "$LOG/NET" server.asn ---------------- [PATHS] $DEF SYB:server1.database1|?|? because we have hardcoded server1 i need to create 14 different asn files for each server , is it possible I can pass this as parameter from open statement . In the uniface documnetation i checked that if i dont provide server name then it will connect to server specified to variable DSQUERY , but not sure how do i set that as for that . In short below things will be helpful 1)if servername can be passed from open connection 2)if we can set DSQUERY the momment we can connect to server. 3)Any other way i can avoid for 14 differetnt asn file.