Handling NULL in DB2
The value of an indicator variable tells the status of a row after a query. Host Variable: 01 FILLER. 05 WS-AMOUNT PIC S9(5)V9(2) COMP-3. 05 …
Personal Blog
Personal Blog
The value of an indicator variable tells the status of a row after a query. Host Variable: 01 FILLER. 05 WS-AMOUNT PIC S9(5)V9(2) COMP-3. 05 …
The list of isoloation leves are listed below. SERIALIZABLE(Repeatable read (RR)) REPEATABLE READ(Read stability (RS)) READ COMMITTED(Cursor …
While working in MS Excel we have the option of “Freeze Panes”. By this options we can freeze some columns and have other columns scrolling. …
Whats the best way to count the number of records in a VSAM File? Choose FILE-AID Option 3.8. At the prompt of ….ENTER NEXT FUNCTION OR END …
By using INHIBIT along with ALTER command, we can have a read-only VSAM dataset. Example: //STEP1 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* …
In general we use DUMMY datasets in JCL instead of a actual file for some requirements. But how can we specify dummy VSAM dataset in a JCL? …
In Temporary Storage Queues Data is read randomly, while in Transient Data Queues data must be read sequentially. In a TSQ data can be read …
The Easiest and Coolest way to locate bad data is thru File-Aid’s FIND command. OPEN the file in FILE-AID (in either browse or edit mode). …
NULLs can present problems because they are handled differently by different computers and the collating sequence is inconsistent with …
When an SQL is executed against or bound to a DB2 database, DB2 Optimizer tool defines the access path used to access the data. This access …