var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Querying special table name
I would ask for your help in the following:
One of the columns in a table have a special character in its name:
SELECT AFO-NEXT FROM DB2ADMIN.LOGISTIK
The query is working for all other columns, but this one. The query is working with Select *, but I cannot access specifically this column.
I tried googling for special escape characters or such, but couldnt find anything.
Someone please help me out, how can I make the above query running?
On execution I get the SQL0206N error, I could not find any workaround for the '-' character.
Thanks in advance !
Enclose the column name in double quotes. Keep in mind that the name then must be entered _exactly_ as it is listed in the catalog; in particular, it becomes case sensitive.
Thanks a lot for your answer !
Pity that its kinda the only case, in which I cannot integrate this query with the R programming langauge, as it messes with " marks...
But anyway, thanks again, have a nice day :-)