I'm going crazy with SQL select. Please help! Post: 302546117

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pipe SQL select statement results to script

Hello I would like to perform a select from a oracle table and return those values to my shell script For example: site=head -1 $infile | cut -c1-15 | awk '{printf "s%", $0} sqlplus -s /nolog |& #Open pipe to sql select col1, col2, col3, col4 from oracle_table where col5 =...

2. Shell Programming and Scripting

formatting the sql select result

Hi, I have about 12 columns and 15 rows to be retrived from sybase isql command through unix. But when i output the sql into a file and see it, the formatting is going for a toss. can someone please suggest how can i get the result correctly in the output file ? Thanks, Sateesh

3. Web Development

SQL Select inside Insert

I have following. . . . $userid = 2 . $query = "select username from users where userid = ".$userid.";"; . $username = $line; $data="Some Data Here"; . $query = "insert into logger (username, data) valuse ($username, $data);"; . I would like to not have 2 database calls.

4. Shell Programming and Scripting

How to redirect value from sql select statment to unix variable

Hi, I need to get the value from the table using the sql command and store this value into the unix variable so that i can use this value for furthure use.. Please can any body help me in this regards Thanks & Regards Abdul Hafeez Shaik

5. Shell Programming and Scripting

SQL Select and awk

Dear All , I have file1.txt contain values like the following: ---------- 23 24 25 and I have shell script which has the following : more file1.txt | awk '{print "select 'DUMP',CODE1||'|'||CODE2||'|'||CODE3 from CODE where CODE1='" $1 "';"}' > file2.sql all I need is to have the...

6. Shell Programming and Scripting

Select SQL Queries Option

count.sh#!/bin/ksh SQL1=`sqlplus -s usr/pwd @count.sql $1 $2 $3` SQL2=`sqlplus -s usr/pwd @selectall.sql $1 $2 $3` LIST="Count Select_All" select i in $LIST do if then echo $SQL1 elif then echo $SQL2 fi done

7. Shell Programming and Scripting

using SELECT sql statement in shell script

Hi there I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this SN=123456 n=server1 m=x4140 sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';" echo $sql |/usr/sfw/bin/mysql -h...

8. 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 ...

9. Programming

[Solved] SQL SELECT REPLACE

Hi All, I had a query related to sql select update replace command. i have a table named clusters and it looks like this name model characteristics sample1.1 +123 parent sample1.2 -456 clone sample1.3 +122 ...

10. Programming

Sql select replace

Hi All, I had a query related to sql select replace command. i have a table named clusters and it looks like this Code: name characteristics sample 1.1 parent sample 1.2 ...

LEARN ABOUT MOJAVE

verify_krb5_conf

VERIFY_KRB5_CONF(8)                                         BSD System Manager's Manual                                        VERIFY_KRB5_CONF(8)

NAME

     verify_krb5_conf -- checks krb5.conf for obvious errors

SYNOPSIS

     verify_krb5_conf [config-file]

DESCRIPTION

     verify_krb5_conf reads the configuration file krb5.conf, or the file given on the command line, parses it, checking verifying that the syntax
     is not correctly wrong.

     If the file is syntactically correct, verify_krb5_conf tries to verify that the contents of the file is of relevant nature.

ENVIRONMENT

     KRB5_CONFIG points to the configuration file to read.

FILES

     /etc/krb5.conf  Kerberos 5 configuration file

DIAGNOSTICS

     Possible output from verify_krb5_conf include:

     <path>: failed to parse <something> as size/time/number/boolean
             Usually means that <something> is misspelled, or that it contains weird characters. The parsing done by verify_krb5_conf is more
             strict than the one performed by libkrb5, so strings that work in real life might be reported as bad.

     <path>: host not found (<hostname>)
             Means that <path> is supposed to point to a host, but it can't be recognised as one.

     <path>: unknown or wrong type
             Means that <path> is either a string when it should be a list, vice versa, or just that verify_krb5_conf is confused.

     <path>: unknown entry
             Means that <string> is not known by verify_krb5_conf.

SEE ALSO

     krb5.conf(5)

BUGS

     Since each application can put almost anything in the config file, it's hard to come up with a watertight verification process. Most of the
     default settings are sanity checked, but this does not mean that every problem is discovered, or that everything that is reported as a possi-
     ble problem actually is one. This tool should thus be used with some care.

     It should warn about obsolete data, or bad practice, but currently doesn't.

HEIMDAL                                                          December 8, 2004                                                          HEIMDAL

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pipe SQL select statement results to script

Discussion started by: houtakker

2. Shell Programming and Scripting

formatting the sql select result

Discussion started by: kotasateesh

3. Web Development

SQL Select inside Insert

Discussion started by: Ikon

4. Shell Programming and Scripting

How to redirect value from sql select statment to unix variable

Discussion started by: abdulhafeez