Need sybase sql command help Post: 302168759

10 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

ms sql command reference

does somebody know where i can find command reference for mssql? i tried to search via google and it does help me that much. maybe someone can refer me a site. thank you very much.

2. Shell Programming and Scripting

Hi, sqlplus -s / <<EOF > /dev/null insert into table1 (a1, a2, a3) values ('a',1,'b'); commit; EOF in the above code can i pass the values to the insert command from shell script like this: insert into table1 (a1, a2, a3) values ('$a',$b,'$c'); If yes, how is it passed?? Any...

3. Programming

Need help with complex SQL query (Sybase)

Hello, I have three tables. I need an SQL query (preferably Sybase) that will return all of the stringID values of table B where the following conditions exist: (1) B.intID = A.intID (2) B.intID != C.intID or (B.intID = C.intID and (C.v1 = 0 or C.v2...

4. Shell Programming and Scripting

sql command question

Hi, Table1 ====== Code1 Field1 Table2 ====== Code1 Field1 Would anyone be able to help me know what's the best sql command to delete the entry in Table1 if its Code1-Field1 combination is already existing in Table2. I used this one - delete from Table1 where Code1 in (select...

5. Shell Programming and Scripting

Bourne shell script with embedded Sybase SQL

Hi, I need a simple (as possible) Bourne shell script that takes an input file of adminID's and spits out a list of adminID's and related tradeID's. Both adminID and tradeID are columns in a Sybase database table called "trades", in which they have a one-to-one relationship. adminID is a...

6. SuSE

my SQL Info command

Is there a command that will output all mysql details. eg. host name, port etc? Cheers Paul

7. Shell Programming and Scripting

Need to capture error of sybase sql in unix

Hi Gurus, I am very new in Unix, I have 1 script, in which I am truncating the table , then BCP the data in Sybase table, and then loading the data from sybase table to sybase table. every thing is working fine, but the problem is with Error. I made some hanges in my insert statement so...

8. UNIX for Dummies Questions & Answers

Help Command in SQL LOADER

Which is the UNIX command to get the SQL Loader Help??:confused:

9. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to...

10. Shell Programming and Scripting

Bcp command error in uploading data to Sybase

Hi All, I had an issue in executing bcp command to connect to Sybase from Unix script for uploading the data from file to table. I have a file called vrs_temp.txt (with two columns): 22055;20181001 21088;20181001 93840;20181001 30990;20181001 50990;20181001 50950;20181001Created a...

LEARN ABOUT OSF1

clear_wait

clear_wait(9r)															    clear_wait(9r)

NAME

       clear_wait - General: Clears the wait condition

SYNOPSIS

       void clear_wait(
	       thread_t thread,
	       int result,
	       boolean_t interrupt_only );

ARGUMENTS

       Specifies  a  pointer  to  the thread Specifies the outcome of the wait. You can pass one of the following values: This is a normal wakeup.
       The timeout period expired.  The clear_wait routine interrupted the wakeup.  Specifies a Boolean value that indicates  how  the	clear_wait
       routine clears the wait condition. You can pass one of the following values: Clears the wait condition only if the kernel thread is waiting
       in an interruptible state.  Clears the wait condition under any circumstances.

DESCRIPTION

       The clear_wait routine clears the wait condition for the specified kernel thread and starts executing the kernel thread, if appropriate. If
       the  kernel  thread is interruptible and is still waiting for the event, clear_wait sets the kernel thread state to TH_RUN and places it on
       the run queue.

RETURN VALUES

       None

SEE ALSO

       Routines: assert_wait_mesg(9r), mpsleep(9r), thread_block(9r), thread_wakeup(9r), thread_wakeup_one(9r)

																    clear_wait(9r)

10 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

ms sql command reference

Discussion started by: inquirer

2. Shell Programming and Scripting

sql insert command

Discussion started by: abey