Search Results

Thank you ..that worked !!

Thank you for the quick response ..but alas
I tried that as well
currenttimestamp=`db2 "select current timestamp from SYSIBM.SYSDUMMY1 with ur" |awk '{print $3}'`
echo currenttimestamp...

hi..

this works if i just type it at the command..
but i need it as a variable ..
how do i do that ?

if I do
currenttimestamp=`db2 "select current timestamp from SYSIBM.SYSDUMMY1 with ur"...

I am doing this in my script ..
currenttimestamp=`db2 "select current timestamp from SYSIBM.SYSDUMMY1 with ur"`

echo s $currenttimestamp
but this is how its shows
s 1...

actually I initially tried with space ..but then it would throw this message
and also it would not insert the row to the table..

SQL3148W A row from the input file was not inserted into the...

There are two columns on the data base table, create and update timestamps of datatype timestamp.

I dont have these fields on the csv file. So I am doing the below.

awk -F , -v d="$(date "+...

I cannot manipulate the Excel file.
It comes from a third party and we have to run the batch file to handle the data that they send before inserting into our DB.

---------- Post updated at 09:01...

I am a newbie to shell scripting ..

I have a .csv file. It has 1000 some rows and about 7 columns...

but before I insert this data to a table I have to parse it and clean it ..basing on the...