# Illegal Character

**URL:** <https://forums.toadworld.com/t/illegal-character/56788>\
**Category:** Toad for IBM DB2\
**Created:** [January 13, 2023, 3:57pm UTC](https://forums.toadworld.com/t/illegal-character/56788 "2023-01-13T15:57:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dwolf75](https://avatars.discourse-cdn.com/v4/letter/d/e68b1a/32.png) [@dwolf75](https://forums.toadworld.com/u/dwolf75)\
**Post date:** [January 13, 2023, 3:57pm UTC](https://forums.toadworld.com/t/illegal-character/56788/1 "2023-01-13T15:57:09Z")

</div>

When I run a specific set of code, I get back the full 10,744 records. When a colleague runs the same code, they only get back 6,144 records and then an error for "Lookup Error - Illegal Characters in path.". I look at record #6,145 and there is nothing in it that should be causing this error. Does anyone know what could cause one person to get this, but not the other? We've compared settings and nothing is jumping out either.

---

<div class="post-metadata">

**Author:** ![parkermi](https://avatars.discourse-cdn.com/v4/letter/p/bcef8e/32.png) [@parkermi](https://forums.toadworld.com/u/parkermi)\
**Post date:** [April 12, 2023, 8:46pm UTC](https://forums.toadworld.com/t/illegal-character/56788/2 "2023-04-12T20:46:07Z")

</div>

I get the exact same error with toad Data Point - connecting to Teradata. I also get it on the same record as noted in the post. looking for suggestions?

---

<div class="post-metadata">

**Author:** ![geparra1](https://avatars.discourse-cdn.com/v4/letter/g/dc4da7/32.png) [@geparra1](https://forums.toadworld.com/u/geparra1)\
**Post date:** [June 26, 2023, 2:48pm UTC](https://forums.toadworld.com/t/illegal-character/56788/3 "2023-06-26T14:48:52Z")

</div>

Go to Tools \> Options \> Database \> General and click on "Restore Defaults" in the upper right.

After defaults are restored, go back to options path above and make sure the click the checkboxes "Unlimited" so you do not have your output rows limited.