awk file to read values from Db2 table replacing hard coded values Post: 302902707

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Converting Binary decimal coded values to Ascii Values

Hi All, Is there any command which can convert binary decimal coded values to ascii values... i have bcd values like below ��0�-- -v - Pls suggest a way to convert this. Thanks, Deepti.Gaur

2. Shell Programming and Scripting

Replacing File values

Currently I am using the tr command in 3 scenarios for a ksh script. 1) Replacing any spaces in the file with a ~ tr ' ' '~' <$orignalFile> $newFile 2) After certain processing is done at the end of the scirpt i convert the Tilde back to spaces tr ' ' '~' <$newFile> $newFile2 3) Last...

3. Shell Programming and Scripting

Reading values from a file using DB2 SQL

I have some alphbetical codes in that

4. Shell Programming and Scripting

AWK: read values from file1; search for values in file2

I have read another post about this issue and am wondering how to adapt it to my own, much simpler, issue. I have a file of user IDs like so: 333333 321321 546465 ...etc I need to take each number and use it to print records wherein the 5th field matches the user ID pulled from the...

5. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is...

6. Shell Programming and Scripting

Replacing values in a file based on values in another file

Hi I have 2 files:- 1. List of files which consists of names of some output files. 2. A delimited file; delimted by "|" I want to replace the value of the $23 (23rd column) in the delimited file with name in the first file. It is always position to position. Meaning first row of the first...

7. Shell Programming and Scripting

Read parameter file in a shell script to unload a DB2 Table???

Hi , I Have following requirement: DB2 Sql query to pass from a parameter file for example, I would create a parameter file with (SELECT column 1, column 2 FROM Table name) then job would read it and create a file with the contents named table.txt How to write/modify below ksh script to...

8. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh...

9. Shell Programming and Scripting

Read record from the text file contain multiple separated values & assign those values to variables

I have a file containing multiple values, some of them are pipe separated which are to be read as separate values and some of them are single value all are these need to store in variables. I need to read this file which is an input to my script Config.txt file name, first path, second...

10. Shell Programming and Scripting

Read values from second file in awk

Hello Friends, I have written a script like the following, which finds some logs and fetchs some desired rows and then calculate average processing time of a spesific application. if then echo echo "----- There are three arguments which is expected to run this script! ...

LEARN ABOUT SUNOS

tolower

tolower(3C)						   Standard C Library Functions 					       tolower(3C)

NAME

       tolower - transliterate upper-case characters to lower-case

SYNOPSIS

       #include <ctype.h>

       int tolower(int c);

DESCRIPTION

       The  tolower()  function  has  as  a domain a type int, the value of which is representable as an unsigned char or the value of EOF. If the
       argument has any other value, the argument is returned unchanged. If the argument of tolower() represents an upper-case letter,	and  there
       exists  a  corresponding lower-case letter (as defined by character type information in the program locale category LC_CTYPE),	the result
       is the corresponding lower-case letter. All other arguments in the domain are returned unchanged.

RETURN VALUES

       On successful completion, tolower() returns the lower-case letter corresponding to the argument passed. Otherwise, it returns the  argument
       unchanged.

ERRORS

       No errors are defined.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       _tolower(3C), setlocale(3C), attributes(5), standards(5)

SunOS 5.10							    14 Aug 2002 						       tolower(3C)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Converting Binary decimal coded values to Ascii Values

Discussion started by: gaur.deepti

2. Shell Programming and Scripting

Replacing File values

Discussion started by: hgjdv

3. Shell Programming and Scripting

Reading values from a file using DB2 SQL

Discussion started by: kavithakuttyk

4. Shell Programming and Scripting

AWK: read values from file1; search for values in file2

Discussion started by: Bubnoff