Search Results

hi Team,

since i am using AIX i am unable to excute the above two command getting error
date -jv-1H -f "%F %T" "2014-12-22 05:15:13.13423" +"%F %T"
date: Not a recognized flag: j
Usage: date...

Hi

Thanks for you answer

But one small issue is there in the above command

when we passing time stamp with below values please see the result.

echo "2014-12-22 00:15:13.788875" | awk...

Hi Team,

i need some help on finding one hour back time.
if current time is 5:18:22 means i have to find 4:18:22
i am having scenario to pull record which as got inserted morethan one hour back...

Thanks very much derekludwig

i am fine with the above mentioned logic but my doubt is will it work for if we are having many columns :wall:


col1, col2,col3,date
1,2,3,20110825...

Hi

i am so sorry i want understand the above mentioned logic could you place comments over there

actually i have pasted for one column
my scenario is if i am having more one column in a...

Sample data pasted below
20110227
20120528
20141142
20110230


in the above sample data 3 & 4 dates are not valid.so i want highlight those two dates to my...

HI,

i have to do some file validations on which i am receving daily.could any one please let me know how we can able to do validations on below scenarios

1) On Date column Ex If i am...

thanks Singh...

but i dont want to display the COL3 and COL4 values. i Just want to display the new concatenated column only

sorry it's not working

its just displaying the file content as output
awk -F, '{$4=$4 $5;NF=4}1' OFS=, /home/dsadm/rpt/dstempdir/SCRIPT_SEQ_LOG/test.txt

Please use CODE tags rather than...

Hi

i am having one requirement like to concatenate two columns in to one columns, can any one help on this please sample scenario i am placing below

COL1,COL2,COL3,COL4
1,A,B,C,D...

hi,


when i have used same syntax in my script it just creating empty file only

HI,

I am having scenario like to print multipule rows from output of database query

sample query i mentioned below


code=`db2 -x select code,values from dummy`


in the query...

hi

i am trying to execute db2 queries through shell script. it's working fine but for few queries is not working ( those queries are taking time so the script is not waiting to get the complete...

hi

in the defining the all to queries to variables finally i have to place the result in to respective cells

here main point how can i place data in to excel sheet cell


Thanks in...

Hi

Thanks for reply

But my main concern is i have generate my report in the excel sheet like below format
i am not getting any idea how to place data in cell wise


SOURCE ROW COUNT...

Hi,

I am new to DB2 and in need of urgent help.
Here we have about 100 queries (SQL) that have been manually executed to retrieve totals from different tables
and post it to Excel spreadsheet....

Thanks alot it works fine now

---------- Post updated at 01:20 PM ---------- Previous update was at 11:10 AM ----------

HI

I am unable to print the value

echo " record count ==...

Hi ,


i am unable to generate dynamic variables can any one please help me on the below issue

j=1
{record_count_"$j"}=`db2 -xselect substr\(job_name,24\) rec_count from...

hi RudiC

the above is just splitting the M records in to one files and D into another files that is not i expected

i m having all M and D records together ;
for example
M <form_name> ...

Hi

just the lines of the 50th M records to go in one file and next till 50th M records in to second file ,and next till 50th M records in to third file and so on ... till end of file
50 th is...

my output is

if file is having 1 lakh records
in 12 k M records and 88k D records (M master ,D detail)
i want split filetill 5000 Mth record along with D records needs to be place one file...

Hi Frank.

Thank for responding

i have tried with below code
awk 's=index($0,"M") { print "line=" NR, "start position=" s}' <file name >
awk 's=index($0,"M") { print "line=" NR}' <file...

Hi

i have requirement like below
M <form_name> sdasadasdMklkM
D ......
D .....
M form_name> sdasadasdMklkM
D ......
D .....
D ......
D .....
M form_name> ...