Using xml to run db2 commands Post: 302821363

10 More Discussions You Might Find Interesting

1. IP Networking

Run commands on a UNIX with NT

Hi I'm trying to automatically run a command on a UNIX (AIX) machine from a Windows NT 4 machine. I can do this manually using the 'rexec' or 'rsh' command but I need an automatic login (on the AIX). In the manual I've found that there should be a '.rhosts' file on the Unix machine in the...

2. UNIX for Dummies Questions & Answers

XML Translator to run in UNIX

Hello, newbie (non-techie) here. I'm a business analyst for a software company in the Bay Area. A project I just got assigned to involved researching for an enterprise version of a XML translator that will run on UNIX. I'm looking for something that won't be too costly to purchase as the...

3. 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...

4. UNIX for Dummies Questions & Answers

Cannot run commands

It would be helpful if someone could help me out here. The problem I have been having is that I cannot run some commands which are valid - whenever I try to run the command I get the message "command not found". Now, if I run the same command as root it executes. These commands do not have to be...

5. Shell Programming and Scripting

Run several commands at a time

Hello guys, I am new at shell scripting and I want to create a script that runs several commands at a time, ie: uptime, w, df -h and so on and send the output of this commands to a text file so it can be send via email at a certain time using crontab. Any help will be much appreciated!

6. Shell Programming and Scripting

Run a shell script from one host which connext to remote host and run the commands

I want to write a script which would run from one host say A and connect to other remote host B and then run rest of commands in that host. I tried connecting from A host to B with SSH but after connecting to host B it just getting me inside Host B command prompt. Rest of the script is not running...

7. Shell Programming and Scripting

Run DB2 export command in loop

Hi All, I have list of 100 table names in a file, how to read table name from and pass to DB2 export command and run for all tables in loop. Please help me with script. db2 EXPORT TO ~/data_export/<table name from file>.ixf OF IXF MESSAGES messages.txt "SELECT * FROM ITG.<Table Name...

8. Shell Programming and Scripting

Assigning value of a select count(*) from tablename ( run on db2 ) to a unix variable

Hi All, I have browsed through the forums for a similar topic, but there is no topic which explains about this problem, when the backend is DB2. I want to assign the output of a select count(*) from tablename to a unix variable in a shell script. I am using ksh. The database used to...

9. UNIX for Dummies Questions & Answers

Run multiple commands

Hi All, Is it possible to run second/multiple commands at a time in script before the completion/return of first command? Pls reply.

10. Shell Programming and Scripting

Problem running db2 commands in awk

Hi , I am trying to use the below in awk but failed, any one assist please, awk '{ print $0; if ( $0 ~ /LOADTMP1/ ) { print $4; Table_name=system($( db2 -x "SELECT TRIM(TD.BSCHEMA) || '.' || TRIM(TD.BNAME) AS TABLE_NAME FROM SYSCAT.TABDEP TD WHERE TD.BTYPE='T' AND...

LEARN ABOUT DEBIAN

dctrl2xml

dctrl2xml(1)															      dctrl2xml(1)

NAME

       dctrl2xml - Debian control data to XML converter

SYNOPSIS

       dctrl2xml [-x | -j] [-f FILE]

DESCRIPTION

       dctrl2xml is a tool that converts Debian control data into an XML representation. It can be used to convert data which is normally found in
       debian/control, .changes, .dsc, Packages, Sources, and similar files to XML.

       For most fields dctrl2xml just uses the field name as element name and the field data as element content. For other fields, such as package
       interrelationship  fields  (Depends,  Build-Depends,  etc.)  or the Files field in .changes or Sources files, dctrl2xml additionally parses
       their field data to represent it in a more fine-structured form.

OPTIONS

       For a full summary of options, run dctrl2xml --help.

       --version
	      Show dctrl2xml's version number.

       -h, --help
	      Show help about options.

       -f FILE, --file=FILE
	      Read Debian control data from file FILE instead of standard input.  FILE can be either a plain text file or a  gzip,  bzip2  or  ZIP
	      file.

       -x, --xml
	      Output Debian control data as XML (default).

       -j, --json
	      Output Debian control data as JSON.

EXAMPLES

       dctrl2xml -f /var/lib/dpkg/available
	      Convert the whole dpkg(1) available file to XML and print it to standard output. This is a typical stress test for dctrl2xml.

       apt-cache show hello build-essential | dctrl2xml
	      Convert  the package records of the hello and build-essential packages to XML and print it to standard output. This is an example of
	      how dctrl2xml can be used in pipes where it reads the control data from standard input.

       apt-cache showsrc hello | dctrl2xml | xmllint --format -
	      This is similar to the above example, except that the xmllint(1) tool (which is in the libxml2-utils Debian package) is used to  re-
	      format  and  reindent dctrl2xml's output to make it more human readable and that the source package records of the hello package are
	      used.

       apt-cache showsrc hello | dctrl2xml -j
	      In this example hello's source package record is printed as JSON instead of XML.

SEE ALSO

       deb-control(5)

AUTHOR

       Written by Frank S. Thomas <fst@debian.org>.

								  20 August 2010						      dctrl2xml(1)

10 More Discussions You Might Find Interesting

1. IP Networking

Run commands on a UNIX with NT

Discussion started by: Mark Detrez

2. UNIX for Dummies Questions & Answers

XML Translator to run in UNIX

Discussion started by: Antsy

3. Shell Programming and Scripting

Run SQL queries in DB2 and output to file

Discussion started by: simhasuri

4. UNIX for Dummies Questions & Answers

Cannot run commands

Discussion started by: BigTool4u2