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
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
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
: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
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
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
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
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
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
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
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
LEARN ABOUT ULTRIX
xrmputresource
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 "