Sponsored Content
Special Forums UNIX and Linux Applications Need small help to write the code in unix Post 302326080 by lkeswar on Wednesday 17th of June 2009 04:42:15 AM
Old 06-17-2009
Need small help to write the code in unix

Hi,

I tried with the shell script but it is not loading into table for the below script

#!/bin/bash

#export custno=""

custno=$(awk -F"," '{print NR " " $3}' 'datafile.txt' | grep 1 | cut -d" " -f2)
sed 's/#x#/'$custno'/g' 'ctrl.ctl'

Below is the data file(datafile.txt)

sno,sNAME,35642,reactflag
1,KIRAN,KUMAR
2,SURESH,KUMAR
3,MADHU,VARIGONDA

Here is the control file(ctrl.ctl)
options(skip =1)
LOAD DATA
INFILE 'datafile.txt'
TRUNCATE INTO TABLE LOADER_TEST
FIELDS TERMINATED BY ','
TRAILING NULLCOLS (
sno Integer external,
sname char(50),
custno char(50) CONSTANT '#x#',
reactflag char(50)
)

Please help me in advance
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

small unix!

i'm looking to put a very minimal unix on a 386 i just acquired. it needs to be downloadable and i need to install it using 3.5 floppies! thanks for suggestions, -nydel (4 Replies)
Discussion started by: nydel
4 Replies

2. UNIX for Dummies Questions & Answers

unix on a small drive?

has any body put freebsd on a drive smaller than 80megs? (4 Replies)
Discussion started by: silverraindog
4 Replies

3. Shell Programming and Scripting

Small UNIX problem

I have a shell script that carries out an extraction process as follows: For a given input file dummy which looks like the following: a.txt a 1 a 2 xnzbcnzbxcbzxncbmnzxbcmzx 546 456 45 5 6 56 a 3 b.txt b1 b2 (1 Reply)
Discussion started by: nbvcxzdz
1 Replies

4. Shell Programming and Scripting

small script - get sql output & write into txt

Hi, how can I write a small script to run the following statement and output the result into check_result.txt select /*+RULE*/ tapname from typetbl where tapname like 'AA%' and rejectcode=9; Normally, I just type sql and get into SQL> (2 Replies)
Discussion started by: happyv
2 Replies

5. Programming

execution small C++ program in UNIX

Hi my friends I am beginner unix programmer I have written small c++ program in text editor and I have change it mode to 555 to make it executable file to use it in unix O.P. #include<iostream.h> main() { cout<<"Hello World"; } but some syntax erroe came for << can any one help... (5 Replies)
Discussion started by: bintaleb
5 Replies

6. Shell Programming and Scripting

AWK deifnition and some small code explanation

Could someone give me a quick simple explanation for the AWK command. And also help me to explain the code i have made. I have made some general comments about it myself. I was wondering if people could help me with the rest: awk -F'' 'END { fmt = "%-20s\t%s\t%s\n" ... (0 Replies)
Discussion started by: amatuer_lee_3
0 Replies

7. Shell Programming and Scripting

Write a small shell script

Hello Forum members, Have a nice day. I have to write a script for the following below scenario. There are 3 applications located in home directory(ie xyz/app) which have multiple directories and files of diff format(.sh,log,other formats). Case 1: I have to find the hardcoded... (8 Replies)
Discussion started by: rajkumar_g
8 Replies

8. UNIX for Advanced & Expert Users

Small database that can be bundled with UNIX

Hi All, I am working on a file transfer tool between unix servers. for this i am looking for a small database which is free and compatible with all unix OS and can be bundled in a package with other scripts. Any suggestions (8 Replies)
Discussion started by: Jcpratap
8 Replies

9. What is on Your Mind?

Number of Small Forum Code Changes (TODO List Items)

In the past few days have I have done a lot of code cleanup work in various categories, including faster page loading and bug fixes: Move countless inline style directives to external CSS stylesheets for key pages (faster page loading) Fixed bug in member panel going between desktop and... (6 Replies)
Discussion started by: Neo
6 Replies
NGRAPH(1)						      General Commands Manual							 NGRAPH(1)

NAME
Ngraph - creating scientific 2-dimensional graphs SYNOPSIS
ngraph [options] [data file(s) or ngp file] DESCRIPTION
Ngraph is the program to create scientific 2-dimensional graphs for researchers and engineers. Graphs can be exported to PostScript, SVG, PNG or PDF format. OPTIONS
Command line options are: -L file load ngp file -x column data column for the x axis -y column data column for the y axis -X use X axis as the x axis -Y use Y axis as the y axis -U use U axis as the x axis -R use R axis as the y axis -d {mark | line | polygon | curve | diagonal | arrow | rectangle | rectangle_fill | rectangle_solid_fill | errorbar_x | errorbar_y | stair- case_x | staircase_y | bar_x | bar_y | bar_fill_x | bar_fill_y | bar_solid_fill_x | bar_solid_fill_y | fit} specify plot type -m type specify mark type (0-89) -o size specify mark size -l style specify line style -w width specify line width -CR n specify red component of the 1st plot color (0-255) -CG n specify green component of the 1st plot color (0-255) -CB n specify blue component of the 1st plot color (0-255) -cr n specify red component of the 2nd plot color (0-255) -cg n specify green component of the 2nd plot color (0-255) -cb n specify blue component of the 2nd plot color (0-255) -s line specify number of the head skip -r step specify number of the read step -f line specify number of the final line -vx n neighbor average of the x data -vy n neighbor average of the y data -mx formula specify math transformation for the x data -my formula specify math transformation for the y data -ex {linear | log | inverse | MJD} specify scale type of the x axis -ey {linear | log | inverse | MJD} specify scale type of the y axis -minx value specify minimum value of x axis -maxx value specify maximum value of x axis -incx value specify increment value of x axis -miny value specify minimum value of y axis -maxy value specify maximum value of y axis -incy value specify increment value of y axis -g load settings from data file -png file convert ngp file to PNG format -pdf file convert ngp file to PDF format -ps file convert ngp file to PostScript format -eps file convert ngp file to Encapsulated PostScript format -svg file convert ngp file to SVG format -gra file convert ngp file to GRA format -dialog show print dialog (with -p option) -p file print ngp file -n output ngp-file to stdout -h, --help show help message -v, --version show version of Ngraph -V, --VERSION show detail information about Ngraph FILES
${HOME}/.Ngraph/Ngraph.nsc start up script ${HOME}/.Ngraph/Ngraph.ini configuration file ${HOME}/.Ngraph/Ngraph.ngp default graph AUTHORS
Satoshi ISHIZAKA Hiroyuki Ito <ZXB01226@nifty.com> SEE ALSO
ngp2(1) COPYRIGHT
Copyright (C) 2003 Satoshi ISHIZAKA Copyright (C) 2008-2011 Hiroyuki Ito 4th Berkeley Distribution Local NGRAPH(1)
All times are GMT -4. The time now is 04:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy