Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help on SED AWK in shell scripting
Top Forums Shell Programming and Scripting Help on SED AWK in shell scripting Post 101551 by tmarikle on Thursday 9th of March 2006 01:40:02 PM
Old 03-09-2006
Database engines typically have command processors like Oracle's sqlplus.

sqlplus allows for arguments to be passed so that copies of SQL scripts don't have to be created every time a value changes.
Code:
sqlplus un/pw @abc.sql 20060309

The abc.sql script might look like this:
Code:
INSERT INTO sometable (columna, columnb, datecolumn)
VALUES (value1, value2, TO_DATE('&1', 'YYYYMMDD'));
COMMIT;

Note: &1 is sqlplus' parameter name.

If you have an SQL script and if you are creating a copy of it with a new value as you indicate then it follows that you are attempting to execute the SQL through some utility. The utility that executes the SQL should allow you to pass parameters. Oracle sqlplus, Sybase's/Microsoft's isql, et. al. all allow for this capability. I don't use MySQL or DB2 but I would be surprised if they don't allow for parameters.
Last edited by tmarikle; 03-09-2006 at 02:46 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

scripting with awk and sed

hey all, i was just wondering if it was possible to to get data from user input , and parse it through sed to remove or add what that user has entered into a flat file? do i need awk ? any help is greatly appreciated ~shan2on (2 Replies)
Discussion started by: shan2on
2 Replies

2. Shell Programming and Scripting

usage...sed/awk/reg-exp ..in shell scripting

in shell scripting there is extensive usage of i> regular expression ii>sed iii>awk can anyone tell me the suitable contexts ...i mean which one is suitable for what kind of operation. like the reg-exp and sed seems to be doing the same job..i.e pattern matching (1 Reply)
Discussion started by: mobydick
1 Replies

3. UNIX for Dummies Questions & Answers

tr, sed, awk, cat or scripting

I need to change all Newline caracters (\12) to Fieldseparator(\34). tr -A '\12' '\34' <file1> file2 Replace all delete (\177) with Newline (\12) tr -A '\177' '\12' <file2> file3 Put the name of the file first in all rows. awk '{printf "%s\34%s\n", FILENAME,$0} file3 > file4 So far no... (6 Replies)
Discussion started by: MrKlint
6 Replies

4. Shell Programming and Scripting

Sed function is shell scripting

Hello everybody, I trying to convert a text inside my file that looks something like this: into hyperlink so that the user can click onto it..... I tried this but doesn't work cat mylist9.html |sed -e '<a href="' >mylist13.html Thanks (13 Replies)
Discussion started by: kev_1234
13 Replies

5. Shell Programming and Scripting

sed or awk scripting help needed

hi all, for an example : df -k output shows: $ df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/cciss/c0d0p6 3099260 1117760 1824068 8% / /dev/cciss/c0d0p1 256666 18065 225349 8% /boot none 8219180 0 8219180 0% /dev/shm /dev/mapper/vglocal-home 1032088 245172 734488 26%... (7 Replies)
Discussion started by: raghur77
7 Replies

6. Shell Programming and Scripting

Scripting awk or sed or shell

input buff_1 abc satya_1 pvr_1 buff_2 def satya_1 pvr_1 buff_3 ghi satya_1 pvr_1 buff_4 jkl satya_1 pvr_1 required out put buff_1 abc satya_1 pvr_1 abc satya_1 buff_2 def satya_1 pvr_1 def satya_1 buff_3 ghi satya_1 pvr_1 ghi satya_1 (6 Replies)
Discussion started by: pvr_satya
6 Replies

7. Shell Programming and Scripting

Shell Scripting -- sed

Hi, In one of my scripts, I am using sed to do an expression replacement. The code in the script is as under sed "s|MY_INP_Lab=""|MY_INP_Lab="${2}"|" file1, where $2=xyz_abc_mbk The EXPECTED output is in file1, all the instances ofMY_INP_Lab="" shall be replaced by... (2 Replies)
Discussion started by: vivekmattar
2 Replies

8. Shell Programming and Scripting

Use case insensitive variable in ksh shell scripting using sed or awk

I am using a variable called $variable in a pattern search to print from a starting variable to a constant value. the variable search should be case in sensitive. i tired using Ip at the end in the below command. but in ksh it is not working. sed -n "/$variable/,/constant/p" file i also... (11 Replies)
Discussion started by: johnjs
11 Replies

9. Shell Programming and Scripting

Need help with awk and sed scripting

I need help with sed and awk scripts to search for Symmetrix ID=000090009902 and then grep its child disk devices associated to the dead paths and display them only, so that those dead devices can be removed. test01:/#powermt display dev=all Pseudo name=hdiskpower0 Symmetrix ID=000090009902... (4 Replies)
Discussion started by: aix_admin_007
4 Replies

10. Shell Programming and Scripting

Help shell scripting using awk or sed or other

I need to create a script to change a file depending of 3 conditions using a target as parameter... first condition <chamada> <numeroTerminalOriginador>CALLER</numeroTerminalOriginador> <imeiOriginador></imeiOriginador> <cgiPrimeiraErbOriginador></cgiPrimeiraErbOriginador>... (2 Replies)
Discussion started by: poulis
2 Replies

LEARN ABOUT DEBIAN

gtk2::recentinfo

Gtk2::RecentInfo(3pm)					User Contributed Perl Documentation				     Gtk2::RecentInfo(3pm)

NAME

       Gtk2::RecentInfo - wrapper for GtkRecentInfo

HIERARCHY

	 Glib::Boxed
	 +----Gtk2::RecentInfo

METHODS

   timestamp = $info->get_added;
   timestamp = $info->get_modified;
   timestamp = $info->get_visited;
       cut

   integer = $info->get_age
   (exec, count, timestamp) = $info->get_application_info ($app_name)
       o   $app_name (string)

   (applications) = $info->get_applications
   string = $info->get_description
   string = $info->get_display_name
   boolean = $info->exists
   (groups) = $info->get_groups
   boolean = $info->has_application ($app_name)
       o   $app_name (string)

   boolean = $info->has_group ($group_name)
       o   $group_name (string)

   pixbuf = $info->get_icon ($size)
       o   $size (integer)

   boolean = $info->is_local
   string = $info->last_application
   boolean = $info->match ($other_info)
       o   $other_info (Gtk2::RecentInfo)

   string = $info->get_mime_type
   unix timestamp = $info->get_modified
   boolean = $info->get_private_hint
   string = $info->get_short_name
   string = $info->get_uri_display
   string = $info->get_uri
   unix timestamp = $info->get_visited
SEE ALSO

       Gtk2, Glib::Boxed

COPYRIGHT

       Copyright (C) 2003-2011 by the gtk2-perl team.

       This software is licensed under the LGPL.  See Gtk2 for a full notice.

perl v5.14.2							    2012-05-27						     Gtk2::RecentInfo(3pm)
All times are GMT -4. The time now is 09:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy