Column not allowed, when I am writing sql in UNIX

10 More Discussions You Might Find Interesting

1. Programming

Help writing SQL query

Hello All, I hope I'm posting this in the right section. I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,...

2. Shell Programming and Scripting

Writing sql results to file using ksh -nevermind

I'm having problems with writing my sql results to a file: sqlplus -S username/password@DB <<!! set echo off set verify off set showmode off set feedback off set timing off set linesize 250 set wrap off set pagesize 0 set newpage none set tab off set trimspool on set colsep...

3. Shell Programming and Scripting

Writing out 2nd column into one file from multiple files

I have several files that are being generated every 20 minutes. Each file contains 2 columns. The 1st column is Text, 2nd column is Data. I would like to generate one single file from all these files as follows: One instance of 1st column Text, followed by 2nd column Data separated by...

4. Shell Programming and Scripting

writing the output of SQL into one file

Hi All, Please help me writing the below script. I have two sql queries. 1. Select count(1),Client_id from TABLE_A group by Client_id; 2. Select count(1),Client_id from TABLE_B group by Client_id; I need the output of above two sql queries in a single file. The output 2nd query should be...

5. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

6. Shell Programming and Scripting

Writing given value into a file in particular record and column

Hi All, Could you ppl plz help me in writing into a file , plz find the example below. Ex: Name1|092387|Address1 Name2||Address2 After executing command/script the file should look like Name1|092387|Address1 Name2|+91900236|Address2 plz let me know of you have some solution...

7. UNIX for Dummies Questions & Answers

Extracting column names from a table.. SQL with UNIX

:rolleyes: hi there everybody, i need help,... thanks anyway! i am working on a very huge table with the name table1. the problem is that i know only one field name in this table..., working with a ksh environment i don't know how to view the table to check out the field names :confused:. ...

8. Programming

Writing to a File using pl/sql

Hi I am new to using pl/sql on a unix platform and am having trouble writing to a file from within a block. Below is an example of the code that I have. I know that I need to use UTL_FILE to accomplish this; however, I keep getting errors. Can someone please help me? I am trying to create a...

9. Shell Programming and Scripting

flags to suppress column output, # of rows selected in db2 sql in UNIX

Hello, I am new to db2 SQL in unix so bear with me while I try to explain the situation. I have a text file that has the contents of the where condition that I am using for a db2 SQL in UNIX ksh. Here is the snippet. if ; then echo "Begin processing VALUEs" ...

10. Shell Programming and Scripting

conditional writing of sql code

Hello again... I have a request from another department to list for them all the columns and tables we use in this certain database. I have spooled the oracle stored procedured into 1 file. I need a way to write out parts of that file. The criteria is to to start the block to be written when...

LEARN ABOUT LINUX

erl_comment_scan

erl_comment_scan(3erl)					     Erlang Module Definition					    erl_comment_scan(3erl)

NAME

       erl_comment_scan - Functions for reading comment lines from Erlang source code.

DESCRIPTION

       Functions for reading comment lines from Erlang source code.

DATA TYPES

	 comment() = {integer(), integer(), integer(), [string()]} :

EXPORTS

       file(FileName::filename() (see module file)) -> [Comment]

	      Types  Comment = {Line, Column, Indentation, Text}
		     Line = integer()
		     Column = integer()
		     Indentation = integer()
		     Text = [string()]

	      Extracts	comments  from	an Erlang source code file. Returns a list of entries representing multi-line comments, listed in order of
	      increasing line-numbers. For each entry, Text is a list of strings representing the consecutive comment lines in top-down order; the
	      strings  contain	all characters following (but not including) the first comment-introducing % character on the line, up to (but not
	      including) the line-terminating newline.

	      Furthermore, Line is the line number and Column the left column of the comment (i.e., the column of the comment-introducing %  char-
	      acter). Indent is the indentation (or padding), measured in character positions between the last non-whitespace character before the
	      comment (or the left margin), and the left column of the comment. Line and Column are always positive integers, and Indentation is a
	      nonnegative integer.

	      Evaluation  exits  with reason {read, Reason} if a read error occurred, where Reason is an atom corresponding to a Posix error code;
	      see the module file(3erl) for details.

       join_lines(Lines::[CommentLine]) -> [Comment]

	      Types  CommentLine = {Line, Column, Indent, string()}
		     Line = integer()
		     Column = integer()
		     Indent = integer()
		     Comment = {Line, Column, Indent, Text}
		     Text = [string()]

	      Joins individual comment lines into multi-line comments. The input is a list of entries representing individual  comment	lines,	in
	      order  of  decreasing line-numbers ; see scan_lines/1 for details. The result is a list of entries representing multi-line comments,
	      still listed in order of decreasing line-numbers , but where for each entry, Text is a list of consecutive comment lines in order of
	      increasing line-numbers (i.e., top-down).

	      See also: scan_lines/1 .

       scan_lines(Text::string()) -> [CommentLine]

	      Types  CommentLine = {Line, Column, Indent, Text}
		     Line = integer()
		     Column = integer()
		     Indent = integer()
		     Text = string()

	      Extracts	individual  comment lines from a source code string. Returns a list of comment lines found in the text, listed in order of
	      decreasing line-numbers, i.e., the last comment line in the input is first in the resulting list. Text is a single string,  contain-
	      ing  all	characters  following (but not including) the first comment-introducing % character on the line, up to (but not including)
	      the line-terminating newline. For details on Line , Column and Indent , see file/1 .

       string(Text::string()) -> [Comment]

	      Types  Comment = {Line, Column, Indentation, Text}
		     Line = integer()
		     Column = integer()
		     Indentation = integer()
		     Text = [string()]

	      Extracts comments from a string containing Erlang source code. Except for reading directly from a string, the behaviour is the  same
	      as for file/1 .

	      See also: file/1 .

AUTHORS

       Richard Carlsson <richardc@it.uu.se >

								syntax_tools 1.6.7					    erl_comment_scan(3erl)

Shell Programming and Scripting