Sponsored Content
Top Forums Shell Programming and Scripting Forming an insert query using awk Post 302464759 by rakesh_s on Thursday 21st of October 2010 01:25:34 AM
Old 10-21-2010
Forming an insert query using awk

Hi,

I'm trying to form an insert sql query using shell programming. I have table named company with four columns 'company name', 'company id', 'company code' and 'last change id'

I have to read the company name, company code and last change id from a file delimited by | which has around 10 companys...The company id has to be incremented from say 1000, 1001, 1002 upto 1010...

My output should be an insert statement like

insert into company values (1000, "ABC company", 'E', "Last_user");
insert into company values (1001, "EFG company", 'A', "Last_user");
.
.
insert into company values (1010, "XYZ company", 'D', "Last_user");

Please let me know how can i do this...Also let me know if you need additional info..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

need to create a insert query for a file

Hi Guys, I need to create a insert query for the below file Fri Sep 4 06:25:51 2009 ACTION : 'CREATE INDEX S100S_DC.PLInsuranceReportRules_testI1 ON S100S_DC.PLInsuranceReportRules_test1(ENTITY_KEY)' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: oracle CLIENT TERMINAL: pts/3... (6 Replies)
Discussion started by: mac4rfree
6 Replies

2. Programming

SQL : Fine tune Insert by query

i would like to know how can i fine tune the following query since the cost of the query is too high .. insert into temp temp_1 select a,b,c,d from xxxx .. database used is IDS.. (1 Reply)
Discussion started by: expert
1 Replies

3. UNIX for Dummies Questions & Answers

forming duplicate rows based on value of a key

if the key (A or B or ...others) has 4 in its 3rd column the 1st A row has to form 4 dupicates along with the all the values of A in 4th column (2.9, 3.8, 4.2) . Hope I explain the question clearly. Cheers Ruby input "A" 1 4 2.9 "A" 2 5 ... (7 Replies)
Discussion started by: ruby_sgp
7 Replies

4. Shell Programming and Scripting

How to use a variable in insert query?

My script contains as follows, VALUE=`sqlplus un/pwd <<EOF > OB.txt set pagesize 0 feedback off verify off heading off echo off select max(1) from table1; exit; EOF` insert into table2 values(1, 'The max value is $value',...); i need the value of VALUE to be inserted after 'The max... (2 Replies)
Discussion started by: savithavijay
2 Replies

5. Shell Programming and Scripting

forming group script from a text file

I am trying to make group of number of ID's. I have prepared following perl script but it does not provide any output. INPUT File 0174 0175 0176 0177 CODE: #!/usr/bin/perl -w $memlst = "/tmp/test.txt"; $membercnt = `wc -l $memlst`; $memhd = `head -1 $memlst`; $memcnt1 = 1; $class... (1 Reply)
Discussion started by: dynamax
1 Replies

6. Programming

insert query help

Hello i want help to load data from file into mysql DB this part i know how to do but during loading i want to combine 2 fields into 1 field and insert into db as primary key in new column thanks advice how to do so (5 Replies)
Discussion started by: mogabr
5 Replies

7. UNIX for Dummies Questions & Answers

Forming a query in unix level

Hi, I will execute a query in sqlplus and redirect to a file. The file will contains the date value such as 2011-04-12 02:00:00. i want to make the content of the file such as, select * from table where col1>to_date('2011-04-12 02:00:00','yyyy-mm-dd HH24:MI:SS'). Apar from the bold... (1 Reply)
Discussion started by: pandeesh
1 Replies

8. Shell Programming and Scripting

Insert query with shell variable with AWK

