Home > IT Answers > Database > QEXECSQL command source
Pclarkeirl
5 pts.
 QEXECSQL command source
CSV, OS/400
Hello,

I am trying to implement a command ZCPYTOCSV. THis command uses ZFFDTOCSV and ZEXECSQL commands. I have the source of ZFFDTOCSV but cannot find the source for command ZEXECSQL. If anyone has access to this - could you please let me know.

Alternatively is there is another better utility for copying Database file to CSV then please let me know.

regards

Pat Clarke



Software/Hardware used:
OS/400 M25
ASKED: April 3, 2012  9:37 AM
UPDATED: May 27, 2012  2:40 AM
RELATED QUESTIONS
Answer Wiki:
Clarke use the command prompt to ask for what command is use for (Accessed through run than typein cmd). i.e. the commant XCOPY is used for coping network file and if you just want to copy an item use COPY ##(# is the item name).
Last Wiki Answer Submitted:  May 10, 2012  10:12 am  by  Tlapeng   45 pts.
All Answer Wiki Contributors:  Tlapeng   45 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

First, the question is tagged with “OS/400 M25″. Can you explain what that means? What version is your OS?

Second, is there a reason not to use the standard CPYTOIMPF command to create .CSV output? If CPYTOIMPF is out of the question for some reason, it can often be possible to use the Qshell db2 utility to manufacture .CSV output as desired. Do you have a reasonably current version of Qshell installed? (Should be at least V5R2 with decent PTFs.)

Finally, I don’t have source for ZEXECSQL, but a replacement should be fairly easy to create. Can you prompt the command and show its parms?

Tom

TomLiotta
 107,845 pts.
 

Sorry … “M25″ is probably the hardware model. Never mind that part, though the OS version may still be helpful.

Tom

TomLiotta
 107,845 pts.