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
Sybase IQ 12.5 - 38
asiqdemo
stored procedure created with ADS skelton code COMPILES successfully, but doesnt execute in Sybase IQ 12.5 but works in Sybase IQ 12.6
Stored Procedures proc_hello_world
ALTER PROCEDURE "DBA"."proc_hello_world"(inout myarg integer)
begin
select 'Hello World!'
end
>[Error] Script lines: 1-4 --------------------------
ASA Error -131: Syntax error near 'myarg'
Msg: 102, Level: 15, State: 0
Line: 0
The code executed by ADS is ...
declare @myarg integer
set @myarg = 1
EXECUTE DBA.proc_hello_world @myarg output
print '@myarg: ' || str(@myarg)
This is correct, but Sybase IQ fails. I think this is a bug in Sybase IQ 12.5.
Tanya, can you verfiy?
I found a .txt file been created in c:\Documents and Settings when i executed this stored procedure
>[SQL] Script lines: 1-4 ----------------------------
declare @myarg integer
set @myarg = null
EXECUTE DBA.proc_hello_world @myarg output
print '@myarg: ' || str(@myarg)
>[Error] Script lines: 1-4 --------------------------
ASA Error -131: Syntax error near 'myarg'
Msg: 102, Level: 15, State: 0
Line: 0
[Executed: 6/12/08 4:08:32 PM PDT] [Execution: 0/ms]
I found a .txt file been created in c:\Documents and Settings when i executed this stored procedure
>[SQL] Script lines: 1-4 ----------------------------
declare @myarg integer
set @myarg = null
EXECUTE DBA.proc_hello_world @myarg output
print '@myarg: ' || str(@myarg)
>[Error] Script lines: 1-4 --------------------------
ASA Error -131: Syntax error near 'myarg'
Msg: 102, Level: 15, State: 0
Line: 0
[Executed: 6/12/08 4:08:32 PM PDT] [Execution: 0/ms]
"Set" doesn't work for IQ 12.5. Changed "set" to "select", as it's shown in the documentation in the example for EXECUTE, for all IQ server versions.
"Set" doesn't work for IQ 12.5. Changed "set" to "select", as it's shown in the documentation in the example for EXECUTE, for all IQ server versions.
Issue #1695 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
The code executed by ADS is ...
declare @myarg integer
set @myarg = 1
EXECUTE DBA.proc_hello_world @myarg output
print '@myarg: ' || str(@myarg)
This is correct, but Sybase IQ fails. I think this is a bug in Sybase IQ 12.5.
Tanya, can you verfiy?