StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Issues
»
QueryInformation: SQL Generated for DB2 is incorrect
QueryInformation: SQL Generated for DB2 is incorrect
Post Reply
Like
0
Prev
1
2
Jump To Page
QueryInformation: SQL Generated for DB2 is incorrect
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
PeterA
PeterA
posted 19 Years Ago
ANSWER
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
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
0
Prev
1
2
Jump To Page
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search