Search results for query: *

Jean-Pierre's solution is fine - I replaced 2>&1 with 2>/dev/null and I must check for 8 files only. Thanks anyway Ygor. Dickie Bird ((:-)))

Yeah - It seems that ksh doesn't want to expand filenames within [[ ]] I used your ls -1 suggestion - thanks, J-P Dickie Bird ((:-)))

...This snippet fails with "Doh" - any ideas why ? Or is there a better way to see if the 8 files exist ? if [[ -a RTSSite* && -a RTSCountr* && -a RTSBuyb* && -a RTSLoyaltyCardT* && -a RTSLoyaltyCardP* && -a RTSLoyaltyCardS* && -a...

Hi Lou I don't believe that Sybase Central is clever enough. Choice 1 - use Embarcadero products instead. Choice 2 - Edit the DDL. If on *nix then use sed to clear all lines with 'go', 'create', 'alter', 'print' etc HTH Dickie Bird ((:-)))

What O/S is this on ? If unix, then you could call a procedure from a script eg : isql -U${DBUSER} -P${DBPASS} -S${SRV}<<-EOF > /tmp/lc_rts1 select * from RTSSchemeTable go EOF and file /tmp/lc_rts1 will have the output in it. HTH Dickie Bird ((:-)))

Use " (double-quote) :- sed "s/,/'/3" file.csv HTH Dickie Bird ((:-)))

Hmmmmm.. Depends what you want You could run something from the cron every 10 mins or so 0,10,20,30,40,50 **** date;w|wc -l >>/tmp/file which would give you : Fri Feb 13 15:21:08 GMT 2004 13 that is - that time and number of users logged on HTH Dickie Bird ((:-)))

I need to know how to do that, too ! Dickie Bird ((:-)))

yes - the transaction numbers are all the same - point proved, thanks. Any ideas ? Dickie Bird ((:-)))

Ha-Ha - I'd worry too - but it's single-user processing of incoming flat files onto a database that is only activated once a day long after the above is run in ! Have I got to use a cursor ? Dickie Bird ((:-)))

Hello again Another problem's occurred - that perhaps you can help with Those 5 rows are now found OK - thanks, but I want to insert new rows based on those found rows. I am trying to increment TransactionID as below - but it returns : " Attempt to insert duplicate key row in object...

Hi Rudy ( or anyone else that's got an idea ) Another problem's occurred - that perhaps you can help with Those 5 rows are now found OK - thanks, but I want to insert new rows based on those found rows. I am trying to increment TransactionID as below - but it returns 'Duplicate row error' (I...

Of Course - how silly of me ! Thanks Rudy - Have a star ! Dickie Bird ((:-)))

...rows, of varying Trandate for the same 5 test cardnumbers I need to find the earliest Trandate row on Transactions for each cardnumber. select * from Transactions lct, MemberPromotion ba where ba.CardNumber = lct.CardNumber and ba.PointsAwarded =0 and...

Thanks guys I see your point re: ps -ef or ps aux - about column content and position etc - this won't be an issue for the 3 or 4 scripts I've been asked to create. Thanks again Dickie Bird ((:-)))

Hi I have scripted (ksh) under AIX and HP-UX. The differnces are minimal - but what of Solaris ? Does Solaris have ksh - is there much difference ? Any thought/opinions are welcome TIA Dickie Bird ((:-)))

Try this : sed -e 's/^,//' -e 's/,$//' orig_file > new_file Dickie Bird ((:-)))

To remove empty lines : sed '/^$/d' filename > newfilename To remove line(s) with just a space : sed '/^ /d' filename > newfilename Dickie Bird ((:-)))

alter table tblCommunity add your_col_name your_col_type Dickie Bird ((:-)))

Passwords may not be unique - but username should be so : ...=(select nsc_users.record_id from nsc_users where nsc_users.password = nsc_community.password and nsc_users.username = nsc_community.username) Dickie Bird ((:-)))