problem with sql command in pro*c - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > High Level Programming
*problem with sql command in proc**

google unix.com

High Level Programming Post questions about C, C++, Java, SQL, and other programming languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
problem in awk command	viveksnv	Shell Programming and Scripting	3	03-03-2008 04:59 AM
problem with tr command	ravi raj kumar	UNIX for Advanced & Expert Users	2	07-02-2007 07:41 AM
problem with dd command or maybe AFS problem	Anta	Shell Programming and Scripting	0	08-25-2006 11:10 AM
ls command problem	buckhtr77	SUN Solaris	2	12-06-2005 04:16 PM
Problem while using Sed command	gopskrish	UNIX for Dummies Questions & Answers	2	06-27-2005 12:26 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

05-09-2008

quynhtrang quynhtrang is offline

Registered User

Join Date: Apr 2008

Posts: 3

problem with sql command in pro*c

In a pro*C program, I use query follow:
INSERT INTO radacct_wk
SELECT (select psid from cscterminfo where cscterminfo.TELNO = username), nasipaddress, acctstarttime, acctstoptime,
acctsessiontime, acctinputoctets, acctoutputoctets, acctterminatecause, framedipaddress
FROM radacct@DBSV_B;

But sql error appear :
SELECT (select psid from cscterminfo where cscterminfo.TELNO = username), understand this command.
Please help me!

Bookmarks

« JRE in Fedora 7 | compile java with GUI on unix system/putty »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 02:59 PM.