SELECT statement

SQL Server equivalent of Oracle’s “when no data found” exception

In a stored procedure, I'm storing the result of a select statement in @variable. Is there a way to capture a SQL Code 100, like Oracle's SQLERRM(100)/ORA-01403 if no records are returned? I'm currently setting @variable = '*' before the select and and IF @variable = '*' afterwards, but there...

Answer Question   |  Aug 15 2008   2:41 PM GMT   |  asked by CO Bill
Stored Procedure variables, Stored procedures, SELECT statement

Need help executing MULTIPLE SQL extracts from a JCL

GREYBEARD52: Thanks again for the info, BUT I'm not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won't help - it doesn't support SELECT.Are there ANY OTHER ALTERNATIVES or a way to tweek this command to 1. Run...

View Answer   |  Jun 3 2008   6:57 PM GMT   |  asked by Jonty Walker
SQL, JCL, DB2

update a field from a file with a field from a selection from two files

Hi!When I try this:update fileD d set d.value = (select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c where d.key = c.key)I get the message "Null values not allowed in column or variable VALUE."on the other hand, when I do this selection:(select...

View Answer   |  Apr 29 2008   11:03 AM GMT   |  asked by Mr.
Update, SELECT statement, SQL

Using SELECT statements

Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?

View Answer   |  Feb 27 2008   9:48 PM GMT   |  asked by OracleATE
Oracle, Oracle development, SELECT statement

Showing all records

DATA SET:Table1XID YID WRKDATE--- --- ------- 1 NOR 2007-012 SOU 2007-03Table2XID ZID QTY --- --- --- 1 PEN 10 1 PAP 202 PAP 51 PEN 102 PAP 5ResultXID YID WRKDATE ZID QTY--- --- ------- --- ---1 NOR 2007-01 PAP 201 NOR 2007-01 PEN 101 NOR 2007-01 PEN 102 SOU 2007-03...

View Answer   |  Nov 27 2007   2:58 AM GMT   |  asked by TeamJR3
SELECT statement, JOIN

oracle quires

while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus

View Answer   |  Oct 26 2007   1:36 PM GMT   |  asked by Balachander k
Oracle, SELECT statement

Nested Selects in CLLE

I am attempting to palce Nested Select Statements within a CLLE program and it will not accept the process.ie:SELECTwHEN a=B THEN(DO)PROCESS....ENDDOWHEN C=D THEN(DO)PROCESSeNDDOWHEN (X=Y) tHEN(DO)selectwHEN X1 = A tHEN(dO)PROCESSeNDDOwHEN X1 = b THEN(DO)PROCESSeNDDOeNDselectwHEN X=z ...

View Answer   |  Oct 16 2007   7:11 PM GMT   |  asked by Wmfsr
NESTED, SELECT statement, CLLE

Select from table where data row missing

I have a table with the main fields being BU, ASSET, BOOKfor any BU and ASSET combination, there should be two to four rows of data, with just the BOOK value being different. Data corruption has caused us to find all BU-ASSET combinations missing the value 'AMT' for BOOK. I need to join the table...

View Answer   |  Oct 15 2007   9:34 PM GMT   |  asked by Jej1216
SELECT statement, Outer Join