Simple ideas and quickly what you need to find to write a query for joining of two tables explained.
Author: Srini
Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.
In this post, I have answered one tricky SQL-view interview question. Views availability after the base table modified confuses many developers. I provided an answer to this.
How to calculate or decode which ISO Bits are present or not present in ISO 8583 message. I have explained in easy to understand method.
Examples for COBOL Evaluate statement for multiple conditions.
In COBOL, Variable-length records stores only in VB or Dynamic arrays. The given sample VB-array logic useful to code in your project.
Given examples of Date condition in the WHERE clause are useful for DATE comparison.
