Spoke too soon, The timestamp is coming back correctly, now the unloads to the variable isn't working.
unload to "$BLGOUTPUT/cycl_dates.txt"
select * from wrk_cycl;
it doesn't evaluate the $BLGOUTPUT variable, I get the following:
806: Cannot open file for unload
No such file or...
Thanks feherke and stefanhei. The double quotes around the exclamation mark within the dbaccess call did the trick.
feherke: I tried your suggestions as well, they didn't work, but I appreciate the help.
Hello, First time post
So I added logic to my script to write data to a log file to see how long my sql's are running within a script but the times come back the same even thought the sql takes several minutes. I was wondering if anyone else tried this solution...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.