Recent content by r9ronaldo

Hi there, I have a very basic problem, I have a Teradata Database to which I connect and select the inofrmation I need, I was trying to use MS Access to connect to the database and link the tables, I am getting this crypted error Reserved error <Item>; there is no message for this error...

Hi, Is it possible to do the following on a UNIX server. Can we point a particular directory (e.g $HOME/incoming_data/) in UNIX file system so that points to a particular directory ( e.g Z:/documents/outgoing_data ) on a SHARED windows server. The crux of this is , say there has been a new...

Thanks for your Answer, How do I know on which port they are running the ftp on ?, I am not that familiar with this process, Can you please shed some light on the ftp process using port numbers Thank you R9

Hi There, I have a functional UNIX script that handles the ftp of files between two UNIX servers, Now I want to change it a bit so that It can handle FTP from a NT server into a UNIX Server, This script should run on the UNIX server, so when I do ftp xx.xx.xxx.xx ( ip address of the NT...

Thank You Santa Mufasa That Helped a lot Thank you Once again R9

Hi All, This might be pretty basic, Say like I have a field type VARCHAR(10), Couple of records were just numbers and some records have Characters in them, How I can write a simple query to get only those records which have characters in them ( Not the ones with pure numbers ) Thank You all...

Thanks a Lot Salem && Cakiwi, I tried both of your approaches, Initially Both seem to work, I was just trying test it out completely, Please don't think other wise, However when I tried to work on another test csv file, I got wrong set of results for Salem's Code, Name,Age,Location,Phone^M...

All, I have an issue, Any input from your experience is highly regarded. I have a .csv file ( in which some data inside the fields is also seperated by a comma ), I need to get a pipedelimited falt file, So If I am doing a , It's substituting all comma "," with a delimter "|" BEGIN{} { if(NR...

Try This date +%Y/%m/%d"/"%H:%M:%S Thanks and goodluck Rama

Hi all, Thanks for all your responses, Here is the script I used, #!/bin/ksh ################################## FTP_HOST='user.xyz.com' FTP_LOGIN='user' FTP_PASSWD='passwd' COMMAND='put' LOCAL_DIR='source/data' REMOTE_DIR='target/data' FTP_FUNCTION='/usr/bin/ftp'...

Thank You One and all, I got it to working. Thanks Again R9ronaldo Forza Inter Forza Neraazzuri

I have defined the Variables in the script Thank You R9ronaldo

Thank You all for your response, I did try what vgersh99 and Ali suggested, Unfortunately when I tried to run the script in the backgroud after making the changes suggested using nohup ftp.ksh 1>$HOME/log/ftp.log 2>&1 & It created a numerous sub processes being created for every second, I...

Having used Perl very Rarely, this may be a very elementary question. I have a Perl script which uses write_excel/parse_excel modules, when I try to run this script, It's not working, Other than that I was able to run other Simple Perl scripts successfully. Should I install any thing special...

As a part of my task I have to ftp a file from one unix server onto the another UNIX server, I was able to do it inte ractively, I jsut thought of coming up with a script, after some dragging the feet I wrote this script, But when I run this, it kind of just hangs up and does nothing, I...