Ready to get started with anonymous questions today? It's easy! Learn more.
#!/usr/bin/tcsh # Checking the prameters if ( $# != 2 ) then echo "Invalid Parameter" exit -1 endif set studentId="$1" set fileName="$2" isql -S$SQL_SRVR -D$DB_NAME -U$SYB_LOAD_ID -P$SYB_LOAD_PWD -b -w3000 -n -h0 -o $fileName <<! set nocount on go select rtr.studentId,count (*) from StudentTrackingRequest rtr, Attendence mtp, RollDistribution rd where rtr.clientID = "$1" and rd.clientID = rtr.clientID and mtp.rtvStatusCode = 'VAL' and rd.creationDateTime > 'Sep 7 2011 9:02:29:000AM' and rd.atendenceDate >= '08/31/11' and rd.atendenceDate <= '09/08/11' group by rtr.clientID go ! exit 0
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.