Thanks. You have a modern version of Sybase.
Try the following query.
I do not have Sybase db to test it; I tested it in SQL Server 2008.
Since Sybase and SQL Server share a common code base, it should work in Sybase, maybe with a few minor tweaks.
Here's my execution:
A few notes follow:
(1) Sybase might require you to use the keyword "recursive" after the keyword "with". So "with emp..." becomes "with recursive emp...". It is optional as per ANSI SQL standard. Some databases like PostgreSQL require it; others like Oracle and DB2 don't.
(2) The "with emp" subquery was created by me to generate the data on-the-fly, without having to create a table. You already have the emp data in a table, so you may want to use that table. If you do that, then your query begins from "hier_tree". So: "with hier_tree..." or "with recursive hier_tree..." - whichever works.
(3) Concatenation operator "+" should work in Sybase.
(4) Not sure about the "cast()" function in Sybase. SQL Server throws an error message if I don't use it.
Last edited by durden_tyler; 06-22-2016 at 03:48 PM..
Hi,
Can anyone please give me a script or let me know how to connect to a sybase database and execute a query using Korn shell scripts.Am new to Unix but i need to do this ASAP.
Please help.
Thanks,
Gops (7 Replies)
Hello Guys,
I'm new to Shell scripting, and i need someone to help me with this issue:
I'm trying to do a dynamic update query on Sysbase database table using shell script.
Lets say, the Update query is "update Table set id=X" , where X is dynamic value for the loop index.
If the loop is... (10 Replies)
Hello Guys,
Well, using shell script, I'm doing loop on DB query as below:
isql -Usa -Ptest -I /opt/sybase/interfaces << EOF
use testdb
go
declare @i int
select @i = 1
while(@i <= 5)
begin
Insert into TEST values (@i,"Test","TestDesc")
select @i = @i + 1
end
go
EOF
The Issue... (2 Replies)
Hi,
Am using informix database. When i give "isqlrf <database name> - " from the command prompt , i get connected to the database and i can run sql queries..
I am moving to freeBSD and when i give the same command at the prompt i get an error : Index already exists on column
Why is this... (0 Replies)
Hello,
I have three tables.
I need an SQL query (preferably Sybase) that will return all of the stringID values of table B where the following conditions exist:
(1) B.intID = A.intID
(2) B.intID != C.intID
or (B.intID = C.intID and
(C.v1 = 0 or C.v2... (2 Replies)
hi,
I'd like to connect to a Sybase ASE 12 through a a graphic user interface (GUI) that run on windows and solaris10, because i need to do some querys.
The database is running on solaris 10.
I'm not an expert using databases, but i know how to use some SQL commands through command line... (3 Replies)
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Hi Team ,
I am new to Sybase Adaptive Server Enterprise/15.7 (ASE) and need some guidance to find the different values in serial format column.
SELECT DISTINCT SERIAL_FORMAT FROM PRODUCTS
It has values with below format which contains 12 digits hexadecimal characters with... (2 Replies)
Dear Team
Please provide suggestion on below query which is used in Sybase Adaptive Server Enterprise/15.7 (ASE).
Query takes more time > 30 Mins to 1 Hr
All required indexes are built
Can we have any efficient approach to get the data retrieval faster for below query.Any help... (0 Replies)