Search Results

Hi Please find the details below:

My DDL structure file will be like this:

CREATE MULTISET TABLE LMS_STG.tbl1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM =...

Hi,

got the Table Structure in a file. Working on creating the control file. Any i/p will be highly appreciated.

Thanks.

Hi Akshay,

I was trying to export the table structure in a file using fastexport but that requires select statement only. Right now the problem is getting the table structure, I am writing a perl...

Hi Team,

I need to create a control file with a pre-defined structure for a given table name. The table is in teradata.
Ex: Table Name: TBL1
Table structure:
create multiset table tbl1, no...

Hi All,

I am creating a text file using perl. The first record I am writing as "$line" and all the other as "\n$line". At the end the file is having N number of lines. I am using this file for...

I am using the below script:
echo "body"| mailx -s 'subject' -c unankix@gmail.com (unankix@gmail.com)

Hi All,

I am using mailx to send the mail. Due to some changes in the requirement, I need to send the mail to CC only (an Email id in CC), with no email ID in "TO" field. Can we do that? bcz I...

Hi All,

I need to send mail with attachment. I am using uuencode but it seems it is sending encoded file. I am getting the mail with attachment but there is no data even the file size is almost...

How should I join this code(jawsnnn's code) with this one..
ls -1rt /work/scripts/Ankit/scripts | while IFS= read -r item; do [[ -f $item ]] && { awk 1 $item; $(stat -c %y $item); } >>...

There is no stat in /bin /usr/bin /etc /sbin /usr/sbin /usr/ucb /usr/local/bin /usr/local/sbin /opt/universal/bin ..
:-(
is there any other way???
Thanks

---------- Post updated at 03:22 PM...

Hi,
even for .txt files i am getting error that Stat not found :-( (its not missing the folder name)

---------- Post updated at 01:28 PM ---------- Previous update was at 01:21 PM ----------
...

ok..I should have explained the scenario at the very beginning itself.
Different users can put some information in pre-defined format (180 bytes) in a file which may end in .dat or .trg or .txt. We...

ohh..is it for .txt only??can't we do it for any kind of extension?(.dat,.trg etc)..and what about the new line :-(

Hi Lem,

i am getting error that "stat: not found." for all the files in the folder.
The first line of all the files are not starting from the new line as well.

Thanks a lot guys..but frankly speaking I did not get what will be the right code to use :-(..I am new to UNIX and this is part of my first assignment in UNIX..and please let me know how to append...

Thanks all for reply..I need to append the timestamp of the file at the end of each record as well...I am new to UNIX,so please provide the code.Thanks for the help..

Hi All,

I have to merge the data in all the files in a folder such that the data of the earliest file come first then the second file's data and so on. Please help.

Thanks.

Thanks a lot for the help. Yes the increment was for moving the file name to new one. I was not able to decrease the count. Thanks again to both of you.

Thanks a lot. But it seems we are not reducing the value of the CNT in this logic.How will we do that?

Hi,
I am new to UNIX and have an issue.
I need to check that whether a perticular file name exists or not. I wan to do that in loop to avoid number of IF statements.
I need to check that
if...

Hi Spacebar,
Thanks for the reply. I am trying to do the same thing (but not ran the query you have mentioned in your answer).
I am casting all the columns with their original length and then...

Hi All,

I am trying to export a file using Fast Export (Teradata) in UNIX. The desired output length is 550 bytes, but the output file is creating string till 75 characters. How to get the full...

Hi All,


Any help to sort the files in a folder depending upon first 15 characters of their name will be highlt appriciated. I need it urgently.
File name: PNN_NN_YYYYMMDD_YYYYJLN_XX.txt
All...

Thanks for the replies.
My code:
my @files=sort -k1,15 (grep{/^[^.]/} readdir(DIR));
is not working.
In this I am trying to sort the files in a folder depending upon the first 15 characters of...

Yes, The timestamp is not the part of the file name.it is the system timestamp when file landed to that folder.