SELECT ibhand,ibald2,ibqlrc
FROM Invbal WHERE istore= 14 and days(current date)-
days(substr( digits(ibcen2+19) ||SUBSTR(DIGITS(ibald2),1,2)||'/'||
SUBSTR(DIGITS(ibald2),3 ,2)||'/'|| SUBSTR(DIGITS(ibald2),5,2) ,4
,10))>180
and ibald2<>0 and inumbr=42372160
This is SQL Statment working in my iseries side but i need this in C# Code, can someone guide me.
thanks.
Go to the complete details ...