Sponsored Content
Top Forums Shell Programming and Scripting Inserting Values From A File Into A Table Post 302089021 by ragha81 on Friday 15th of September 2006 06:43:06 PM
Old 09-15-2006
Inserting Values From A File Into A Table

Guys,

I want to insert some values from a log file into a temporary table. the values in the log file looks like this
Code:
SV_NAME  CC_NAME              CP_DISP_RUN_STATE  
-------  -------------------  -----------------  
sble01   ALLTEL WorkMon24Hrs  Running

I want to enter the values under SV_NAME, CC_NAME, CP_DISP_RUN_STATE
into a temporary table. the table has similar columns SV_NAME, NAME, Status.

Please help me guys. thanks in advance
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inserting records from flat file to db table

I have 20000 numbers present in a file in each line like 25663, 65465, 74579, 56446, .. .. I have created a table in db with single number column in it. create table testhari (no number(9)); I want to insert all these numbers into that table. how can i do it? can anybody please... (4 Replies)
Discussion started by: Hara
4 Replies

2. Shell Programming and Scripting

Comparing data in file with values in table

Hi, I want to calculate the number of pipe delimiters in a file for all lines seperately. For eg:i have a file Project.txt Mohit|chawla|123|678 File1|File2|345|767|678 And my file contains many lines like this it shd give me the output as 4 5 or give me the output for all the... (0 Replies)
Discussion started by: Mohit623
0 Replies

3. Shell Programming and Scripting

Help Inserting data in mysql table

Cant understand the error #!/bin/bash temp="" A="" D=$(date +"%Y-%m-%d") H=$(date +"%R") temp=$(wget -q -O - website | grep -o "Temperature:]**" | grep \-E -o "+") mysql -D "weather_wise" -e "INSERT INTO weather (Date, Hour, Degrees) VALUES ($D,$H, $temp)"; my data types for... (11 Replies)
Discussion started by: vadharah
11 Replies

4. Shell Programming and Scripting

inserting data into a table from a flat file

Hi, I want to insert data into a table from a flat file, the file is having around 25 columns and some 10,000 records. The columns values are seperated by a space. Thanks (1 Reply)
Discussion started by: ss_ss
1 Replies

5. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

6. Shell Programming and Scripting

modify a file by inserting a conditional values

Hi, input file CCCC 1204 215764.85 9405410.40 1189 DDDD 4498 1503 4617 1507 4723 1517 4829 1528 4996 1540 DDDD 5199 1556 5278 1567 5529 1603 5674 1614 6076 1915 DDDD 6605 2371 7004 2779 CCCC ... (4 Replies)
Discussion started by: Indra2011
4 Replies

7. Shell Programming and Scripting

Update the table using values from a csv file

i want to run update query for oracle which is in up.sql taking values from a.csv. I have implemented shell script to do it. extn="perl" ls -1 | while read file do echo "$file,$extn" > a.csv done up.sql contains update file_list set filename=$1 where extn=$2; The code to update is... (2 Replies)
Discussion started by: millan
2 Replies

8. Shell Programming and Scripting

Perl: Writing table values to a file

I have a file like this, 1,a,saurav 2,b,rout I want to show this file in a perl cgi page table and want to add a column which will contain a text box. There I will give some manual input, which will be written to the existing file(or a new file) in below format. 1|a|saurav|bangalore... (2 Replies)
Discussion started by: sauravrout
2 Replies

9. Shell Programming and Scripting

awk file to read values from Db2 table replacing hard coded values

Hi, I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below... if (start_new_rec=="true"){ exclude_user="false"; user=toupper($6); match(user, "XXXXX."); if (RSTART ==2 ) { ... (9 Replies)
Discussion started by: asandy1234
9 Replies

10. Shell Programming and Scripting

Error inserting a clob file into DB table

Hi all, I am reading control file log from my server and putting it to a variable for j in $(cat $dirname/ctl_file.log) do if then Y=${#fileclob_ctl_file} if then fileclob_ctl_file=$j else fileclob_ctl_file="${fileclob_ctl_file},${j}" fi fi ... (5 Replies)
Discussion started by: Pratiksha Mehra
5 Replies
XtParseTranslationTable()												 XtParseTranslationTable()

Name
  XtParseTranslationTable - compile a translation table into its internal representation.

Synopsis
  XtTranslations XtParseTranslationTable(table)
	 String table;

Inputs
  table     Specifies the translation table to compile.

Returns
  The compiled form of table.

Description
  XtParseTranslationTable()  compiles  table  into its opaque internal representation of type XtTranslations.  This compiled form can then be
  set as the value of a widget's XtNtranslations resource, or merged with a widget's existing translation table with  XtAugmentTranslations()
  or XtOverrideTranslations().

  The syntax of the string representation of a translation table is documented in Appendix F.

  If  an  empty  translation table is required for any purpose, one can be obtained by calling XtParseTranslationTable() and passing an empty
  string.

Usage
  This function is generally only needed by application writers.  When writing a widget, you specify a default translation table as a string,
  which the Intrinsics automatically parse.

  You  only need to use this function when you want to set translation values from C code; translation tables specified in resource files are
  automatically compiled by a resource converter.

  It is also possible to set a translation table with the XtVaTypedArg feature of XtVaCreateWidget() and XtVaSetValues().  This allows you to
  specify the translation table in string form, and have the appropriate resource converter automatically invoked to compile it.

  The string table passed to XtParseTranslationTable can be freed after the call if there are no more explicit references to it.

See Also
  XtAugmentTranslations(1), XtOverrideTranslations(1), XtUninstallTranslations(1).

Xt - Translations and Actions												 XtParseTranslationTable()
All times are GMT -4. The time now is 04:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy