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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by taylor5pak

  1. taylor5pak

    Character Set Collation Question

    Hello Catadmin, Thank you for the response. No specific concerns.. This question was sent to us by our vendor. I think they are just asking at a high level to evaluate what responses would be if they were to say this.. All of the data for this application is stored in SQL Server 2000. The...
  2. taylor5pak

    Collation HELP

    Hello, I have received this question and was wondering what other DBA responses would be ... Our export application which is on SQL Server 2000 currently, on its own server is currently supporting both Western European as well as UTF-8 character sets. What would your reaction be if they were...
  3. taylor5pak

    Character Set Collation Question

    Hello, I have received this question and was wondering what other DBA responses would be ... Our export application which is on SQL Server 2000 currently, on its own server is currently supporting both Western European as well as UTF-8 character sets. What would your reaction be if they were...
  4. taylor5pak

    Import from Foxpro 2.6 to SQL2000

    Hello Arles, Please forgive me, but I am in this circumstance right now. I am exactly where you are but I need the data in a table within SQL for later use by another group for a web page link.. You create the view in Foxpro or SQL? Please explain further.. Thank you very much! Donna
  5. taylor5pak

    AWK and SQL DB Informix Lookup

    Hi PH Please excuse the quick answers.. My appologies to you as you still are the man (my appologies I do not know if you are male or female), and I am just plain old rude.. I was being hounded to get an answer to my problem asap and was very angered by it... I know this is feasible but...
  6. taylor5pak

    AWK and SQL DB Informix Lookup

    Please diregard we have decided not to go this route... But for future reference, I gave you the details.. All I needed was where to place the call to dbaccess.. It is very time consuming to write the details... awk ' if ($1 == value) call to db to verify evaluate value if is...
  7. taylor5pak

    AWK and SQL DB Informix Lookup

    Hello, is it possible to do a database lookup within an awk script to verify a value exist and then if so insert values from the record being read into the database? Ex. I have a huge file and in it contains an invoice data, first I want to see if the invoice already exists in the database, if...
  8. taylor5pak

    Multiple File with Lookup - Help

    Hello PH That worked ..... YOU ARE THE MAN !!! CYBER DRINK ON ME !!!!! Thank you soo much .... Donna
  9. taylor5pak

    Multiple File with Lookup - Help

    Hi, sorry when I say at the end the remainder of the file, I mean from byte 81, on the rest of input2... It should be looping thru input2 replacing the itm number where necessary and outputting the exact input2 file with the new itm number where required... I hope this helps.. Donna
  10. taylor5pak

    Multiple File with Lookup - Help

    Hello, First off thank you very much for responding... I have tried this and again not good.. I reran your first suggestion thru with a slight modification and have been able to replace the item field, awk ' {s=substr($0,62,18)} FILENAME==ARGV[1]{x[substr($0,24,18)]=substr($0,5,18)}...
  11. taylor5pak

    Multiple File with Lookup - Help

    Hello, I did try this and it does it on every line... What I have is this.. I have a huge file coming in where the item number is at byte (62,18) and I need to cross reference/match up this field with a field from another file where the field is at (23,18) and pull out bytes (5,18) from this...
  12. taylor5pak

    Multiple File with Lookup - Help

    Hi all, I am hoping someone can help me... I have to compare two files and where I have a match on file 1 field x and file 2 field x, I need to pull a value from file 1 (field w).. Here is a sample: for example purposes awk ' FILENAME = ARGV[1] {x[substr($0,23,18) = substr($0,62,18)}...
  13. taylor5pak

    Shared Files on Win 2000 Server

    I am sorry Dave by one more clarification, does this handle process occur with the database files as well? Is this just a handle for the database file or is the database actually open on the server? Sorry Dave and Thank you again! Donna
  14. taylor5pak

    Shared Files on Win 2000 Server

    Thank you very much Dave, that is exactly what I thought and was looking for.. Now I can pass this on to operations. Have a wonderful day! Donna
  15. taylor5pak

    Shared Files on Win 2000 Server

    Thank you for your response Dave, but I am still not sure. Let me explain a bit further: We have a Foxpro 2.6a Windows application residing on a Windows 2000 server which has a shared folder for the clients to map to. The app and db are on the server with a shared network folder created for...
See more

Part and Inventory Search

Back
Top