-
3 top Teradata certifications add value to career
The more you need to know about Teradata certifications and the rules behind and eligibility of certification in Teradata. Read More ⇢
-
How to Open a Queue in MQseries with MQOPEN
Explained sample MQSeries program with different options of MQOPEN call. A good example to use in your projects. Read More ⇢
-
The Real Purpose of DBDGEN Utility in IMS DB
DBDGEN Utility the purpose of this utility for IMS DB programs explained in this article. Read More ⇢
-
List of IMS DB Topics for Interviews
The below is the complete list you need to refresh before you take for IMS DB interview: Prepare These Before Your Interview IMS DB Architecture IMS DB DBD declaration. What is PSB and PCB IMS DB DL/I entry. different Calls in IMS DB Tools being used to browse IMS DB… Read More ⇢
-
Mastering EXPLAIN PLAN: Improve SQL Performance
Syntax for EXPLAIN PLAN What happens when you issue EXPLAIN PLAN? Explanation for Set Query No SET QUERYNO = integer ==>Associates integer with explainable-sql-statement. The column QUERYNO is given the value integer in every row inserted into the plan table, statement table, or function table by the EXPLAIN statement. If… Read More ⇢
-
How to Understand SAS Macro Easily
The SAS program explained the syntax rules you need and program rules how to write it. Highly suitable for dummies in SAS. Read more. Read More ⇢
-
How to Run a Query in QMF Automatically
Best example to run SQL query automatically in QMF. Useful for mainframe developers. Read More ⇢
-
IDCAMS Sort File Skip Header and Trailer
The logic is again in two ways: Method-1 Use IDCAMS utility skip header record and trailer record. IDCAMS Skip record code snippet: // EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=A //SYSIN DD * Skip(1)count(48) /* Method-2 Use IFTHEN in sort on input file, that is INREC. That means you need to reformat… Read More ⇢
-
10 Killer Tips to Write PLI program Easily
The following are the top 10 tips to write perfect PLI program. Tip#1 Source programs may be written in upper or lower case. There is no difference between the cases, except within strings. Tip#2 Varying strings (declared with the attribute VARYING) are similar to C’s char. For an exact equivalant,… Read More ⇢
Srinimf 