Search results for query: *

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

Hello, We have recently gone from Novell to Windows 2000 Server and have noticed many files being left open in the Computer Management - Shares - Files locations.. It looks like there are multiple files of the same file open for the same user and multiple users. I am not sure how this is...

I was wondering if anyone out there has had success with FPW2.6 win application on an EMC NAS Device? Any feedback at all would help.. We are evaluating the product... Thanks

Thanks so much for the info, I will try it as soon as we move the app to the new server... Will update within a week. Thanks again

I have one more question to ask of you regarding the rights situation and our lockups... We have ~30 users, who all were assigned new logins and rights to new shares... if they were give full access to a folder called folder (\\apps\folder) and access deny at the top level (\\apps) and have...

Sorry, one more question that kind of goes with this is the ability to access a network share as a mapped directory with a job that would launch thru the scheduler in the situation listed above. Ex. the job launches and requires access to k:\tech\tips\ ...