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....
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....
105 pts.
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: ...
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: ...
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?
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?
Showing all records
DATA SET: Table1 XID YID WRKDATE --- --- ------- 1 NOR 2007-01 2 SOU 2007-03 Table2 XID ZID QTY --- --- --- 1 PEN 10 1 PAP 20 2 PAP 5 1 PEN 10 2 PAP 5 Result XID YID WRKDATE ZID QTY --- --- ------- --- --- 1 NOR 2007-01 PAP 20 1 NOR 2007-01 PEN 10 1 NOR 2007-01...
DATA SET: Table1 XID YID WRKDATE --- --- ------- 1 NOR 2007-01 2 SOU 2007-03 Table2 XID ZID QTY --- --- --- 1 PEN 10 1 PAP 20 2 PAP 5 1 PEN 10 2 PAP 5 Result XID YID WRKDATE ZID QTY --- --- ------- --- --- 1 NOR 2007-01 PAP 20 1 NOR 2007-01 PEN 10 1 NOR 2007-01...
oracle quires
while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus
while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus
Nested Selects in CLLE
I am attempting to palce Nested Select Statements within a CLLE program and it will not accept the process. ie: SELECT wHEN a=B THEN(DO) PROCESS.... ENDDO WHEN C=D THEN(DO) PROCESS eNDDO WHEN (X=Y) tHEN(DO) select wHEN X1 = A tHEN(dO) PROCESS eNDDO wHEN X1 = b THEN(DO) PROCESS eNDDO...
I am attempting to palce Nested Select Statements within a CLLE program and it will not accept the process. ie: SELECT wHEN a=B THEN(DO) PROCESS.... ENDDO WHEN C=D THEN(DO) PROCESS eNDDO WHEN (X=Y) tHEN(DO) select wHEN X1 = A tHEN(dO) PROCESS eNDDO wHEN X1 = b THEN(DO) PROCESS eNDDO...
Select from table where data row missing
I have a table with the main fields being BU, ASSET, BOOK for 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...
I have a table with the main fields being BU, ASSET, BOOK for 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...
