Recent content by CALYAN

select to_char(plp_chg_timestamp, '%d %m %R') from <table name> what i have to do to get seconds in my query? fyi plp_chg_timestamp datatype : datetime year to fraction(3) regards s.kalyan

thanks works fine

Hi i am not able to remove the files like this which is created accidentaly. rm electsum(ti_nptotal),.sql h: syntax error: `(' unexpected h: syntax error: `(' unexpected regards calyan

Is there any function available in Informix for converting numeric to char and char to numeric? regards s.kalyan

thanks to all there is another way i found :g/../s/type tab/|/g by substituing it also works fine regards scalyan

EU The European Union GBP N I want to insert a pipe symbol between the columns irrespective of the colum bumber. how to do it with awk? regards s.calyan

ABE, ABI, ABQ, ACT, ALB, AMA, ANC, ARB, ATL, ATW, AUS, AVL, AVP, AYE, BBX,BDL, BFL,BHM,BIL,BIS,BLV,BMI,BNA, BOI, BOS, BPT, BTR, BTV, BUF, BWI, BZN, CAE, CAK, CCR, CDW, CGX, CHA, CHS, CID, CLE, CLL, CLT, CXL, CMH, COS, CRP, CRW, CVG, CWA, CYS, DAY, DAB, DEN, DFW...

cat /gns/gnsadm/errrpt/gnserrs/reports/ggc1.rpt.$DD$MM | awk -F'|' 'BEGIN{ printf &quot; GTT DATA COMPARISION DAILY &quot; printf &quot;\n&quot; printf &quot; -------------------------- &quot...

I am having the report like this Reg code Cntry code Count -------- ---------- ------ AF AO 177 AF BF 56 AF BI 8 AF BJ 78 AF BW 282 AF...

How to consolidate the count? Reg code Cntry code Area code Count -------- ---------- --------- ------ AF AO CAB 15 AF AO LAD 20 AF BF OUA 23 AF BI BJM 11 AF BW GBE 72 AF CD FIH 30 AF CD MNB 8 I need the result like this Reg code cntry code Total AF AO 35 AF BF 23 AF BI 11 AF Bw 72...

The ';' can be omited : FILENAME=$(TZ=TZ+23 date +%b%d).gr print $FILENAME Jean Pierre. Thank aigles for this valuable post! Inappropriate post? If so, Red Flag it! Check out the FAQ area for this forum! CALYAN (Programmer) Jan 14, 2004 Hi it shows only current date...

Hi it shows only current date Jan14.gz I want to reduce one day from it. how to do?

I used this to extract somepart of the date FILENAME=$(date +%b%d) printf $FILENAME It generates output like this.? Jan13(example) But I need Jan13.gz how to add this? regards s.kalyan

how to reduce one day from this Jan013.gz ---> it should be Jan012.gz thanks

I used this to extract somepart of the date FILENAME=$(date +%b%d) printf $FILENAME It generates output like this.? Jan13(example) But I need Jan13.gz how to add this? regards s.kalyan