Hello all,
The SYSIBM.SYSCOLUMNS contains the coloums mentioned below:
NAME: Name of the coloum
TBNAME: Name of the Table
TBCREATOR:
COLNO:
COLTYPE:
LENGTH: You need to chk it
So if you give a simple select * on the SYSIBM.SYSCOLUMNS
with the TBNAME you will get the col name and...
Hello Devesh,
Hope you have found the answer till now but I can tell you how I would have solved such problems:
1)If your job is just to check the file is there or not and if its there it will do an FTP,you can put a file dependency on the job ie as soon as the file will be there JOBTRAC will...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.