Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: SQL*Loader
Top Forums UNIX for Dummies Questions & Answers SQL*Loader Post 302488467 by ajaykumarkona on Monday 17th of January 2011 09:24:49 AM
Old 01-17-2011
SQL*Loader
HI Experts,

We have a ksh file named ldr_empdelta.ksh and it is having the SQL*LOADER script as follows.
Code:
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" >> $WEDB_GEN/lldrscan.ctl
print "INTO TABLE MED_TABLE" >> $WEDB_GEN/ldrscan.ctl
print "(EMPNO POSITION(001:008) CHAR," >> $WEDB_GEN/ldrscan.ctl
print "PROD POSITION(059:060) CHAR," >> $WEDB_GEN/ldrscan.ctl
print "SBPRD POSITION(061:062) CHAR," >> $WEDB_GEN/ldrscan.ctl
print "FAMILY_NM POSITION(143:162) CHAR " >> $WEDB_GEN/ldrscan.ctl
print "JOIN_DT POSITION(163:166) DATE " >> $WEDB_GEN/ldrscan.ctl
print ")"

But now I want to modify the FAMILY_NAME while inserting data into the table.

I tried the following ,
Code:
print "FAMILY_NM POSITION(143:162) CHAR "REPLACE(:family_nm,'^','''')"," >> $WEDB_GEN/ldrscan.ctl

but i eas getting the error .Please help me to resolve this.
Thanks in advance.
Code:
****************************************************
Begin script: ldr_empdelta.ksh
****************************************************
date: Mon Jan 17 04:48:22 PST 2011
parms values:
 
 
parms number: 0
process_id: 5537
parent_process_id: 4006
wedb_env_file:
wedb_path_file:
 
ldr_empdelta.ksh[135]: syntax error at line 171 : `(' unexpected

Last edited by Scott; 01-17-2011 at 12:10 PM.. Reason: Code tags, please...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SQL loader error

Hi friends, i am getting the following error when i am using sql loader. SQL*Loader: Release 8.1.7.4.0 - Production on Tue Apr 19 13:00:07 2005 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL*Loader-704: Internal error: ulconnect: OCIServerAttach ORA-12535:... (4 Replies)
Discussion started by: sveera
4 Replies

2. Shell Programming and Scripting

A SQL Loader Script

Hi Guys, I am looking to develop a SQL Loader script that would bascially allow the user to have a txt file (or such) as an input file containing .sql scripts procedures, triggers, bascially anything against a database that could then be run automatically. Let me break it down a bit more,... (2 Replies)
Discussion started by: LiquidChild
2 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 in shellscript

Hi, what is the ideal format of the file to load it into oracle table by using SQL*LOADER. The file contains six columns and the oracle table contains 15 columns. Is there any criteria that columns should be equal in no.? Can anyone help me on this, i need to use this in my shell script? ... (2 Replies)
Discussion started by: venkatesht
2 Replies

5. 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

6. 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

7. 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

8. UNIX for Dummies Questions & Answers

Help Command in SQL LOADER

Which is the UNIX command to get the SQL Loader Help??:confused: (1 Reply)
Discussion started by: venkatesh sunil
1 Replies

9. Shell Programming and Scripting

Issue in SQL Loader scripts

Hi, I'm planning to load the data from FLAT files into tables. Source file: more input.txt LRNO|Bale|Horsepower|NumberOfBarges|BollardPull|NumberOfCars|GasCapacity|GrainCapacity|IndicatedHorsepower|LiquidCapacity|... (6 Replies)
Discussion started by: shyamu544
6 Replies

10. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

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 DEBIAN

gen-ctl-io

GEN-CTL-IO(1)							      libctl							     GEN-CTL-IO(1)

NAME

       gen-ctl-io - generate C interface code for libctl control files

SYNOPSIS

       gen-ctl-io [OPTION]... [spec-file]

DESCRIPTION

       gen-ctl-io  generates  C  code  to import/export the input/output variables used in a libctl control file.  gen-ctl-io generates files like
       ctl-io.h and ctl-io.c.  These files define global variables, data structures, and functions for the input/output  variables,  classes,  and
       function interfaces defined in the spec-file argument, automating the interaction between C and Guile.

       The  arguments  such  as  --code and --header are used to control whether ctl-io.c or ctl-io.h, etcetera, are generated.  If no argument is
       specified then both of these files are generated by default, for backwards compatibility.

       libctl is a free library to aid in interfacing scientific software with the GNU Guile scripting and extension language.	Documentation  for
       it may be found online at the libctl home page: http://ab-initio.mit.edu/libctl

OPTIONS

       --code Generate C (or C++) source code to implement the Guile interface functions.  The default output file name is ctl-io.c (in C) or ctl-
	      io.cpp (in C++).

       --header
	      Generate the header file declaring the interface data types and functions. The default output file name is ctl-io.h (in C)  or  ctl-
	      io.hpp (in C++).

       --swig Generate	a  SWIG  interface  definition file declaring automatic conversions for the various libctl data types.	The default output
	      file name is ctl-io.i.

       --cxx  Generate C++ code instead of C code.

       -o file
	      Use file as the output file name instead of the defaults (above).

BUGS

       Send bug reports to S. G. Johnson, stevenj@alum.mit.edu.

AUTHORS

       Written by Steven G. Johnson.

libctl								  March 27, 2006						     GEN-CTL-IO(1)
All times are GMT -4. The time now is 05:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy