Sponsored Content
Full Discussion: Trouble with external tables
Top Forums Shell Programming and Scripting Trouble with external tables Post 302561156 by PG3 on Monday 3rd of October 2011 10:31:37 AM
Old 10-03-2011
radoulov,

The script errors with the following msg -
Code:
hdflldRR3:/Users/PGonzalez 06:26:57 cat SBR.sh 

printf 'select %s from dual;' "$(
  printf "'%s'\n" $(<infile) |
     paste -sd, -A
 )" |
   sqlplus -s "db info"



hdflldRR3:/Users/PGonzalez 06:27:01 SBR.sh 
paste: illegal option -- A
usage: paste [-s] [-d delimiters] file ...
select	from dual
        *
ERROR at line 1:
ORA-00936: missing expression


paste: illegal option -- A
usage: paste [-s] [-d delimiters] file ...
select	from dual
        *
ERROR at line 1:
ORA-00936: missing expression


Last edited by PG3; 10-03-2011 at 11:33 AM.. Reason: Code tags.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

viewing tables

I have completely blanked out on this and I have done it a million times. I need to modify some tables in unix. What is the command for opening/viewing the tables? Thanks so much. :o (2 Replies)
Discussion started by: itldp
2 Replies

2. UNIX for Dummies Questions & Answers

Routing tables

Hey guys, I needed to add a route to my routing table and I got it to work but on reboot it gets removed. Anyone know what file I can add this route to so it stays on the machine after a reboot? (9 Replies)
Discussion started by: kingdbag
9 Replies

3. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies

4. Shell Programming and Scripting

Tables and borders

when i do this: cat HITS i get the following displayed: sport.hits:87.114.172.31 Thu Sep 28 22:45:12 GMT 2006 how do i put this information into a bordered table? so it will output like this: ...........File /... (9 Replies)
Discussion started by: amatuer_lee_3
9 Replies

5. Shell Programming and Scripting

Display tables of 6

I'm new to linux and unix I would like to know how to display tables of 6 line after line Output should be 1*6 = 6 2*6 = 12 3*6 = 18 4*6 = 24 etc I can display line by line but not continuously Any suggestion (3 Replies)
Discussion started by: electricair
3 Replies

6. UNIX for Dummies Questions & Answers

Mysqldump certain tables

Hi, I have to upload part of my database periodically when i make changes to product data etc. However I only want to upload certain tables. We suffer from bandwidth chock here, so i want to write a couple of separate scripts that upload parts of the database that changed. The database is large... (5 Replies)
Discussion started by: timgolding
5 Replies

7. Programming

C++ Dictionaries and tables

I was looking at this code from a programming book: #include <time.h> #include <iostream> #include <string> #include <deque> #include <map> #include <vector> #include <cstdlib> using namespace std; const int NPREF = 2; const char NONWORD = "\n"; // cannot appear as real line: we... (1 Reply)
Discussion started by: totoro125
1 Replies

8. Shell Programming and Scripting

Compare with 2 tables

I have 3 file inputs, file1 20160302|5485368299953|96|510101223440252|USA|5485368299953|6|800|2300|0 20160530|5481379883742|7|510101242850814|USA|5481379883742|5|540|2181|1500 20160513|5481279653404|24|510100412142433|INDIA|5481279653404|3|380|1900|0... (1 Reply)
Discussion started by: radius
1 Replies

9. Programming

How to arhive hive external tables?

Hi Guys, Is there a way to check hive external tables which are created 90 days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script? (10 Replies)
Discussion started by: Master_Mind
10 Replies
ISASET(8)						      System Manager's Manual							 ISASET(8)

NAME
isaset - set ISA registers SYNOPSIS
isaset [-y] addrreg datareg address value [mask] #for I2C-like access isaset [-y] -f address value [mask] #for flat address space DESCRIPTION
isaset is a small helper program to set registers visible through the ISA bus. OPTIONS
-f Enable flat address space mode. -y Disable interactive mode. By default, isaset will wait for a confirmation from the user before messing with the ISA bus. When this flag is used, it will perform the operation directly. This is mainly meant to be used in scripts. OPTIONS (I2C-like access mode) Four options must be provided to isaset. addrreg contains the ISA address of the address register for the chip to probe; datareg contains the address of the data register. Both addresses are integers between 0x0000 and 0x3FFF. Usually, if the chip's base address is 0x0nn0, the address register is at 0x0nn5 and the data register is at 0x0nn6. The most common base address for hardware monitoring chips is 0x0290. For Super-I/O chips, address register is typically at 0x2E with data register at 0x2F. The address and value parameters are two integers between 0x00 and 0xFF. isaset will write value value to address address. An optional mask can be provided as a fifth parameter, preserving unmasked bits at the written location. OPTIONS (flat address space mode) In flat mode, two parameters must be provided. address contains the ISA address of the register to write to; it is an integer between 0x0000 and 0xFFFF. Basically, it is the sum of the chip's base address and the chip register's address. isaset will write value value at this address. An optional mask can be provided as a third parameter, preserving unmasked bits at the written location. WARNING
Poking around in ISA data space is extremely dangerous. Running isaset with random parameters can cause system crashes, data loss, and worse! Be extremely careful when using this program. SEE ALSO
i2cset(8), isadump(8) AUTHOR
Mark D. Studebaker, and the lm_sensors group (http://www.lm-sensors.org/) This manual page was shamelessly ripped from the i2cset and isadump manual pages by Jean Delvare. May 2005 ISASET(8)
All times are GMT -4. The time now is 10:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy