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 PHP

getdate

GETDATE(3)								 1								GETDATE(3)

getdate - Get date/time information

SYNOPSIS

       array getdate ([int  $timestamp = time()])

DESCRIPTION

	Returns an associative array containing the date information of the $timestamp, or the current local time if no $timestamp is given.

PARAMETERS

	      o $timestamp
		-  The	optional  $timestamp parameter is an integer Unix timestamp that defaults to the current local time if a $timestamp is not
		given. In other words, it defaults to the value of time(3).

RETURN VALUES

	Returns an associative array of information related to the $timestamp. Elements from the returned associative array are as follows:

       Key elements of the returned associative array

       +----------+--------------------------------------+---+
       |   Key	  |					 |   |
       |	  |					 |   |
       |	  |		Description		 |   |
       |	  |					 |   |
       |	  |	  Example returned values	 |   |
       |	  |					 |   |
       +----------+--------------------------------------+---+
       |	  |					 |   |
       |"seconds" |					 |   |
       |	  |					 |   |
       |	  |  Numeric representation of seconds	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  0 to 59		 |   |
       |	  |					 |   |
       |	  |					 |   |
       |"minutes" |					 |   |
       |	  |					 |   |
       |	  |  Numeric representation of minutes	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  0 to 59		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "hours"  |					 |   |
       |	  |					 |   |
       |	  |   Numeric representation of hours	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  0 to 23		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "mday"   |					 |   |
       |	  |					 |   |
       |	  | Numeric representation of the day of |   |
       |	  | the month				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		  1 to 31		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "wday"   |					 |   |
       |	  |					 |   |
       |	  | Numeric representation of the day of |   |
       |	  | the week				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  | 0 (for Sunday) through 6 (for Satur- |   |
       |	  | day)				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |  "mon"   |					 |   |
       |	  |					 |   |
       |	  |  Numeric representation of a month	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |		1 through 12		 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "year"   |					 |   |
       |	  |					 |   |
       |	  | A  full  numeric representation of a |   |
       |	  | year, 4 digits			 |   |
       |	  |					 |   |
       |	  |	   Examples: 1999 or 2003	 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "yday"   |					 |   |
       |	  |					 |   |
       |	  | Numeric representation of the day of |   |
       |	  | the year				 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |	       0 through 365		 |   |
       |	  |					 |   |
       |	  |					 |   |
       |"weekday" |					 |   |
       |	  |					 |   |
       |	  | A full textual representation of the |   |
       |	  | day of the week			 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |	  Sunday through Saturday	 |   |
       |	  |					 |   |
       |	  |					 |   |
       | "month"  |					 |   |
       |	  |					 |   |
       |	  | A full textual representation  of  a |   |
       |	  | month, such as January or March	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |	  |	  January through December	 |   |
       |	  |					 |   |
       |	  |					 |   |
       |    0	  |					 |   |
       |	  |					 |   |
       |	  |  Seconds since the Unix Epoch, simi- |   |
       |	  | lar  to  the  values   returned   by |   |
       |	  | time(3) and used by date(3).	 |   |
       |	  |					 |   |
       |	  |  System	Dependent,     typically |   |
       |	  | -2147483648 through 2147483647.	 |   |
       |	  |					 |   |
       +----------+--------------------------------------+---+
EXAMPLES

       Example #1

	      getdate(3) example

	      <?php
	      $today = getdate();
	      print_r($today);
	      ?>

	      The above example will output something similar to:

	      Array
	      (
		  [seconds] => 40
		  [minutes] => 58
		  [hours]   => 21
		  [mday]    => 17
		  [wday]    => 2
		  [mon]     => 6
		  [year]    => 2003
		  [yday]    => 167
		  [weekday] => Tuesday
		  [month]   => June
		  [0]	    => 1055901520
	      )

SEE ALSO

       date(3), idate(3), localtime(3), time(3), setlocale(3).

PHP Documentation Group 														GETDATE(3)
All times are GMT -4. The time now is 07:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy