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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT PHP
db2_procedures
DB2_PROCEDURES(3) 1 DB2_PROCEDURES(3)
db2_procedures - Returns a result set listing the stored procedures registered in a database
SYNOPSIS
resource db2_procedures (resource $connection, string $qualifier, string $schema, string $procedure)
DESCRIPTION
Returns a result set listing the stored procedures registered in a database.
PARAMETERS
o $connection
- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
o $qualifier
- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
o $schema
- The schema which contains the procedures. This parameter accepts a search pattern containing _ and % as wildcards.
o $procedure
- The name of the procedure. This parameter accepts a search pattern containing _ and % as wildcards.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the stored procedures matching the specified parameters. The
rows are composed of the following columns:
+------------------+---------------------------------------------------+
| Column name | |
| | |
| | Description |
| | |
+------------------+---------------------------------------------------+
| PROCEDURE_CAT | |
| | |
| | The catalog that contains the procedure. The |
| | value is NULL if this table does not have cata- |
| | logs. |
| | |
| PROCEDURE_SCHEM | |
| | |
| | Name of the schema that contains the stored pro- |
| | cedure. |
| | |
| PROCEDURE_NAME | |
| | |
| | Name of the procedure. |
| | |
|NUM_INPUT_PARAMS | |
| | |
| | Number of input (IN) parameters for the stored |
| | procedure. |
| | |
|NUM_OUTPUT_PARAMS | |
| | |
| | Number of output (OUT) parameters for the stored |
| | procedure. |
| | |
| NUM_RESULT_SETS | |
| | |
| | Number of result sets returned by the stored pro- |
| | cedure. |
| | |
| REMARKS | |
| | |
| | Any comments about the stored procedure. |
| | |
| PROCEDURE_TYPE | |
| | |
| | Always returns 1, indicating that the stored pro- |
| | cedure does not return a return value. |
| | |
+------------------+---------------------------------------------------+
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_special_columns(3),
db2_statistics(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_PROCEDURES(3)