Search Results

Suppose I am executing a sql query thru shell script.
DB : IBM DB2



If none of the rows are fetched, I will be getting the sql code as 100
If rows > 0 are fetched, I will be getting the...

Johnson,

The script that you have given works fine. But in my case it is a different one.

I have given the sample what I am working now. Let me give you the exact one what i am working...

Thank you for your reply Johnson.

Here the problem is how to read PCN, ACCNO, TRANCD, AMOUNT, LOB_TIMESTAMP from a text file. The data will be as follows in the text file.



The data existing...

I am writing a shell script for Archive Purge for the table having rows < 1 year. The shell script has to extract the rows from the table and write those extracted rows to a text file. Then from the...

I am giving the output as follows:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
# cat currenttimestamp

1
--------------------------
2008-10-06-10.06.01.455592

1 record(s) selected.

...

F Y I.. we are using Korn Shell .ksh ..

Krishnakanth

Thanks for your reply.

The code is not working. I simply copied and pasted it. I don't know why ?.

Could you please explain the function of "grep '^[12][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]"
...

#! /bin/ksh
############################
# AFI Monitor Script
############################
. /db2/uszlad48/sqllib/db2profile
export mondir=/home/script/krishna
export...

I am new to Unix shell Script
_________________________
db2 connect to r2pdev user bmwdevup using summer08 >>$monlog
# get the current timestamp from SYSIBM.SYSDUMMY1
currenttimestamp=""
echo...