Sponsored Content
Full Discussion: SQL Column Heading
Top Forums Shell Programming and Scripting SQL Column Heading Post 302945092 by Skrynesaver on Tuesday 26th of May 2015 06:45:48 AM
Old 05-26-2015
Which database client?
Can we see the shell script?
How are you sending the mail?
Is there a column format specifier in place?

Actually no need for that info, I see the problem now, you accidentally left out a semi-colon on line 42...
This User Gave Thanks to Skrynesaver For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

What is the command to add heading to a file?

Hi, I'd like to add one line to the top of my file. I know there is a command to be able to do it. But I forgot ...... Please help if you can .... (3 Replies)
Discussion started by: whatisthis
3 Replies

2. Shell Programming and Scripting

Print column names along with values from SQL

Hi, Can anyone tell me how to print the column name anong with the value from the table in shell script e.g #!/bin/ksh var=`sqlplus scott/tiger << -e set heading off feedback off select * from emp; quit; e` echo $var My output should be; ... (5 Replies)
Discussion started by: thana
5 Replies

3. 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:. ... (4 Replies)
Discussion started by: fmina
4 Replies

4. Shell Programming and Scripting

SQL select all but not if it is already in an other column

I know I know.. for sure one of the easier mysql statements. But somehow I can not figure out this. I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row) data_12 ... (6 Replies)
Discussion started by: lowmaster
6 Replies

5. Shell Programming and Scripting

SQL sorrting issue, and unwanted blank line above heading

Hi, I am running a shell script on Compaq Tru64 UNIX V5.1A. I have attached the shill script with the sql script it is calling to extract some data(hyp_dta_Extr.sql), and the results. I need the file to be tab delimited. (please note that I have renamed hyp_dta_Extr.sql to hyp_dta_Extr.txt to... (1 Reply)
Discussion started by: dazz
1 Replies

6. Shell Programming and Scripting

Column not allowed, when I am writing sql in UNIX

Please advice to rectify below error #!/bin/ksh X=$(sqlplus -s user/pass << EOSQL set serveroutput on; set heading off feedback off serveroutput on trimout on pagesize 0 INSERT INTO TEST(df) VALUES('a'); COMMIT; EXIT; EOSQL) echo $X echo $? ERROR at line 2: ORA-00984: column not... (1 Reply)
Discussion started by: mirwasim
1 Replies

7. Shell Programming and Scripting

Script to get the heading in files along with data

Hi everyone, I have a file which has data with different heading and column names as below. Static Data Ingested ,,,,,,,,,,,,Known Explained Rejections Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10... (1 Reply)
Discussion started by: Vivekit82
1 Replies

8. UNIX for Dummies Questions & Answers

Replacing "." with "GG" in a certain column of a file that has heading

Hi, all, I have a file that looks like: ## XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ## YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY #AA AB AC AD AE AF AG AH AI AJ AK AL 20 60039 60039 ... (5 Replies)
Discussion started by: kush
5 Replies

9. Shell Programming and Scripting

Need heading in files

Hi All, The below code is splitting the file "data.csv" into several files based on the"client_code" column. date_yyyymmdd=$(my_date "" -e"%Y%m%d") file_format="_$date_yyyymmdd.csv awk '{print $2, $3> DIR"/clients_" $1 file_out}' FS=' *; *' OFS=";" DIR="$TEMPL" file_out="_$file_format"... (3 Replies)
Discussion started by: ROCK_PLSQL
3 Replies

10. Programming

Joining Columnar heading from 2 lines

Hi, Below is the format of a report generated by a custom reporting solution. I opened the report in Notepad++ and junked data and values as in the image below. https://www.unix.com/attachment.php?attachmentid=7907&stc=1&d=1575507708 I want to convert the values to a PIPE delimited format as... (2 Replies)
Discussion started by: ramkrix
2 Replies
XrmPutResource(3X11)						     MIT X11R4						      XrmPutResource(3X11)

Name
       XrmPutResource, XrmQPutResource, XrmPutStringResource, XrmQPutStringResource, XrmPutLineResource - store database resources

Syntax
       void XrmPutResource(database, specifier, type, value)
	  XrmDatabase *database;
	  char *specifier;
	  char *type;
	  XrmValue *value;

       void XrmQPutResource(database, bindings, quarks, type, value)
	  XrmDatabase *database;
	  XrmBindingList bindings;
	  XrmQuarkList quarks;
	  XrmRepresentation type;
	  XrmValue *value;

       void XrmPutStringResource(database, specifier, value)
	  XrmDatabase *database;
	  char *specifier;
	  char *value;

       void XrmQPutStringResource(database, bindings, quarks, value)
	  XrmDatabase *database;
	  XrmBindingList bindings;
	  XrmQuarkList quarks;
	  char *value;

       void XrmPutLineResource(database, line)
	  XrmDatabase *database;
	  char *line;

Arguments
       bindings  Specifies a list of bindings.

       database  Specifies the resource database.

       line	 Specifies the resource name and value pair as a single string in the valid ResourceLine format.  A single colon (:) separates the
		 name from the value.  Note that comment lines are not stored.

       quarks	 Specifies the complete or partial name or the class list of the resource.

       specifier Specifies a complete or partial specification of the resource.

       type	 Specifies the type of the resource.

       value	 Specifies the value of the resource, which is specified as a string.

Description
       If database contains NULL, creates a new database and returns a pointer to it.  is a convenience function that calls followed by:

       XrmQPutResource(database, bindings, quarks,
	     XrmStringToQuark(type), value)

       If database contains NULL, creates a new database and returns a pointer to it.

       If database contains NULL, creates a new database and returns a pointer to it.  adds a resource with the specified value to the specified
       database.  is a convenience function that first calls on the specifier and then calls using a ``String'' representation type.

       If database contains NULL, creates a new database and returns a pointer to it.  is a convenience routine that constructs an for the value
       string (by calling to compute the size) and then calls using a ``String'' representation type.

       If database contains NULL, creates a new database and returns a pointer to it.  adds a single resource entry to the specified database.
       Any white space before or after the name or colon in the line argument is ignored.  The value is terminated by a new-line or a NULL charac-
       ter.  To allow values to contain embedded new-line characters, a ``
'' is recognized and replaced by a new-line character.  For example,
       line might have the value ``xterm*background:green
''.	Null-terminated strings without a new line are also permitted.

       To allow values to contain arbitrary octets, the 4-character sequence 
nn, where n is a digit in the range of "0"-"7", is recognized and
       replaced with a single byte that contains this sequence interpreted as an octal number.	For example, a value containing a NULL byte can be
       stored by specifying "00" in the string.

See Also
       XrmGetResource(3X11), XrmInitialize(3X11), XrmMergeDatabases(3X11), XrmUniqueQuark(3X11)
       X Window System: The Complete Reference, Second Edition, Robert W. Scheifler and James Gettys

															      XrmPutResource(3X11)
All times are GMT -4. The time now is 06:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy