Hi,
I hope so that u would have got information by now, but more info can be got at www-3.ibm.com/software/ts/mqseries or
www-3.ibm.com/software/ts/mqseries/ platforms/integrator
this is the best place.
Ok, in breif i would only explain in a manner in which u try to make the other application...
Hi,
You can wirte a procedure with a if condition checking the country and then accordingly you set the NLS_DATE_FORMAT
create procedure ppp (country as VARCHAR)
begin
if country = 'XXX' then
SET NLS_DATE_FORMAT = 'mm/dd/yyyy';
elsif ....
SET NLS_DATE_FORMAT = 'dd/mm/yyyy';
end if;
end...
no, the btter way is have different procedures, as out them up in a package, this not only gives u access rights of the user to control.
Yaa, if still u want to continue off, then u can write it. but that will be very much cucumbersome.
as one is updateing, other is inserting etc..
bye
this is the code that i am using to connect to a queue manager.
Dim gHconn As Long
Dim gHobj As Long
Private Sub Form_Load()
Dim CompCode As Long
Dim Reason As Long
'=========================
'Initialize the structures
'=========================
MQ_SETDEFAULTS...
it is very easy doing this. Go to MQseries Explorer, and open the queue manager ,and click the queue folder, which displays u all the quesues on the right side. Double click the queue u want to see, and see all the messages. u get all information.
About seeing the data, u double click any one...
yes, when u submit your form , then what u do is update the datanbase, and pass the data in another screen with the data, so that the user can edit it. Then have another button "SEND" and he will send the mail, and then redirect him to the page u want. That is how we do.
I think this code would get u the Drop Down with the data.
<%
Dim rsItems
strSQL = "SELECT * FROM Item "
Set rsItems = Server.CreateObject("ADODB.Recordset")
rsItems.Open strSQL, objConn
rsItems1.open strSQL, objConn
If Not rsItems.EOF Then
Response.Write _...
here is the code from what i have understood
create or replace trigger john_labor
before insert on labor
for each row
begin
if inserting then
if :new.laborcode is null then
:new.laborcode:=substr(:new.name,1,4)||substr(:new.rowstamp,1,4);
end if;
end if;
end;
insert into labor...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.