Hi, I'm a first timer with Unix so pardon my ignorance. I'm trying to read a comma separated file from the same folder where the script is and insert the value in a DB2 table. I'm using AWK for the same. I'm getting `)' not expected error. I'm not sure but for me it doesn't look like detailed... (8 Replies)
Discussion started by: Kabira Speaking
8 Replies

9. Shell Programming and Scripting

From sql Insert Query to XML format

Hi How do I translate Let say Cat inserts.sql gives Insert into PM9_TAXATION_ROUNDING (STATE_GECODE, TAX_TYPE, TAX_AUTHORITY, SYS_CREATION_DATE, SYS_UPDATE_DATE, APPLICATION_ID, DL_SERVICE_CODE, ROUNDING_METHOD) Values ('xx', 'xx', 'x', TO_DATE('10/26/2012 13:01:20',... (3 Replies)
Discussion started by: anuj87in
3 Replies

10. Shell Programming and Scripting

How to insert new column with awk?

Hello guys, I'm new to shell programming, I would like to insert two new columns in a space separated file having this format using awk, starting from the third row: A B C D E F 1 ; A B C D E F 1 ; A B C D E F 1 ; A B C D E F 1 ; Basically, the resulting file should have the following... (3 Replies)
Discussion started by: transat
3 Replies
LedgerSMB::ScriptLib::Company(3pm)			User Contributed Perl Documentation			LedgerSMB::ScriptLib::Company(3pm)

NAME
LedgerSMB::ScriptLib::Company - LedgerSMB class defining the Controller functions, template instantiation and rendering for vendor and customer editing and display. This would also form the basis for other forms of company contacts. SYOPSIS
This module is the UI controller for the vendor DB access; it provides the View interface, as well as defines the Save vendor. Save vendor/customer will update or create as needed. METHODS
set_entity_class($request) returns int entity class Errors if not inherited. Inheriting classes MUST define this to set $entity_class appropriately. get_by_cc Populates the company area with info on the company, pulled up through the control code dispatch_legacy This is a semi-private method which interfaces with the old code. Note that as long as any other functions use this, the contact interface cannot be said to be safe for code caching. Not fully documented because this will go away as soon as possible. add_transaction Dispatches to the Add (AR or AP as appropriate) transaction screen. add_invoice Dispatches to the (sales or vendor, as appropriate) invoice screen. add_order Dispatches to the sales/purchase order screen. rfq Dispatches to the quotation/rfq screen new_company($request) returns object inheriting LedgerSMB::DBObject::Company This too must be defined in classes that inherit this class. get($self, $request, $user) Requires form var: id Extracts a single company from the database, using its company ID as the primary point of uniqueness. Shows (appropriate to user privileges) and allows editing of the company information. add_location Adds a location to the company as defined in the inherited object save_new_location Adds a location to the company as defined in the inherited object, not overwriting existing locations. generate_control_code Sets $company->{control_code} equal to the next in the series of entity_control values add This method creates a blank screen for entering a company's information. get_results($self, $request, $user) Requires form var: search_pattern Directly calls the database function search, and returns a set of all vendors found that match the search parameters. Search parameters search over address as well as vendor/Company name. history($request) Generates the filter screen for the customer/vendor history report. display_history($request) Displays the customer/vendor history based on criteria from the history filter screen. The following request variables are optionally set in the HTTP query string or request object. Search Criteria name: search string for company name contact_info: Search string for contact info, can match phone, fax, or email. salesperson: Search string for employee name in the salesperson field notes: Notes search. Not currently implemented meta_number: Exact match for customer/vendor number address_line: Search string for first or second line of address. city: Search string for city name state: Case insensitive, otherwise exact match for state or province zip: leading match for zip/mail code country_id: integer for country id. Exact match tartdate_from: Earliest date for startdate of entity credit account startdate_to: Lates date for entity credit accounts' start date type: either 'i' for invoice, 'o' for orders, 'q' for quotations from_date: Earliest date for the invoice/order to_date: Latest date for the invoice/order Unless otherwise noted, partial matches are sufficient. Control variables: inc_open: Include open invoices/orders. If not true, no open invoices are displayed inc_closed: Include closed invoices/orders. If not true, no closed invoices are displayed report_type: Either summary or detail Columns to display: l_partnumber: parts.partnumber l_sellprice: invoice/orderitems.sellprice l_curr: ar/ap/oe.curr l_unit: invoice/orderitems.unit l_deliverydate: invoice.deliverydate or orderitems.reqdate l_projectnumber: project.projectnumber l_serialnumber: invoice/orderitems.serialnumber csv_company_list($request) Generates CSV report (not working at present) save($self, $request, $user) Saves a company to the database. The function will update or insert a new company as needed, and will generate a new Company ID for the company if needed. save_credit($request) This inserts or updates a credit account of the sort listed here. save_credit_new($request) This inserts a new credit account. edit($request) Displays a company for editing. Needs the following to be set: entity_id, account_class, and meta_number. The account_class requireent is typically set during the construction of scripts which inherit this library. PRIVATE _render_main_screen($company) Pulls relevant data from db and renders the data entry screen for it. search($request) Renders the search criteria screen. save_contact($request) Saves contact info as per LedgerSMB::DBObject::Company::save_contact. delete_contact Deletes the selected contact info record Must include company_id or credit_id (credit_id used if both are provided) plus: * contact_class_id * contact * form_id delete_bank_acct Deletes the selected bank account record Required request variables: * bank_account_id * entity_id * form_id delete_location Deletes the selected contact info record Must include company_id or credit_id (credit_id used if both are provided) plus: * location_class_id * location_id * form_id edit_bank_acct($request) displays screen to a bank account Required data: bank_account_id bic iban save_contact_new($request) Saves contact info as a new line as per save_contact above. save_bank_account($request) Adds a bank account to a company and, if defined, an entity credit account. save_notes($request) Saves notes. entity_id or credit_id must be set, as must note_class, note, and subject. pricelist This returns and displays the pricelist. The id field is required. delete_price save_pricelist This routine saves the price matrix. For existing rows, valid_to, valid_from, price fields are saved. For the new row, the partnumber field matches the beginning of the part number, and the description is a full text search. pricelist_search_handle Handles the return from the parts search from the pricelist screen. COPYRIGHT
Copyright (c) 2009, the LedgerSMB Core Team. This is licensed under the GNU General Public License, version 2, or at your option any later version. Please see the accompanying License.txt for more information. perl v5.14.2 2012-03-28 LedgerSMB::ScriptLib::Company(3pm)
All times are GMT -4. The time now is 01:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy