Recent content by spiff2002

Hi I am having the same issue. is it possible to explain how you solved this problem? We have a canon ImageRunner iR3245 and Exchange 2007. The options dor LDAP on the canon are: Server Name : Server Address : Location to Start Search : Use SSL (this is a checkbox) Port Number ...

We are running a i5 series V4 IBM server and we use SAP as our ERP. The SAP program generates some text files that are saved on some specific folder. The remote client FTP's to our server and grabs the file but they are having security issues where they cannot grab the file. I check permissions...

Than you for the ideas Hoinz I'm looking into th epossibilities. And yes the files are being transfered via FTP ascii mode.

We are in the middle of a new SAp implementation. I never worked on SAP nor AS400. We are finishing one of the third vendor interfaces that requires importing a fixed size text file into SAP. The file is created in a unix system ( that is all I know about the remote system). I can open the text...

It worked out perfect. Yes it is usually the two digit format for the vintage. Thanks a lot Frank

is there a function to find numbers in a string? Varchar type or any kind of stirng type? We have a large item master table for wines. In the original design, the vintage was included in the description. I am trying to create a second column with the vintage. I already know that this won't work...

sorry my bad it is a varchar field not a text field. I used ptheriault code and it worked like a charm thank you all.

I need to write a query that will split a text field after the first space found, i.e: if the contents of the text field is 'red small car 4 door' the query will return 'small car 4 door' thanks in adavance for any help

We get a file on a daily, weekly basis. I need to import that file into our MS SQL server 2000 database. The file that comes in has a period column which (for instance: '2005-02') The file has sales for the same period only so all items in that column will be the same. I need to read the file...

Our Exchange server went down (EX 2k Standard SP3) due to a hard drive failure on our RAID. Windows never went down but it seems like Exchange was trying to commit a log file to tha database when the disk failed. We recovered the database sucessfully using the eseutil command with diffrent...

This may be an easy one I have a price table with different dates. The prices apply according to the current date. The table is mor eor less like this: price item_no effective_date end_date region price 1 12/01/1992 null NY 120 1...

Thank you all. The isnull function did it.

Let's say I have to small tables customer id name 1 cust1 2 cust2 3 cust3 4 cust4 Sales inv# custid date sale 1 1 2004-12-03 $203.56 2 1 2004-12-04 $405.67 3 2 2004-12-04 $304.68 4 3...

Is there a way to run a DTS package from a stored procedure? The idea is to trigger a package from an ASP webpage. The Package cannot be shcedule because it has to be run by a user that needs to finish some tasks befero he can run the package. If there is a way can you post the code to create...

Our company just finished the purchase of a small company and we will start the process of merging the two databases. The small company is using AS400 (I'm have no info of equipment nor OS version). I'm just going ahead of the game doing research. We have a Alpha DS10 running open VMS 7.3. We...