I try to create tables with dynamic names, that means that i add the creation date to the table name ( e.g. myTable20020301 ) in Sybase 11
Is there any possibility to use a parameter as tablename ?
ASE 11 didn't support dynamic SQL via the 'EXEC(..)' function. Are you using stored procedures I assume? What I'd do is send the raw SQL from an application, but perhaps this won't work in your case. Maybe also try using xp_cmdshell and running a script to create the table that way (e.g. myscript '20020301').