MVSFORUMS.com

Thanks but that doesn't help.

I cut the field to 6 packed by moving it to a work area first and then to the output field and it still does not propagate the decimal and does not use the sign positi ...

I am a neophyte in easytriev and the manuals don't seem to help.

I have a DB2 input field decimal 20v4.

I need to report it in the format of -999999999999.9999. I can't seem to get the mask wor ...

I looked all over IBM but didn't do as good a job as you folks.

Thanks!
Mike

My boss asked me if our stuff will work - I know about the enterprise COBOL versus VS COBOL issue.

Is there anything else?

Can you point me to a "list" that defines differences and po ...

There's a third table involved and I wound up with a 5,000,000 row result so I added distinct and it's now down to almost the right result but I am getting duplicate rows, only, when the ay,az are no ...

THX, THIS IS WHAT I'M CODING... WILL IT WORK?

SELECT DISTINCT
A.ID, A.NBR, B.NM, B.LOB, A.OPEN, A.CLS
,CASE WHEN A.TX IS NULL THEN CHAR('-')
WHEN A.TX = C.ID THEN C.N ...

Thanks,

If the rows look like this.

A
AA1,AB1,null,null
AA2,AB2,null,AA3
AA3,AB3,AA2,null

B
AA1,BA1,BB1
AA2,BA2,BB2
AA3,BA3,BB3

The result has to look like this.

...

Problem: I have to do a select on two tables - one that has to join back to itself. I can't code it right.

Table A looks like this: aa,ab,ac,ad...ay,az
Table B looks like this: aa, bb, bc, bd ... ...