#8029: Sybase IQ -> Extract Rule -> text can be split through many records | Aqua Data Studio

Issues
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 828

IDE for Relational Databases

Back

Ivan Gron

ivangron reported 2012-12-06T16:44:30Z · swissarmyknife(*) last modified 2013-02-14T20:37:04Z

Sybase IQ -> Extract Rule -> text can be split through many records

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - General
Version	13.0

Because the catalog table is containing the records text in many rows we need to make sure to rebuild the text in the extraction.

example:

CREATE RULE dbo.title_idrule

as

@title_id like "BU[0-9][0-9][0-9][0-9]" or

@title_id like "[MT]C[0-9][0-9][0-9][0-9]" or

@title_id like "P[SC][0-9][0-9][0-9][0-9]" or

@title_id like "[A-Z][A-Z]xxxx" or

@title_id like "[A-Z][A-Z]yyyy"

/*valid values: BU, MC, TC, PS, PC + 4 digits

**or

**any two uppercase letters followed by x's or y's

*/

GO

1 attachment

GIF animation - fixed - extraction working

2013-02-14T20:37:04Z

244 KB

All Comments (3) Change History

Ivan Gron

ivangron 2012-12-06T16:56:21Z

extraction fixed...

Tariq Rahiman

tariqrahiman 2012-12-24T19:57:17Z

I cant find a Rule node for Sybase IQ. What version of Sybase IQ ?

Jonathan Powers

swissarmyknife(*) 2013-02-14T20:31:27Z

Fixed in at least

Version: 13.0-rc-6

Build #: 31338

Build Date: 2013-Feb-13 09:45:47 AM

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017