hi again,
i need help on,
1> creating views in as400
im making a vb program and i want to have the flexibility to change the query without having to recompile my vb program.
my view should be something like
select a.bnkind, a.entity, CASE ((a.bnktyp*100) + a.branch) wHEN 0 THEN 'Head Office'
ELSE trim(substring(a.inst, posstr(a.inst,'-') + 1)) END brancHName
from banklibrary left join geographylib b on a.region=b.region and a.province=b.province and a.town=b.town where a.bnkind between 0 and 10
2> and is it possible to save the source/view on a different library?
the banklibrary & geographylibrary belongs to bankreference library
our current working library is loanlibrary?
thanks again.
i need help on,
1> creating views in as400
im making a vb program and i want to have the flexibility to change the query without having to recompile my vb program.
my view should be something like
select a.bnkind, a.entity, CASE ((a.bnktyp*100) + a.branch) wHEN 0 THEN 'Head Office'
ELSE trim(substring(a.inst, posstr(a.inst,'-') + 1)) END brancHName
from banklibrary left join geographylib b on a.region=b.region and a.province=b.province and a.town=b.town where a.bnkind between 0 and 10
2> and is it possible to save the source/view on a different library?
the banklibrary & geographylibrary belongs to bankreference library
our current working library is loanlibrary?
thanks again.
Comment