The following operators can be used to better focus your queries.
( ) , AND, OR, NOT, W/#
? single char wildcard, not at start
* multi char wildcard, not at start
(Cat? OR feline) AND NOT dog?
Cat? W/5 behavior
(Cat? OR feline) AND traits
Cat AND charact*
This guide provides a more detailed description of the syntax that is supported along with examples.
This search box also supports the look-up of an IP.com Digital Signature (also referred to as Fingerprint); enter the 72-, 48-, or 32-character code to retrieve details of the associated file or submission.
Concept Search - What can I type?
For a concept search, you can enter phrases, sentences, or full paragraphs in English. For example, copy and paste the abstract of a patent application or paragraphs from an article.
Concept search eliminates the need for complex Boolean syntax to inform retrieval. Our Semantic Gist engine uses advanced cognitive semantic analysis to extract the meaning of data. This reduces the chances of missing valuable information, that may result from traditional keyword searching.
Disclosed is a method to allow National Language Support (NLS)
Relational database application developers to store DBCS characters in
Binary Large Object and retrieve them back in their original DBCS
English (United States)
This text was extracted from a PDF file.
This is the abbreviated version, containing approximately
52% of the total text.
Page 1 of 2
RDBMS function to allow NLS developer to retrieve DBCS char from Binary Large Object in their original language or Unicode
NLS Relational database application developers who want to store DBCS characters in Binary Large Object and retrieve them back in their original DBCS characters cannot do so because DB2 select only returns Hexadecimal chars.
The common work around used is to store the DBCS chars in a VARCHAR field in UTF-8 (unicode) enabled database. But this design has major limitations : 1) Not all existing databases are UTF-8 enabled and migration from a non-unicode to UTF-8 enabled database is a big effort 2) VARCHAR has its limitation in length whereas BLOB does not 3) When the DBCS data stored in BLOB is retrieved from database, an external code conversion is required. This has proven to be problematic for many developers and causes much code duplication in development across applications.
Disclosed is a method to allow National Language Support (NLS) Relational database application developers to store DBCS characters in Binary Large Object and retrieve them back in their original DBCS characters
A database (DB2) function is implemented to give NLS database application developers more flexibility for their choice of application design. That is with this function, user can perform a select statement against a Binary Large Object that stores DBCS char data and the return results will be in their original language or unicode such as UTF-8.
This function can be used either from DB2 command line or in the SQL query statements within an application program.
High Level architectural implementation is as follows:
The database function can be designed to take in three parameters: the first parameter can be...