IDS Forum

what's in Your INFORMIX Library (was stored procedure)

Posted By:
Date:

Tah:

My preference is for the Ron Flannery book, The INFORMIX Handbook. I use a
lot of other references, and I'd be interested to know what others have in
their library.

Rob Konikoff
Eagle Group-2CMMC Ft Bragg
COMM:910-396-1686/1096/6105/4883
DSN:236-XXXX
Have you tried FINLOG today?
http://www.finlogonline.com


-----Original Message-----
From: tah davis [mailto:tdavis@knrq.com]
Sent: Thursday, April 17, 2003 10:10 AM
To: ids@iiug.org
Subject: RE: syntax in 'store procedure' [954]


Thanks so much for your help - it worked. I'd like to know where I can find
the useful syntaxs or procedure commands - just like 'trim' that in the
future I can use in the store procedure or trigger codes.
Thanks in advances
Tah Davis

-----Original Message-----
From: Eric Washal.... [mailto:Eric.Washaliski@mediware.com]
Sent: Wednesday, April 16, 2003 5:34 PM
To: ids@iiug.org
Subject: RE: syntax in 'store procedure' [951]





let pronumber_set1 = trim(pronumber_set1) || " " || p_pro;




-----Original Message-----
From: Grumelart, .... [mailto:agrumela@foxboro.ca]
Sent: Wednesday, April 16, 2003 4:45 PM
To: ids@iiug.org
Subject: RE: syntax in 'store procedure' [950]


I had to deal with the same problem.
I found that self concatenation does not work
because char types are padded with spaces.
So there is never any space left to concatenate anything to oneself.
I think this will work.

define procnumber varchar(10);
let procnumber = procnumber_set1; -- I think this trims the trailing
spaces
let pronumber_set1 = pronumber || p_pro;


-----Original Message-----
From: tah davis [mailto:tdavis@knrq.com]
Sent: Wednesday, April 16, 2003 2:38 PM
To: ids@iiug.org
Subject: RE: syntax in 'store procedure' [948]


Yes, I did try, but it does not work.


-----Original Message-----
From: Jairo Gubler [mailto:jairo.gubler@digitro.com.br]
Sent: Wednesday, April 16, 2003 1:34 PM
To: tah davis
Subject: Re: syntax in 'store procedure' [946]


Try this.

let pronumber_set1 = pronumber_set1 || p_pro;


----- Original Message -----
From: "tah davis " <tdavis@knrq.com>
To: <ids@iiug.org>
Sent: Wednesday, April 16, 2003 2:18 PM
Subject: syntax in 'store procedure' [946]


Hi,
I need help on 'store procedure' codes. Did the store procedure allow
'concatenated text'?
There is an example below. It does not work. How do I supposed to do to
get the row of 'p_pro' in one line of text such as: A123 B234 ...
p_pro p_pro ---> define as char(16)
EX: pronumber_set1 = 'A123 B234 C345 D456.......' ---> the result
which I want to be

foreach
select pro_number, seqnum, mnfst_set
into p_pro, totalnumberpros, manifestnumber
from fb_delivery
where trailer_key = trailernumber
and mnfst_date = trl_status_date
order by seqnum

if totalnumberpros <= 54 then
let pronumber_set1 = pronumber_set1 , p_pro;
else
let pronumber_set2 = pronumber_set2 , p_pro;
end if
end foreach

Thanks,
Tah Davis

Messages In This Thread

• what's in Your INFORMIX Library (was stored procedure)
  Konikoff, Rob (Contractor) -- Thursday, 17 April 2003, at 11:32 a.m.
  • RE: what's in Your INFORMIX Library (was stored procedure)
    tah davis -- Thursday, 17 April 2003, at 12:49 p.m.
  • RE: what's in Your INFORMIX Library (was stored procedure)
    Berner, Carl (Carl)** CTR ** -- Thursday, 17 April 2003, at 1:48 p.m.
    • RE: what's in Your INFORMIX Library (was stored procedure)
      Sam Gentsch -- Thursday, 17 April 2003, at 3:01 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.