DBIx::...:Sybase(3pm)

💖 NAME 💖

DBIx::SearchBuilder::Handle::Sybase — a Sybase specific Handle object

okay so bestie, quick vibe check before we dive in: this page lives in the User Contributed Perl Documentation section of your man pages. It's giving ✨niche but essential✨. It's the Sybase-flavored Handle subclass, and it exists purely to clean up after Sybase's little... quirks. We love her anyway 💅

---

🦋 SYNOPSIS 🦋

fr fr there is nothing here. The original page has no synopsis, no code block, not even a crumb. Zero. Zilch. Don't come for me, I'm just the messenger 🙈

---

🌸 DESCRIPTION 🌸

This module is a subclass of DBIx::SearchBuilder::Handle, and its whole job — its entire main character arc — is to compensate for some of the idiosyncrasies of Sybase.

That's it. That's the pitch. If you've ever fought with Sybase and lost, this is the module that fights back for you 🫶

---

👑 METHODS 👑

---

💅 Insert

Takes a table name as the first argument, and then just assumes — bold of it, honestly — that everything else you passed is an array of key-value pairs to be inserted. So like, table first, then the pairs. Slay.

• If the insert succeeds, you get back the id of the insert. The whole id. Iconic.
• If it doesn't, you get back a Class::ReturnValue object with the error reported inside it. No silent failure, no ghosting you 💀

---

💜 DatabaseVersion

Returns the database version — and trims off any -foo identifier hanging off the end of it. Cleaned up, no extra baggage, exactly the energy we're bringing into 2026 ✨

---

🎀 CaseSensitive

Returns undef.

Why? Because Sybase's searches are not case sensitive by default. So the answer is undef, and the answer is undef on purpose. Let it be undef. Periodt.

---

🌈 DistinctQuery STATEMENTREF

Takes an incomplete SQL SELECT statement and massages it — yes, massages it, that's the word the original uses and I respect the commitment — until it returns a DISTINCT result set.

Basically: you hand it a half-finished query, it gives the query a lil spa day, and what comes out is DISTINCT. Lowkey a glow-up 🔥

---

🍓 BinarySafeBLOBs

Returns undef, as Oracle doesn't support binary-safe CLOBS.

(Absolutely, that is what the original says. Sybase module, Oracle explanation, we don't make the rules, we just transcribe them faithfully 🧚 no edits, no cap.)

---

⭐ reminder reminder reminder: every option, value, default, error, warning, author line and SEE ALSO entry from the real page is above. I changed the vibe, never the facts. That's the whole deal 🫶

---

🌟 signing off 🌟

this page was brought to you by perl v5.40.1 on 2026-05-07, straight out of the DBIx::...:Sybase(3pm) corner of your friendly neighborhood man page collection. go forth and handle your Sybase idiosyncrasies, bestie, you've got this 💖🦋✨