Sponsored Content
Full Discussion: processing db2 output
Top Forums Shell Programming and Scripting processing db2 output Post 302412682 by valero on Tuesday 13th of April 2010 08:42:44 AM
Old 04-13-2010
Works, but...

Thanks durden_tyler, you rock! I am trying to use the your code for another scenario, and it gives me all the output in one line, well, it really shows that I got to learn perl Smilie

Can you suggest me good online source for learning perl syntax, thanks again!!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

flags to suppress column output, # of rows selected in db2 sql in UNIX

Hello, I am new to db2 SQL in unix so bear with me while I try to explain the situation. I have a text file that has the contents of the where condition that I am using for a db2 SQL in UNIX ksh. Here is the snippet. if ; then echo "Begin processing VALUEs" ... (1 Reply)
Discussion started by: jerardfjay
1 Replies

2. Shell Programming and Scripting

Run SQL queries in DB2 and output to file

Hi, I new to Unix and scripting. Following is my requirement. Can someone tell me whether its possible or not. Also please let me know how to proceed further if this is possible. List of queries are stored in a file. For example, I have to run a query like this: Select * from &XYZ where... (0 Replies)
Discussion started by: simhasuri
0 Replies

3. Shell Programming and Scripting

running db2 sql and exporting output from ksh scipt

Hi there, I am trying to write a shell script as root on AIX 5.3 where I change user to db2inst1, connect to our db2 database, run a sql select query and export the result of the query to a file. The code I have so far is as follows:- #!/usr/bin/ksh su - db2inst1 -c "db2 connect to... (0 Replies)
Discussion started by: candlino
0 Replies

4. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies

5. IP Networking

processing tcpflow output

I'm using tcpflow to analyze traffic traces. When I launch tcpflow with -r option it creates some files, one for each flow. The problem is that some of these files are not readable. I tryed to process them with awk, but also using it i cannot visualize them correctly. Can anyone suggest me a... (5 Replies)
Discussion started by: littleboyblu
5 Replies

6. Shell Programming and Scripting

Need Fix in Exporting a db2 query output

When I use export for sql query in a Script : Select '1',ModHist',count(*) from cc.mdhist; it was exporting the record to a file as: "1" "ModHist" 778201 Here 1 & ModHist are coming in Doublequotes. If I run the above query directly in Unix prompt it was displaying the output as... (1 Reply)
Discussion started by: karumudi7
1 Replies

7. Shell Programming and Scripting

processing the output of AWK

Hi my input file is <so > < Time > <Pid> <some ro><Job Name> 111004 04554447 26817 JOB03275 MBPDVLOI 111004 04554473 26817 JOB03275 MBPDVLOI 111004 04554778 26807 JOB03276 MBPDVAWD 111004 04554779 26807 JOB03276 MBPDVAWD 111004 04554780 26817 ... (4 Replies)
Discussion started by: rakeshkumar
4 Replies

8. Shell Programming and Scripting

Printing the output of a db2 query on to an unix file

I want to print the output of a db2 query, on to an unix file in a manner that the columns are separated by 'commas'. Please help me out..thanx in advance (1 Reply)
Discussion started by: prasan_ven
1 Replies

9. UNIX for Dummies Questions & Answers

Take output of processing in text file

Hi ALL, I am presently using perl script mukesh.pl I just want to catch its output into another text file . So I am using > File.txt . I am getting output but i want the whole processing of the script into that file please let me know . Thanks in advance Cheers Mukesh (1 Reply)
Discussion started by: mumakhij
1 Replies

10. Shell Programming and Scripting

Processing diff output

How to get diff to not print the chevrons and the dashes? In this case the differences are all single line differences. Also the first few lines don't matter. How to get the output to always exclude the first few lines? Thanks! (1 Reply)
Discussion started by: stevensw
1 Replies
Mojolicious::Plugin::EPRenderer(3pm)			User Contributed Perl Documentation		      Mojolicious::Plugin::EPRenderer(3pm)

NAME
Mojolicious::Plugin::EPRenderer - Embedded Perl renderer plugin SYNOPSIS
# Mojolicious $self->plugin('EPRenderer'); $self->plugin(EPRenderer => {name => 'foo'}); $self->plugin(EPRenderer => {template => {line_start => '.'}}); # Mojolicious::Lite plugin 'EPRenderer'; plugin EPRenderer => {name => 'foo'}; plugin EPRenderer => {template => {line_start => '.'}}; DESCRIPTION
Mojolicious::Plugin::EPRenderer is a renderer for "ep" templates. "ep" or "Embedded Perl" is a simple template format where you embed perl code into documents. It is based on Mojo::Template, but extends it with some convenient syntax sugar designed specifically for Mojolicious. It supports Mojolicious template helpers and exposes the stash directly as Perl variables. This is a core plugin, that means it is always enabled and its code a good example for learning to build new plugins, you're welcome to fork it. OPTIONS
Mojolicious::Plugin::EPRenderer supports the following options. "name" # Mojolicious::Lite plugin EPRenderer => {name => 'foo'}; Handler name. "template" # Mojolicious::Lite plugin EPRenderer => {template => {line_start => '.'}}; Attribute values passed to Mojo::Template object used to render templates. METHODS
Mojolicious::Plugin::EPRenderer inherits all methods from Mojolicious::Plugin and implements the following new ones. "register" $plugin->register($app, $conf); Register renderer in Mojolicious application. SEE ALSO
Mojolicious, Mojolicious::Guides, <http://mojolicio.us>. perl v5.14.2 2012-09-05 Mojolicious::Plugin::EPRenderer(3pm)
All times are GMT -4. The time now is 04:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy