Search results for query: *

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

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

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

Rather than use if ...then...fi, can ksh use the comparison short-cut that's used in C ? ( using ? and : ) I do a check on a count to roll from 1 to 99 - so can I do : cty=($cty < 99 ? cty++ : cty=1) echo $cty TIA Dickie Bird ((:-)))

Hi I have a Dell latitude originally with Windows NT4 sp5 I have just upgraded to Windows 2000 professional and now the only sound I ever hear is my modem noise when connecting At each login I get a window with something like 'Audio ( and a speaker icon ) - Searching for Device Driver' - which...

Hi guys We receive s.w.i.f.t files daily, contents are like :- {1:F01FRED3322AXXX7279625440}{2:O8011651031208RNNSZAJJAXXX29021728160312081451N}{4: :20:5998RBRB00064AUD :28:00064/01 :51C:/405605 :23:F188-148011 :30:031205 :26A:AF4419070/9075 :26A:ZD8193201/3222 :33B:AUD2500, :34B:AUD2500, :16A:1...

Hi Guys, Just need to know if I can redirect output/errors after I've already started a job ( either in foreground or background) Any thoughts ?? TIA Dickie Bird ((:-)))

Guys.... I'm guilty of cross-posting, but I don't think I was in the right forum earlier. I'm new to this forum - so if its been asked before - I didn't know ( and couldn't find it) We run a MSAccess2 process on Windows 2000, which refers to Sybase tables for a report via a form. Unfortunately...

Guys.... I'm to this forum - so if its been asked before - I didn't know ( and couldn't find it) We run a MSAccess2 process on Windows 2000, which refers to Sybase tables for a report via a form. Unfortunately, we have non-Engish characters on the table (addresses) which ODBC can't interpret...

Can anyone show me how to use defncopy I want to extract the text of all my stored procedures, in a loop in a script. Here's a sample of just trying to get the text from one sp defncopy -Usduser -Psdpass out audit.sp_groupccy.P.ddl audit So there's my 'out filename' and the database name...

Hi I have obtained and installed SQL Server 7 on windows 95. Now what ? All I want to do is examine,explore and generally get to grips with the sample database (northwind ?) I can run Enterprise Manager, Client Network, Profiler all OK, but BOL doesn't give a step-by-step guide to starting up...

Hi I'm attempting to extract data from a table and can't get my head around datediff or datepart. If date is less than 1 Jan 2004, I don't want the value of the column. How do I code the below psuedo-code correctly ? case RunDate when < &quot;1 Jan 2004&quot; then 0 else CurrYrCGCSalesYTD Thanks...

This is not going to plan - guess my brain died! I have a sorted flat file, a sample of which :- JOBURG,10072003,FG8,19,0,500,1,32000 JOBURG,10072003,FG9,10,0,50,1,2000 JOBURG,10072003,FG9,10,0,100,1,4000 JOBURG,10072003,FG9,11,0,100,1,6510 JOBURG,10072003,FG9,11,0,100,5,100...

I can't get my head round this one : I have several files on a remote server to rename daily. files are in format cm99ddmmyy.tx and I want to rename them cm99ddmmyy (ie drop the tx) rsh remserv1 mv /data/dfy/cm99*.tx /data/dfy/cm99?????? > /dev/null 2>&1 It'll be basename, I guess, but how ...

An engineer called 5 days ago to service our RS6000 Aix 4.3.3 server, since when rsh doesn't work anymore ( we only use root to rsh). We can still ping, rlogin and rcp perfectly well. The set-up of /.rhosts and /etc/hosts.equiv has not been changed in any way. Anyone any thoughts ? TIA Dickie...

Hi Guys I want to pass the pointer of a struct item, to a function : Which do I use ( and why, if you've time to explain) ? 1. format_group_code(&rec->agent_group); 2. format_group_code(&rec.agent_group); 3. format_group_code(rec->agent_group); typedef struct { char...

As root user, can I see what users' passwords are currently set to ? TIA Dickie Bird ((:-)))

I can move around all our remote IBM6000's running AIX4.3.3 with rlogin as root to those sites, but I can't rsh or rcp to rmach2 box. I can rcp or rsh to/from all the others and I can rsh or rcp from rmach2 OK. /.rhosts on all machines are identical, naming each machine with root user ie...

I've been lumbered with fixing an Access 2 application that utilises DDE to obtain info from our mainframe via Rumba. As a Unix/C type - I'm struggling to discover how 'screen-scaping' works - Anyone any good source of information ( other than the help on Access 2 - haha) T.I.A Dickie Bird ((:-)))