Recent content by dickiebird

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 ((:-)))

Hi Mental breakdown morning ! I'm trying to test for the presence of 8 files minimum in current directory, with names of : RTSBuybacks.0402260909 RTSCountries.0402260909 RTSLoyaltyCardPointBandHistory.0402260909 RTSLoyaltyCardScheme.0402260909...

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 ((:-)))

Hi I'm working in Sybase 12.0 I have two tables, MemberPromotion has 5 test cardnumbers. Transactions has several 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...

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 ((:-)))