Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

can't use a UNION in a VIEW - workaround ?

In Sybase 11 I can't use UNION selects (6) in a VIEW.
Anybody an idea to work around that ?
0
mmullens
Asked:
mmullens
  • 2
1 Solution
 
mmullensAuthor Commented:
the message returned by Sybase :
197- SET operators may not appear in the definition of a view
0
 
mmullensAuthor Commented:
Adjusted points to 200
0
 
bretCommented:
I recently posted a method of faking a view containing UNIONs (based on proxy tables in ASE 11.5) to comp.databases.sybase, you can find it if you go to http://www.dejanews.com and search for "~g comp.databases.sybase union view bret"

As written, it only works for "select *" with no where clause against the view.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now