11-05-2009
Quote:
Originally Posted by
frans
I can try if i can get a sample of data but i believe that there are powerful (and free) tools to manage such tables. I don't know what kind of system and distribution you are using but i'm sure you can find an appropriate one.
Did you get that xml code by exporting from DB2 ?
Hi Frans,
Let me explain the scenario.
We are using SAS DI studio to do the ETL.
The source DB2 table has 6 columns and one of the column is CLOB datatype containing the xml. When we imported into SAS DI it used lot of memory for the CLOB datatype, since we needed just the part of the xml we thought we'll process the xml thru shell scripting to get the string we need.
Instead of exporting the db2 table and processing the xml, it will be easier if we can read the xml column from the db2 table process it and save it in another new column in the same db2 source table.
Hope I'm clear.
Thanks,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Compete noob question....
I need a script to search through a directory and find files containing text string abcde1234 for example and then copy that file with that text string to another directory
help please :eek: (9 Replies)
Discussion started by: imeadows
9 Replies
2. Shell Programming and Scripting
I need a script to process a huge single line text file:
The sample of the text is:
"forward_inline_item": "Inline", "options_region_Australia": "Australia", "server_event_err_msg": "There was an error attempting to save", "Token": "Yes", "family": "Family","pwd_login_tab": "Enter Your... (1 Reply)
Discussion started by: hmsadiq
1 Replies
3. Shell Programming and Scripting
HI all,
I want to script where all the server names will be in a text file like
server1
server2
server3 . and the script should take servernames from a text file and perform copy of files if the files are not present on those servers.after which it should take next servername till the end of... (0 Replies)
Discussion started by: joseph.dmello
0 Replies
4. Shell Programming and Scripting
Hello!
I have text file:
From aaa@bbb Fri Jun 1 10:04:29 2010
--____OSPHWOJQGRPHNTTXKYGR____
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
My code '234565'. ... (2 Replies)
Discussion started by: candyme
2 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I want to copy text between expressions ">bcr1" and ">bcr2" to another file.
Any simple solutions?
Thanks (4 Replies)
Discussion started by: alpesh
4 Replies
6. UNIX for Dummies Questions & Answers
Input File1 constatntly running and growing in size.
My Program Erorr ddmmyy hh:mm:ss My Program Error
**Port 123 terminated
**ID PIN 12345
Comamnd Successful
Command Terminated
Command Successful
Command Terminated
**My Program Erorr ddmmyy hh:mm:ss My Program Error
**Port 345... (3 Replies)
Discussion started by: eurouno
3 Replies
7. Shell Programming and Scripting
I am a newbie to shell scripting
I have a large log file , i need to work on the part of the log file for a particular date.
Is there a way to find the first occurance of the date string and last occurance of the next day date date string and move this section to a new file.
to explain it... (3 Replies)
Discussion started by: swayam123
3 Replies
8. Shell Programming and Scripting
Hi friends,
i need to prepare a script ( in perl)
i have a file called "demo.exe" in my local unix host.
i have a list of remote hosts in a file "hosts.txt"
now i need to push "demo.exe" file to all the hosts in "hosts.txt" file.
for this i need to prepare a script(in perl, but shell... (5 Replies)
Discussion started by: siva kumar
5 Replies
9. Shell Programming and Scripting
Hello experts,
I am facing an very typical problem and hope the issue can be solved.
I have a page download.cgi in /cgi-bin folder.
use CGI;
use CGI::Carp qw ( fatalsToBrowser );
use File::Copy
copy("C:\\Program Files\\Apache Software... (8 Replies)
Discussion started by: scriptscript
8 Replies
10. Shell Programming and Scripting
Hi,
I want to do the following in a Unix shell script and wonder if someone could assist me?
I want to take files in a specific directory that start with the name pxpur012 and copy them to the same directory with the file name not containg pxpur012. For example, I have files like... (4 Replies)
Discussion started by: lnemitz
4 Replies
LEARN ABOUT REDHAT
xml::dumper
Dumper(3) User Contributed Perl Documentation Dumper(3)
NAME
XML::Dumper - Perl module for dumping Perl objects from/to XML
SYNOPSIS
# Convert Perl code to XML
use XML::Dumper;
my $dump = new XML::Dumper;
$data = [
{
first => 'Jonathan',
last => 'Eisenzopf',
email => 'eisen@pobox.com'
},
{
first => 'Larry',
last => 'Wall',
email => 'larry@wall.org'
}
];
$xml = $dump->pl2xml($perl);
# Convert XML to Perl code
use XML::Dumper;
my $dump = new XML::Dumper;
# some XML
my $xml = <<XML;
<perldata>
<scalar>foo</scalar>
</perldata>
XML
# load Perl data structure from dumped XML
$data = $dump->xml2pl($Tree);
DESCRIPTION
XML::Dumper dumps Perl data to a structured XML format. XML::Dumper can also read XML data that was previously dumped by the module and
convert it back to Perl.
This is done via the following 2 methods: XML::Dumper::pl2xml XML::Dumper::xml2pl
AUTHOR
Jonathan Eisenzopf <eisen@pobox.com>
CREDITS
Chris Thorman <ct@ignitiondesign.com> L.M.Orchard <deus_x@pobox.com> DeWitt Clinton <dewitt@eziba.com>
SEE ALSO
perl(1), XML::Parser(3).
perl v5.8.0 1999-06-20 Dumper(3)