Search Results

I am running the ETL job to passing the database username,pssswd positional arguments to shell script (bash) and how can we suppress/hide the password from ps command.

Thank you so much Tyler,

when i run the following command with out -w, it displaying the count with long warning message saying that
ODBC Data direct for SQL SERVER is exclusive to ETL tool....

getting error message could not SQLexecute.

need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)

i 'm able connect to database with below command line syntex but i could not get working...

shell script positional parameters have to be inside double quotes and singe quotes when using the sed.

below is code:

schema_name=1
table_name=2

sed -e...

Thank you for reply.

I added to the script as follows.
':8s/$table_name/$schema.$table_name/' file_name > file_new
it has give error.

i need to substitute word on a specific line.
I was able to do it on command line like below but it is not working in vi.
command line like below:
sed -e '8s/table_name/schema.table_name/'...

I need to create the shell script load the few 100 table using the SQLLDR.

Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using...