Search results for query: *

Hi All, Is it possible to assign FTP hostname & portnumber in one parameter? To the current script we have the values are passed via csv file(comma seperated values). This csv file consists of multiple FTP host records and all hosts got default port number. Now for one of our server there is a...

Hi, I need to compare value1= '2010-06-03 22:29:42:109615'(this in character) and to a timestamp field value2='16-JUL-10 04.42.44.296985000 PM' in a SQL. Table value format is: 16-JUL-10 04.42.44.296985000 PM' Value compared format is:'2010-08-03 22:29:42:109615' I need to display values...

Good Morning All, I have a scenario where I have to get the total count of the days. Data in the table: col1 col2 col3 101 12/12/06 A 101 02/15/07 H 101 03/10/07 B 101 04/18/07 C 101 05/27/07 H 101...

Hi All, I have a script which takes multiple files from a UNIX server and renames them and put to a Unix folder. Below is the script: SrcDir=$1 cd $SrcDir ls *_*.txt | nawk ' {x=$0;sub(/_.*\.txt$/,".txt",x); printf "cp %s /ap/test/cat/%s\n",$0,x} ' |sh -v I am successfully moving all the...

Good Morning All, I have to write a script to concatenate multiple files to a single and move the file to other folder. We mayget a single file or two files or more..it depends..I have to put them all file to a single file and move to a new folder.All files will be in same structure(mean same...

Hi All I have to send an email if the count of the folder does nt match with what expected. #!/bin/ksh/ #Sends an email if the count of the files in a folder are less then expected SrcDir=$1 Count=$2 cd $SrcDir | ls -l | wc -l -ne $Count && mutt -s "The count of $SrcDir is not equal to...

Hi All, I want a list of files sent to a file with word count. Ex: Srcdirectory: File1.txt File2.txt File3.txt File4.txt File5.txt . .. I need a to build a file in this way Filename,Count File1.txt,2 File2.txt,78 File3.txt,100 File4.txt,90 File5.txt,78 And I want to overwrite this...

Hi All, I need to rename multiple files after copying them to a folder from other folder. I am getting files in this format.. test_20070513.txt, test1_20070513.txt,... I want to strip the _ & date and I want file names to be as test.txt, test1.txt,..... I am trying to do something...

Hi All... I am trying to execute below script to check the count of multiple files in the MAIN folder. And if the count is 2 then send an email with the file name. If there are two files with line count 2 then send 2 emails with respective filnames. I was given this code for my previous...

Good Morning all, I have a scenario where I need to handle 110 files. I have to get the count of lines of each file individually and need to send an email when the count of the file is 2. I want to do it in a single script. For Example: FILE1 has two lines then I need to send a mail saying...

Good Morning.. I have 100 files to be ftp from one serverA to two places(ServerB). I am getting files in this format "FILE_12/23/2006.txt", (files are getting with date in them). While moving the file to one folderA I have to rename the file by removing the date part and straight move to...

Hi All, I have a requirement where I need to generate multiple records for each record with addition of two columns. EXAMPLE: Input: COL1,COL2,COL3 SAM,VICTOR,09/08/2006 BEN,THOMAS,06/05/2006 JOHN,RHYS,08/07/2005 Output: COL1,COL2,COL3,COL4,COL5 SAM,VICTOR,09/08/2006,1,I.D...

Hi All, Unknowingly a file got deleted from the folder. I want to get it back. Is there a way to get back the deleted file. Thanks a lot, Kumari

Hi, I am getting following errors: [IBM][CLI Driver] [DB2/AIX 64] SQL0902C A system error (n reason code="13") occurred. Subsequent SQL statements cannot nbe processed. SQLSTATE=58005. [IBM][CLI Driver] CLI0112E Error in assignment SQLSTATE=22005 I am trying to update and insert columns(...

Hi, I need to get sequence of a value. I am new to teradata database.I want to know the exact command to get the sequence and the query.After doing a search in the google I felt I can use rank command, but not sure whether I can use it or not. Is there any online site or free documention...

Hi, Good Morning.. I have situation where I have leave the first line of text file and display from the second line.Here I have text file with column heading.I do not want column heading.So,I have to display it from the second line.And 1st line is of 1944 characters length(column names...

Hi All, I have to write a query for number of working days in a month.Is it possible to write a SQL with this condition. Thank you

Hi All, I like to retrieve data from db2 based on 4 columns which are keys..Something like this c1,C2,c3,C4 with distinct values of c4,c2. I am trying SELECT DISTINCT( C2,C4) ,C1,C2 FROM CRMADMIN.T_WHSE_PO_DTL Group by C1,C2,C3,C4 ; I am not able to run it .. Any help is great Thank you

Hi All.. Good morning...I like know to how can I find out rows based on a condition. I have something like this: My file is of 2Gb size..I need to check data with this file based on the certain columns.This is a comma separated file..I want to get the complete row when there is match and also...

Hi All,.. I am getting a file which is created in Excel and converted .csv. The permission given to this .csv are shown like this -rw-r----- . I am doing a ftp'ing.This file is transfered through datastage to other server.Where i am using this script to FTP:(a part in the script where chmod is...