Ignore dollar sign in table name during db read UCCX

[taolaayan]

Hi People,

Does anyone know how to ignore the dollar sign in a table name during a db read operation. I performed a db read with the statement 'Select * from [CIC$Table]' but i get the error message 'Sql statement variable not defined: Table]'.

Any help would be appreciated. Thanks.

[Gergely Szabo]

Hi,

what kind of database is that?

Did you try to escape the $ with a backslash [CIC\$Table]?

G.

[taolaayan]

Hi,

The database is MS SQL 2008.

I have tried with the backslash but i still get the 'Sql statement variable not defined' error message.

Tola.

[Gergely Szabo]

Hm. Why the dollar sign.

Anyway, would it be possible to create a view (this time, the name without the dollar sign) just with a SELECT , , FROM [CIC$Table] ?

Then, of course, use this view from the UCCX scrript.

G.

[taolaayan]

Thanks for your reply.

I already created a view (CIC_Table) and i could successfully read the database. However, when i try to perform a db get operation using the  database view table and map fields to variables, the fields on the db get disappear as soon as i save.

Tola

[Gergely Szabo]

Hmm. Can you please give me the version of UCCX you are using, and also the version of the MS SQL Server. I would like to replicate the problem in my lab.

G.

[taolaayan]

The version of UCCX is 9.0.2 and the version of the MS Sql Server 2008.

Tola

[Gergely Szabo]

Hi, all I have is UCCX 8 and MS SQL 2K5, so I can't test it.

Can you do another thing, just to be sure: run a query on a different table or view. Do you see the same issue?

G.