Recent content by taylor5pak

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

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

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

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

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

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

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

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

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

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)}...

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

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)}...

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

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

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