Hi I desperately need some help regarding the following.
I am trying to read a list of stored procedure names and their input parameters from a file and execuet them one after the other irrespective of any errors.
I would like to know if i could put this statement in a loop till EOF...
but i dont want to embed any commands, i want the script to be seperate from the sql statements but to be stored in a single file. i dont know if that is too far fetched but i would like to know if that can be done.
Thanks a lot for replying.
hi, thanks a lot richman for helping me with my doubt, i have another question, pls bear with me :) i was wondering if i can package some script files as well as .sql files together in a single commandfile and execute it? or do they have to be in seperate commandfiles?
Thanks a lot Richman, I have just one more question, is it possible that i can package some scriptfiles and the .sql files together in the same commandfile and execute it, will the scripts get executed as well?
hi, i am pretty new to informix and would appreciate an answer to this doubt..I would like to know how can i batch execute multiple .sql files from commandline using dbaccess and then direct the output to a file. Thanks in advance.
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.