How to include SQL within a script Post: 302454152

10 More Discussions You Might Find Interesting

1. Programming

How to include shell script in C program

hi I want to call a shell script in C program the script is : ssh -t user@remote sh /<remote>home/user/<file_name>.sh and other several commands C program : Call this script and the retrive the task that is been done in <file_name>.sh file can any one tell me how...

2. Shell Programming and Scripting

Include lines within a script

I want to add lines in my script dynamically. My script: ... echo addscript end addscript ... Lines to add: (can be put in a file and can be added) cp /opt/script1.sh opt/script1_org.sh sed 's/testusr/'${FUNCTID}'/g' /opt/script1.sh > ./tmpfile mv ./tmpfile /opt/script1.sh...

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

4. UNIX for Dummies Questions & Answers

Include PERL script with in the unix shell script

Hi Gurus, Is it possible to include perl script with in the unix shell script? What would be the general syntax? In the above case, is it required to write the below first two lines of codes? #!usr/bin/sh -x #!usr/bin/perl -w Thanks in advance / Mysore Ganapati.

5. Shell Programming and Scripting

include in script

Hello, I have a script and a second file that contains all parameters needed for the script. How can I include this file in the script ? I tried source but I have a "no such file or directory" error. :)

6. UNIX for Dummies Questions & Answers

script/program in vi include $? or...

Hi. When you write a script/program in vi Do you include the $ Eg. #!/bin/bash $ echo "Today's date is `date`" or echo "Today's date is `date`" Make your script executable. $chmod +x script I included that. I keep getting a permission denied... why? Thanks!

7. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

8. UNIX for Dummies Questions & Answers

Option in sql script to include column headers when spooling file to .csv format

Can anyone help me how to include COLUMN HEADER when spooling file to .CSV format through SQL statement. Thanks, Akbar

9. Shell Programming and Scripting

How to include a command in shell script?

# dbc "delete from alert;" DELETE 10 # However, the script created below generates an error that command does not exits. Can any one please exist. script.sh: #!/bin/sh dbc "delete from alert;" >>$TASKLOGFILE ./script.sh: line 38: dbc: command not found can any one please...

10. UNIX for Dummies Questions & Answers

[solved] Script creation (how to include options in the script)

Hi guys i have written a script which takes the options given to him and execute itself accordingly. for example if a script name is doctortux then executing doctortux without option should made doctortux to be executed in automatic mode i.e. doctortux -a or if a doctortux is needed to run in...

LEARN ABOUT ULTRIX

xrmgetstringdatabase

XrmMergeDatabases(3X11) 					     MIT X11R4						   XrmMergeDatabases(3X11)

Name
       XrmMergeDatabases, XrmGetFileDatabase, XrmPutFileDatabase, XrmGetStringDatabase, XrmDestroyDatabase - manipulate resource databases

Syntax
       void XrmMergeDatabases(source_db, target_db)
	  XrmDatabase source_db, *target_db;

       XrmDatabase XrmGetFileDatabase(filename)
	  char *filename;

       void XrmPutFileDatabase(database, stored_db)
	  XrmDatabase database;
	  char *stored_db;

       XrmDatabase XrmGetStringDatabase(data)
	  char *data;

       void XrmDestroyDatabase(database)
	  XrmDatabase database;

Arguments
       data	 Specifies the database contents using a string.

       database  Specifies the database that is to be used.

       filename  Specifies the resource database file name.

       source_db Specifies the resource database that is to be merged into the target database.

       stored_db Specifies the file name for the stored database.

       target_db Specifies a pointer to the resource database into which the source database is to be merged.

Description
       The function merges the contents of one database into another.  It may overwrite entries in the destination database.  This function is
       used to combine databases (for example, an application specific database of defaults and a database of user preferences).  The merge is
       destructive; that is, the source database is destroyed.

       The function opens the specified file, creates a new resource database, and loads it with the specifications read in from the specified
       file.  The specified file must contain lines in the format accepted by If it cannot open the specified file, returns NULL.

       The function stores a copy of the specified database in the specified file.  The file is an ASCII text file that contains lines in the for-
       mat that is accepted by

       The function creates a new database and stores the resources specified in the specified null-terminated string.	is similar to except that
       it reads the information out of a string instead of out of a file.  Each line is separated by a new-line character in the format accepted
       by

       If database is NULL, returns immediately.

See Also
       XrmGetResource(3X11), XrmInitialize(3X11), XrmPutResource(3X11), XrmUniqueQuark(3X11)
       X Window System: The Complete Reference, Second Edition, Robert W. Scheifler and James Gettys

															   XrmMergeDatabases(3X11)

10 More Discussions You Might Find Interesting

1. Programming

How to include shell script in C program

Discussion started by: mridula

2. Shell Programming and Scripting

Include lines within a script

Discussion started by: chiru_h

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Discussion started by: rajagavini

4. UNIX for Dummies Questions & Answers

Include PERL script with in the unix shell script

Discussion started by: ganapati