08-17-2006
Thanks both of you!!!
That was very helpful!!
Appreciate your guidance
Regards,
Bhagat
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies
2. Shell Programming and Scripting
i have a file a.txt and following is only one portion.
I want to search <branch value="/dev36/AREA/" include="yes"></branch> present in between
<template_file name="Approve External" path="core/approve/bin" and </template_file>
where the no of lines containing "<branch value= " is increasing ... (2 Replies)
Discussion started by: millan
2 Replies
3. Shell Programming and Scripting
I have many pdf's scattered across 4 machines. There is 1 location where I have other Pdf's maintained. But the issues it the 4 machines may have duplicate pdf's among themselves, but I want just 1 copy of each so that they can be transfered to that 1 location.
What I have thought is:
1) I have... (11 Replies)
Discussion started by: deaddevil
11 Replies
4. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
5. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
6. Shell Programming and Scripting
Hi,
I want to access mysql query from database , for that i have tried the below code
#! /bin/bash
TABLE_NAME=database1
USER_NAME=root
IP_ADDR=111.20.9.256
somevar=`echo "select altid from alert where altid='2724'"| mysql -h $IP_ADDR -u $USER_NAME $TABLE_NAME `
echo $somevar
... (1 Reply)
Discussion started by: aish11
1 Replies
7. Shell Programming and Scripting
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (11 Replies)
Discussion started by: aish11
11 Replies
8. Shell Programming and Scripting
Hi all,
Help needed urgently.
I am currently writing a shellscript to read data/record from a flat file (.txt) file, and import/upload the data to oracle database. The script is working fine, but it takes too long time (for 18000 records, it takes around 90 mins).
I guess it takes so long... (1 Reply)
Discussion started by: robot_mas
1 Replies
9. UNIX for Advanced & Expert Users
LOG_DIR=/app/rpx/jobs/scripts/just/logs
sendEmail()
{
pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7"
(
echo "From: $pzFrom\nTo: $pzTo\nSubject: $pzTitle${pzReplyTo:+\nReply-To: $pzReplyTo}"
] && echo... (1 Reply)
Discussion started by: ankit.mca.aaidu
1 Replies
10. Shell Programming and Scripting
I have a problem with my shell script. I want to insert data from file to table1(empty) and then, compare table1 with table2 and update some fields.
The first part is correct, but the second part does not work. The only way it works is if after the first part I truncate table1 and run the script... (1 Reply)
Discussion started by: nika_mill
1 Replies
TASKS(3) User Contributed Perl Documentation TASKS(3)
NAME
TASKS - Want to help? These things need doing...
Increase test coverage
More tests need to be added to test the codes that not urrently being tested.
It's pretty poor right now:
http://pjcj.sytes.net/cover/latest/DBI-1.52/coverage.html
Start with improving the subroutine coverage
http://pjcj.sytes.net/cover/latest/DBI-1.52/blib-lib-DBI-pm--subroutine.html
Test the proxy
The current t/80proxy.t is isolated from the rest of the test suite so actually tests very little, and what it does test is duplicating
other tests.
Ideally the proxy should be tested in the same way as DBI::PurePerl. In other words, by creating wrappers test files for each test file
that set $ENV{DBI_AUTOPROXY} and run the original test. They'll also need to start and stop a proxy server.
Fixing bugs
The official bug list is here:
http://rt.cpan.org/NoAuth/Bugs.html?Dist=DBI
Naturally I'll offer direction and guidance on any you want to tackle. I've also got a few that could be entered into rt.cpan.org.
Others
General:
Protect trace_msg from SIGPIPE?
prepare(...,{ Err=>my $isolated_err, ...})
Add trace module that just records the last N trace messages into an array
and prepends them to any error message to provide context for the error.
Document DBI_PROFILE_FLOCK and LockFile attrib in DBI::ProfileData and DBI::ProfileDumper
Performance:
Move _new_sth to DBI::db::_new_sth (leave alias) and implement in C
Or call _new_child and move to DBI::common?
Implement FETCH_many() in C
Add high-res dbi_time for windows - via Time::HiRes glob replace dbi_time()?
perl v5.12.1 2009-06-08 TASKS(3)