SQL substring function statement not working in IBM Datacap FastDoc Capture

Technote (troubleshooting)


Problem(Abstract)

Attempts to use the SQL substring function result in no value returned when using IBM Datacap FastDoc Capture

Symptom

Field lookup returns no values. RRS logs show DB Errors


Cause

FastDoc unable to parse SQL statements with more then one comma in its statement

Diagnosing the problem

DB Errors logs in RRS log files

Resolving the problem

Replace commas in SQL statement with smart parameter ASCII values. For example convert SQL statement:


substr('Hello',1,4)

to

substr('Hello'+@CHR(44)+1+@CHR(44)+4)"


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Datacap FastDoc Capture

Software version:

1.0, 1.1, 1.2

Operating system(s):

Windows 7, Windows XP

Reference #:

1574270

Modified date:

2012-03-14

Translate my page

Machine Translation

Content navigation