Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    5

    Unanswered: DELIMIDENT with JDBC

    I have IDS 9.4 running on Windows 2000.
    I have DELIMIDENT set equal to "yes" in the Environment Variables
    When I connect to the database via DBAccess and try something like this:
    select accountId as "ACCT" from account
    It works fine.
    If I try the same thing over JDBC I get:
    Message : A syntax error has occurred.
    Error Code : -201
    SQLState : 42000
    StackTrace :java.sql.SQLException: A syntax error has occurred.

  2. #2
    Join Date
    Feb 2005
    Posts
    5
    Never mind--I was passing the SQL via XML and had something like this:
    select accountId as "ACCT", acountName as .....

    When I put a space between the " and the "," it worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •