Recent content by lynchdog

I was wondering what hardware to buy to make this setup work. Details: - A Dlink wireless router connect to a broadband modem in the living room (Used for my laptop and my desktop in the next room over.) What piece of hardware do I have to get for the garage that will allow me to connect my...

Is it possible in UDB 7.2 to specify that you only want inserts replicated?

I was wondering if somebody could give me some information on DRDA connections. They are the only kind of connection I appear to be able to make between the db servers. The reason for this is that the db runs on W2K in a DMZ and in my new company they have the machines locked down pretty...

I've been asked to write a report against a transactional database which is made up of 3-7 transactions. TRANSTYPE STATUS --------- -------- 68 SUCCESS specific data for this transtype 71 MATCH specific data for this transtype 76 SUCCESS specific data for this transtype...

How do I control bounced emails from removed employees. &quot;The following recipients did not receive the attached mail. Reasons are listed with each recipient: <X-EMPLOYEE@imagedatallc.com> X-EMPLOYEE@imagedatallc.com MSEXCH:IMS:IMAGE DATA:IMAGEDATA-DOM:IDEXCH01 0 (000C05A6) Unknown...

Yes that was the trick...Thanks for the posts/help. I've been confused by this for a day now on other if formulas.. Josh

Thanks for the input but still no dice...I am completely confused by this. if ({FORMATTEDTRANS.TYPE_69_STATUS} = &quot;MATCH&quot; or {FORMATTEDTRANS.TYPE_70_STATUS} = &quot;MATCH&quot; or {FORMATTEDTRANS.TYPE_71_STATUS} = &quot;MATCH&quot;) then &quot;Image Displayed: Accepted&quot...

I for the life of me can not figure out what is wrong with this formula. It appears that the only thing being evaluated is the very first line of the if statement and nothing beyond that. I appreciat any help on this one... Thanks, Josh if {FORMATTEDTRANS.TYPE_69_STATUS} = &quot;MATCH&quot...

I have a string &quot;YYNNYYYXXNYN&quot;, from which I need to be able to count the number of X(s), Y(s), and N(s). I am unable to locate a command or think of a why to programatcally do this...any help would be appreciated. Josh

Is there anyway to write a script that could send an email when a scheduled backup fails? Josh

I've never ran the ddl from the command line. I've always done it in the command window gui. As for knowing if there is a problem between the versions, i don't know for sure. I've been working with db2 for about six months now and have only used it on NT. good luck

In the control center I right click on a table or on the database container. From the menu that select Generate DDL. The next screen that appears is for the parameters for the dblookup command.

I understand how to setup a trigger to move data around with the local database. What I would like to try is a trigger that when set moves the data to another database on another machine.

I did a little more reading on this. I've never used the db2move (though I should start!) that sounds like it will move the data for you by exporting and importing the data for you. As for a ddl (Database defination language) It is created view the db2look command. I use the gui tools so the...

I'd think that you would want to generate the ddl for the database. From there look through the file and change the database name to your new one. After running this script this will get you a database the looks like the original. Next, export and than import (or load depending on the amount...