Search Results

File 1
---------
N_ACCT,CARD_TYPE,CARD_BAL,CUST_CODE
---------------------------------------------------
0301,38,0.00,10
0319,38,54422.92,10
0392,38,0.00,10
0418,38,35254.87,10...

Thanks for your input. Could you plz share some example.
However, I used the procedure script alone it was successful. Please see the details below.

/pd/SG/uat/EBBS> db2 connect to DPHK0 user...

Hi All,
As per my biz requirement, I need to drop the partition from our PROD table based on the retention period.

Hence I have written the script and called the drop partition procedure within...

Thanks Scrutinizer. Have got the expected result. Thanks again for resolve the issue.

this is my input
C1|C2|C3|C4|C5|C6|C7|C8|C9|C10|C11
-------------------------------------------
1|0123452|C501|Z|Z|Z|E|E|E|E|E|E|E
1|0156123|C501|X|X|X|E|E|E|E|E|E|E...

Apologies!it was typo error.

Hi All,

let's say an input looks like:

C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11
----------------------------------
1|0123452|C501|Z|Z|Z|E|E|E|E|E|E|E
1|0156123|C501|X|X|X|E|E|E|E|E|E|E...

Have tried like you said. But it did not return any matching value.

awk -F, 'FNR==NR{m[$1]; next} $2 in m{print $2,$3}' OFS=, /tmp/Data_MisMatch.txt /Prd/HK/ACCTCARD_20160115.txt

Could you...

Thanks for your reply. Have two source files and both are from different directories. Please find the file format below.



File1: Data_MisMatch.txt Directory:/tmp

Customer No:...

[Hi All,
I am new to Unix and trying to find matched records between two files and from different directories. Finally want to store the output in excel file. I have tried the query like below. But...

Hi All,

Everyday we will receive 33 files in our source directory(/prd/pk) with the current date. Once our jobs are completed all the 33 files immediately will be moved to backup folder...

Thanks to all. My problem resolved. Thanks to you all once again for your timely help :)

Hi All,

One of my source file is having Date column and the format of the column is YYYY-MM-DD. As per my business logic I have to check if the date format either YYY-MM-DD or YYYY-M-DD. If any...

Hi,

I need to extract the first character of second column of my file. If the condition matches, then I need to print the 2nd and 3rd column as my output

I tried below mentioned query but it...

Thanks Anbu for your kind reply :)

Hi All,

One of my source file column name RelationshipNumber. I need to filter below mentioned records in RelationshipNumber column.

RelationshipNumber:
S45678
D89763
Y09246579
A91234
...

Thanks Srini for your reply. I will check tomorrow and update the status:)

Hi All,

Need to compare two date columns from the filname FinalDate.txt. My data's are like below


D_OT_START D_EXP_STR Amount
1/3/2012 1/3/2012 5000
6/21/2011 6/25/2011 6000...

Hi All,

One of my source file is having more than 100 columns. Now, I need to check the particular string in 75th,76th and 79th columns of the source file.

If I find the particular string in...

Thanks Yoda! for your help at the right time.

I got my expected result.

Thanks once again :)

Thanks for your reply.

I have tried like below. But I did not get any result.

awk -F' ' $4='^5' file.txt

Please guide me how to handle this issue

Hi Experts,

I am new to UNIX. One of my file records are like below

220 IN C/A 515013 NULL NULL
220 IN C/A 515017 NULL NULL
225 IN C/A 333701 NULL NULL
225 IN C/A 515034 NULL NULL
225 IN...

Really thanks to everyone for your right time help

Hi All,

How to fetch the particular row based on my search command. For example

Source Column

Column A Column B

001,56123456
002,57123456
003,123456

Expected Output:
...

Hi all,

I am new for linux environment, and i am working as a DBA.

I am facing some issues in OS level:

In our dev boxes /db2home under this directory i'm not finding any folder but it's...