a query at db2 - DB2 Database

Maryam S via DBMonster.com

I 'm new at db2,I wrote a query which doesn't run at spufi:

------------------------
select distinct grade.gradecode,
((pamt+lvby+clal+poal+mhal)-(select distinct (pamt+lvby+clal+poal+mhal)
from grade as g where g.gradecode=
(select max(gradecode) from grade as g2 where g2.gradecode<grade.gradecode
and g2.empno=grade.empno)))

as ExcessSum from grade
------------------------
the error is :
ILLEGAL SYMBOL "GRADECODE". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: + ) -
42601 SQLSTATE RETURN CODE
------------------------
tnx in advanced

--
Message posted via http://www.dbmonster.com

Nov 12 '05 #1

Subscribe Post Reply

3428

Mark A

"Maryam S via DBMonster.com" <fo***@nospam.DBMonster.com> wrote in message
news:31******************************@DBMonster.co m...

I 'm new at db2,I wrote a query which doesn't run at spufi:

------------------------
select distinct grade.gradecode,
((pamt+lvby+clal+poal+mhal)-(select distinct (pamt+lvby+clal+poal+mhal)
from grade as g where g.gradecode=
(select max(gradecode) from grade as g2 where g2.gradecode<grade.gradecode
and g2.empno=grade.empno)))

as ExcessSum from grade
------------------------
the error is :
ILLEGAL SYMBOL "GRADECODE". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: + ) -
42601 SQLSTATE RETURN CODE
------------------------
tnx in advanced

You need to start out by looking at the SQL Reference manual. You can
download it here:
http://www-306.ibm.com/software/data...s/v7books.html

Other versions are also available, since you didn't specify which version
you are using.

Nov 12 '05 #2

Maryam S via DBMonster.com

it's DB2 ver7 as I got I can't use nested query,yes?

--
Message posted via http://www.dbmonster.com

Nov 12 '05 #3

Mark A

"Maryam S via DBMonster.com" <fo***@DBMonster.com> wrote in message
news:ac******************************@DBMonster.co m...

it's DB2 ver7 as I got I can't use nested query,yes?

There are multiple things wrong with your query. Check the SQL reference
manual. You can search it with Acrobat reader.

Nov 12 '05 #4

Maryam S via DBMonster.com

I can run it at SQl but when I want to run it at DB2 it doesn't I think
there is sth which DB2 doesn't support.

--
Message posted via http://www.dbmonster.com

Nov 12 '05 #5

Mark A

"Maryam S via DBMonster.com" <fo***@DBMonster.com> wrote in message
news:0a******************************@DBMonster.co m...

I can run it at SQl but when I want to run it at DB2 it doesn't I think
there is sth which DB2 doesn't support.

Are you talking about MS SQL Server? That is a different product, that
rarely follows ANSI SQL standards. Check out the DB2 SQL Reference manual.

Nov 12 '05 #6

Maryam S via DBMonster.com

tnx Mark for ur help.

--
Message posted via http://www.dbmonster.com

Nov 12 '05 #7

Similar topics

PHP MySQL query not displaying data

by: jaysonsch | last post by:

Hello! I am having some problems with a database query that I am trying to do. I am trying to develop a way to search a database for an entry and then edit the existing values. Upon submit, the...

PHP

Syntax error (missing operator) in query expression

by: shank | last post by:

1) I'm getting this error: Syntax error (missing operator) in query expression on the below statement. Can I get some advice. 2) I searched ASPFAQ and came up blank. Where can find the "rules"...

ASP / Active Server Pages

Need help with query

by: netpurpose | last post by:

I need to extract data from this table to find the lowest prices of each product as of today. The product will be listed/grouped by the name only, discarding the product code - I use...

Microsoft SQL Server

asp query form

by: Harvey | last post by:

Hi, I try to write an asp query form that lets client search any text-string and display all pages in my web server that contain the text. I have IIS 6.0 on a server 2003. The MSDN site says...

ASP / Active Server Pages

Query looking back

by: Diamondback | last post by:

I have two tables, WIDGETS and VERSIONS. The WIDGETS table has descriptive information about the widgets while the VERSIONS table contains IDs relating to different iterations of those widgets...

MySQL Database

MySQL Query

by: Dave Thomas | last post by:

If I have a table set up like this: Name | VARCHAR Email | VARCHAR Age | TINYINT | NULL (Default: NULL) And I want the user to enter his or her name, email, and age - but AGE is optional. ...

PHP

Multiple List Box form to build dynamic query feedback wanted

by: starace | last post by:

I have designed a form that has 5 different list boxes where the selections within each are used as criteria in building a dynamic query. Some boxes are set for multiple selections but these list...

Microsoft Access / VBA

Use Select Query variable against a table and return value to same select query

by: jjturon | last post by:

Can anyone help me?? I am trying to pass a Select Query variable to a table using Dlookup and return the value to same select query but to another field. Ex. SalesManID ...

Microsoft Access / VBA

Query of a Query DataSheet

by: Stan | last post by:

I am using MS Office Access 2003 (11.5614). My basic question is can I run a query of a query datasheet. I want to use more that one criteria and can not get that query to work. I thought I...

Microsoft Access / VBA

Access Query on SQL Linked Tables

by: jsacrey | last post by:

Hey everybody, got a secnario for ya that I need a bit of help with. Access 97 using linked tables from an SQL Server 2000 machine. I've created a simple query using two tables joined by one...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++