- Blog
- Blog
- Homepage
- Homepage
-
DB2 LOCATE Function Advanced Examples
LOCATE SCALAR – Function returns first occurrence position in first string, second string: Example 1: SELECT LOCATE(‘I’,’MINE STRING’) FROM SYSIBM.SYDUMMY1 It returns value 2. Since first occurrence is 2. Example 2: SELECT LOCATE(‘I’,’MINE STRING’,3) FROM SYSIBM.SYDUMMY1 Now the answer will be 9. Since after third position it starts searching for ‘I’. Read my post on…
-
3 Popular Ways to Handle DB2 VARCHAR Field in COBOL
Handling VARCHAR in COBOL is a tricky subject. Explained to handle it in COBOL 49 level with examples in a way that a novice can understand quickly.
-
5 ways to deal with a difficult team member
1.Spot Signs Early Observe signs early on. ” Procrastination, blaming others and not trying for self improvement are signs of a non-cooperative team member,” says Sudhir Dhar, associate director and head — human resources and administration at Motilal Oswal Financial Services. 2.Tolerate or Counsel Them One approach is to live with the fact that you…
-
The Usage of Each PL/SQL Block
Oracle PL SQL tutorial explained how to write a procedure in oracle or any RDBMS.
-
UNIX and Shell Scripting Programming – A to Z PPT
-
6 Ways to Manage People in the Office
Managing people very much needed when you are working for an office.
-
Webserver Basics For Dummies
Server plays prominent role in running applications. Many people false understand that OS is the same as Server. OS and Server both are different. The main job of Web server is to respond to requests from Web client computers. There are 3 components of a Web server: –Hardware –Operating system software –Web server software The…
-
7 Jigsaw Puzzles That Boost Brain Power
Top jigsaw puzzles you can try at your free time to improve your brain power. Do not focus watching TV instead try these puzzles to get growth in your career also.
-
PL/SQL Engine – How it Process SQL Statements
PLSQL engine in Oracle the functionality explained with graphical image that how PLSQL statement process inside of oracle database.
-
DB2 Cursors simplified tutorial part 2 of 2
Complete tutorial on DB2 cursors part 2 of 2
-
5 Essential Commands for Navigating Files in UNIX
You can swiftly and easily control your file by utilizing these commands in UNIX. File navigating commands catConcatenate: displays a file. cdChange directory: moves you to the directory identified. cpCopy: copies one file/directory to specified location. fileIdentifies the file type (binary, text, etc). findFinds a file/directory. headShows the beginning of a file. lessBrowses through a…
-
5 COBOL Frequently Asked Interview Questions
Frequently asked COBOL questions but you will not remember these until you revise many times. If you do that these questions good for your next interview.