Hi, How does one execute this SQ

[shyamal]

Hi,

How does one execute this SQL stored procedure in Sybase 12.5?

declare
@i integer
set @i = 1
while @i <= 5000
begin
insert into T00 (RECID) values (@i)
insert into T50 (RECID) values (@i)
set @i = @i + 1
end

Thanks in advance.

 

[JeanNiBee]

Hi

Sorry but I am not sure I understand your question.

Are you getting an error or, do you just need to know how to execute commands in Sybase?

If you are getting an error, please post the error and I will be glad to help out.

Thanks.




-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[sybaseguru]

I think you have a mistake in your code

set @i = 1 should be

select @i = 1

Anyway this is the correct code as far as I can see

declare
@i integer
select @i = 1
while @i <= 5000
begin
insert into T00 (RECID) values (@i)
insert into T50 (RECID) values (@i)
select @i = @i + 1
end


Try it & good luck

 

[shyamal]

Thanks SybaseGuru! This worked. The set is used in SQL vs. the select in Sybase.