Directory command is not working

20 pts.
Tags:
IBM i 7.1
QCMDEXC
SQL
Call qcmdexc parm('CPYTOIMPF FROMfile(mylib/myfile)
TOSTMF(/home/test/test.txt)')
It is not working I think because of the missing ' I tried to fix it with a hex value of x'7D' but the run SQL procedure didn't accept it


Software/Hardware used:
IBM i
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    What does "the run SQL procedure didn't accept it" mean? What SQL procedure?
    33,670 pointsBadges:
    report
  • pdraebel
    A call to QCMDEXC needs two parameters : the command and the length. Length parm should be declared as 15,0
    7,545 pointsBadges:
    report
  • WilsonAlano
    " Length parm should be declared as 15,0"
    Must be declared DEC(15, 0) not NUMERIC...
    2,710 pointsBadges:
    report
  • pdraebel
    The TOSTMF parameter is invalid. In case it has to be enclosed in QUOTES. TOSTMF('/home/test/mytest.file')
    7,545 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: