Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Using awk and grep for sql generation
Top Forums Shell Programming and Scripting Using awk and grep for sql generation Post 302983928 by RudiC on Tuesday 18th of October 2016 01:24:08 PM
Old 10-18-2016
Code:
T[$1"."$2]=$3

This statement first concatenates the first and second field with a dot separator, then uses this string as an index for array T and assigns the third field's value to it. Reading all lines from "desc.txt":
Code:
Table|Field|Type
Employee|id|int
Contact|name|string
Contact|country|string
Contact|phone|bigint

would yield
Code:
T["Employee.id"] = "int"
T["Contact.name"] = "string"
T["Contact.country"] = "string"
T["Contact.phone"] = "bigint"

With the flds=split($2, F, ",") function and the "pk.txt2" file
Code:
TableName | PK
Employee | id
Contact|name,phone,country

,in the second line the T[$1"."F[i+1]] statement would loop across name,phone,country and reference
Code:
T["Contact.name"] = "string"
T["Contact.country"] = "string"
T["Contact.phone"] = "bigint"

to be able to select the output format.
This User Gave Thanks to RudiC For This Post:
wahi80
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL Loader Auto Number Generation

Hi all, I have a doubt in SQL Loader. We have SEQUENCE function in SQL Loader or can create Sequence in Oracle database for generating a number sequence for a column while loading data using SQL Loader into table or multiple tables. My requirment is this. For the first run in SQL... (2 Replies)
Discussion started by: vinoth_kumar
2 Replies

2. Shell Programming and Scripting

awk- report generation from input file

I have input file with below content: Person: Name: Firstname1 lastname1 Address: 111, Straat City : Hilversum Person: Name : Fistname2 lastname2 Address: 222, street Cit: Bussum Person: Name : Firstname2 lastname3 Address: 333, station straat City: Amsterdam I need... (6 Replies)
Discussion started by: McLan
6 Replies

3. Shell Programming and Scripting

Dynamic command line generation with awk

Hi, I'm not an expert in awk but i need a simple script to do this: I'd like to AutoCrop PDF files. I found 2 simple script that combined together could help me to automatize :) The first utiliti is "pdfinfo" that it gives the MediaBox and TrimBox values from the pdf. The pdfinfo output... (8 Replies)
Discussion started by: gbagagli
8 Replies

4. Shell Programming and Scripting

Report Generation with Grep

All, I am pretty new to Unix Environment. I am not sure if my requirement can be accomplished in Unix. I did try searching this forum and others but could not get an answer. Requirement is explained below: I have a set of files in a folder. file1_unload file2_unload file3_unload... (7 Replies)
Discussion started by: bharath.gct
7 Replies

5. Shell Programming and Scripting

Random word generation with AWK

Hi - I have a word GTTCAGAGTTCTACAGTCCGACGAT I need to extract all the possible "chunks" of 7 or above letter "words" from this. SO, my out put should be GTTCAGA TTCAGAG TCAGAGT CAGAGTTCT TCCGACGAT CAGTCCGACG etc. How can I do that with awk or any other language? I have no... (2 Replies)
Discussion started by: polsum
2 Replies

6. Shell Programming and Scripting

How to grep the where clause of a SQL?

Hi UNIX Gurus, I want to use extract the where clause of a SQL present in a file. Please suggest me how can I do it. Select * from emp where emp_id>10; cat <file_name> | grep -i "where" returns whole SQL. how can I extract only "where emp_id>10;" Thanks in advance (4 Replies)
Discussion started by: ustechie
4 Replies

7. Programming

[ask]SQL command act like sort and grep

for example, I have a text file in random content inside, maybe something like this. 234234 54654 123134 467456 24234234 7867867 23424 568567if I run this command cat "filename.txt" | sort -n | grep "^467456$" -A 1 -B 1the result is 234234 467456 568567is it possible to do this command... (2 Replies)
Discussion started by: 14th
2 Replies

8. UNIX for Dummies Questions & Answers

Grep SQL output file for greater than number.

Hi, This is my first post. I have a korn shell script which outputs a select statment to a file. There is only one column and one row which contains a record count of the select statement. The select statement looks something like this: SELECT COUNT(some_field) AS "count_value" ... (2 Replies)
Discussion started by: MurdocUK
2 Replies

9. Shell Programming and Scripting

awk concatenation issue - SQL generation

Greetings Experts, I have an excel file and I am unable to read it directly into awk (contains , " etc); So, I cleansed and copied the data into notepad. I need to generate a script that generates the SQL. Requirement: 1. Filter and select only the data that has the "mapping" as "direct"... (4 Replies)
Discussion started by: chill3chee
4 Replies

10. UNIX for Beginners Questions & Answers

Finding The Complete SQL statement Using PDFGREP Or Grep

Linux Gods, I am simply attempting to parse SQL statements from a PDF doc in creating a base SQL script at a later time but for the life of me, am having a tough time extracting this data.This exact string worked perfectly a couple of months ago and now it doesnt. Below is an example of the data... (4 Replies)
Discussion started by: metallica1973
4 Replies

LEARN ABOUT DEBIAN

net::dri::data::contact::us

Net::DRI::Data::Contact::US(3pm)			User Contributed Perl Documentation			  Net::DRI::Data::Contact::US(3pm)

NAME

       Net::DRI::Data::Contact::US - Handle .US contact data for Net::DRI

DESCRIPTION

       This subclass of Net::DRI::Data::Contact adds accessors and validation for .US specific data.

METHODS

       The following accessors/mutators can be called in chain, as they all return the object itself.  They are needed only for registrant
       contacts.

   application_purpose()
       intended usage for the domain name

   nexus_category()
       the nexus cateogry

SUPPORT

       For now, support questions should be sent to:

       <netdri@dotandco.com>

       Please also see the SUPPORT file in the distribution.

SEE ALSO

       http://www.dotandco.com/services/software/Net-DRI/

AUTHOR

       Patrick Mevzek, <netdri@dotandco.com>

COPYRIGHT

       Copyright (c) 2006,2007,2008 Patrick Mevzek <netdri@dotandco.com>.  All rights reserved.

       This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
       the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

       See the LICENSE file that comes with this distribution for more details.

perl v5.10.1							    2010-03-25					  Net::DRI::Data::Contact::US(3pm)
All times are GMT -4. The time now is 03:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy