Search Results

I have got the answer, just used different delimiter.


echo /opt/fedex/acqulev1/abinitio/acqu/private_sand/legacy_acquisition/sql/DELETE/FCIS/delete_CS53_2.sql|sed 's|'$AI_SQL'||'

Dear Experts,

I have some directory structure something like follows. I would like to cut portion of it. Would you please help me? I have to run this on several sql's. The directory path is...

Thanks for looking into it. I have corrected it later. Its my bad. I will try myself and let you know.

I tried grep the lines for every phase but its becoming a complex program as I had different other phases as well.
I am using Linux and korn shell. Anytime 01182018 100009, 01182018 100010 works...

Dear Experts,

I need some help to get the time stamps from the Unix logs. Basically I am want to analyze which step is taking more time. Please give me some inputs. Thanks a lot for your help.
...

Here is the stty commands in my profile. I dont have any .kshrc file. Is this something needs to fixed by root level?

stty rows 40 cols 130 erase ^? intr ^C
export TERM=xterm
set -o vi
stty...

Thank you for correcting my post and responding. Thanks a ton.

I have .profile in my home directory. I kept the code you have given in it but still having the same result.

Should i remove rest...

We are getting a following stty error when I am running a script.


stty: standard input: Inappropriate ioctl for device

I have some of following stty settings in my .profile. Tried other...

Thanks for your reply, Rename is a ftp command. I already compared the versions, it seems fine. Would like to understand why it is behaving differently.

I have to ftp and rename the file with #finished# extension after successfully transfer. In some environments the command rename ABCD.dat ABCD.#finished# is working fine, but some environments its...

Linux XXXXX.prod.XXXX.com 2.6.18-194.11.4.el5 #1 SMP Fri Sep 17 04:57:05 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

Its Linux - I just want to find out the difference , something like (01212015 203238) - (01212015 201302) = 19(M):36(S).

I have a script which is printing date in below format while writing the logs.

theDate=`date +"%m%d%Y"`
theTime=`date +"%H%M%S"`
echo $theDate $theTime

How can i find out difference current...

I actually wanted to search "|FK|" in the file and take that position. Based on that position if any nulls are presented replace with "FK".

Now i found a way with above suggestion. I have kept...

I have 6 different pipe delimiter files. My loads failing due to missing company code.

File1: 31 st field is company code.

402660076310|2014-12-10...

Thank you for your reply. No its not working. I was able to get it using following command.

grep -P "[\x80-\xFF]" <file_name>

We have huge file with control A as delimiter. Somehow one record is corrupted. This time i figured it out using ETL graph. If future , how to print only bad record.

Example Correct record:...

Thank you Jim, i will check check sum with source and let you know how it goes.

Hi Guys,

We receive some huge files on to Linux server. Source system use FTP mechanism to transfer these files on our server. Occasionally one record is getting corrupted while transfer, some...

Dear All,

I have getting data as follows, the second field signifies table name and last one is time stamp. I have return always latest record based on time stamp. Could you please help me ?
...

Thank a lot Yoda. This worked like a charm.

Dear Experts,

I need your help here. I have lot of teradata DDL's as follows, i want to extract field names , field attributes and NOT NULL information from DDL.Could you please help here.
...

Dear All,
The row_eff_tmstp (4th field) and row_expr_tmstp(5th field) in below data represents. If row_expr_tmstp is less than row_eff_tmstp I should replace that as null. First record is header...

Thank you Rudi. Appriciate you help. It worked fine.

Hi Rudi,

Thank you for your quick response.

We have some data as CHAR(10) and CHAR(15) as well in the data. We can to change that also VARCHAR(10) and VARCHAR(15) respectively. Kindly...