Wi-Skier

What famous piece of music is 100 years old today?

It was NOT debuted on this day, but the composer completed his work on the piece 100 years ago this very day.

Our '02 Impala is in a ditch and the best option for pulling it out is nosefirst. Where is a good tie point I can get a tow strap onto?

Thanks

Hey I have to alter a table field from varchar2(5) to number(11) the table contains roughly 50 million records and is indexed and the like. I have used regular DDL and then went with bulk collecting & updating via PL/SQL and the PL/SQL did improve things but not enough.

To alter, I have been adding a temp field, assigning the data to the temp field, nulling the old field, reassigning the temp_field back to the old field, and dropping the temp field.

One complication is the old field occasionally has a non-numeric in it. I have a trigger designed to handle this when assigning to the temp field.

Anyway thanks

The Wisconsin Skier

Greetings,

I have to convert a field in a number of datasets, all are GDGs. Two questions.

1.) How can I loop through the GDGs? Right now, my idea is to copy the GDGs to another GDG base, process the new base rewriting the datasets back to the old base. Seems to me I have to create job steps to copy & process each GDG member separately.

2.) The field I am converting is a PIC X(5) and I have to recreate it as a PIC S9(11) COMP-3. In some cases I think I am going to be able to use File-Aid but one set of these is more problematic. The field I am converting may contain values such as all spaces, "#", all digits, and digits followed by spaces. I have been able to scrub all spaces and "#" characters but the digits followed by spaces is causing me problems. Need I write a COBOL program to do this? Or shold File-Aid or Sort be able to handle this?

Thanks

Greetings,

What is your favorite recording of John Cage's 4'33?

Greetings,

I am writing a Perl application that reads through data and occasionally updates an Oracle table. I got it working just fine in test, but we have a situation in the production environment.

On my test system I set up the DSN with a username of "testid/testpwd". I mentioned this to our DBA and he has security concerns with the password being exposed in such manner. Is there a way to more securely define the DSN with Windows?

Thanks

Greetings,

I am working on a Perl script to read through an Oracle extract file containing two fields. The first is a table key field and the second is a 2000 max character varchar2 field containing notes. Some of those notes contain embedded new line characters. The script performs a replacement on a certain pattern (if present).

I read the file binary raw, unpack, search & replace on the pattern, chomp the field, prepare the field for updating (including eliminating field delimiter characters and prepping embedded apostrophes), format the update statement, and update.

I added in code to attempt to escape newlines (i.e. replace \n with \\n) and I just gave pack a try to format the update statement (using both a & b to encode the update statement).

Is there a special character I can substitute new lines for? Is there a function to help out here?

BTW, I am accessing Oracle via Win32::ODBC

Thanks

Mark

I have a PERL script creating a TAR archive via PERL's Archive::TAR class. I get a listing of the files & directory structure by recursing through the tree & putting all into a list.

Then I use: $TarObject->create_archive

($ArchiveFile, $CompressionLevel, @FilesToTar); where I have used compression levels 2 & 9. These create TARs of about 40+ MB.

When I retrieve the TARs to my workstation I attempt to run them through tar -xzvf and I get:

tar: Skipping to next header

tar: Archive contains obsolescent base-64 headers

gzip: stdin: invalid compressed data--format violated

tar: Child returned status 1

tar: Error exit delayed from previous errors

I have attempted to use gzip & uncompress as well.

Any ideas?

Thanks

Mark

Listening to:

Suppé's Light Calvary Overture?

Rossini's William Tell Overture?

Tchaikovsky's 1812 Overture?

Have you been ticketed because the music impelled you to speed? I have been, a long time ago a Led Zeppelin song gave me a Led foot. Today it would be one of the above. What pieces give you a lead foot?

Have you heard or seen a performance by the University of Santo Tomas Singers? What did you think?

Have you heard of or seen a performance by the University of Santo Tomas Singers? What did you think?

my $SelectSelectFlds = sprintf("select sfld_field_name, sfld_size, sfld_maxlength, sfld_html_id, sfld_float_txt, sfld_anchor, slctc_choice_value, slctc_default from select_fields, select_choices where sfld_apf_id = %s and sfld_id = slctc_sfld_id;", $APFID);

my $SelectFieldsQuery = $DBConnection->prepare($SelectSelectFlds) or die;

$SelectFieldsQuery->execute() or die;

$SelectFieldsQuery->bind_columns(undef, \$FieldName, \$FieldSize, \$MaxLength, \$HTMLSelectID, \$FloatTxt, \$AnchorLabel, \$ChoiceValue, \$DefaultInd) or die;

my $numrows = $SelectFieldsQuery->rows;

print LOGFILE "Number of select field rows selected is $numrows\n";

The DB connection is good. I have logged the query and then pasted it into MySQLCC and it returns three rows (expected), but numrows is logged as 0.

Does anything leap out at you?

New sea creature discovered off of Hawaii. Appears to be a cross between a squid and octopus.

What do you think would be the best way to cook this thing up?

See: http://starbulletin.com/2007/07/05/news/story03.ht... for a photo & details.

I have done some searching, but is there a listing of PERL's NET::FTP messages.

In case of a put failure, I want to determine the cause and then direct an alerting e-mail based on the cause (e.g. a connection gone bad message would be sent to X and a permissions problem alert goes to Y).

Thanks

WiSkier

Check this website out: http://bisdak.wordpress.com/2006/10/05/ang-iring-k... Does that animated photo remind you any YAPers?

I am trying to match a pattern such as: llmci0705171.dat. I have the following regular expression: /llmci\d+\.dat/ but this does not work. However, this pattern does work: /llmci\w+\.dat/.

This seems to hold true on win system I am developing this for and on my home linux system (where I am testing the expression w/egrep looking through files e.g. egrep -e "llmci\d|\.dat" *)

Thanks!

Greetings,

The Wisconsin Snow Bunny and myself are being presented with an opportunity to invest in the Philippines (a family venture). Being we are both US Dollar earners and savers and the transaction (investment and return) would be in Philippine Pesos we would be exposed to Ph. Peso vs. US Dollar currency risks. Right now, the trend is favorable. Do you see the trend continuing and stabilizing? Do you see the trend reversing itself?

What do you see happening in the future regarding Philippine Peso vs. US Dollar trading?

Salamat po kayo!

Greetings, I am researching the feasibility of solar electricity in a house we are about to build. I found a set of data giving average monthly insolation by city. Of course, I did not write down the location of that table. Do you know of any such table and where it is?

Thanks

The Wisconsin Skier

I had a P0422 ODB2 code on my '02 Impala. I reset the code & wonder about resetting the ODB2 Cycle. Is it just a matter of driving it until it resets or is there a procedure to doing it?

If there is a procedure, what is it? Owners manual says nada, wala, zip, nothing.

Thanks!

I have a process splitting out detail records from files. The last file written out always has records in it, but PERL's stat says the last file is size of 0 bytes. This messes up attempts to FTP that file.

Have you run into this before? What was the cause? Any ideas?

Thanks