UNIX for Dummies Questions & Answers

I have a varchar column which contains the data at ‘bit' level.the data needs to be extract / transform at bit level and this will contain a Boolean value - 0/1. How can we handle using shell scripts
At source level(DB2 Database) we have a column of length 250 char ie varchar(250) so each char will hold a byte information and from this byte we need to extract bit level information.

Create a script to convert the DB2 character to an integer, presumably 32 through 255, and then run through bc.

Code:

echo "obase=2\n$char"|bc

Where $char is the value of the byte.
The output is binary, but you have to supply leading zeros to pad to 8 characters total.
Edit
Add 256 to $char before running bc, and the output will always be 9 characters the first being 1 which you can easily ignore or discard

Thanks a lot will try on htis phase and let u know...