QueryInformation: SQL Generated for DB2 is incorrect

Author	Message
PeterA	PeterA posted 17 Years Ago HOT Topic Details Share Topic
Group: Forum Members Posts: 72, Visits: 235	I'm hooking into DB2 and it returns a DB2 error when I start view the ASP page: [DB2Exception (0x80004005): ERROR [42601] [IBM][DB2/NT] SQL0104N An unexpected token "[ID_SUPPLIER], [NM_SUPPLIER], [CD_COUNTRY], [IND_STATUS] FROM " was found following "SELECT DISTINCT ". Expected tokens may include: "". SQLSTATE=42601] In this case, I believe the SQL is being generated incorrectly because of the square brackets around each field name - DB2 doesn't accept these. Are there any options I need to set on the QueryInformation object to change how it generates SQL and for what database? Thanks in advance! Peter
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

PeterA - 17 Years Ago

Some additional information. I was looking at the source code for the...

PeterA - 17 Years Ago

Brackets around SQL Server items is OK. This allows for non-compliant...

Greg McGuffey - 17 Years Ago

[quote][b]Greg McGuffey (08/28/2007)[/b][hr]Brackets around SQL Server...

PeterA - 17 Years Ago

You are correct both correct.The "identifier delimiter" used by the...

StrataFrame Team - 17 Years Ago

[quote][b]Ben Chase (08/29/2007)[/b][hr]You are correct both...

PeterA - 17 Years Ago

Aha, you're not going through any SF stuff to get there. You're using...

StrataFrame Team - 17 Years Ago

Well, I've got it sort of working. I created a static SqlHandler...

PeterA - 17 Years Ago

Excellent. Glad it's working for you :) As for the objects, we tried...

StrataFrame Team - 17 Years Ago

[quote][b]Ben Chase (08/30/2007)[/b][hr]Excellent. Glad it's working...

PeterA - 17 Years Ago

[quote]I know more about PHP/MySQL applications than anything else at...

StrataFrame Team - 17 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login