aborting job while executing the select statement

deesh · Post by **deesh** » Wed Oct 21, 2009 9:12 am

SELECT
`A`.`A Key` AS A_Key,
`A`.`E Key` AS E_Key,
`A`.ID
FROM
dbo.`A`
I am trying above query in ODBC connector but its giving bellow error, please can clarify any one

[IIS-CONN-ODBC-000004] ODBC function {0} reported: SQLSTATE = 42000: Native Error Code = 102: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '`'.

chulett · Post by **chulett** » Wed Oct 21, 2009 9:55 am

First try using single quotes (') rather than that accent mark (`).

deesh · Post by **deesh** » Wed Oct 21, 2009 9:55 pm

I tried with single quote its giving below error.

[IIS-CONN-ODBC-000004] ODBC function {0} reported: SQLSTATE = 42000: Native Error Code = 102: Msg = [IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Key'.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 21, 2009 10:32 pm

What happens when you let DataStage generate the SQL based on the table definition you have imported?

HariK · Post by **HariK** » Thu Oct 22, 2009 4:00 am

I have never worked on SQL server. But the question is, is it possible to have spaces in column identifiers ('A Key') in SQL Server?

chulett · Post by **chulett** » Thu Oct 22, 2009 6:52 am

ODBC doesn't support them, from what I recall. For Access you'd need to put square brackets around them, perhaps the same would work here?

deesh · Post by **deesh** » Fri Oct 23, 2009 2:33 am

thanx for your help and with the " [ ] " brackets my problem has solved

chulett wrote:ODBC doesn't support them, from what I recall. For Access you'd need to put square brackets around them, perhaps the same would work here? ...