MVSFORUMS.com

Hello

Could someone let me know how best we can get the resultset

We have 3 table T1 T2 & T3 we need to find out those (empno) records which are there in t1 and not there in t2 and then joi ...

Hi ,
Please some one let me know for a table where we can get all the associated objects defined aganist that table. Can this informatio we get by querying the catlog tables?

Thanks,
Raj

Thanks Kolusu for the info the query is corrected.
Thanks,
Raj

Hi,

The below query when i am trying to execute is giving error of -199, please some one let me know where the issue is.

SELECT NAT_ID,TERM_DATE,EMPLOY_STAT_CODE FROM TABLE AS
(SELECT ...

Thanks & it worked fine.

yes there are filler spaces at the end & the file can be a new one with a new record length

Hi.

we have got a file of length 80, the 1'st 10 bytes is character and from 11 byte there is a comp field which is s9(09) comp and rest of the field is charcter
I need to change the comp field ...

Yes kolusu, the PO Number will be spaces after the 10 bytes & only the 1'st 10 bytes will have data value and with leading zeros can have ..

T1- value 11111
T3 -Value "000011111 ...

Thanks Kolusu for the reply, just to confirm another thing the table T1 and T3 teh PO number are defined with a picture clause of s9(9) comp and the table T2 is defined as x(26), here the data is stor ...

Hi,
I have 3 table tabe1,table2,table3, here i need to pick all of the purchase orders(po_nbr) column which are there in table1 and should be there in table3 and in table3 purchase orders(po_nbr) not ...

Apologies for spelling your name incorrectly.. The issue i am facing is that the query is hanging when i ran in the system, working fine the data size is of a smaller size , so i believe we may need t ...

Thanks kolsu, the issue is query is hanging as the tables are having more 7 billons reords.. so we need to unload to flat file and do a file matching..that is my thought

Regards
Rajeev V

ok kolusu.
The Empno in T1 is S9(09) COMP & in the 2'nd table the data is x(30).
The data in t2 is shown as '000000008'

Regards
Raj

ok. empno in table (t1) is binary and that empno in table t2 is character of length 30.

Regards
Ron

ok Kolusu, the issue here is the datatype of one is binary and the other is character , i used the cast function, it is saying the "OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPA ...