Linear Regression for Machine Learning Introduction Linear Regression is one of the basic concept used in Machine Learning. Do not think it’s complex as it’s related to Machine …
Getting JIRA Issues based on filter using Java Let’s see how to fetch all issues from JIRA in JAVA based on the provided JQL search filter. To know about the required Maven dependencies …
Create a new Issue in JIRA using Java API We are now going to see how to create new JIRA issue in JAVA using the REST API library. We can use this cod with some little modifications …
Get JIRA Field ID using Java Let’s see how to fetch the field Id from JIRA in JAVA using the REST API library provided by Atlassian. To know about the required Maven …
Getting all JIRA Issue Details using Java Let’s see how to fetch all details of a given JIRA issue in JAVA using the REST API library provided by Atlassian. To know about the …
Getting all JIRA Issue Types using Java Let’s see how to fetch all available issues from JIRA in JAVA using the REST API library provided by Atlassian. To know about the required …
How to work with Atlassian JIRA API using Java To work with JIRA REST API in Java, we need to import the required Java packages and we might also need to import the trust-store file. Java …
நிம்மதி சூழ்க! சில நாட்களுக்கு முன்பு என் அலுவலக நண்பர் திரு.கோபி மூலமாக ஒரு பாடலை கேட்க நேர்ந்தது. நான் பல தத்துவ பாடல்களை இதற்கு முன் கேட்டிருந்தாலும், …
Running Cron in Windows We all would have heard of Cron jobs, if you are involved in website management, development or working on Linux/Unix machines. What’s a …
Solution for Disk Drive Full error with USB Pen Drives When you copy large files (greater than 3 GB) to your USB pen drive, it’s almost sure that you will get an error alerting that “Disk drive …
French letters - modeles de lettres Je voudrais partager quelques sites sur le sujet de “lettre”. OK, now in English. I would like to share some good website resources for …
Monsta FTP - FileZilla like FTP software for browsers You would have came across a FTP application like FileZilla or WinSCP which you have used to access a FTP server. These are Windows based …
Overriding Concatenated Datasets in JCL Lets assume that you have a PROC with the following step which has 5 concatenated steps. //STEP010 EXEC PGM=PROGRAM1 //INPUTF DD …
Unlock Your Android Phone and Earn Money Are you an smart phone user? How many times in a given day, you unlock your phone screen to work on it? Read the title of this article. Yes. …
DB2 9 Family Fundamentals(000-730) - Q & A Read and Download several question and answers for the IBM DB2 9 certification exam. Section 1 - Planning (14%) Knowledge of restricting …
Replacing low values to spaces in Mainframe Sort In Mainframe, using Sort, how can I replace all the low-values in a file to spaces? We can use ALTSEQ CODE to change the low-values or …
Ce n'est pas vos oignons Dans les expressions occupe-toi de tes oignons ou ce ne sont pas tes oignons. le terme oignon prend bizarrement le sens metaphorique de …
ca fait un bon bout de temps C’est quand vous avez rendu visite à vos amis? Je pense que c’est longtemps. Ne c’est pas? Alors, on dit “Ça fait un bon bout de temps” pour …
Why this Kolaveri di French Version Our own song lyrics and singing for “Christmas” event in Alliance Français of Madras. We friends rocked the floor with the french version of …
Fumer Comme un Pompier Avec cet expression vous pensez que les pompiers fument beacoup du tabac que les autres? Non. Cet expression signifie une personne fumant …
COBOL Code Optimization To assist in the optimization of the code, you should use the OPTIMIZE compiler option. With the OPTIMIZE(STD) or OPTIMIZE(FULL) options in …
ARITH Compiler Option in COBOL ARITH affects the maximum number of digits that you can code for integers, and the number of digits used in fixed-point intermediate …
Converting a file from VB to FB. DFSORT can be used to do VB to FB conversion, when sorting, copying or merging. The VTOF or CONVERT and OUTREC operands of OUTFIL can be …
Recovering Deleted Flat Files in Mainframe Flat files can be recovered by following the below mentioned steps. Start 6 HLIST BCDS DSN(‘filename’) Wait for the system notification Type …
AUTOTYPE Suggestion How wonderful it feels when Internet explorer suggests names for URLs when we start typing the first few letters! Our mainframe also has the …
Options on DECLARE CURSOR Use FOR READ/FETCH ONLY or WITH UR for retrieval only cursors. Use OPTIMIZE when you know the accurate number of rows that will be fetched …
Useful List of SYSIBM tables SYSCHECKDEP Column references for CHECK constraints SYSCHECKS CHECK constraint specifications SYSCHECKS2 (V7) Information about CHECK …
GDG - A Basic Introduction Introduction GDG stands for Generation Data Group. Here a group of files are related functionally or chronologically and can be accessed …
Ranking and Numbering for Records in DB2 DB2 supports ranking and numbering in much the same way that Oracle does. The available functions are: ROW_NUMBER(), which simply numbers …
Selecting first few rows in DB2 DB2’s method of performing a Top-N query is the FETCH FIRST clause. You can append these variations to a regular SELECT query: FETCH FIRST …
INSPECT in COBOL The INSPECT verb has two options, TALLYING and REPLACING. You can do one or the other or both. If both are done, the TALLYING IS DONE BEFORE …
COBOL Numeric Data Types-COMP The following common COBOL data types are discussed below: Binary Computational (comp) Comp-1 Comp-2 Comp-3 Packed Decimal **BINARY ** …
ISPF Special Searching A picture string in a FIND, CHANGE, or EXCLUDE command allows you to search for a particular kind of character without regard for the …
TIME=NOLIMIT and TIME=MAXIMUM We can specify the max limit of TIME parameter as TIME=NOLIMIT TIME=MAXIMUM Now which specification gives maximum time for a JOB? …
Run a step only from a set of steps in a job I have a JCL with 20 steps. Due to some reasons I want to execute the step 15 only. One way to do it is to use RESTART from STEP15, but it …
DB2 Index with Expressions Prior to DB2 9, the create index statement only allowed you to use the column name from the table the index is being built on. The same …
Run a Program using Referback It is possible to execute a program from any library using the referback feature. STEP1 EXEC PGM=IEFBR14 //PROGRAM DD …
Like the DB2 LIKE The LIKE phrase defines a mask for comparing characters: WHERE COL_VAL [NOT] LIKE mask A mask may be a host variable or a literal enclosed …
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 …
Isolation level in DB2 The list of isoloation leves are listed below. SERIALIZABLE(Repeatable read (RR)) REPEATABLE READ(Read stability (RS)) READ COMMITTED(Cursor …
Freezing columns in File-Aid 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. …
VSAM record count using File-Aid 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 …
Read Only VSM Files By using INHIBIT along with ALTER command, we can have a read-only VSAM dataset. Example: //STEP1 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* …
Dummy VSM Dataset in JCL 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? …
TSQ Vs. TDQ 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 …
Find bad data using File-Aid 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). …
Points to Ponder on DB2 NULL NULLs can present problems because they are handled differently by different computers and the collating sequence is inconsistent with …
Explanation on DB2 Explain 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 …
Appending to ISPF Clipboard Scenario: I have a dataset with 10,000 lines. I want to cut the first 10 lines and last 10 lines and paste into another dataset. When I cut …
Viewing Mainframe ISPF Clipboard When I issue CUT , I know that the CUT content are placed in a clipboard. And when I issue PASTE, the clipboard content are pasted. But is …
Changing the Create or Update User ID in Mainframe Usually the PDS or PS bears the ID of the creator or the ID of the person who modified it recently. It’s possible to change these ID values …
Repeating the ISPF command without typing again Any command entered in the ISPF COMMAND LINE disappears after the successful execution of its intended function. If you want to repeat the …
Verification of DB2 Consistency token When a Job abends at a program due to bind error with SQL code of -805 or -818 then generally there is issue with consistency token (often …
COBOL Calendar and Date Functions You need to know what date is 150 days from today (and this kind of stuff happens more often than you’d think)? Convert today to an integer …
Filtering Jobs in Spool There is a possibility to list only the jobs which has ABENDED, leaving out all other jobs in the spool. For such a kind of listing, use the …
Rearrage SDSF Columns If you want to rearrange the columns in SDSF. Go to SDSF;ST. In command line type “arr ?”. This will bring the complete list of SDSF column …
Change uppercase to lowercase or lowercase to uppercase in Sort Translation features of INREC, OUTREC and OUTFIL make it easy to change the case of characters in your fields. The TRAN=LTOU operand can be …
Easy & Fast Editing of PDS using File-Aid Projects do testing of their code multiple times before they move their code to production. Once the test JCLs are created. From the second …
Add leading and trailing Characters in Sort Lets assume that we have a sequential dataset with records as below: ONE TWO THREE FOUR FIVE I want to reformat the records for output as …
