anyone know what database this is from ???

[TRYP]

CREATE procedure
clx.proc_strip_markup(inout @adtext varchar(32000))
begin
--% Declare all variable required used in stored procedures
declare @li_asc integer;
declare @ls_output varchar(32000);
declare @ls_char varchar(255);
declare @ls_body varchar(32000);
declare @ls_setspace char(1);
declare @ls_lastspace char(1);
declare @li_tagon integer;
--% Initialiase variables
set @ls_output='';
set @li_tagon=0;
set @ls_setspace='N';
set @ls_lastspace='N';
--% set @ls_body = 'pronto [mb1] for//m/ja/dt *1* 1/4more @ web/@mymail.com {...}Start {.} [pc7f4fb]words {...}End {.}1{11} ';
set @ls_body=@adtext;
--% Start the loop
while length(@ls_body) > 0 loop
if ASCII(@ls_char) = 255 then
set @ls_body=SUBSTR(@ls_body,2)
end if;
set @ls_setspace='N';
case "Left"(@ls_body,1) when '*' then
--% Format

 

[jbenson001]

Looks like SQL Server to me...?

 

[checkai]

that's what I was thinking but sql server uses SubString instead of SubStr and Len instead of Length....

"...your mom goes to college..."

 

[jbenson001]

Humm yeah.. I missed that... not sure now ???

 

[macleod1021]

a quick google of "SUBSTR database" pulls up a bunch of DB2 and Oracle articles. So, I'd guess that

 

[checkai]

it's amazing what google can do...

 

[DotNetGnat]

sybase??

-DNG

 

[TRYP]

i thought oracle but nope swisSQL gives many errors during conversion


and im not a sybase user at all
soooo...

 

[macleod1021]

DB2 is from IBM.

From the sounds of it, you're attempting to convert a database. Did the sender not let you know what it came off of? If not, you should hope in the ole time machine and go back to make sure you don't pick up the phone when they call you the first time

 

[TRYP]

lol
nah i was given a proc to show how to parse a specific markup back into pure text...

thing is vendor of product is in australia and its well...night so i cant just say "Well hey there what type of proc is this u sent me" lol

thanks for all the help guys...if anyone has a moment of clarity let me know
-tryp

 

[vongrunt]

Hm...

Variable prefixes a la 'li_', 'ls_' etc (scope + datatype + underscore) are typical for Sybase programmers who did a lots of PowerBuilder stuff.

LENGTH() is not supported by Sybase ASE (Adaptive Server Enterprise).

So... gotta be Sybase ASA = former Sybase SQLAnywhere = former Watcom SQL.

------
[small]<this is sig>
select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')
</this is sig>[/small]