Sybase and inline views, Intersect, MINUS

[dba...@yahoo.com]

Dear Experts,

I'm an Oracle guy, and I'm being given an assignment in Sybase.

I have to do lots of comparisons between two Sybase "databases"
and note the differences.

Sybase does have:
outer joins, UNION, IN, EXISTS, GROUP BY.

But it seems that my some of my favorite tools in Oracle are
not found in Sybase:

inline views, Intersect, MINUS.

Am I correct on this? Or is there a way to do the same behavior
in Sybase?

When I did comparisons the other year in Teradata, the only way
to ultimately do the tough comparisons was to export everything
to file, import it into Oracle, and then do the comparisons.
I'm hoping to avoid this with Sybase.

Thanks

[Carl Kayser]

<dba...@yahoo.com> wrote in message
news:1161267381.9...@e3g2000cwe.googlegroups.com...

> Dear Experts,
>
> I'm an Oracle guy, and I'm being given an assignment in Sybase.
>
> I have to do lots of comparisons between two Sybase "databases"
> and note the differences.
>
> Sybase does have:
> outer joins, UNION, IN, EXISTS, GROUP BY.

Yes.

>
> But it seems that my some of my favorite tools in Oracle are
> not found in Sybase:
>
> inline views, Intersect, MINUS.

Negative on "intersect" and "minus". As of ASE 12.5.2 "inline views" are
supported as I remember. 12.5.2 is several years old and has been
superceded by 12.5.3, 15.0, and 15.0.1.

>
>
>
> Am I correct on this? Or is there a way to do the same behavior
> in Sybase?
>
> When I did comparisons the other year in Teradata, the only way
> to ultimately do the tough comparisons was to export everything
> to file, import it into Oracle, and then do the comparisons.
> I'm hoping to avoid this with Sybase.
>

I can sympathize with that viewpoint.

> Thanks
>