Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. r9ronaldo

    -- Error Connecting to a Teradata Database --

    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...
  2. r9ronaldo

    -- A question regarding Mount Points in UNIX --

    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...
  3. r9ronaldo

    Need some advice on ftp script from NT server to UNIX machine

    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
  4. r9ronaldo

    Need some advice on ftp script from NT server to UNIX machine

    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...
  5. r9ronaldo

    -- to get only records with characters

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

    -- to get only records with characters

    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...
  7. r9ronaldo

    -- Need some help in generalizing the script --

    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...
  8. r9ronaldo

    -- Need some help in generalizing the script --

    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...
  9. r9ronaldo

    Coverting TimeStamp to '%Y%m%d %H%M'

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

    -- Need some serious help regarding FTP script --

    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'...
  11. r9ronaldo

    -- Need some serious help regarding FTP script --

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

    -- Need some serious help regarding FTP script --

    I have defined the Variables in the script Thank You R9ronaldo
  13. r9ronaldo

    -- Need some serious help regarding FTP script --

    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...
  14. r9ronaldo

    how read and change columns in .xls

    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...
  15. r9ronaldo

    -- Need some serious help regarding FTP script --

    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...
  16. r9ronaldo

    Help in Perl script for converting excel sheet data into a delimited f

    Hi All, I am a novice to Perl Programming. I would greatly appreciate if somebody can just lead me some way on How I could handle this problem. As of Now I recieve Excel sheet data which is updated monthly. I need to automate the process of extracting the data in Excel sheets and placing...
  17. r9ronaldo

    -- to use grep to find a pattern --

    Hi, I have a situation where I have to grep for the Pattern, and notjust one keyword or one line. Anyway I can do that, Your help is appreciated, Thanks
  18. r9ronaldo

    -- Truncate Table --

    Hi All, This maybe a Basic Question. I am using WINSQL as a client to query a Redbrcik Database. Somehow when I use the following command. truncate table A it gives me a syntax error I was able to do it with comman delete from A I just want to know what is the problem with the syntax...
  19. r9ronaldo

    -- Need to FTP from Unix

    Thanks a lot all of you, Cheers and warm regards R9ron
  20. r9ronaldo

    -- Need to FTP from Unix

    Thankyou Laurie, It helped, I was able to make a connection and transfer the file, but there is a problem. it says 200 PORT command successful. 150 ASCII data connection for salesfees.dat (192.44.33.567,3921) (499 bytes) 226 ASCII Transfer complete. ftp: 506 bytes received in 0.00Seconds...

Part and Inventory Search

Back
Top