Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Intelligent Script to Insert Records in Database Table
Top Forums Shell Programming and Scripting Intelligent Script to Insert Records in Database Table Post 302930534 by RudiC on Monday 5th of January 2015 10:23:25 AM
Old 01-05-2015
For that, try
Code:
awk     '       {gsub (/\|/,",")
                }
         NR==1  {gsub (/"/,"")
                 TMP = "insert into EMPLOYEE (" $0 ") values ("
                 next
                }
                {print TMP, $0, ");"
                }
        ' FS="\|" file
insert into EMPLOYEE (Name,Dept,Empno,Salary,DOB,DOJ) values ( "Alexander","10","200","$1000","25/05/1977","01/01/2015" );
insert into EMPLOYEE (Name,Dept,Empno,Salary,DOB,DOJ) values ( "Graham","11","300","$1500","05/09/1970","19/02/2011" );
insert into EMPLOYEE (Name,Dept,Empno,Salary,DOB,DOJ) values ( "Bell" ,"12","400","$2000","31/01/1965","01/10/1999" );

To allow for your word processor's non-ASCII double quotes, you may want to add gsub (/“|”/, "\"") upfront.

I had to remove my former post as I missed the requirement by far. pravin27's suggestion will work for you after a little polishing.
This User Gave Thanks to RudiC For This Post:
chetanojha
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script: want to insert values in database when update script runs

Hi , I am new to linux and also also to shell scripting. I have one shell script which unpacks .tgz file and install software on machine. When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder... (1 Reply)
Discussion started by: ring
1 Replies

2. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies

3. Web Development

INSERT data to a Database Table from a text file

If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' (0 Replies)
Discussion started by: sitex
0 Replies

4. UNIX for Dummies Questions & Answers

Bash script to insert data into an html table

hi, I need to create a bash shell script which picks up data from a text file and in the output file puts it into an html made table. I have to use sed and awk utilties to do this the input text file will contain data in the format: job name para1 para2 para3 para4 para4 1 ... (1 Reply)
Discussion started by: intern123
1 Replies

5. Shell Programming and Scripting

Script to count the dataflow in a table in oracle database

I need to write a unix shell script to connect to oracle database and retrieve data from a table, the script should count the total number of rows till date in that table number of rows which are getting filled per hour on current day and the peak hour of the current day number of rows which are... (5 Replies)
Discussion started by: PhAnT0M
5 Replies

6. Shell Programming and Scripting

Insert script result into Oracle Table

Hi All, I want to insert STAT and ENDTIME values for each job in joblist into TBL_DAILY_STATUS table. Eg: insert into tbl_daily_status values(STAT,ENDTIME); Please help me on this. #!/bin/ksh joblist="com_abc_job com_abc_dot_job com_abc_seq com_abc_det" for i in $joblist do... (8 Replies)
Discussion started by: vichuelaa
8 Replies

7. Shell Programming and Scripting

Shell script for insert multiple records into a Database

I have a table in an Informix DB into which I want to insert multiple records at a time. Data for one of the column should be unique & other column data may be the same for all the records I insert Typical Insert Statement I use to insert one row : insert into employee(empid, country, state)... (5 Replies)
Discussion started by: nisav
5 Replies

8. Shell Programming and Scripting

UNIX Script required for count the records in table

Hi Friends, I looking for the script for the count of the records in table. and then it's containg the zero records then should get abort. and should notify us through mail. Can you please help me out in this area i am lacking. (5 Replies)
Discussion started by: victory
5 Replies

9. Shell Programming and Scripting

How to read a text file line by line and insert into a database table?

I have a test file that I want to read and insert only certain lines into the the table based on a filter. 1. Rread the log file 12 Hours back Getdate() -12 Hours 2. Extract the following information on for lines that say "DUMP is complete" A. Date B. Database Name C.... (2 Replies)
Discussion started by: JolietJake
2 Replies

10. UNIX for Beginners Questions & Answers

1. This will insert the records into db table by reading from ta csv file

I have this code with me but the condition is If any of the mandatory columns are null then entire file will be rejected. LOAD DATA infile ' ' #specifies the name of a datafile containing data that you want to load BADFILE ' ' #specifies the name of... (1 Reply)
Discussion started by: raka123
1 Replies

LEARN ABOUT CENTOS

gldebugmessageinsert

GLDEBUGMESSAGEINSERT(3G)					   OpenGL Manual					  GLDEBUGMESSAGEINSERT(3G)

NAME

       glDebugMessageInsert - inject an application-supplied message into the debug message queue

C SPECIFICATION

       void glDebugMessageInsert(GLenum source, GLenum type, GLuint id, GLenum severity, GLsizei length, const char *message);

PARAMETERS

       source
	   The source of the debug message to insert.

       type
	   The type of the debug message insert.

       id
	   The user-supplied identifier of the message to insert.

       severity
	   The severity of the debug messages to insert.

       length
	   The length string contained in the character array whose address is given by message.

       message
	   The address of a character array containing the message to insert.

DESCRIPTION

       glDebugMessageInsert inserts a user-supplied message into the debug output queue.  source specifies the source that will be used to
       classify the message and must be GL_DEBUG_SOURCE_APPLICATION or GL_DEBUG_SOURCE_THIRD_PARTY. All other sources are reserved for use by the
       GL implementation.  type indicates the type of the message to be inserted and may be one of GL_DEBUG_TYPE_ERROR,
       GL_DEBUG_TYPE_DEPRECATED_BEHAVIOR, GL_DEBUG_TYPE_UNDEFINED_BEHAVIOR, GL_DEBUG_TYPE_PORTABILITY, GL_DEBUG_TYPE_PERFORMANCE, or
       GL_DEBUG_TYPE_OTHER.  severity indicates the severity of the message and may be GL_DEBUG_SEVERITY_LOW, GL_DEBUG_SEVERITY_MEDIUM, or
       GL_DEBUG_SEVERITY_HIGH.	id is available for application defined use and may be any value. This value will be recorded and used to identify
       the message.

       length contains a count of the characters in the character array whose address is given in message. If length is negative then message is
       treated as a null-terminated string. The length of the message, whether specified explicitly or implicitly, must be less than or equal to
       the implementation defined constant GL_MAX_DEBUG_MESSAGE_LENGTH.

ERRORS

       GL_INVALID_ENUM is generated if any of source, type or severity is not one of the accepted interface types.

       GL_INVALID_VALUE is generated if the length of the message is greater than the value of GL_MAX_DEBUG_MESSAGE_LENGTH.

SEE ALSO

       glDebugMessageControl(), glDebugMessageCallback(), glGetDebugMessageLog().

COPYRIGHT

       Copyright (C) 2012 Khronos Group. This material may be distributed subject to the terms and conditions set forth in the Open Publication
       License, v 1.0, 8 June 1999.  http://opencontent.org/openpub/.

AUTHORS

       opengl.org

opengl.org							    06/10/2014						  GLDEBUGMESSAGEINSERT(3G)
All times are GMT -4. The time now is 06:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy