Sponsored Content
Full Discussion: A SQL Loader Script
Top Forums Shell Programming and Scripting A SQL Loader Script Post 302115202 by LiquidChild on Monday 23rd of April 2007 04:58:41 AM
Old 04-23-2007
Guys,

Quick question on this, hopefully.

I am going to go down the road that i have mentioned above, i.e. having one control file of format:

@database
--connection details
@procedure
--procedures etc
.
.
.
@database
--connection details

Basically my question is could someone give me some hints on how to parse the file so that i can grab all the stuff between (for example) the two @databases. I want to know what i should be loading against one database, and what against the others, if there is more than one @database, as it may be the case that everything has to be done against one database.

Hope that makes sense.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

problems running a sql loader script

Hi Folks, I have created a number of unix scripts that i can run from the scheduler on a server-side application that we use (Chordiant Marketing Director). All scripts are working except one. This last script is a user load script which first truncates a table and then loads it using a flat... (2 Replies)
Discussion started by: jibbadiah
2 Replies

2. Shell Programming and Scripting

Shell script for accessing a file in the network drive and invoking oracle sql loader

Hi, Please let me know if anybody is having a solution handy for the below tasks... It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task. Task: Check if the network drive exists Check... (0 Replies)
Discussion started by: sayydevara
0 Replies

3. UNIX for Dummies Questions & Answers

Problem with SQL loader

Hi, I am trying to load the records in a .txt file into the data base using SQL loader. I gave: $ sqlldr user/pass@DB control=filename.ctl log =mylog.log It throwed the following error: SQL*Loader-297: Invalid syntax or bind variable in SQL string for column STATUS. ORA-01756: quoted... (2 Replies)
Discussion started by: risshanth
2 Replies

4. Shell Programming and Scripting

sql loader script

hi all i am new to shell scripting. i have 35 flat files delimited files that i have to load in to a table. i was asked to create a shell script that loads the data into the table... could you please help me if you have a script. Also .. how to create logs files...does my sql... (3 Replies)
Discussion started by: rajesh_tns
3 Replies

5. Shell Programming and Scripting

Problem in sql loader

Hi Frnds, I wanto load the data thats in data file with comma(,) delimited. it throw this errors SQL*Loader-951: Error calling once/load initialization ORA-00604: error occurred at recursive SQL level 1 ORA-00054: resource busy and acquire with NOWAIT specified Plz look at my file... (3 Replies)
Discussion started by: Gopal_Engg
3 Replies

6. UNIX for Dummies Questions & Answers

SQL*Loader

HI Experts, We have a ksh file named ldr_empdelta.ksh and it is having the SQL*LOADER script as follows. print "LOAD DATA" > $WEDB_GEN/ldrscan.ctl print "INFILE '"$LED_SCAN"/delta/led_del.dat'" >> $WEDB_GEN/ldrparms.ctl print "TRUNCATE" >> $WEDB_GEN/ldrscan.ctl print "PRESERVE BLANKS" >>... (1 Reply)
Discussion started by: ajaykumarkona
1 Replies

7. UNIX for Dummies Questions & Answers

SQL loader script - ORACLE environmental variable

I am new in unix.. I am running a sql loader script where I have to specify the data file path but the file name contains spaces in it so giving error multiple arguments I have tried it with "" and '' but does n't work the command is : $ORACLE_HOME/bin/sqlldr... (1 Reply)
Discussion started by: Sandip Dey
1 Replies

8. Shell Programming and Scripting

use of sql loader in the script

All, Below is the code written when sql loader loads the data: $ORACLE_EXEC_PATH/sqlldr userid=$user_passwd control=$CNTR_FILES/invoice.ctl log=$LOG_FILES/$INVOICE_FILE.log bad=$ER ROR_FILES/$INVOICE_FILE.bad data=$DATA_FILES/$INVOICE_FILE silent=FEEDBACK direct=false errors=50000 rc=$?... (1 Reply)
Discussion started by: Oracle_User
1 Replies

9. Homework & Coursework Questions

Write a shell script for SQL loader to load data into a staging table

Hi, I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script. The table has two columns - Acct_number (not nullable) and date (timestamp). I'm not able to write a shell script for that. Can any one help me? ... (3 Replies)
Discussion started by: saisudeep
3 Replies

10. Shell Programming and Scripting

How to call SQL Loader in shell script?

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
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)
All times are GMT -4. The time now is 09:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy