@@@@calling All Datastage Developers@@@@

[qwerty1204]

[quote name='Silver_mani' timestamp='1331693122' post='1301513695']


stage lo ekkada istam baa ... oka sample stage cheppava [img]http://i45.tinypic.com/ivaf6p.gif[/img]
[/quote]

stage properies loo..aa advances tab loo configuation file ani oka radio button untadi baa...maa danilo always disable chesi untadi..so never tries to use it

inka info kavali antee[img]http://i45.tinypic.com/ivaf6p.gif[/img]

[Silver_mani]

[quote name='arey ooo samba' timestamp='1331693436' post='1301513719']

stage properies loo..aa advances tab loo configuation file ani oka radio button untadi baa...maa danilo always disable chesi untadi..so never tries to use it

inka info kavali antee[img]http://i45.tinypic.com/ivaf6p.gif[/img]
[/quote]

adi chalu baa ... repu try chesi work out aithe chepta [img]http://i49.tinypic.com/25jzg1t.gif[/img]

[pandemkodi]

[quote name='Silver_mani' timestamp='1331692704' post='1301513663']
Mama inko doubt .... we can restrict a job to run on a single node ...Kani oka stage ni restrict cheyali ante ela??
Configuration file lo cheyyocha ?? ... ekkada vetikina correct ga evadu cheppaledu [img]http://i46.tinypic.com/98da8m.gif[/img]
[/quote]
manam job mottaniki change cheyyochu but i don't think we change for individual stage baa

[Silver_mani]

[quote name='pandemkodi' timestamp='1331696973' post='1301513820']
manam job mottaniki change cheyyochu but i don't think we change for individual stage baa
[/quote]


cheyyochu baa ... documentation lo chadiva

[pandemkodi]

[quote name='Silver_mani' timestamp='1331697135' post='1301513822']


cheyyochu baa ... documentation lo chadiva
[/quote]
avunaa my bad

maa vallu vnix script lu rayi antunnaru baa ikkademo naaku script mottam ichina ela execute cheyyalo telesu bokka

[Silver_mani]

[quote name='pandemkodi' timestamp='1331697235' post='1301513823']
avunaa my bad

maa vallu vnix script lu rayi antunnaru baa ikkademo naaku script mottam ichina ela execute cheyyalo telesu bokka
[/quote]


ninna nee post chusina baa ... reply iccha

[pandemkodi]

[quote name='Silver_mani' timestamp='1331697289' post='1301513825']


ninna nee post chusina baa ... reply iccha
[/quote]
choosa baa

but adi zip files baa just ila cheyyalem
first adi zip oo kaado choodali

tarava count nenu raasindi ista aagu


FILENAME=$1
PATHNAME=$2
echo "FILENAME = $FILENAME"
echo "PATHNAME = $PATHNAME"
#-----------------checking for zip files-------------#
if [ ${FILENAME} == *.z ];then
a=gzip -cd FILENAME|wc -l
echo Record COunt is $a
else
b=sed -n '$=' FILENAME
echo Record COunt is $b
fi
#------------Count for no of files------------------#
c=ls -ltr FILENAME.*|wc -l
echo count of files $c
d=date '+%Y%m%d%H%M'
echo Date $d
echo $a'-'$b-'$c-'$d

idi naaku telisina conditions baa
but denni script gaa ela malachalo teletla

[Silver_mani]

[quote name='pandemkodi' timestamp='1331697960' post='1301513838']
choosa baa

but adi zip files baa just ila cheyyalem
first adi zip oo kaado choodali

tarava count nenu raasindi ista aagu


FILENAME=$1
PATHNAME=$2
echo "FILENAME = $FILENAME"
echo "PATHNAME = $PATHNAME"
#-----------------checking for zip files-------------#
if [ ${FILENAME} == *.z ];then
a=gzip -cd FILENAME|wc -l
echo Record COunt is $a
else
b=sed -n '$=' FILENAME
echo Record COunt is $b
fi
#------------Count for no of files------------------#
c=ls -ltr FILENAME.*|wc -l
echo count of files $c
d=date '+%Y%m%d%H%M'
echo Date $d
echo $a'-'$b-'$c-'$d

idi naaku telisina conditions baa
but denni script gaa ela malachalo teletla
[/quote]




Script anta vundi kada baa akkaada .......oka doubt baa ... Zip files count chestunnavu kani danni Unzip cheyyava ? avasaram leda ?

[pandemkodi]

[quote name='Silver_mani' timestamp='1331698195' post='1301513844']




Script anta vundi kada baa akkaada .......oka doubt baa ... Zip files count chestunnavu kani danni Unzip cheyyava ? avasaram leda ?
[/quote]
maaku vachevi .z files baa

akkada gzip -cd filename|wc -l vundi gaa adey count chestadi baa

[Silver_mani]

[quote name='pandemkodi' timestamp='1331698312' post='1301513849']
maaku vachevi .z files baa

akkada gzip -cd filename|wc -l vundi gaa adey count chestadi baa
[/quote]


kk... Baa nuvvu tension padaku chala simple neeku already akkada sol vundi .. adi script lo pettali anthe ...


first ila start chey ..
#!/bin/bash
aa tarvata add 1 conditions at a time and run and see .. if all condition work .. then combine it a script

[pandemkodi]

[quote name='Silver_mani' timestamp='1331698542' post='1301513856']


kk... Baa nuvvu tension padaku chala simple neeku already akkada sol vundi .. adi script lo pettali anthe ...


first ila start chey ..
#!/bin/bash
aa tarvata add 1 conditions at a time and run and see .. if all condition work .. then combine it a script
[/quote]
idi baa mottam script


#!/bin/ksh
# usage : ./FIle_count.sh <DataStage Project Name> <filename> <pathname>
#Get parameters
FILENAME=$1
PATHNAME=$2
echo "FILENAME = $FILENAME"
echo "PATHNAME = $PATHNAME"
#-----------------checking for zip files-------------#
if [ ${FILENAME} == *.z ];then
a=gzip -cd FILENAME|wc -l
echo Record COunt is $a
else
b=sed -n '$=' FILENAME
echo Record COunt is $b
fi
#------------Count for no of files------------------#
c=ls -ltr FILENAME.*|wc -l
echo count of files $c
d=date '+%Y%m%d%H%M'
echo Date $d
echo $a'-'$b-'$c-'$d

[pandemkodi]

naakithey okati telusu baa
daanlo vunna stmts tho adi work avvudhi
but aa variables tokka passing lu naaku teliyav

[qwerty1204]

I have some data in a text file having 10 columns

by using sequential file stage..nenu data frm columns frm 4 to 8 matramee extract cheyachaa..

I mean instead of reading the entire 10 columns frm sequential file stage and later taking columns 4 to 8 frm a transformer stage...can I do it in the sequential file stage itself??

[pandemkodi]

cut -d "," -f4,5,6,7,8 filename---will give u only 4 5 6 7 8 columns

ee command working avutondi baa unix lo ithey

deenni seq file lo filter options lo petti choodu ostadi

[pandemkodi]

akkada nenu comma petta kada nuvvu nee file delimiter pettu (quotes madyalo)