what's in Your INFORMIX Library (was stored procedure)
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
Yes, I
did read from the INFORMIX books for 'store procedure and trigger'
but there is not much of samples and utilities tools or commands or built-in
functions (just like informix-4gl language) for 'store procedure and
trigger' that shows how to use when you have to write more complicated store
procedure - not just update or insert into tables.
And
-----Original Message-----
From: Konikoff, R.... [mailto:konikoffr@BRAGG.ARMY.MIL]
Sent: Thursday, April 17, 2003 10:32 AM
To: ids@iiug.org
Subject: what's in Your INFORMIX Library (was stored procedure) [955]
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
I enjoy the Informix Power References by Art Taylor
Informix Stored Procedure Programming by Michael L. Gonzales
Carl W Berner - Team Lead Informix/Oracle DBA
IBM Global Services - Serving Lucent Technologies
Work : (770) 750 5225
Pager: 1-800-759-8888 Pin#1615039
Email: cberner@lucent.com
-----Original Message-----
From: Konikoff, R.... [mailto:konikoffr@BRAGG.ARMY.MIL]
Sent: Thursday, April 17, 2003 11:32 AM
To: ids@iiug.org
Subject: what's in Your INFORMIX Library (was stored procedure) [955]
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
My
library is the textbooks from Informix training.
I'd pay the price for the "all you can eat" training all over again,
just for the
books (the training that comes with the books makes the deal three times
as sweet).
Sam
-----Original Message-----
From: Konikoff, R.... [mailto:konikoffr@BRAGG.ARMY.MIL]
Sent: Thursday, April 17, 2003 11:32 AM
To: ids@iiug.org
Subject: what's in Your INFORMIX Library (was stored procedure) [955]
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