×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Getting an -171 SQL error when I substring a DB2 time field -Impromptu

Getting an -171 SQL error when I substring a DB2 time field -Impromptu

Getting an -171 SQL error when I substring a DB2 time field -Impromptu

(OP)
Having major problems. Created a report in Impromptu Adminstrator that connects to a DB2 database using Neon Shadow Direct. All latest versions. Getting an -171 sql code error when substringing a time field. This was working on an older version of Neon Shadow Direct but not newer versions, though when i reinstalled the old version its now not working at all.

Also tried various combinations of the advanced options in ODBC Admin on the Neon Driver to no avail.

My question is, has anyone else come across this and figured a way around it ?
Is the way around it creating User Defined Functions ?
Is anyone else also peeved at the lack of time field support..?

Please help as im running out of hair to pull out

RE: Getting an -171 SQL error when I substring a DB2 time field -Impromptu

Can you convert the time field to a string then substring?

RE: Getting an -171 SQL error when I substring a DB2 time field -Impromptu

(OP)
Unfortunatley no, because its a time field. When trying to use the built in functions to convert it to a string before substringing it, no time columns show in the selection.
I have also tried to set the ODBC advanced options to convert DB2 time to a string but that did not work either.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close