Recent content by masalachol

I have weblogic 8.1 and When trying to create a connection pool to db2 on z\os. I get the following message : "The selected database driver is not installed in the classpath. You must install the driver to create a working connection pool". So I need help on the following: 1. Where can I go...

Hello: I am bringing this up again since we have gotten a little further and my previous comments and thus looking for some urgent input. Well I have a csv file where some strings are enclosed by a quotation marks. We found that the following sed operation sed 's/\(".*\)[,]\(.*"\)/\1\2/g'...

I have a file where I have to remove the commas that are between quotation marks and then replace the quatation marks with a pipe |. ie so far I have sed 's/\("*[,]*"\)/\|/g' and this replaces the quotation marks with a | but I feel I am going about it the wrong way. Any suggestions? file...

ok thank you very much .... i figured it out.

Ok i did what you suggested and it worked ... 1 2 PL/SQL procedure successfully completed. ok now I only want to capture the total number which would be 2 ....how do I do that?

I have multiple inserts and would like to know the total insert per job.....below with sql%rowcount I am only getting a count per insert not the total. Any suggestions? CREATE OR REPLACE PACKAGE BODY dbcarrier_load_data_pkg IS PROCEDURE invoice_load_pp (p_orgid IN cc_invoice.org_id%TYPE...

Golom and PHV .... YOU ARE AWSOME, THANKS!!!

I am trying to do the following in a query without success. Any suggestions If ParseOne+ParseTwo-Imp3=-0.01 then 0.01+ParseTwo Else ParseTwo OR If ParseOne+ParseTwo-Imp3=0.01 then ParseTwo-0.01 Else ParseTwo P2...

To me the best one in the market is navicat

Does anyone in this forum use mysql on a suse linux personal edition 9.1? If you do what mirror did you use to dowload mysql version 4.0. Also any linux pc user that has mysql I would sure appreciate some insight as your experience downloading and starting mysql on linux....any do's and don't do.

I am new and had similar problems with 5.0 and decided to go back to 3.23 and have not had any issues.

I am new at this also... there seems to be a couple of ways to do it. First I believe that if you are in a windows environment you can go to the c:\window directory and you will find a my.ini file. When you restart your computer this file will be read and the database will mount... you will see...

Hello: I am new to MYSQL and my knowlege base is from reading online documentatation. I found that the quickest and most convinient manner to load data to existing tables is using the load data infile <filename> into table <table_name> fields terminated by ' ' lines terminated by ' ' My...

Thanks, It works great!!!

hello: I am in a UNIX environment and I have a file named "mailout" that I am reading with the program below.What I really want to do is mail the report to my email address without echoing it to my screen. Looking forward to your replies...