Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dickiebird

  1. dickiebird

    test - if [[ .........]] failure

    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 ((:-)))
  2. dickiebird

    test - if [[ .........]] failure

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

    test - if [[ .........]] failure

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

    Generating DDL

    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 ((:-)))
  5. dickiebird

    Output to a file from sybase stored procedure ?

    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 ((:-)))
  6. dickiebird

    Using quotations in sed script

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

    Need Help with a KornShell script

    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 ((:-)))
  8. dickiebird

    Unique value independent of an IDENTITY column

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

    Insert problems for Rudy (or anyone else)

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

    Insert problems for Rudy (or anyone else)

    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 ((:-)))
  11. dickiebird

    Insert problems for Rudy (or anyone else)

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

    Select and min() problem

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

    Select and min() problem

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

    Select and min() problem

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

    AIX v Solaris

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

Part and Inventory Search

Back
Top