Home - All Categories - Scripts

java Simple Java JDBC Program To Execute SQL Select Query

Below is a sample Java JDBC program which takes database connection string as command line arguments and returns the SQL select query output Â Replace the SQL Select query in the below code with the desired select query and modify the variabl...

java Simple Java JDBC Program To Execute SQL Update Statement

Below is a sample Java JDBC program which takes database connection string as command line arguments and executes the SQL update statement. Â Â Â Value to be updated in the table is passed as a command line argument. Â Â Â Replace the SQL update stat...

Transform XML to CSV Format | Unix String Pattern Manipulation The Ugly Way

Transform XML to CSV Format | Unix String Pattern Manipulation The Ugly Way Updated:Â Jun 22, 2020 Â Â Disclaimer: I do not claim the below method to be the best optimum method of transforming XML to CSV format on the Unix command p...

Convert JSON to CSV with bash script

A tale of two formats: Converting JSON to CSV Peter Andersson Follow May 5, 2016Â Â·Â 4Â min read Â So this just happened:- âPeter, can you send me a CSV of those search results?â- ââ¦yeah, sureâ¦give me a minuteâ We’d been looking ...

Convert CSV to JSON with jq

jqÂ the JSON processorÂ isÂ a new toolÂ forÂ command-lineÂ dataÂ mining.Â I’ve beenÂ using jqÂ for a couple of months and it’sÂ super useful. In this post I present a simple example of convertingÂ CSVÂ to JSON using jq. Parsing CSV with jq is import...

Convert CSV to JSON with bash script

#!/bin/bash # CSV to JSON converter using BASH # original script from https://gist.github.com/dsliberty/3de707bc656cf757a0cb # Usage ./csv2json.sh input.csv > output.json # cat | csv2json > output.json #set -x shopt -s ...

O`Reilly`s CD bookshelf

https://docstore.mik.ua/orelly/bookshelfs.html Â The Java Reference Library, version 1.3 The Java Enterprise CD Bookshelf, Version 1.0 The Perl CD Bookshelf, version 1.0 ...

Epoch & Unix Timestamp Conversion Tools

The current Unix epoch time isÂ 1529656113 Â Convert epoch to human readable date and vice versa Â [batch convert timestamps to human dates] GMT: Friday, 22 June 2018 07:40:23Your time zone: piÄtek, 22 czerwca 2018 09:40:23 GMT+02:00 DST Yr Mon D...

Unix - eval command example

Unix - eval command example Â Have you ever have the need to remotely execute a long list of command to a list of unix machines to perform tasks like gathering their information? Well, if you did then you will mostly came across an issue where you ra...

Unix - Find command examples

Unix - Find command examples Â Below are some find command examples on Unix OS. #find

Unix - Examples for grep command

Unix - Examples for grep command Â Below are some examples on the usage of grep and egrep in Unix. We are using file text.txt as our source file. Content of text.txt ================================================================== onetwothreefou...

To do a quick check on the number of path present (does not mean all are Enabled] using for loop

To do a quick check on the number of path present (does not mean all are Enabled] using for loop. ===================================================== for i in `/usr/sbin/lspath | grep scsi | awkÂ '{print $2}' | sort |uniq ` ;Â do echo "$...

bash for do done AIX

for i in `lsdev -Cc adapter | egrep "^ent" | awk '{ print $1 }'` ;Â do echo "#### $i ####" ;Â lsattr -El $i ; echo "####Â Â Â ####" ;Â done

Display basic information about Physical Volumes

# Small script to display some interesting information about Physical Volumes DISP="1"; ls -l /dev/hdisk* | awk '{print $10 " " $5 $6}' | sed -e "s:/dev/::" -e "s/,/ /"Â | while read DISK MAJOR MINORdoÂ Â SIZE=$(bootinfo -s $DISK)Â Â LUN=$(...