Search results for query: *

Does anyone know what the following error means - sorry not used BO for a while and we have upgraded recently to xi. I keep getting the following error(fetching data error) and was wondering if anyone know what this means:- Query 1; universname; no data fetched. My query was working perfectly...

Hi All, Can anyone help with the following. In a directory I have the following:- -rw-rw-rw- 1 root other 17077 May 1 15:23 1790 -rw-rw-rw- 1 root other 31651 May 1 11:31 1789 -rw-rw-rw- 1 root other 17372 Apr 30 15:25 1788 -rw-rw-rw- 1 root other...

Hi All, Can anyone help I am pain stakingly trying to go through a file and in vi trying to join to line together. But the file is rather large there must be an easier way to do this. e.g file :- 2226697 29/01/08 2226697 "630511" "0P0705011" 1.00 2226698 29/01/08 2226698 "630571"...

Does anyone use the universes provided by Orchard housing management systems. I am trying to obtain information by designing our own universe unfortunatly we do not have a data dictionary with table names and field names so its difficult to do. Their data dictionaries definitions are not...

Hi All, Does anyone know the best way to do the following if its at all possible using awk or sed. I have a file that contains 3 fields per transaction e.g. Field1,Field2,Field3 I want to recreate the file so that Field1 starts at potion 1 on the line, field2 starts at character position 42...

Hi all, Can anyone help. I have a set of files held in a directory some of the files are empty. What I want to do is generate a list from that directory excluding the empty files. Any clues how I can achieve this please. Thanks in advance for your help.

Hi All Happy new year to you all. Hope your Xmas was good too. I have a question, in my existing script I carry out the following:- if test ... then do whatever I want fi else send an email to notify users of the problem end This script runs in cron every 10 minutes. When the script runs...

I have used the mailx command to send mail to users within our organisation. It looks like mailx can not be used to send mail to receipients outside of our organisation. Does any one know a way of sending mail to an external email. mail from {sun email} mail to {external email outside of the...

does anyone know what this error mean, not being an operations person I don't know. I was able to connect using sftp to an external file server. But all of a sudden I am getting the following error. Anyone know if this is a firewall issue at the external file server end. Connecting to...

I have carried out a simple task in my script to email me as below:- mailx -s "Message" emailaddress When I type this in at the prompt or within a script the system is expecting a ctl-d before it gets sent. Anyone know of a way around this. I am using bash/ksh and on solaris 10. any help...

Hi, I would very much appreciate your help in this. I need to write a condition around the whole of my scripts. In that I need to check if a directory is empty before the script kicks off and does it business. The script is run in cron. e.g. if the directory a is empty I want the rest of...

Can anyone help in a directory I have a list of files. import directory abc.txt def.txt ghf.txt transfer directory contains. abc1.txt abc2.txt def1.txt def2.txt etc.. Whats the best way to check that the import directory doesn't already have this file. If it does I want to save it into the...

There are some files on a web site which I need to retreive but as I am retrieving these files I assume using 'get' as soon as I have got this file I want to rename the file. The idea is:- sftp onto server cd into directory get files rename files exit sftp I will be very grateful for any...

I have a list of files with a file structure as below:- 07(year)+11(month)+19(day of the month)+24(hour)+10(minutes)+55(seconds)+afilenameanylength.txt I need to rename the file so I get rid of the 07(year)+11(month)+19(day of the month)+24(hour)+10(minutes)+55(seconds) and rename it to...

Hi I am on solaris v10 using bash as well. I have generated a script that transfers files using sftp but I some how need to know that all the files have transferred i.e. transfer has completed successfully. The last file that will get sent will be EOF{todaysdate)(followedbythenumber of files...

Hi, I have 2 files:- File A contains a list of numbers but the 1st 7chrs is a unique. File B contains duplicate sequence number (1st 7chrs) Any ideas on how I can count how many duplicates in file B. I suspect I will have to use subscript or substring it but not sure what to use awk/sed or...

Hi Can anyone help please; I have created a simple script which transfers some files into another directory. I need to put a whole loop around the main body. Basically.. There will be a file which will hold a number of records. e.g. number = 127 At the end of the script I need to reset...

Can anyone help. When I run this error:- (Openlink)(ODBC)(Progress Server) Table XXXXX does not exist or cannot be accessed (962)962 Hope someone can help, I am fairly new to BO Reporting. Cheers in advance

Hi, Has anyone sent an attachement against an email from Unix to Groupwise. If so how have you done this. I don't want to cat the contents of the file within the email. Its needs tobe a file. Hope someone can help.

Does anyone know if there is a drive available on this operating system for an HP Laserjet 4300DTN Duplex Printer or is it something I need to do. Not sure. I have set the printer up as a HP Laserjet 4000 series which is the closes I can get on our system. Hope someone can help and if you can...