02-10-2018
Please clarify: Do you want
- database tables modified or inserted using
- db internal tools (artisan[?] / SQL / ...)
- external tools working on query results
- output files to be operated upon
- with which tools
- with which results (store / print / transfer / ...)
Last edited by RudiC; 02-10-2018 at 04:13 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
if u have a data
2 4 6 8 5 4 4 5 6
then result shud be like
2
4
6
7
5
4
4
5
6 (3 Replies)
Discussion started by: cdfd123
3 Replies
3. Shell Programming and Scripting
Hi,
I have a file with below contents.
Heading1 Heading2 Heading3 Heading4
Value1 Value2 Value3 Value4
The file has only 2 rows and is tab separated
The desired output is :
Heading1 Value1
Heading2 Value2
Heading3 Value3
Heading4 Value4
CAn you please help? (5 Replies)
Discussion started by: kaponeh
5 Replies
4. Shell Programming and Scripting
abc
xyz
-
-
-
-
-
-
-
-
-
-
-
How to sort the second column in ascending order. (2 Replies)
Discussion started by: sandy1028
2 Replies
5. Shell Programming and Scripting
Hi,
I have a problem where I need to make this input:
nameRow1a,text1a,text2a,floatValue1a,FloatValue2a,...,floatValue140a
nameRow1b,text1b,text2b,floatValue1b,FloatValue2b,...,floatValue140b
look like this output:
nameRow1a,text1b,text2a,(floatValue1a - floatValue1b),(floatValue2a -... (4 Replies)
Discussion started by: nricardo
4 Replies
6. Shell Programming and Scripting
hi,
I am basically running a sql that returns me values and I have stored them to a variable for example value of the variable will be:
123 124 345
now I want to write values stored in the variable into a file as
123
124
345
thanks in advance (3 Replies)
Discussion started by: babom
3 Replies
7. Shell Programming and Scripting
Hi Experts,
I have a requirement to convert rows into columns.
For e.g.
Input File:
Output File should be like
Appreciate if you could suggest code snippet(may be awk) for above requirement...
Thanks in Advance for your help... (3 Replies)
Discussion started by: sai_2507
3 Replies
8. Shell Programming and Scripting
Hi all ,
I have a file with the below content
Header Section
employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep
Data section ... (1 Reply)
Discussion started by: Hypesslearner
1 Replies
9. Programming
Dear Team
I am using DB2 v9 .
I have a condition to check roles based on hierarchies like below example.
1.Ramesh has Roles as "Manager" and "Interviewer"
2.KITS has Roles as "Interviewer"
3.ANAND has Roles as "Manager" and "Interviewer"
select * FROM TESTING
NAME ... (6 Replies)
Discussion started by: Perlbaby
6 Replies
10. UNIX for Beginners Questions & Answers
I am using DB2 v9 and trying to get country values in comma seperated format using below query
SELECT distinct LISTAGG(COUNTRIES, ',') WITHIN GROUP(ORDER BY EMPLOYEE)
FROM LOCATION ;
Output Achieved
MEXICO,UNITED STATES,INDIA,JAPAN,UNITED KINGDOM,MEXICO,UNITED STATES
The table... (4 Replies)
Discussion started by: Perlbaby
4 Replies
br(1) General Commands Manual br(1)
NAME
br - utility to interact with Firecracker device
SYNOPSIS
br [options] [housecode[list]] [native command] ...
DESCRIPTION
This manual page documents briefly the br command. br is a program that interacts with X10's Firecracker device allowing the user to
manipulate X10 devices throughout their house/office.
OPTIONS
The programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options are included
below.
-h, --help
Show summary of options.
-v, --verbose
Each -v will increase the verbosity.
-x, --port=PORT
Set port to communicate with (should be the port the Firecracker module is plugged into)
-c, --house=[A-P]
Use alternate house code for operations, default is A
-n, --on=LIST
Turn on all devices in LIST
-f, --off=LIST
Turn off all devices in LIST
-N, --ON
Turn on all devices in housecode
-F, --OFF
Turn off all devices in housecode
-d, --dim=LEVEL[,LIST]
Dim devices in housecode [or LIST] to relative LEVEL
-B, --lamps_on
Turn on all lamps in housecode
-D, --lamps_off
Turn off all lamps in housecode
-r, --repeat=NUM
Repeat commands NUM times (0 = ~forever)
AUTHOR
This manual page was written by Ashley Clark <aclark@debian.org>, for the Debian GNU/Linux system (but may be used by others).
Ashley Clark br(1)